SAP table TKA07 (Fiscal-Year Dependent Version Parameters)

SAP table TKA07 has 4 primary key fields being MANDT,KOKRS,VERSN,GJAHR.

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
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
VERSN Version CHAR 3 0 TKA09 VERSN
GJAHR Fiscal Year NUMC 4 0 GJAHR
VSPKZ Ind.: Version Locked Against Changes? CHAR 1 0 VSPKZ
EPSKZ Ind.: Write line items in planning? CHAR 1 0 EPSKZ
ANFBESTAND Ind.: Take over Opening Balance as Line Item? CHAR 1 0 ANFBESTAND
KOPIEREN Ind.: Maintenance by Copying Allowed? CHAR 1 0 KOPIEREN
REFERENZ Ind.: Maintenance by Reference Allowed? CHAR 1 0 RVERSREF
KURST Exchange Rate Type CHAR 4 0 TCURV KURST
PLDAT Value Date for Currency Translation DATS 8 0 PLDAT
PIVIT Purely Iterative Price CHAR 1 0 CO_PIVIT
RWINKZ Integrated Planning CHAR 1 0 RWINKZ
YRATE Price Calculation with Period-Based Average Prices CHAR 1 0 CO_YRATE
PLICC Integrated planning with CCtr Accounting and ABC CHAR 1 0 PLICC
VPDIO Version w/ind.actv.alloc. for non-integrated order planning CHAR 3 0 TKA09 VPDIO
RATMI Actual price calculation: Determination method NUMC 1 0 CO_RATMI
RATMP Plan price calculation: Determination method NUMC 1 0 CO_RATMP
1 Periodic price
2 Average price
ELEHK Cost Component Structure - CGM and Sales/Administr. Costs CHAR 2 0 TCKH4 CK_ELESMHK
ACUPD Revaluation at Actual Prices NUMC 2 0 CO_ACUPD
00 Do not revalue
01 Own business transaction
02 Original business transaction
CHBTC Background Processing Active CHAR 1 0 SYBATCH
VERSI Receiver Plan Version (CO-PA) CHAR 3 0 TKEVS RKEVERSIRECEIVER
VARIANT Valuation Variant for CO Resource Planning CHAR 3 0 CRVAR1 CRVARIANT
VRGAR Record Type CHAR 1 0 TVGA RKE_VRGAR
COMP_OWAER Cost Component Split in Object Currency CHAR 1 0 COMP_OWAER
PLICC_IMMO Integrated planning with cost centers/bus. processes CHAR 1 0 PLICC_IMMO
ACT_TWAER Transaction currrency for activity recording CHAR 1 0 ACTIVITY_TWAER
Object currency
1 Controlling aera currency

TKA07 foreign key relationships

Table Field Check Table Check Field
0 TKA07 ELEHK TCKH4 Cost Component Structure for Cost of Goods Manufactured MANDT
1 TKA07 KOKRS TKA01 Controlling Areas MANDT
0 TKA07 KURST TCURV Exchange rate types for currency translation MANDT
0 TKA07 KURST TCURV Exchange rate types for currency translation KURST
1 TKA07 VARIANT CRVAR1 Variants for CO Resource Price Determination MANDT
1 TKA07 VARIANT CRVAR1 Variants for CO Resource Price Determination KOKRS
0 TKA07 VERSI TKEVS CO-PA version attributes MANDT
0 TKA07 VERSI TKEVS CO-PA version attributes VERSI
0 TKA07 VERSI TKEVS CO-PA version attributes ERKRS
1 TKA07 VERSN TKA09 Basic Settings for Versions MANDT
1 TKA07 VERSN TKA09 Basic Settings for Versions KOKRS
1 TKA07 VERSN TKA09 Basic Settings for Versions VERSN
0 TKA07 VPDIO TKA09 Basic Settings for Versions MANDT
0 TKA07 VPDIO TKA09 Basic Settings for Versions KOKRS
0 TKA07 VPDIO TKA09 Basic Settings for Versions VERSN
1 TKA07 VRGAR TVGA Record types for CO-PA MANDT