SAP table TD01 (Table for collateral keys)

SAP table TD01 has 2 primary key fields being MANDT,SSICH.

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
SSICH Collateral type CHAR 4 0 SSICH
SSICHART Category Of Collateral Group (Internal) NUMC 2 0 SSICHART
01 Encumb. on real estate (indiv.right in section III)
02 Life insurance policies
03 Building loan contract
04 Pledged loans
05 Pledged fixed-interest securities
06 Pledged stock
07 Other credit
08 Other insurances
09 Guarantees
11 Assigned encumbrances on real estate
50 Primary collateral
98 Credit Life Insurance
99 Other
GSART Product Type CHAR 3 0 TZPA VVSART
STITEL Loan Type Indicator NUMC 3 0 TD03A STITEL
SOESART Austrian collateral security type ind. CHAR 2 0 VVSOESART
00 No collateral
01 Pledge earnings from legally regulated charges
02 Pledge of real estate in domestic country or treaty state
03 Pledge claims from life insurance contracts
04 Pledge officially quoted securities Para.78/1 L 1,2,4 VAG
05 Pledge pension entitlement and/or clearance claims
06 Pledge accounts receivable
21 Liability of domestic (treaty state) local authorities
22 Liability of local authorities outside treaty state
23 Liabilitiy of domestic (treaty state) municipal authorities
24 Liability of domestic/treaty state banks
25 Liability of banks outside treaty state
41 Other collateral

TD01 foreign key relationships

Table Field Check Table Check Field
0 TD01 GSART TZPA Financial Assets Management Product Types MANDT
0 TD01 GSART TZPA Financial Assets Management Product Types GSART
1 TD01 STITEL TD03A Define Loan Type MANDT
1 TD01 STITEL TD03A Define Loan Type STITEL