SAP table TKKAP (Results Analysis Versions for Results Analysis)

SAP table TKKAP has 3 primary key fields being MANDT,KOKRS,VERSA.

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
VERSA Results Analysis Version CHAR 3 0 VERSN_ABGR
ABSBW Cutoff Period for Planned Results Analysis NUMC 7 0 ABSCHL_PER_PLAN
ABSPE Cutoff Period NUMC 7 0 ABSCHL_PER
RUNDZ Rounding Number for Decimal Places NUMC 1 0 RUND_ZAHL
SCHIC Indicator for Cost Component Split CHAR 1 0 SCHICHTUNG
TRBVA Split According to Creation and Usage CHAR 1 0 BI_VB_AU
KERLE Cost Element for Calculated Revenue CHAR 10 0 KST_ERL_E
KKSTE Cost Element for Calculated Costs CHAR 10 0 KST_KST_E
KGWBS Cost Element for Capitalized Profit CHAR 10 0 KST_GWBST
KRDVB Cost Element for Reserves for Imminent Loss (Crtn/Balance) CHAR 10 0 KST_RDV_BI
KRDVV Cost Element for Reserves for Imminent Loss (Usage) CHAR 10 0 KST_RDV_VB
KRDVW Cost Element for Reserves for Imminent Loss (Value Adjust.) CHAR 10 0 KST_RDV_WB
KEBST Cost Element for Revenue in Excess of Billings CHAR 10 0 KST_EF_BST
KEUBS Cost Element for Revenue Surplus CHAR 10 0 KST_E_UBS
KGEWB Cost Element for POC Profit Increase CHAR 10 0 KST_GEW_BI
KGEWA Cost Element for POC Profit Decrease CHAR 10 0 KST_GEW_AU
KVRLB Cost Element for POC Loss Creation CHAR 10 0 KST_VRL_BI
KVRLA Cost Element for POC Loss Cancellation CHAR 10 0 KST_VRL_AU
KVRLV Cost Element for POC Loss Realization CHAR 10 0 KST_VRL_VB
KKSTI Cost Element for Valuated Actual Costs CHAR 10 0 KST_KST_I
KPROI Cost Element for Valuated Actual Costs of Comp./Commissions CHAR 10 0 KST_PRO_I
RFLG1 Legacy Data Transfer CHAR 1 0 ALTDATEN
Legacy Data Transfer Inactive
X Legacy Data Transfer Active
RFLG2 Deletion of Results Analysis Data CHAR 1 0 LOESCHEN
Deletion Not Allowed
X Deletion Allowed
RFLG3 Transfer Results Analysis Data to Financial Accounting? CHAR 1 0 ABGRFIBUKZ
Do Not Transfer Results Analysis Data to Financial Acctg
X Transfer Results Analysis Data to Financial Accounting
RFLG4 Valuation Across Company Codes CHAR 1 0 BEW_ALL_BU
Ignore Actual Data from Other Company Codes
X Valuation Across Company Codes
RFLG5 Usage of Results Analysis Version CHAR 1 0 VSN_ABG_VW
A (Actual) Results Analysis (Blank Interpreted As A)
B (Actual) Results Analysis: Simulate Actual Data w/ Plan Data
C (Actual) Results Analysis and Planned Results Analysis
RKST1 Cost Element for Variances CHAR 10 0 KST_ABW
RKST2 Cost Elem Reduction in Rev.in Excess of Billg by Down Paymts CHAR 10 0 KKA_KST_ANZ_KB
EZPOS Generate Line Items CHAR 1 0 ENZLPOSUPD
RFLG6 Can Orders for Project or Sales Order Have WIP? CHAR 1 0 AUFT_WIPEL
Do Not Calculate WIP on Dependent Orders
A WIP Only on Orders Without Material Rule
B WIP Only on Orders for Sales Order
C WIP Only on Orders for Project
D WIP Only on Internal and Service Orders Without Revenue
E WIP on Orders Without Material Rule and for Sales Order
F WIP on Orders Without Material Rule and for Project
G WIP on Orders w/o Material Rule and I&S Orders w/o Revenue
H WIP on Orders for Sales Order and for Project
I WIP on Orders for Sales Order and I&S Orders w/o Revenue
J WIP on Orders for Project and I&S Orders Without Revenue
K WIP on Orders w/o Mat. Rule, for Sales Order and for Project
L WIP on Orders w/o Mat. Rule, for Sales Order and I&S w/o Rev
M WIP on Orders w/o Mat. Rule, for Project and I&S w/o Revenue
N WIP on Orders for Sales Order, for Project and I&S w/o Rev.
X Calculate WIP on Dependent Orders
RFLG7 Status Control CHAR 1 0 STATU_ZEIT
Interpreted as A
A Production Order: DLV, TECO; Sales Order: DLV, FNBL
B Production Order: DLV, TECO
C Production Order: DLV, TECO; Others: Status Change Documents
RFLG8 Copy Flag: Copy or Maintain Referenced Version CHAR 1 0 KKA_KOPIE
ZOABG Interpret Assignment with Results Analysis Key? CHAR 1 0 ABGSL_TKAZ
FSABG Define Update Separately for Each Results Analysis Key CHAR 1 0 ABGSL_TKAR
RFLG9 Cross-Business-Area Valuation CHAR 1 0 KKA_BEW_ALL_GB
Ignore Actual Data from Other Business Areas
X Cross-Business-Area Valuation
RFLG10 Object Currency in Results Analysis CHAR 1 0 KKA_OBJEKTWAEHRUNG
Results Analysis Standard
A Autom. Adjustment Obj. Curr. (Incompatible with Settl.)
C Calculate Company Code Currency Independently
D Option A and C Together
RFLG11 Reserved for SAP Development CHAR 1 0 RESERV_FLG
RFLG12 Reserved for SAP Development CHAR 1 0 RESERV_FLG
RKST3 Cost Element for Down Payment Surplus CHAR 10 0 KKA_KST_ANZ_UE
REFVA Associated Results Analysis Version w/ Operational Valuation CHAR 3 0 TKKAP KKA_REFVA
VALUTYP Valuation View NUMC 1 0 VALUTYP
0 Legal Valuation
1 Group Valuation
2 Profit Center Valuation
ABRKZI Version of Actual RA Data Relevant to Settlement CHAR 1 0 KKA_ABRKZI
ABROBI Flag: Objects Settled with Actual Results Analysis CHAR 1 0 KKA_OBIABR
VERSP Plan Version CHAR 3 0 TKA09 PLAN_VERSN
ABRKZP Version of Planned RA Data Relevant to Settlement CHAR 1 0 KKA_ABRKZP
ABROBP Flag: Objects Settled with Planned Results Analysis CHAR 1 0 KKA_OBPABR
FIBUP Transfer Planned Results Analysis to Financial Accounting? CHAR 1 0 KKA_P_FIBU
BUABG Interpret Posting Rule with Results Analysis Key? CHAR 1 0 ABGSL_TKAB
PLBFS Update Plan Values of Valuation CHAR 1 0 KKA_PLBFS
PLBERL Cost Element for Planned Revenues of Valuation CHAR 10 0 KKA_KST_PLB_ERL
PLBKOS Cost Element for Planned Costs of Valuation CHAR 10 0 KKA_KST_PLB_KOS
RKST4 Cost Element Reserved for SAP Development CHAR 10 0 RESERV_KST
RKFT5 Cost Element Reserved for SAP Development CHAR 10 0 RESERV_KST
SAVE_WIP Indicator: Save Work in Progress Details for Reporting CHAR 1 0 AD01_SAVE_WIP

TKKAP foreign key relationships

Table Field Check Table Check Field
0 TKKAP KOKRS TKA01 Controlling Areas MANDT
1 TKKAP REFVA TKKAP Results Analysis Versions for Results Analysis KOKRS
1 TKKAP REFVA TKKAP Results Analysis Versions for Results Analysis VERSA
0 TKKAP VERSP TKA09 Basic Settings for Versions MANDT
0 TKKAP VERSP TKA09 Basic Settings for Versions KOKRS
0 TKKAP VERSP TKA09 Basic Settings for Versions VERSN