I_WORKCENTERCAPALLOC

CDS View

Work Center Capacity Allocation

I_WORKCENTERCAPALLOC is a CDS View in S/4HANA. Work Center Capacity Allocation. It contains 4 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_WorkCenterHeaderCapDef view from COMPOSITE
P_WrkCtrMntrSchedInterval view from CONSUMPTION Work Center Intervals

Fields (4)

KeyField CDS FieldsUsed in Views
KEY CapacityCategoryAllocation CapacityCategoryAllocation 1
KEY CapacityInternalID CapacityInternalID 2
KEY WorkCenterInternalID WorkCenterInternalID 2
KEY WorkCenterTypeCode WorkCenterTypeCode 2

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
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_WORKCENTERCAPALLOC (
    CAPACITYCATEGORYALLOCATION,
    CAPACITYINTERNALID,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    PRIMARY KEY (CAPACITYCATEGORYALLOCATION, CAPACITYINTERNALID, WORKCENTERINTERNALID, WORKCENTERTYPECODE)
);