P_PROCORDOPERATIONWITHSTATUS

CDS View
27 Fields 3 CDS Views

Process Order operations with status

P_PROCORDOPERATIONWITHSTATUS is a CDS View in S/4HANA. Process Order operations with status. It contains 27 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_ProcOrdOpsMgmtAllOperations view from COMPOSITE Process Order Operations All Operations
I_ProcOrdOpsMgmtAllOperations view inner COMPOSITE Process Order Operations All Operations
P_ProcOrdMgmtOperationCalc view from COMPOSITE Process Order Operation Calculations

Fields (27)

KeyField CDS FieldsUsed in Views
KEY MfgOrderInternalID OrderInternalBillOfOperations 1
KEY OrderOperationInternalID OrderIntBillOfOperationsItem,OrderOperationInternalID 1
ManufacturingOrder ProcessOrder 1
ManufacturingOrderCategory ManufacturingOrderCategory 1
ManufacturingOrderSequence ManufacturingOrderSequence 1
ManufacturingOrderType ManufacturingOrderType 1
Material Material 1
MaterialName MaterialName 1
MfgOrderOperationIsPhase MfgOrderOperationIsPhase 1
MRPController MRPController 1
OperationIsConfirmed OperationIsConfirmed 1
OperationIsInterrupted OperationIsInterrupted 1
OperationUnit OperationUnit 1
OpPlannedTotalQuantity OpPlannedTotalQuantity 1
PlannedActualEndDateDvtnDurn PlannedActualEndDateDvtnDurn 1
PlannedActualStartDateDvtnDurn PlannedActualStartDateDvtnDurn 1
PlannedCurrentEndDateDvtnDurn PlannedCurrentEndDateDvtnDurn 1
PlannedCurrentStrtDateDvtnDurn PlannedCurrentStrtDateDvtnDurn 1
ProcOrdOpActualEndDateTime ProcOrdOpActualEndDateTime 1
ProcOrdOpActualStartDateTime ProcOrdOpActualStartDateTime 1
ProcOrdOpSchedldEndDateTime ProcOrdOpSchedldEndDateTime 1
ProcOrdOpSchedldStartDateTime ProcOrdOpSchedldStartDateTime 1
ProductionPlant ProductionPlant 1
ProductionSupervisor ProductionSupervisor 1
WorkCenter WorkCenter 1
WorkCenterInternalID WorkCenterInternalID 1
WorkCenterText WorkCenterText 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.

-- Process Order operations with status
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_PROCORDOPERATIONWITHSTATUS (
    MFGORDERINTERNALID,
    ORDEROPERATIONINTERNALID,
    MANUFACTURINGORDER,
    MANUFACTURINGORDERCATEGORY,
    MANUFACTURINGORDERSEQUENCE,
    MANUFACTURINGORDERTYPE,
    MATERIAL,
    MATERIALNAME,
    MFGORDEROPERATIONISPHASE,
    MRPCONTROLLER,
    OPERATIONISCONFIRMED,
    OPERATIONISINTERRUPTED,
    OPERATIONUNIT,
    OPPLANNEDTOTALQUANTITY,
    PLANNEDACTUALENDDATEDVTNDURN,
    PLANNEDACTUALSTARTDATEDVTNDURN,
    PLANNEDCURRENTENDDATEDVTNDURN,
    PLANNEDCURRENTSTRTDATEDVTNDURN,
    PROCORDOPACTUALENDDATETIME,
    PROCORDOPACTUALSTARTDATETIME,
    PROCORDOPSCHEDLDENDDATETIME,
    PROCORDOPSCHEDLDSTARTDATETIME,
    PRODUCTIONPLANT,
    PRODUCTIONSUPERVISOR,
    WORKCENTER,
    WORKCENTERINTERNALID,
    WORKCENTERTEXT,
    PRIMARY KEY (MFGORDERINTERNALID, ORDEROPERATIONINTERNALID)
);

Learn More