A_WORKCENTERCAPPPLINEOP

CDS View
37 Fields 1 CDS Views

Queued Operations Capacity

A_WORKCENTERCAPPPLINEOP is a CDS View in S/4HANA. Queued Operations Capacity. It contains 37 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_WorkCenterCapDayOp view from COMPOSITE Daily Operations Capacity

Fields (37)

KeyField CDS FieldsUsed in Views
KEY CapacityInternalID CapacityInternalID 1
KEY CapacityRequirement CapacityRequirement 1
KEY Material Material 1
KEY MRPController MRPController 1
KEY Operation Operation 1
KEY OrderID OrderID 1
KEY Plant Plant 1
KEY WorkCenter WorkCenter 1
BaseUnit BaseUnit 1
CapacityRequirementOrigin CapacityRequirementOrigin 1
CapacityRequirementsAreDtmnd CapacityRequirementsAreDtmnd 1
CapacityRequirementUnit CapacityRequirementUnit 1
OperationLatestEndDate OperationLatestEndDate 1
OperationLatestEndTime OperationLatestEndTime 1
OperationLatestStartDate OperationLatestStartDate 1
OperationLatestStartTime OperationLatestStartTime 1
OperationPlanningStatusCode OperationPlanningStatusCode 1
OperationPlanningStatusText OperationPlanningStatusText 1
OpLtstSchedldProcgStrtDte OpLtstSchedldProcgStrtDte 1
OpLtstSchedldProcgStrtTme OpLtstSchedldProcgStrtTme 1
OpLtstSchedldTrdwnStrtDte OpLtstSchedldTrdwnStrtDte 1
OpLtstSchedldTrdwnStrtTme OpLtstSchedldTrdwnStrtTme 1
OrderFirmingStatusText OrderFirmingStatusText 1
OrderInternalID OrderInternalID 1
OrderPlannedTotalQty OrderPlannedTotalQty 1
OrderStatusCode OrderStatusCode 1
OrderStatusText OrderStatusText 1
OrderType OrderType 1
OrderTypeName OrderTypeName 1
ProductionVersion ProductionVersion 1
RemainingCapReqOpSegProcgDurn RemainingCapReqOpSegProcgDurn 1
RemainingCapReqOpSegSetupDurn RemainingCapReqOpSegSetupDurn 1
RemainingCapReqOpSegTrdwnDurn RemainingCapReqOpSegTrdwnDurn 1
WorkCenterCategoryCode WorkCenterCategoryCode 1
WorkCenterDesc WorkCenterDesc 1
WorkCenterInternalID WorkCenterInternalID 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.

-- Queued Operations Capacity
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE A_WORKCENTERCAPPPLINEOP (
    CAPACITYINTERNALID,
    CAPACITYREQUIREMENT,
    MATERIAL,
    MRPCONTROLLER,
    OPERATION,
    ORDERID,
    PLANT,
    WORKCENTER,
    BASEUNIT,
    CAPACITYREQUIREMENTORIGIN,
    CAPACITYREQUIREMENTSAREDTMND,
    CAPACITYREQUIREMENTUNIT,
    OPERATIONLATESTENDDATE,
    OPERATIONLATESTENDTIME,
    OPERATIONLATESTSTARTDATE,
    OPERATIONLATESTSTARTTIME,
    OPERATIONPLANNINGSTATUSCODE,
    OPERATIONPLANNINGSTATUSTEXT,
    OPLTSTSCHEDLDPROCGSTRTDTE,
    OPLTSTSCHEDLDPROCGSTRTTME,
    OPLTSTSCHEDLDTRDWNSTRTDTE,
    OPLTSTSCHEDLDTRDWNSTRTTME,
    ORDERFIRMINGSTATUSTEXT,
    ORDERINTERNALID,
    ORDERPLANNEDTOTALQTY,
    ORDERSTATUSCODE,
    ORDERSTATUSTEXT,
    ORDERTYPE,
    ORDERTYPENAME,
    PRODUCTIONVERSION,
    REMAININGCAPREQOPSEGPROCGDURN,
    REMAININGCAPREQOPSEGSETUPDURN,
    REMAININGCAPREQOPSEGTRDWNDURN,
    WORKCENTERCATEGORYCODE,
    WORKCENTERDESC,
    WORKCENTERINTERNALID,
    WORKCENTERRESPONSIBLE,
    PRIMARY KEY (CAPACITYINTERNALID, CAPACITYREQUIREMENT, MATERIAL, MRPCONTROLLER, OPERATION, ORDERID, PLANT, WORKCENTER)
);

Learn More