WRKCTRCAPPPLINEOP

39 Fields

WRKCTRCAPPPLINEOP is an SAP database table in S/4HANA. It contains 39 fields.

Fields (39)

KeyField CDS FieldsUsed in Views
KEY CapacityCategoryAllocation CapacityCategoryAllocation 1
KEY CapacityInternalID CapacityInternalID 2
KEY CapacityRequirement CapacityRequirement 3
KEY Material Material 3
KEY MRPController MRPController 3
KEY Operation Operation 3
KEY OrderID OrderID 3
KEY Plant Plant 3
KEY WorkCenter WorkCenter 2
KEY WorkCenterInternalID WorkCenterInternalID 2
KEY WorkCenterTypeCode WorkCenterTypeCode 1
BaseUnit BaseUnit 2
CapacityRequirementOrigin CapacityRequirementOrigin 3
CapacityRequirementsAreDtmnd CapacityRequirementsAreDtmnd,RemainingCapReqExecutionDurn 3
CapacityRequirementUnit CapacityRequirementUnit 3
OperationLatestEndDate OperationLatestEndDate 2
OperationLatestEndTime OperationLatestEndTime 2
OperationLatestStartDate OperationLatestStartDate 2
OperationLatestStartTime OperationLatestStartTime 2
OperationPlanningStatusCode OperationPlanningStatusCode 3
OpLtstSchedldExecEndTme OpLtstSchedldExecEndTme 2
OpLtstSchedldExecStrtTme OpLtstSchedldExecStrtTme 2
OpLtstSchedldProcgStrtDte OpLtstSchedldProcgStrtDte 2
OpLtstSchedldProcgStrtTme OpLtstSchedldProcgStrtTme 2
OpLtstSchedldTrdwnStrtDte OpLtstSchedldTrdwnStrtDte 2
OpLtstSchedldTrdwnStrtTme OpLtstSchedldTrdwnStrtTme 2
OrderCategory OrderCategory 3
OrderFirmingStatusCode OrderFirmingStatusCode 2
OrderInternalID OrderInternalID 3
OrderPlannedTotalQty OrderPlannedTotalQty 3
OrderStatusCode OrderStatusCode 3
OrderType OrderType 3
ProductionVersion ProductionVersion 3
RemainingCapReqOpSegProcgDurn RemainingCapReqOpSegProcgDurn 3
RemainingCapReqOpSegSetupDurn RemainingCapReqOpSegSetupDurn 3
RemainingCapReqOpSegTrdwnDurn RemainingCapReqOpSegTrdwnDurn 3
TotRequirementInSeconds TotRequirementInSeconds 1
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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WRKCTRCAPPPLINEOP (
    CAPACITYCATEGORYALLOCATION,
    CAPACITYINTERNALID,
    CAPACITYREQUIREMENT,
    MATERIAL,
    MRPCONTROLLER,
    OPERATION,
    ORDERID,
    PLANT,
    WORKCENTER,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    BASEUNIT,
    CAPACITYREQUIREMENTORIGIN,
    CAPACITYREQUIREMENTSAREDTMND,
    CAPACITYREQUIREMENTUNIT,
    OPERATIONLATESTENDDATE,
    OPERATIONLATESTENDTIME,
    OPERATIONLATESTSTARTDATE,
    OPERATIONLATESTSTARTTIME,
    OPERATIONPLANNINGSTATUSCODE,
    OPLTSTSCHEDLDEXECENDTME,
    OPLTSTSCHEDLDEXECSTRTTME,
    OPLTSTSCHEDLDPROCGSTRTDTE,
    OPLTSTSCHEDLDPROCGSTRTTME,
    OPLTSTSCHEDLDTRDWNSTRTDTE,
    OPLTSTSCHEDLDTRDWNSTRTTME,
    ORDERCATEGORY,
    ORDERFIRMINGSTATUSCODE,
    ORDERINTERNALID,
    ORDERPLANNEDTOTALQTY,
    ORDERSTATUSCODE,
    ORDERTYPE,
    PRODUCTIONVERSION,
    REMAININGCAPREQOPSEGPROCGDURN,
    REMAININGCAPREQOPSEGSETUPDURN,
    REMAININGCAPREQOPSEGTRDWNDURN,
    TOTREQUIREMENTINSECONDS,
    WORKCENTERCATEGORYCODE,
    WORKCENTERRESPONSIBLE,
    PRIMARY KEY (CAPACITYCATEGORYALLOCATION, CAPACITYINTERNALID, CAPACITYREQUIREMENT, MATERIAL, MRPCONTROLLER, OPERATION, ORDERID, PLANT, WORKCENTER, WORKCENTERINTERNALID, WORKCENTERTYPECODE)
);

Learn More