P_WORKCENTERCALCDFIELD

CDS View
42 Fields 2 CDS Views

P_WORKCENTERCALCDFIELD is a CDS View in S/4HANA. It contains 42 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_WorkCenterCapOrderPerBucket view from COMPOSITE Load Distribution at shift level for operations
I_WorkCenterCapPerBucket view from COMPOSITE WorkCenter capacity evaluation

Fields (42)

KeyField CDS FieldsUsed in Views
KEY CapacityCategoryAllocation CapacityCategoryAllocation 2
KEY CapacityEvaluationTimePeriod CapacityEvaluationTimePeriod 1
KEY CapacityInternalID CapacityInternalID 2
KEY Material Material 1
KEY MRPController MRPController 1
KEY Operation Operation 1
KEY OrderID OrderID 1
KEY Plant Plant 2
KEY ShiftName ShiftName 2
KEY WorkCenter WorkCenter 2
KEY WorkCenterInternalID WorkCenterInternalID 2
KEY WorkCenterTypeCode WorkCenterTypeCode 2
BaseUnit BaseUnit 1
CapacityEndTime CapacityEndTime 1
CapacityRequirementOrigin CapacityRequirementOrigin 1
CapacityRequirementUnit CapacityRequirementUnit 1
CapacityStartTime CapacityStartTime 1
FactoryCalendar FactoryCalendar 1
OperationLatestEndDate OperationLatestEndDate 1
OperationLatestEndTime OperationLatestEndTime 1
OperationLatestStartDate OperationLatestStartDate 1
OperationLatestStartTime OperationLatestStartTime 1
OperationPlanningStatusCode OperationPlanningStatusCode 1
OpLtstSchedldProcgStrtDte OpLtstSchedldProcgStrtDte 1
OpLtstSchedldProcgStrtTme OpLtstSchedldProcgStrtTme 1
OpLtstSchedldTrdwnStrtDte OpLtstSchedldTrdwnStrtDte 1
OpLtstSchedldTrdwnStrtTme OpLtstSchedldTrdwnStrtTme 1
OrderCategory OrderCategory 1
OrderFirmingStatusCode OrderFirmingStatusCode 1
OrderInternalID OrderInternalID 1
OrderPlannedTotalQty OrderPlannedTotalQty 1
OrderStatusCode OrderStatusCode 1
OrderType OrderType 1
ProductionVersion ProductionVersion 1
RemainingCapReqOpSegProcgDurn RemainingCapReqOpSegProcgDurn 1
RemainingCapReqOpSegSetupDurn RemainingCapReqOpSegSetupDurn 1
RemainingCapReqOpSegTrdwnDurn RemainingCapReqOpSegTrdwnDurn 1
WorkCenterAvailableCapacity WorkCenterAvailableCapacity 1
WorkCenterCapacityUnit WorkCenterCapacityUnit 1
WorkCenterCapRqmtInCapUnit WorkCenterCapRqmtInCapUnit 1
WorkCenterCategoryCode WorkCenterCategoryCode 1
WorkCenterResponsible WorkCenterResponsible 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_WORKCENTERCALCDFIELD (
    CAPACITYCATEGORYALLOCATION,
    CAPACITYEVALUATIONTIMEPERIOD,
    CAPACITYINTERNALID,
    MATERIAL,
    MRPCONTROLLER,
    OPERATION,
    ORDERID,
    PLANT,
    SHIFTNAME,
    WORKCENTER,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    BASEUNIT,
    CAPACITYENDTIME,
    CAPACITYREQUIREMENTORIGIN,
    CAPACITYREQUIREMENTUNIT,
    CAPACITYSTARTTIME,
    FACTORYCALENDAR,
    OPERATIONLATESTENDDATE,
    OPERATIONLATESTENDTIME,
    OPERATIONLATESTSTARTDATE,
    OPERATIONLATESTSTARTTIME,
    OPERATIONPLANNINGSTATUSCODE,
    OPLTSTSCHEDLDPROCGSTRTDTE,
    OPLTSTSCHEDLDPROCGSTRTTME,
    OPLTSTSCHEDLDTRDWNSTRTDTE,
    OPLTSTSCHEDLDTRDWNSTRTTME,
    ORDERCATEGORY,
    ORDERFIRMINGSTATUSCODE,
    ORDERINTERNALID,
    ORDERPLANNEDTOTALQTY,
    ORDERSTATUSCODE,
    ORDERTYPE,
    PRODUCTIONVERSION,
    REMAININGCAPREQOPSEGPROCGDURN,
    REMAININGCAPREQOPSEGSETUPDURN,
    REMAININGCAPREQOPSEGTRDWNDURN,
    WORKCENTERAVAILABLECAPACITY,
    WORKCENTERCAPACITYUNIT,
    WORKCENTERCAPRQMTINCAPUNIT,
    WORKCENTERCATEGORYCODE,
    WORKCENTERRESPONSIBLE,
    PRIMARY KEY (CAPACITYCATEGORYALLOCATION, CAPACITYEVALUATIONTIMEPERIOD, CAPACITYINTERNALID, MATERIAL, MRPCONTROLLER, OPERATION, ORDERID, PLANT, SHIFTNAME, WORKCENTER, WORKCENTERINTERNALID, WORKCENTERTYPECODE)
);

Learn More