SAP Table T5D1K
Branch Offices
T5D1K (Branch Offices) 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 T5D1K to other SAP tables.
T5D1K table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||
| KVSCH | HI Fund Key for Compulsory Health Insurance Fund | KVSCH | T5D11 | CHAR | 8 | 0 | ||||||||||
| KVGES | HI Fund Branch Office | KVGST | CHAR | 6 | 0 | |||||||||||
| ENDDA | End Date | ENDDA | DATS | 8 | 0 | |||||||||||
| BEGDA | Start Date | BEGDA | DATS | 8 | 0 | |||||||||||
| TXT01 | Short text for branch office | TXTGS | CHAR | 20 | 0 | |||||||||||
| KVPSK | Payee Fund for Reporting | KVPSK | CHAR | 1 | 0 |
Possible values
|
||||||||||
| KZART | Health Insurance Fund Category | KZART | T515A | CHAR | 2 | 0 | ||||||||||
| TXT02 | Fund description | TXTKR | CHAR | 25 | 0 | |||||||||||
| TXT03 | Fund description | TXTKR | CHAR | 25 | 0 | |||||||||||
| TXT04 | House number and street | STRAS | CHAR | 30 | 0 | |||||||||||
| PSTLZ | Postal Code | PSTLZ | CHAR | 10 | 0 | |||||||||||
| ORT01 | City | ORT01 | CHAR | 25 | 0 | |||||||||||
| TELNR | Telephone Number | TELNR | CHAR | 14 | 0 | |||||||||||
| BTRNR | Company Number | BTRNR | CHAR | 8 | 0 | |||||||||||
| BANKS | Bank country key | BANKS | T005 | CHAR | 3 | 0 | ||||||||||
| BLZZS | Bank number | BANKL | CHAR | 15 | 0 | |||||||||||
| KNRZS | Account Number of Health Insurance Fund | KNRZS | CHAR | 10 | 0 | |||||||||||
| KVBFE | HI Contribution Deduction Voluntarily Reduced | KVBFE | CHAR | 1 | 0 |
Possible values
|
||||||||||
| KVBFR | HI Contribution Deduction for Voluntarily Insured Person | KVBFR | CHAR | 1 | 0 |
Possible values
|
||||||||||
| WOKNZ | West/East Indicator | WOKNZ | CHAR | 1 | 0 |
Possible values
|
||||||||||
| PVBFR | CI Contribution Deductions for Voluntarily Insured Person | P011_PVBFR | CHAR | 1 | 0 |
Possible values
|
||||||||||
| PVBFE | CI Contrib. Deductions for Voluntarily Reduced Ins. Persons | PVBFE | CHAR | 1 | 0 |
Possible values
|
||||||||||
| GSTYP | Locked Branch Office | P01_GSTYP | CHAR | 1 | 0 |
Possible values
|
||||||||||
| ZLSCH | Payment method | P01_ZLSCH | T042Z | CHAR | 1 | 0 | ||||||||||
| IBAN | IBAN (International Bank Account Number) | IBAN | CHAR | 34 | 0 | |||||||||||
T5D1K foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| T5D1K | BANKS | T5D1K | MANDT | T005 | Countries | MANDT |
| T5D1K | BANKS | T5D1K | BANKS | T005 | Countries | LAND1 |
| T5D1K | KVSCH | * | T5D11 | Calculation Procedures and Indicators of Health Ins. Funds | ENDDA | |
| T5D1K | KVSCH | T5D1K | MANDT | T5D11 | Calculation Procedures and Indicators of Health Ins. Funds | MANDT |
| T5D1K | KVSCH | T5D1K | KVSCH | T5D11 | Calculation Procedures and Indicators of Health Ins. Funds | KVSCH |
| T5D1K | KZART | T5D1K | MANDT | T515A | Fund Categories | MANDT |
| T5D1K | KZART | T5D1K | KZART | T515A | Fund Categories | KKA |
| T5D1K | MANDT | T5D1K | MANDT | T000 | Clients | MANDT |
| T5D1K | ZLSCH | T5D1K | ZLSCH | T042Z | Payment Methods for Automatic Payment | ZLSCH |
| T5D1K | ZLSCH | T5D1K | MANDT | T042Z | Payment Methods for Automatic Payment | MANDT |
| T5D1K | ZLSCH | 'DE' | T042Z | Payment Methods for Automatic Payment | LAND1 | |
