I_WORKCENTERCAPACITY

CDS View
20 Fields 23 CDS Views

Work Center Capacity

I_WORKCENTERCAPACITY is a CDS View in S/4HANA. Work Center Capacity. It contains 20 fields. 23 CDS views read from this table.

CDS Views using this table (23)

ViewTypeJoinVDMDescription
A_WorkCenterAllCapacity_2 view from COMPOSITE Capacity Assignment Version 2
C_CapEvalWcUtilznInEvalHorzn view from CONSUMPTION WorkCenter Utilizn in Evaluation Horizon
C_MaintWrkCtrAssignedPersonVH view union CONSUMPTION Value Help for Maint. Work Center Person
C_MassMaintCapWrkCtrFltr view_entity from CONSUMPTION Filter for Capacity List
C_MassMaintCapWrkCtrGrpUsage view_entity from CONSUMPTION Work center group where used
I_CapEvalByAreaOfRespy view inner COMPOSITE Work Center By Area Of Responsibility
I_MassMaintCapAreaOfRespy view_entity from COMPOSITE Work Center Capacity AOR
I_MassMaintCapAreaOfRespy view_entity union COMPOSITE Work Center Capacity AOR
I_WorkCenterAllCapacity view from COMPOSITE All Capacities of Work Center
I_WorkCenterCapacity_2 view inner COMPOSITE Work Center Capacity
I_WorkCenterCapacity_3 view_entity inner COMPOSITE Work Center Capacity
I_WorkCenterPooledCapAlloc view_entity inner COMPOSITE Work Center Pooled Capacity Allocation
I_WrkCntrAssociatedCapForPlnr view from COMPOSITE Associated Capacity for planner
I_WrkCntrAssociatedCapForPlnr view cross COMPOSITE Associated Capacity for planner
I_WrkCtrCapByAreaOfRespy view from COMPOSITE Work Center By Area Of Responsibility
I_WrkCtrCapByAreaOfRespy view inner COMPOSITE Work Center By Area Of Responsibility
I_WrkCtrCapByAreaOfRespy view union COMPOSITE Work Center By Area Of Responsibility
P_CapEvalCalcdField view from CONSUMPTION
P_RSHWorkCenterCapacityChange view left_outer CONSUMPTION Work Center Capacity Change
P_WorkCenterAllCapacity view from COMPOSITE
P_WorkCenterCalcdField view from COMPOSITE
P_WrkCtrMntrSchedValidShift view from CONSUMPTION Work Center Valid Shifts
P_WrkCtrMntrSchedValidShift view union_all CONSUMPTION Work Center Valid Shifts

Fields (20)

KeyField CDS FieldsUsed in Views
KEY CapacityCategoryAllocation CapacityCategoryAllocation 10
KEY CapacityInternalID AssociatedCapacityInternalID,CapacityInternalID 10
KEY WorkCenterInternalID AssociatedWorkCenterInternalID,WorkCenterInternalID 11
KEY WorkCenterTypeCode WorkCenterTypeCode 9
_WorkCenter _WorkCenter 2
_WorkCenterTypeCode _WorkCenterTypeCode 2
Capacity Capacity 1
CapacityCategoryCode CapacityCategoryCode 4
LastChangeDate LastChangeDate 2
LastChangedByUser LastChangedByUser 2
OtherCapRequirementFormula OtherCapRequirementFormula 2
Plant Plant 5
ProcgCapRequirementFormula ProcgCapRequirementFormula 2
SetupCapRequirementFormula SetupCapRequirementFormula 2
TeardownCapRequirementFormula TeardownCapRequirementFormula 2
ValidityEndDate ValidityEndDate 2
ValidityStartDate ValidityStartDate 2
WorkCenter AssociatedWorkCenter,WorkCenter 9
WorkCenterCategoryCode WorkCenterCategoryCode 4
WorkCenterLastChangeDateTime WorkCenterLastChangeDateTime 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
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_WORKCENTERCAPACITY (
    CAPACITYCATEGORYALLOCATION,
    CAPACITYINTERNALID,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    _WORKCENTER,
    _WORKCENTERTYPECODE,
    CAPACITY,
    CAPACITYCATEGORYCODE,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    OTHERCAPREQUIREMENTFORMULA,
    PLANT,
    PROCGCAPREQUIREMENTFORMULA,
    SETUPCAPREQUIREMENTFORMULA,
    TEARDOWNCAPREQUIREMENTFORMULA,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    WORKCENTER,
    WORKCENTERCATEGORYCODE,
    WORKCENTERLASTCHANGEDATETIME,
    PRIMARY KEY (CAPACITYCATEGORYALLOCATION, CAPACITYINTERNALID, WORKCENTERINTERNALID, WORKCENTERTYPECODE)
);

Learn More