SAP Table TN23V
IS-H: Fixed Values for BDT Format (OU-Related)
TN23V (IS-H: Fixed Values for BDT Format (OU-Related)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link TN23V to other SAP tables.
TN23V table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||||
| EINRI | Institution | EINRI | TN01 | CHAR | 4 | 0 | ||||||||||||||||||
| ORGID | Identification Key of Organizational Unit | ORGID | NORG | CHAR | 8 | 0 | ||||||||||||||||||
| PERNR | IS-H: Person Number | RI_PERNR | NGPA | CHAR | 10 | 0 | ||||||||||||||||||
| PKVNF | IS-H: Person no. as PPA billing no. for emergency cases | PERNR_NF | NGPA | CHAR | 10 | 0 | ||||||||||||||||||
| PTYP | IS-H: Practice category | PRATYP | NUMC | 1 | 0 |
Possible values
|
||||||||||||||||||
| VERSN | IS-H: BDT version (internal) | ISH_VERSN | TN23S | CHAR | 3 | 0 | ||||||||||||||||||
| PFAD | Path for Directory Application or Presentation Server | PFAD | CHAR | 40 | 0 | |||||||||||||||||||
| BSNR_AC | ISH_BSNR_AC | NBSNR | CHAR | 9 | 0 | |||||||||||||||||||
| BSNR_EC | ISH_BSNR_EC | NBSNR | CHAR | 9 | 0 | |||||||||||||||||||
TN23V foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| TN23V | BSNR_AC | TN23V | BSNR_AC | NBSNR | NBSNR | |
| TN23V | BSNR_AC | TN23V | MANDT | NBSNR | MANDT | |
| TN23V | BSNR_AC | TN23V | PERNR | NBSNR | PHYSNO | |
| TN23V | BSNR_EC | TN23V | MANDT | NBSNR | MANDT | |
| TN23V | BSNR_EC | TN23V | PKVNF | NBSNR | PHYSNO | |
| TN23V | BSNR_EC | TN23V | BSNR_EC | NBSNR | NBSNR | |
| TN23V | EINRI | TN23V | EINRI | TN01 | IS-H: Institutions | EINRI |
| TN23V | EINRI | TN23V | MANDT | TN01 | IS-H: Institutions | MANDT |
| TN23V | MANDT | TN23V | MANDT | T000 | Clients | MANDT |
| TN23V | ORGID | TN23V | MANDT | NORG | IS-H: Organizational Units | MANDT |
| TN23V | ORGID | TN23V | ORGID | NORG | IS-H: Organizational Units | ORGID |
| TN23V | PERNR | TN23V | MANDT | NGPA | IS-H: Business Partners | MANDT |
| TN23V | PERNR | TN23V | PERNR | NGPA | IS-H: Business Partners | GPART |
| TN23V | PKVNF | TN23V | MANDT | NGPA | IS-H: Business Partners | MANDT |
| TN23V | PKVNF | TN23V | PKVNF | NGPA | IS-H: Business Partners | GPART |
| TN23V | VERSN | TN23V | MANDT | TN23S | IS-H: BDT Format Versions | MANDT |
| TN23V | VERSN | TN23V | VERSN | TN23S | IS-H: BDT Format Versions | VERSN |
