SAP table CRCA (Work Center Capacity Allocation)

SAP table CRCA has 4 primary key fields being MANDT,OBJTY,OBJID,CANUM.

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
CANUM Capacity allocation number NUMC 4 0 CR_CAPNUM
BEGDA Start Date DATS 8 0 BEGDATUM
ENDDA End Date DATS 8 0 ENDDATUM
AEDAT_KAPA Changed on DATS 8 0 AEDTM
AENAM_KAPA User Name CHAR 12 0 USRNAME
KAPID Capacity ID NUMC 8 0 KAKO KAPID
FORK1 Formula for Setup Capacity Requirements CHAR 6 0 TC25 AP_FORM_K1
FORK2 Formula for Processing Capacity Requirements CHAR 6 0 TC25 AP_FORM_K2
FORK3 Formula for Teardown Capacity Requirements CHAR 6 0 TC25 AP_FORM_K3
FORKN Formula for Other Capacity Requirements CHAR 6 0 TC25 AP_FORM_KN
PROZT Percentage share of available capacity NUMC 3 0 AP_PROZ_KA
VERT1 Distribution of capacity requirements (Planned/prod.order) CHAR 8 0 TC29 CR_VERT1
VERT2 Key for distributing requirements over processing time CHAR 8 0 TC29 CR_VERT2
VERT3 Distribution key for teardown requirements CHAR 8 0 TC29 CR_VERT3
VERTN Distr.cap.reqmts (plant maint.,process order, network) CHAR 8 0 TC29 CR_VERTN
CAROL Role of work center capacity CHAR 40 0 CR_CAPROLE
ISTBED_KZ Calculation of actual capacity requirements CHAR 1 0 CY_ISTBEDKZ
No actual cap. reqs.
1 Act. Cap. Reqts from Work Center Formulas
2 Actual Cap. Requirements from Activities
VGWT1 Actual requirements for operation segment setup CHAR 6 0 * CY_VGWT1
VGWT2 Actual requirements for operation segment processing CHAR 6 0 * CY_VGWT2
VGWT3 Actual capacity requirements for operation segment teardown CHAR 6 0 * CY_VGWT3
VGWTN Actual capacity requirements for in-house processing CHAR 6 0 * CY_VGWTN
CAP_BACKFLUSH_SU Control: Calc. of Remaining Req./Duration After Confirmation NUMC 1 0 CAP_BACKFLUSH
0 Formula-Related
1 Completely for Partial Confirmation
2 Completely for Final Confirmation
3 Proportional to Service
CAP_BACKFLUSH_PR Control: Calc. of Remaining Req./Duration After Confirmation NUMC 1 0 CAP_BACKFLUSH
0 Formula-Related
1 Completely for Partial Confirmation
2 Completely for Final Confirmation
3 Proportional to Service
CAP_BACKFLUSH_TD Control: Calc. of Remaining Req./Duration After Confirmation NUMC 1 0 CAP_BACKFLUSH
0 Formula-Related
1 Completely for Partial Confirmation
2 Completely for Final Confirmation
3 Proportional to Service

CRCA foreign key relationships

Table Field Check Table Check Field
0 CRCA FORK1 TC25 Work center formulas MANDT
1 CRCA FORK2 TC25 Work center formulas MANDT
0 CRCA FORK3 TC25 Work center formulas MANDT
1 CRCA FORKN TC25 Work center formulas MANDT
0 CRCA KAPID KAKO Capacity Header Segment MANDT
1 CRCA MANDT T000 Clients MANDT
0 CRCA OBJID CRID CIM Resource - Entities MANDT
0 CRCA OBJID CRID CIM Resource - Entities OBJID
1 CRCA VERT1 TC29 Distribution key for capacity load MANDT
0 CRCA VERT2 TC29 Distribution key for capacity load MANDT
1 CRCA VERT3 TC29 Distribution key for capacity load MANDT
0 CRCA VERTN TC29 Distribution key for capacity load MANDT