SAP Table
CSLA Activity master
SAP table CSLA has 4 primary key fields being MANDT,KOKRS,LSTAR,DATBI.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
CSLA columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | MANDT | ||||||||||||||
| KeyKOKRS | Controlling Area | CHAR | 4 | 0 | TKA01 | KOKRS | |||||||||||||
| KeyLSTAR | Activity Type | CHAR | 6 | 0 | LSTAR | ||||||||||||||
| KeyDATBI | 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 | ||||||||||||||
|
|||||||||||||||||||
| LATYPI | Variant Activity Type Category for Actual Postings | CHAR | 1 | 0 | LATYPI | ||||||||||||||
|
|||||||||||||||||||
| 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 | ||||||||||||||
/ Relationships
CSLA foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| CSLA | AUSEH | T006 | Units of Measurement | MANDT |
| CSLA | KOKRS | TKA01 | Controlling Areas | MANDT |
| CSLA | LEINH | T006 | Units of Measurement | MANDT |
| CSLA | TARKZ | TKA10 | Master Data Table, Price Indicators | MANDT |
| CSLA | TARKZ | TKA10 | Master Data Table, Price Indicators | TARKZ |
| CSLA | TARKZ_I | TKA10 | Master Data Table, Price Indicators | MANDT |
| CSLA | TARKZ_I | TKA10 | Master Data Table, Price Indicators | TARKZ |