SAP table T5D1H (Supplementary Insurance)

SAP table T5D1H has 4 primary key fields being MANDT,SVSPA,SVVER,ENDDA.

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
SVSPA Social Insurance Division CHAR 1 0 SVZSP
1 Health Insurance
2 Pension Insurance
4 Care Insurance
7 BVV Benefits
8 Press Pension Plan
O Public Sector Supplementary Insurance
SVVER Supplementary SI CHAR 8 0 SVVER
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA
TXT01 Short Text for SI Supplementary Insurance CHAR 20 0 DZVTXT
TXT02 Fund description CHAR 25 0 TXTKR
TXT03 Fund description CHAR 25 0 TXTKR
TXT04 Street and House Number CHAR 30 0 STRAS
PSTLZ Postal Code CHAR 10 0 PSTLZ
ORT01 City CHAR 25 0 ORT01
TELNR Telephone Number CHAR 14 0 TELNR
BANKS Country/Region Key of Bank CHAR 3 0 T005 BANKS
BLZZS Bank Number CHAR 15 0 BANKL
KNRZS Account Number of Health Insurance Fund CHAR 10 0 KNRZS
ZLSCH Payment method CHAR 1 0 T042Z P01_ZLSCH
IBAN IBAN (International Bank Account Number) CHAR 34 0 IBAN

T5D1H foreign key relationships

Table Field Check Table Check Field
0 T5D1H BANKS T005 Countries MANDT
0 T5D1H BANKS T005 Countries LAND1
1 T5D1H ZLSCH T042Z Payment Methods for Automatic Payment MANDT
1 T5D1H ZLSCH T042Z Payment Methods for Automatic Payment LAND1
1 T5D1H ZLSCH T042Z Payment Methods for Automatic Payment ZLSCH