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 |
|
|||||||||||||
| 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 |
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 |