SAP table T5D1K (Branch Offices)
SAP table T5D1K has 4 primary key fields being MANDT,KVSCH,KVGES,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
Client
CLNT
3
0
T000
MANDT
HI Fund Key for Compulsory Health Insurance Fund
CHAR
8
0
T5D11
KVSCH
HI Fund Branch Office
CHAR
6
0
KVGST
End Date
DATS
8
0
ENDDA
BEGDA
Start Date
DATS
8
0
BEGDA
TXT01
Short text for branch office
CHAR
20
0
TXTGS
KVPSK
Payee Fund for Reporting
CHAR
1
0
KVPSK
KZART
Health Insurance Fund Category
CHAR
2
0
T515A
KZART
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 (Long form)
CHAR
30
0
TELNR_EXT
BTRNR
Company Number
CHAR
8
0
BTRNR
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
KVBFE
HI Contribution Deduction Voluntarily Reduced
CHAR
1
0
KVBFE
Possible values
B
Gross Calculation
F
Fixed Value Calculation
P
Percentage Calculation
S
Graduated Calculation
KVBFR
HI Contribution Deduction for Voluntarily Insured Person
CHAR
1
0
KVBFR
Possible values
B
Gross Calculation
F
Fixed Value Calculation
P
Percentage Calculation
WOKNZ
West/East Indicator
CHAR
1
0
WOKNZ
Possible values
PVBFR
CI Contribution Deductions for Voluntarily Insured Person
CHAR
1
0
P011_PVBFR
Possible values
B
Gross Calculation
F
Fixed Value Calculation
P
Percentage Calculation
PVBFE
CI Contrib. Deductions for Voluntarily Reduced Ins. Persons
CHAR
1
0
PVBFE
Possible values
B
Gross Calculation
F
Fixed Value Calculation
P
Percentage Calculation
S
Graduated Calculation
GSTYP
Locked Branch Office
CHAR
1
0
P01_GSTYP
ZLSCH
Payment method
CHAR
1
0
T042Z
P01_ZLSCH
IBAN
IBAN (International Bank Account Number)
CHAR
34
0
IBAN
LFDNR
Account Data Key
NUMC
4
0
T5D1KK
P01_KDLFD
T5D1K foreign key relationships
Table
Field
Check Table
Check Field
0 T5D1K
BANKS
T005 Countries
MANDT
0 T5D1K
BANKS
T005 Countries
LAND1
1 T5D1K
KVSCH
T5D11 Calculation Procedures and Indicators of Health Ins. Funds
MANDT
1 T5D1K
KVSCH
T5D11 Calculation Procedures and Indicators of Health Ins. Funds
ENDDA
0 T5D1K
KZART
T515A Fund Categories
MANDT
0 T5D1K
KZART
T515A Fund Categories
KKA
1 T5D1K
LFDNR
T5D1KK Account Data from Contribution Rate File
MANDT
0 T5D1K
ZLSCH
T042Z Payment Methods for Automatic Payment
MANDT
0 T5D1K
ZLSCH
T042Z Payment Methods for Automatic Payment
LAND1
0 T5D1K
ZLSCH
T042Z Payment Methods for Automatic Payment
ZLSCH