I_WORKCENTERALLCAPACITY

CDS View

All Capacities of Work Center

I_WORKCENTERALLCAPACITY is a CDS View in S/4HANA. All Capacities of Work Center. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_WorkCenterAllCapacity view from COMPOSITE Capacity Assignment

Fields (12)

KeyField CDS FieldsUsed in Views
KEY CapacityCategoryAllocation CapacityCategoryAllocation 1
KEY CapacityInternalID CapacityInternalID 1
KEY WorkCenterInternalID WorkCenterInternalID 1
KEY WorkCenterTypeCode WorkCenterTypeCode 1
CapacityCategoryCode CapacityCategoryCode 1
Plant Plant 1
SupplyArea SupplyArea 1
WorkCenter WorkCenter 1
WorkCenterCategoryCode WorkCenterCategoryCode 1
WorkCenterDesc WorkCenterDesc 1
WorkCenterResponsible WorkCenterResponsible 1
WorkCenterUsage WorkCenterUsage 1

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.

-- All Capacities of Work Center
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_WORKCENTERALLCAPACITY (
    CAPACITYCATEGORYALLOCATION,
    CAPACITYINTERNALID,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    CAPACITYCATEGORYCODE,
    PLANT,
    SUPPLYAREA,
    WORKCENTER,
    WORKCENTERCATEGORYCODE,
    WORKCENTERDESC,
    WORKCENTERRESPONSIBLE,
    WORKCENTERUSAGE,
    PRIMARY KEY (CAPACITYCATEGORYALLOCATION, CAPACITYINTERNALID, WORKCENTERINTERNALID, WORKCENTERTYPECODE)
);