P_WORKCENTERCAPPPLINEOP

CDS View
48 Fields 4 CDS Views

Load day opr for manufacturing and planned order for Cap

P_WORKCENTERCAPPPLINEOP is a CDS View in S/4HANA. Load day opr for manufacturing and planned order for Cap. It contains 48 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_WorkCenterCapPplineOp view from COMPOSITE Load all opr for manufacturing and planned order for Cap
P_CapOpMaxMinDte view from COMPOSITE Maximum and Minimum Date for Operations of Workcenter
P_WrkCtrCapOpDateRange view from COMPOSITE Work Center operations in given date range
P_WRKCTRCAPREQSINSECS view from COMPOSITE Work Center operations in given date range

Fields (48)

KeyField CDS FieldsUsed in Views
KEY CapacityCategoryAllocation CapacityCategoryAllocation 3
KEY CapacityInternalID CapacityInternalID 3
KEY CapacityRequirement CapacityRequirement 3
KEY CapacityRequirementItem CapacityRequirementItem 2
KEY Material Material 3
KEY Operation Operation 3
KEY OrderID OrderID 3
KEY WorkCenterInternalID WorkCenterInternalID 3
KEY WorkCenterTypeCode WorkCenterTypeCode 3
BaseUnit BaseUnit 3
CapacityBaseQtyUnit CapacityBaseQtyUnit 1
CapacityRequirementOrigin CapacityRequirementOrigin 3
CapacityRequirementsAreDtmnd CapacityRequirementsAreDtmnd 2
CapacityRequirementUnit CapacityRequirementUnit 3
MRPController MRPController 3
OperationLatestEndDate OperationLatestEndDate 2
OperationLatestEndDateTime OperationLatestEndDateTime 1
OperationLatestEndTime OperationLatestEndTime 2
OperationLatestStartDate OperationLatestStartDate 2
OperationLatestStartDateTime OperationLatestStartDateTime 1
OperationLatestStartTime OperationLatestStartTime 2
OperationPlanningStatusCode OperationPlanningStatusCode 3
OperationText OperationText 1
OpLtstSchedldExecEndTme OpLtstSchedldExecEndTme 2
OpLtstSchedldExecStrtTme OpLtstSchedldExecStrtTme 2
OpLtstSchedldProcgStrtDte OpLtstSchedldProcgStrtDte 3
OpLtstSchedldProcgStrtTme OpLtstSchedldProcgStrtTme 3
OpLtstSchedldTrdwnStrtDte OpLtstSchedldTrdwnStrtDte 3
OpLtstSchedldTrdwnStrtTme OpLtstSchedldTrdwnStrtTme 3
OrderCategory OrderCategory 3
OrderFirmingStatusCode OrderFirmingStatusCode 3
OrderInternalID OrderInternalID 3
OrderPlannedTotalQty OrderPlannedTotalQty 3
OrderStatusCode OrderStatusCode 3
OrderType OrderType 3
Plant Plant 3
PlantTimeZone PlantTimeZone 2
ProductConfiguration ProductConfiguration 1
ProductionVersion ProductionVersion 3
RemainingCapReqOpSegProcgDurn RemainingCapReqOpSegProcgDurn 3
RemainingCapReqOpSegSetupDurn RemainingCapReqOpSegSetupDurn 3
RemainingCapReqOpSegTrdwnDurn RemainingCapReqOpSegTrdwnDurn 3
SalesOrder SalesOrder 1
SalesOrderItem SalesOrderItem 1
Sequence Sequence 2
WorkCenter WorkCenter 3
WorkCenterCategoryCode WorkCenterCategoryCode 3
WorkCenterResponsible WorkCenterResponsible 3

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.

-- Load day opr for manufacturing and planned order for Cap
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_WORKCENTERCAPPPLINEOP (
    CAPACITYCATEGORYALLOCATION,
    CAPACITYINTERNALID,
    CAPACITYREQUIREMENT,
    CAPACITYREQUIREMENTITEM,
    MATERIAL,
    OPERATION,
    ORDERID,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    BASEUNIT,
    CAPACITYBASEQTYUNIT,
    CAPACITYREQUIREMENTORIGIN,
    CAPACITYREQUIREMENTSAREDTMND,
    CAPACITYREQUIREMENTUNIT,
    MRPCONTROLLER,
    OPERATIONLATESTENDDATE,
    OPERATIONLATESTENDDATETIME,
    OPERATIONLATESTENDTIME,
    OPERATIONLATESTSTARTDATE,
    OPERATIONLATESTSTARTDATETIME,
    OPERATIONLATESTSTARTTIME,
    OPERATIONPLANNINGSTATUSCODE,
    OPERATIONTEXT,
    OPLTSTSCHEDLDEXECENDTME,
    OPLTSTSCHEDLDEXECSTRTTME,
    OPLTSTSCHEDLDPROCGSTRTDTE,
    OPLTSTSCHEDLDPROCGSTRTTME,
    OPLTSTSCHEDLDTRDWNSTRTDTE,
    OPLTSTSCHEDLDTRDWNSTRTTME,
    ORDERCATEGORY,
    ORDERFIRMINGSTATUSCODE,
    ORDERINTERNALID,
    ORDERPLANNEDTOTALQTY,
    ORDERSTATUSCODE,
    ORDERTYPE,
    PLANT,
    PLANTTIMEZONE,
    PRODUCTCONFIGURATION,
    PRODUCTIONVERSION,
    REMAININGCAPREQOPSEGPROCGDURN,
    REMAININGCAPREQOPSEGSETUPDURN,
    REMAININGCAPREQOPSEGTRDWNDURN,
    SALESORDER,
    SALESORDERITEM,
    SEQUENCE,
    WORKCENTER,
    WORKCENTERCATEGORYCODE,
    WORKCENTERRESPONSIBLE,
    PRIMARY KEY (CAPACITYCATEGORYALLOCATION, CAPACITYINTERNALID, CAPACITYREQUIREMENT, CAPACITYREQUIREMENTITEM, MATERIAL, OPERATION, ORDERID, WORKCENTERINTERNALID, WORKCENTERTYPECODE)
);

Learn More