CRCA

Transparent Table Application Table
27 Fields 2 CDS Views

Work Center Capacity Allocation

CRCA is an SAP database table in S/4HANA. Work Center Capacity Allocation. It contains 27 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_WorkCenterCapacity view from BASIC Work Center Capacity
P_CRCA view from BASIC

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY objty cr_objty Object Type
KEY objid cr_objid Object ID
KEY canum cr_capnum Wrk ctr cap no
begda begdatum Start date
endda enddatum End Date
aedat_kapa aedtm Changed on
aenam_kapa usrname User Name
kapid kapid Capacity ID
fork1 ap_form_k1 Setup Formula
fork2 ap_form_k2 Processing Formula
fork3 ap_form_k3 Teardown Formula
forkn ap_form_kn Other Formula
prozt ap_proz_ka Share
vert1 cr_vert1 Distribution
vert2 cr_vert2 Key:processing
vert3 cr_vert3 Teardown req.
vertn cr_vertn Int. dist. key
carol cr_caprole Capacity role
istbed_kz cy_istbedkz CalcActCpReqmts
vgwt1 cy_vgwt1 ActCapReqSetup
vgwt2 cy_vgwt2 ActRqProcessing
vgwt3 cy_vgwt3 ActRqtsTeardown
vgwtn cy_vgwtn ActReqIn-house
cap_backflush_su cap_backflush Cap. Reduction
cap_backflush_pr cap_backflush Cap. Reduction
cap_backflush_td cap_backflush Cap. Reduction

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Work Center Capacity Allocation
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRCA (
    MANDT,             -- Client [mandt]
    OBJTY,             -- Object Type [cr_objty]
    OBJID,             -- Object ID [cr_objid]
    CANUM,             -- Wrk ctr cap no [cr_capnum]
    BEGDA,             -- Start date [begdatum]
    ENDDA,             -- End Date [enddatum]
    AEDAT_KAPA,        -- Changed on [aedtm]
    AENAM_KAPA,        -- User Name [usrname]
    KAPID,             -- Capacity ID [kapid]
    FORK1,             -- Setup Formula [ap_form_k1]
    FORK2,             -- Processing Formula [ap_form_k2]
    FORK3,             -- Teardown Formula [ap_form_k3]
    FORKN,             -- Other Formula [ap_form_kn]
    PROZT,             -- Share [ap_proz_ka]
    VERT1,             -- Distribution [cr_vert1]
    VERT2,             -- Key:processing [cr_vert2]
    VERT3,             -- Teardown req. [cr_vert3]
    VERTN,             -- Int. dist. key [cr_vertn]
    CAROL,             -- Capacity role [cr_caprole]
    ISTBED_KZ,         -- CalcActCpReqmts [cy_istbedkz]
    VGWT1,             -- ActCapReqSetup [cy_vgwt1]
    VGWT2,             -- ActRqProcessing [cy_vgwt2]
    VGWT3,             -- ActRqtsTeardown [cy_vgwt3]
    VGWTN,             -- ActReqIn-house [cy_vgwtn]
    CAP_BACKFLUSH_SU,  -- Cap. Reduction [cap_backflush]
    CAP_BACKFLUSH_PR,  -- Cap. Reduction [cap_backflush]
    CAP_BACKFLUSH_TD,  -- Cap. Reduction [cap_backflush]
    PRIMARY KEY (MANDT, OBJTY, OBJID, CANUM)
);

Learn More