SAP table TZK01 (Condition types)

SAP table TZK01 has 3 primary key fields being MANDT,RANTYP,SKOART.

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
RANTYP Contract Type CHAR 1 0 RANTYP
1 Loans
2 Securities
3 Lease-Out - Real Estate
4 Foreign Exchange
5 Money Market
6 Derivatives
7 Open Item Transactions
8 Administration Contract - Real Estate
9 General Contract - Real Estate
A Internal use only
B Bank Accounts
E Exposures
T Trade Finance
V Contract Management - Consumer Products
X External Accounts
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
SKOART Condition Type (Smallest Subdivision of Condition Records) NUMC 4 0 SKOART
SKOAREF Reference cond.type which the current cond.type refers to NUMC 4 0 TZK01 VVSKOAREF
SBEWART1 Flow Type 1 (Debit/Credit) CHAR 4 0 TZB0A VVSBEWART1
SBEWART2 Flow Type 2 (Debit/Credit) CHAR 4 0 TZB0A VVSBEWART2
SBEWZITI Flow category CHAR 4 0 TZB03 SBEWZITI
AUSWAHL Field selection CHAR 180 0 FEAUS
SDOKU Documentation identification NUMC 4 0 TZK06 VVSDOKU
SBERFIMA Calculation category for cash flow calculator CHAR 4 0 AT40 SBEWFIMA
JZINSBAS Flow in interest base CHAR 1 0 JZINSBAS
SEFFZIVZ +/- sign for effective interest rate calculation CHAR 1 0 VVSEFFZIVZ
SZART Payment Transaction CHAR 1 0 TB_SZART
CONTAB_RELEVANT Relevant for Condition Table CHAR 1 0 TB_FICO_CONTAB_RELEVANT
COND_INCLUSIV Include Condition Type in Loan CHAR 1 0 TB_FICO_INCLUSIV
COND_CATEGORY Condition Category NUMC 2 0 TDCONDCATEGORY TB_MD_CONDITION_CATEGORY
COND_VIEW Selected View for Customer-Specific UI Layout CHAR 20 0 TB_MD_CONDITION_VIEW

TZK01 foreign key relationships

Table Field Check Table Check Field
0 TZK01 COND_CATEGORY TDCONDCATEGORY Condition Category CATEGORY
1 TZK01 SBEWART1 TZB0A Definition of flow types MANDT
1 TZK01 SBEWART1 TZB0A Definition of flow types RANTYP
1 TZK01 SBEWART1 TZB0A Definition of flow types SBEWART
0 TZK01 SBEWART2 TZB0A Definition of flow types MANDT
0 TZK01 SBEWART2 TZB0A Definition of flow types RANTYP
0 TZK01 SBEWART2 TZB0A Definition of flow types SBEWART
1 TZK01 SBEWZITI TZB03 Flow categories SBEWZITI
0 TZK01 SDOKU TZK06 Documentation key for condition type-dependent documentation MANDT
1 TZK01 SKOAREF TZK01 Condition types MANDT
1 TZK01 SKOAREF TZK01 Condition types SKOART