SAP table CSKB (Cost Elements (Data Dependent on Controlling Area))

SAP table CSKB has 4 primary key fields being MANDT,KOKRS,KSTAR,DATBI.

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
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
KSTAR Cost Element CHAR 10 0 CSKA KSTAR
DATBI Valid To Date DATS 8 0 DATBI
DATAB Valid-From Date DATS 8 0 DATAB
KATYP Cost element category CHAR 2 0 KATYP
01 Primary costs/cost-reducing revenues
03 Accrual/deferral per surcharge
04 Accrual/deferral per debit = actual
11 Revenues
12 Sales deduction
21 Internal settlement
22 External settlement
31 Order/project results analysis
41 Overhead Rates
42 Assessment
43 Internal activity allocation
50 Project-related incoming orders: Sales revenue
51 Project-related incoming orders: Other revenues
52 Project-related incoming orders: Costs
61 Earned value
66 Reporting Cost Element CO-PA
90 Statistical cost element for balance sheet account
ERSDA Entered On DATS 8 0 ERFDT
USNAM Entered By CHAR 12 0 ERFNM
EIGEN Cost element attributes CHAR 8 0 EIGEN
PLAZU Indicator for Planning Access CHAR 1 0 PLAZU
PLAOR Indicator for the Planning Location CHAR 1 0 PLAOR
PLAUS Indicators for Planning User CHAR 2 0 PLAUS
KOSTL Cost Center CHAR 10 0 CSKS KOSTL
AUFNR Order Number CHAR 12 0 AUFK AUFNR
MGEFL Indicator for Recording Consumption Quantities CHAR 1 0 MGEFL
MSEHI Unit of Measurement UNIT 3 0 T006 MSEHI
DEAKT Indicator: Cost Element Deactivated CHAR 1 0 CO_DEAKT
active
X not active
LOEVM Indicator: Cost Element Is Flagged for Deletion CHAR 1 0 CO_LOEFL
LAST_CHANGED_TS UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TIMESTAMP
RECID Recovery Indicator CHAR 2 0 T8JJ JV_RECIND

CSKB foreign key relationships

Table Field Check Table Check Field
0 CSKB AUFNR AUFK Order master data AUFNR
1 CSKB KOKRS TKA01 Controlling Areas MANDT
0 CSKB KOSTL CSKS Cost Center Master Record MANDT
0 CSKB KOSTL CSKS Cost Center Master Record KOKRS
0 CSKB KOSTL CSKS Cost Center Master Record KOSTL
0 CSKB KOSTL CSKS Cost Center Master Record DATBI
1 CSKB KSTAR CSKA Cost Elements (Data Dependent on Chart of Accounts) MANDT
1 CSKB KSTAR CSKA Cost Elements (Data Dependent on Chart of Accounts) KTOPL
0 CSKB MSEHI T006 Units of Measurement MANDT
1 CSKB RECID T8JJ Recovery Indicator MANDT
1 CSKB RECID T8JJ Recovery Indicator BUKRS