P_WORKCENTERHEADERCAPDEF

CDS View
21 Fields 3 CDS Views

Work Center Header Capacity Definition

P_WORKCENTERHEADERCAPDEF is a CDS View in S/4HANA. Work Center Header Capacity Definition. It contains 21 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_CapEvalShiftDefVH view_entity from COMPOSITE Capacity Evaluation Shift Definition Value Help
I_CapEvalShiftSequenceVH view_entity from COMPOSITE Capacity Evaluation Shift Definition Value Help
P_WorkCenterHeaderCapacity view from COMPOSITE Work Center Header Capacity

Fields (21)

KeyField CDS FieldsUsed in Views
KEY CapacityCategoryAllocation CapacityCategoryAllocation 3
KEY CapacityInternalID CapacityInternalID 3
KEY WorkCenterInternalID WorkCenterInternalID 3
KEY WorkCenterTypeCode WorkCenterTypeCode 3
Capacity Capacity 1
CapacityActiveVersion CapacityActiveVersion 1
CapacityBreakDuration CapacityBreakDuration 1
CapacityCategoryCode CapacityCategoryCode 1
CapacityCategoryName CapacityCategoryName 1
CapacityEndTime CapacityEndTime 1
CapacityNumberOfCapacities CapacityNumberOfCapacities 1
CapacityPlanUtilizationPercent CapacityPlanUtilizationPercent 1
CapacityResponsiblePlanner CapacityResponsiblePlanner 1
CapacityStartTime CapacityStartTime 1
FactoryCalendar FactoryCalendar 1
Plant Plant 1
ShiftGroup ShiftGroup 1
WorkCenter WorkCenter 1
WorkCenterCategoryCode WorkCenterCategoryCode 1
WorkCenterDesc WorkCenterDesc 1
WorkCenterResponsible WorkCenterResponsible 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.

-- Work Center Header Capacity Definition
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_WORKCENTERHEADERCAPDEF (
    CAPACITYCATEGORYALLOCATION,
    CAPACITYINTERNALID,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    CAPACITY,
    CAPACITYACTIVEVERSION,
    CAPACITYBREAKDURATION,
    CAPACITYCATEGORYCODE,
    CAPACITYCATEGORYNAME,
    CAPACITYENDTIME,
    CAPACITYNUMBEROFCAPACITIES,
    CAPACITYPLANUTILIZATIONPERCENT,
    CAPACITYRESPONSIBLEPLANNER,
    CAPACITYSTARTTIME,
    FACTORYCALENDAR,
    PLANT,
    SHIFTGROUP,
    WORKCENTER,
    WORKCENTERCATEGORYCODE,
    WORKCENTERDESC,
    WORKCENTERRESPONSIBLE,
    PRIMARY KEY (CAPACITYCATEGORYALLOCATION, CAPACITYINTERNALID, WORKCENTERINTERNALID, WORKCENTERTYPECODE)
);

Learn More