SAP table TCK33 (Assignment of Condition Types to Origin Group)

SAP table TCK33 has 9 primary key fields being MANDT,CONDITIONTYPE,VALUTYP,CURRTYP,BWVAR,KOKRS,BUKRS,BWKEY,VALUSUBTYP.

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 MANDT
CONDITIONTYPE Condition Type CHAR 4 0 T685 KSCHA
VALUTYP Valuation View (for Transfer Prices) NUMC 1 0 FINS_VALUTYP_WO_COGM
0 Legal Valuation
1 Group Valuation
2 Profit Center Valuation
3 Segmentation Valuation
CURRTYP Currency Type CHAR 2 0 CURRTYP
00 Document currency
10 Company code currency
20 Controlling area currency
30 Group currency
40 Hard currency
50 Index-based currency
60 Global company currency
70 Controlling object currency
80 Ledger currency
90 Profit center accounting currency
A0 Financial management area currency
B0 Operating concern currency
C0 Consolidation unit currency
BWVAR Valuation Variant in Costing CHAR 3 0 TCK05 CK_BWVAR
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
BUKRS Company Code CHAR 4 0 T001 BUKRS
BWKEY Valuation area CHAR 4 0 T001K BWKEY
VALUSUBTYP Subtype of Valuation View (for Transfer Prices) CHAR 2 0 FINSC_VALUSUBTYP FINS_VALUSUBTYP
ORIGINGROUP Origin Group as Subdivision of Cost Element CHAR 4 0 TKKH1 HRKFT

TCK33 foreign key relationships

Table Field Check Table Check Field
0 TCK33 BUKRS T001 Company Codes BUKRS
1 TCK33 BWVAR TCK05 Valuation Variants in Costing MANDT
0 TCK33 CONDITIONTYPE T685 Conditions: Types KAPPL
0 TCK33 CONDITIONTYPE T685 Conditions: Types KSCHL
1 TCK33 KOKRS TKA01 Controlling Areas MANDT
0 TCK33 ORIGINGROUP TKKH1 Origin in CO Object KOKRS
0 TCK33 ORIGINGROUP TKKH1 Origin in CO Object KOATY
0 TCK33 ORIGINGROUP TKKH1 Origin in CO Object HRKFT
1 TCK33 VALUSUBTYP FINSC_VALUSUBTYP Valuation View Subtype VALUSUBTYPE