SAP Table CSLA
Activity master
CSLA (Activity master) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link CSLA to other SAP tables.
CSLA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT |
CLNT
|
3 | 0 | ||||||||||||||||
|
KOKRS
Controlling Area
|
KOKRS | TKA01 |
CHAR
|
4 | 0 | |||||||||||||||
|
LSTAR
Activity Type
|
LSTAR |
CHAR
|
6 | 0 | ||||||||||||||||
|
DATBI
Valid To Date
|
DATBI |
DATS
|
8 | 0 | ||||||||||||||||
|
DATAB
Valid-From Date
|
DATAB |
DATS
|
8 | 0 | ||||||||||||||||
|
LEINH
Activity Unit
|
LEINH | T006 |
UNIT
|
3 | 0 | |||||||||||||||
|
LATYP
Activity Type Category
|
LATYP |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
LATYPI
Variant Activity Type Category for Actual Postings
|
LATYPI |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
ERSDA
Created on
|
ERFDT |
DATS
|
8 | 0 | ||||||||||||||||
|
USNAM
Entered by
|
ERFNM |
CHAR
|
12 | 0 | ||||||||||||||||
|
KSTTY
Valid Cost Center Categories
|
KSTTY |
CHAR
|
8 | 0 | ||||||||||||||||
|
AUSEH
Output Unit
|
AUSEH | T006 |
UNIT
|
3 | 0 | |||||||||||||||
|
AUSFK
Output factor
|
AUSFK |
DEC
|
5 | 2 | ||||||||||||||||
|
VKSTA
Allocation Cost Element
|
VKSTA |
CHAR
|
10 | 0 | ||||||||||||||||
|
LARK1
Indicator for component relevancy CO
|
LARK1 |
CHAR
|
1 | 0 | ||||||||||||||||
|
LARK2
Indicator: Component Relevance, HR
|
LARK2 |
CHAR
|
1 | 0 | ||||||||||||||||
|
SPRKZ
Lock Indicator
|
SPRKZ |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
HRKFT
Origin Group as Subdivision of Cost Element
|
HRKFT |
CHAR
|
4 | 0 | ||||||||||||||||
|
FIXVO
Predistribution of fixed costs for acty type/bus. process
|
CO_FIXVO |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
TARKZ
Price Indicator: Calculate Allocation Price
|
TARKZ | TKA10 |
CHAR
|
3 | 0 | |||||||||||||||
|
YRATE
Price Calculation with Period-Based Average Prices
|
CO_YRATE |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
TARKZ_I
Indicator: Actual Allocation Price
|
CO_TARKZ_I | TKA10 |
CHAR
|
3 | 0 | |||||||||||||||
|
MANIST
Indicator: Confirm quantity manually in actual
|
CO_MANIST |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
MANPLAN
Indicator: Plan quantity manually set.
|
CO_MANPLAN |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
CSLA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| CSLA | AUSEH | CSLA | MANDT |
T006
Units of Measurement
|
MANDT |
| CSLA | AUSEH | CSLA | AUSEH |
T006
Units of Measurement
|
MSEHI |
| CSLA | KOKRS | CSLA | MANDT |
TKA01
Controlling Areas
|
MANDT |
| CSLA | KOKRS | CSLA | KOKRS |
TKA01
Controlling Areas
|
KOKRS |
| CSLA | LEINH | CSLA | MANDT |
T006
Units of Measurement
|
MANDT |
| CSLA | LEINH | CSLA | LEINH |
T006
Units of Measurement
|
MSEHI |
| CSLA | TARKZ | CSLA | MANDT |
TKA10
Master Data Table, Price Indicators
|
MANDT |
| CSLA | TARKZ | CSLA | TARKZ |
TKA10
Master Data Table, Price Indicators
|
TARKZ |
| CSLA | TARKZ_I | CSLA | MANDT |
TKA10
Master Data Table, Price Indicators
|
MANDT |
| CSLA | TARKZ_I | CSLA | TARKZ_I |
TKA10
Master Data Table, Price Indicators
|
TARKZ |