SAP table T5D1KK (Account Data from Contribution Rate File)
SAP table T5D1KK has 3 primary key fields being MANDT,KVSCH,LFDNR.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| KVSCH | HI Fund Key for Compulsory Health Insurance Fund | CHAR | 8 | 0 | T5D11 | KVSCH | |
| LFDNR | Account Data Key | NUMC | 4 | 0 | P01_KDLFD | ||
| BLZZS | Bank Number | CHAR | 15 | 0 | BANKL | ||
| KNRZS | Account Number of Health Insurance Fund | CHAR | 10 | 0 | KNRZS | ||
| IBAN | IBAN (International Bank Account Number) | CHAR | 34 | 0 | IBAN | ||
| SWIFT | SWIFT/BIC for International Payments | CHAR | 11 | 0 | SWIFT | ||
| INVAL | Invalid | CHAR | 1 | 0 | P01_INVAL | ||
| BANKS | Country/Region Key of Bank | CHAR | 3 | 0 | T005 | BANKS | |
| BANKL | Bank Keys | CHAR | 15 | 0 | BANKK |
T5D1KK foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T5D1KK | BANKS | T005 | Countries | MANDT |
| 0 T5D1KK | BANKS | T005 | Countries | LAND1 |
| 1 T5D1KK | KVSCH | T5D11 | Calculation Procedures and Indicators of Health Ins. Funds | MANDT |
| 1 T5D1KK | KVSCH | T5D11 | Calculation Procedures and Indicators of Health Ins. Funds | ENDDA |