SAP table CSLA (Activity master)

SAP table CSLA has 4 primary key fields being MANDT,KOKRS,LSTAR,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
LSTAR Activity Type CHAR 6 0 LSTAR
DATBI Valid To Date DATS 8 0 DATBI
DATAB Valid-From Date DATS 8 0 DATAB
LEINH Activity Unit UNIT 3 0 T006 LEINH
LATYP Activity Type Category CHAR 1 0 LATYP
1 Manual entry, manual allocation
2 Indirect determination, indirect allocation
3 Manual entry, indirect allocation
4 Manual entry, no allocation
LATYPI Variant Activity Type Category for Actual Postings CHAR 1 0 LATYPI
As in planning
1 Manual entry, manual allocation
2 Indirect determination, indirect allocation
3 Manual entry, indirect allocation
4 Manual entry, no allocation
5 Taget=actual allocation
ERSDA Entered On DATS 8 0 ERFDT
USNAM Entered By CHAR 12 0 ERFNM
KSTTY Valid Cost Center Categories CHAR 8 0 KSTTY
AUSEH Output Unit UNIT 3 0 T006 AUSEH
AUSFK Output factor DEC 5 2 AUSFK
VKSTA Allocation Cost Element CHAR 10 0 * VKSTA
LARK1 Indicator for component relevancy CO CHAR 1 0 LARK1
LARK2 Indicator: Component Relevance, HR CHAR 1 0 LARK2
SPRKZ Lock Indicator CHAR 1 0 SPRKZ
HRKFT Origin Group as Subdivision of Cost Element CHAR 4 0 * HRKFT
FIXVO Predistribution of fixed costs for acty type/bus. process CHAR 1 0 CO_FIXVO
TARKZ Price Indicator: Calculate Allocation Price CHAR 3 0 TKA10 TARKZ
YRATE Price Calculation with Period-Based Average Prices CHAR 1 0 CO_YRATE
TARKZ_I Indicator: Actual Allocation Price CHAR 3 0 TKA10 CO_TARKZ_I
MANIST Indicator: Confirm quantity manually in actual CHAR 1 0 CO_MANIST
MANPLAN Indicator: Plan quantity manually set. CHAR 1 0 CO_MANPLAN

CSLA foreign key relationships

Table Field Check Table Check Field
0 CSLA AUSEH T006 Units of Measurement MANDT
1 CSLA KOKRS TKA01 Controlling Areas MANDT
0 CSLA LEINH T006 Units of Measurement MANDT
1 CSLA TARKZ TKA10 Master Data Table, Price Indicators MANDT
1 CSLA TARKZ TKA10 Master Data Table, Price Indicators TARKZ
0 CSLA TARKZ_I TKA10 Master Data Table, Price Indicators MANDT
0 CSLA TARKZ_I TKA10 Master Data Table, Price Indicators TARKZ