SAP table CRCO (Assignment of Work Center to Cost Center)

SAP table CRCO has 6 primary key fields being MANDT,OBJTY,OBJID,LASET,ENDDA,LANUM.

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 T000 MANDT
OBJTY Object types of the CIM resource CHAR 2 0 CR_OBJTY
A Work Center
AA Work center alias
FH Production resources/tools
G Group
H Hierarchy
OBJID Object ID of the resource NUMC 8 0 CRID CR_OBJID
LASET Activity type set CHAR 6 0 CR_LASET
ENDDA End Date DATS 8 0 ENDDATUM
LANUM Activity type number within a set NUMC 4 0 CR_LANUM
BEGDA Start Date DATS 8 0 BEGDATUM
AEDAT_KOST Changed on DATS 8 0 AEDTM
AENAM_KOST User Name CHAR 12 0 USRNAME
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
KOSTL Cost Center CHAR 10 0 CSKS KOSTL
LSTAR Activity Type CHAR 6 0 CSLA LSTAR
LSTAR_REF Field is referenced CHAR 1 0 AP_KZREF
FORML Formula key for costing CHAR 6 0 TC25 AP_FORM_C1
PRZ Business Process CHAR 12 0 * CO_PRZNR
ACTXY Activity Description Type CHAR 1 0 ACTXY
Description of parameter from standard value key
0 No description
1 Description of activity type
2 Description of activity from Customizing
ACTXK Key for alternative activity description CHAR 4 0 ACTXK
LEINH Activity Unit UNIT 3 0 * LEINH
BDE Transfer activity types to incentive wages CHAR 1 0 BDENR
1 Labor time
2 Setup time
3 Machine time
4 Variable activity
5 Teardown time
6 Not currently in use
SAKL Record type group NUMC 1 0 SA_KLASSE
0 Variable activity
1 Setup
2 Processing
3 Teardown

CRCO foreign key relationships

Table Field Check Table Check Field
0 CRCO FORML TC25 Work center formulas MANDT
1 CRCO KOKRS TKA01 Controlling Areas MANDT
0 CRCO KOSTL CSKS Cost Center Master Record MANDT
0 CRCO KOSTL CSKS Cost Center Master Record KOKRS
0 CRCO KOSTL CSKS Cost Center Master Record KOSTL
0 CRCO KOSTL CSKS Cost Center Master Record DATBI
1 CRCO LSTAR CSLA Activity master MANDT
1 CRCO LSTAR CSLA Activity master KOKRS
1 CRCO LSTAR CSLA Activity master DATBI
0 CRCO MANDT T000 Clients MANDT
1 CRCO OBJID CRID CIM Resource - Entities MANDT
1 CRCO OBJID CRID CIM Resource - Entities OBJID