I_MFGORDEROPERATIONCONF

CDS View
113 Fields 6 CDS Views

Manufacturing Order Operation Confirmation

I_MFGORDEROPERATIONCONF is a CDS View in S/4HANA. Manufacturing Order Operation Confirmation. It contains 113 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_Operationconfirmations view_entity from CONSUMPTION Operation Confirmations
I_MfgOrderConfObjPgQtSum view_entity union COMPOSITE Manufacturing order confirmation Quantity Sum
I_MfgOrderObjPgOpConfQty view_entity from COMPOSITE Today Operation Confirmed Quantity
I_MfgOrderOperationConfCube view from COMPOSITE Manufacturing Order Operation Confirmation - Cube
I_MfgOrderOperationConfOper view from COMPOSITE Mfg Order Operation Confirmation with Operation Details
P_MfgOrdOperConfObjPgQtSum view_entity from COMPOSITE Manufacturing order confirmation Quantity Sum

Fields (113)

KeyField CDS FieldsUsed in Views
KEY ManufacturingOrder ManufacturingOrder,ProductionOrder 5
KEY ManufacturingOrderCategory ManufacturingOrderCategory,OrderCategory 3
KEY ManufacturingOrderOperation ManufacturingOrderOperation,Operation 3
KEY MfgOrderConfirmation MfgOrderConfirmation 3
KEY MfgOrderConfirmationCount MfgOrderConfirmationCount 3
_BusinessArea _BusinessArea 2
_BusinessProcess _BusinessProcess 2
_Capacity _Capacity 2
_CompanyCode _CompanyCode 2
_ConfirmationGroup _ConfirmationGroup 4
_ConfirmationUnit _ConfirmationUnit 2
_ControllingArea _ControllingArea 2
_Employee _Employee 1
_EmployeeSuitability _EmployeeSuitability 2
_EmployeeWageGroup _EmployeeWageGroup 2
_Language _Language 2
_ManufacturingOrder _ManufacturingOrder 2
_MfgOrder _MfgOrder 4
_MfgOrderCategory _MfgOrderCategory 2
_MfgOrderOperation _MfgOrderOperation 2
_MfgOrderSequence _MfgOrderSequence 2
_MfgOrderType _MfgOrderType 4
_MRPController _MRPController 2
_OrderInternalID _OrderInternalID 2
_OrdInternalBillOfOperations _OrdInternalBillOfOperations 2
_Plant _Plant 2
_ProductCostCollector _ProductCostCollector 2
_ProductionPlant _ProductionPlant 4
_ProductionSupervisor _ProductionSupervisor 2
_ProfitCenter _ProfitCenter 2
_User _User 2
_VarianceReason _VarianceReason 2
_WorkCenter _WorkCenter 2
_WorkCenterType _WorkCenterType 2
BusinessArea BusinessArea 2
BusinessProcess BusinessProcess 2
BusinessProcessConfirmedQty BusinessProcessConfirmedQty 2
BusinessProcessEntryUnit BusinessProcessEntryUnit 2
BusinessProcessRemainingQty BusinessProcessRemainingQty 2
BusinessProcRemainingQtyUnit BusinessProcRemainingQtyUnit 2
CancldMfgOrderOpConfCount CancldMfgOrderOpConfCount 2
CapacityInternalID CapacityInternalID 2
CapacityRequirementSplit CapacityRequirementSplit 2
CompanyCode CompanyCode 2
ConfirmationExternalEntryDate ConfirmationExternalEntryDate 2
ConfirmationExternalEntryTime ConfirmationExternalEntryTime 2
ConfirmationReworkQuantity ConfirmationReworkQuantity 2
ConfirmationScrapQuantity ConfirmationScrapQuantity 2
ConfirmationText ConfirmationText 2
ConfirmationTotalQuantity ConfirmationTotalQuantity 2
ConfirmationUnit ConfirmationUnit 4
ConfirmationYieldQuantity ConfirmationYieldQuantity 2
ConfirmedExecutionEndDate ConfirmedExecutionEndDate 2
ConfirmedExecutionStartDate ConfirmedExecutionStartDate 2
ControllingArea ControllingArea 2
EmployeeSuitability EmployeeSuitability 2
EmployeeWageGroup EmployeeWageGroup 2
EmployeeWageType EmployeeWageType 2
EnteredByExternalUser EnteredByExternalUser 2
EnteredByUser EnteredByUser 2
IsConfirmedByMilestoneConf IsConfirmedByMilestoneConf 2
IsFinalConfirmation IsFinalConfirmation 2
IsReversal IsReversal 2
IsReversed IsReversed 2
Language Language 2
LastChangeDate LastChangeDate 2
LastChangedByUser LastChangedByUser 2
ManufacturingOrderOperation_2 ManufacturingOrderOperation_2 2
ManufacturingOrderSequence ManufacturingOrderSequence 2
ManufacturingOrderType ManufacturingOrderType 4
MfgOrderConfirmationEntryDate MfgOrderConfirmationEntryDate 2
MfgOrderConfirmationEntryTime MfgOrderConfirmationEntryTime 2
MfgOrderConfirmedReworkQty MfgOrderConfirmedReworkQty 1
MfgOrderConfirmedScrapQty MfgOrderConfirmedScrapQty 1
MfgOrderConfirmedTotalQty MfgOrderConfirmedTotalQty 1
MfgOrderConfirmedYieldQty MfgOrderConfirmedYieldQty 1
MilestoneConfirmationType MilestoneConfirmationType 2
MilestoneIsConfirmed MilestoneIsConfirmed 2
MRPController MRPController 2
NoFurtherBusinessProcQtyIsExpd NoFurtherBusinessProcQtyIsExpd 2
NoFurtherOpWorkQuantity1IsExpd NoFurtherOpWorkQuantity1IsExpd 2
NoFurtherOpWorkQuantity2IsExpd NoFurtherOpWorkQuantity2IsExpd 2
NoFurtherOpWorkQuantity3IsExpd NoFurtherOpWorkQuantity3IsExpd 2
NoFurtherOpWorkQuantity4IsExpd NoFurtherOpWorkQuantity4IsExpd 2
NoFurtherOpWorkQuantity5IsExpd NoFurtherOpWorkQuantity5IsExpd 2
NoFurtherOpWorkQuantity6IsExpd NoFurtherOpWorkQuantity6IsExpd 2
NumberOfEmployees NumberOfEmployees 2
OpConfirmedWorkQuantity1 OpConfirmedWorkQuantity1 2
OpConfirmedWorkQuantity2 OpConfirmedWorkQuantity2 2
OpConfirmedWorkQuantity3 OpConfirmedWorkQuantity3 2
OpConfirmedWorkQuantity4 OpConfirmedWorkQuantity4 2
OpConfirmedWorkQuantity5 OpConfirmedWorkQuantity5 2
OpConfirmedWorkQuantity6 OpConfirmedWorkQuantity6 2
OpenReservationsIsCleared OpenReservationsIsCleared 2
OpWorkQuantityUnit1 OpWorkQuantityUnit1 2
OpWorkQuantityUnit2 OpWorkQuantityUnit2 2
OpWorkQuantityUnit3 OpWorkQuantityUnit3 2
OpWorkQuantityUnit4 OpWorkQuantityUnit4 2
OpWorkQuantityUnit5 OpWorkQuantityUnit5 2
OpWorkQuantityUnit6 OpWorkQuantityUnit6 2
OrderIntBillOfOperationsItem OrderIntBillOfOperationsItem 2
OrderInternalBillOfOperations OrderInternalBillOfOperations 2
Personnel Personnel 1
Plant Plant 2
PostingDate PostingDate 2
ProductCostCollector ProductCostCollector 2
ProductionPlant ProductionPlant 4
ProductionSupervisor ProductionSupervisor 2
ProductionUnit ConfirmedQuantityUnit 1
TimeRecording TimeRecording 2
VarianceReasonCode VarianceReasonCode 2
WorkCenterInternalID WorkCenterInternalID 2
WorkCenterTypeCode WorkCenterTypeCode 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.

-- Manufacturing Order Operation Confirmation
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MFGORDEROPERATIONCONF (
    MANUFACTURINGORDER,
    MANUFACTURINGORDERCATEGORY,
    MANUFACTURINGORDEROPERATION,
    MFGORDERCONFIRMATION,
    MFGORDERCONFIRMATIONCOUNT,
    _BUSINESSAREA,
    _BUSINESSPROCESS,
    _CAPACITY,
    _COMPANYCODE,
    _CONFIRMATIONGROUP,
    _CONFIRMATIONUNIT,
    _CONTROLLINGAREA,
    _EMPLOYEE,
    _EMPLOYEESUITABILITY,
    _EMPLOYEEWAGEGROUP,
    _LANGUAGE,
    _MANUFACTURINGORDER,
    _MFGORDER,
    _MFGORDERCATEGORY,
    _MFGORDEROPERATION,
    _MFGORDERSEQUENCE,
    _MFGORDERTYPE,
    _MRPCONTROLLER,
    _ORDERINTERNALID,
    _ORDINTERNALBILLOFOPERATIONS,
    _PLANT,
    _PRODUCTCOSTCOLLECTOR,
    _PRODUCTIONPLANT,
    _PRODUCTIONSUPERVISOR,
    _PROFITCENTER,
    _USER,
    _VARIANCEREASON,
    _WORKCENTER,
    _WORKCENTERTYPE,
    BUSINESSAREA,
    BUSINESSPROCESS,
    BUSINESSPROCESSCONFIRMEDQTY,
    BUSINESSPROCESSENTRYUNIT,
    BUSINESSPROCESSREMAININGQTY,
    BUSINESSPROCREMAININGQTYUNIT,
    CANCLDMFGORDEROPCONFCOUNT,
    CAPACITYINTERNALID,
    CAPACITYREQUIREMENTSPLIT,
    COMPANYCODE,
    CONFIRMATIONEXTERNALENTRYDATE,
    CONFIRMATIONEXTERNALENTRYTIME,
    CONFIRMATIONREWORKQUANTITY,
    CONFIRMATIONSCRAPQUANTITY,
    CONFIRMATIONTEXT,
    CONFIRMATIONTOTALQUANTITY,
    CONFIRMATIONUNIT,
    CONFIRMATIONYIELDQUANTITY,
    CONFIRMEDEXECUTIONENDDATE,
    CONFIRMEDEXECUTIONSTARTDATE,
    CONTROLLINGAREA,
    EMPLOYEESUITABILITY,
    EMPLOYEEWAGEGROUP,
    EMPLOYEEWAGETYPE,
    ENTEREDBYEXTERNALUSER,
    ENTEREDBYUSER,
    ISCONFIRMEDBYMILESTONECONF,
    ISFINALCONFIRMATION,
    ISREVERSAL,
    ISREVERSED,
    LANGUAGE,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    MANUFACTURINGORDEROPERATION_2,
    MANUFACTURINGORDERSEQUENCE,
    MANUFACTURINGORDERTYPE,
    MFGORDERCONFIRMATIONENTRYDATE,
    MFGORDERCONFIRMATIONENTRYTIME,
    MFGORDERCONFIRMEDREWORKQTY,
    MFGORDERCONFIRMEDSCRAPQTY,
    MFGORDERCONFIRMEDTOTALQTY,
    MFGORDERCONFIRMEDYIELDQTY,
    MILESTONECONFIRMATIONTYPE,
    MILESTONEISCONFIRMED,
    MRPCONTROLLER,
    NOFURTHERBUSINESSPROCQTYISEXPD,
    NOFURTHEROPWORKQUANTITY1ISEXPD,
    NOFURTHEROPWORKQUANTITY2ISEXPD,
    NOFURTHEROPWORKQUANTITY3ISEXPD,
    NOFURTHEROPWORKQUANTITY4ISEXPD,
    NOFURTHEROPWORKQUANTITY5ISEXPD,
    NOFURTHEROPWORKQUANTITY6ISEXPD,
    NUMBEROFEMPLOYEES,
    OPCONFIRMEDWORKQUANTITY1,
    OPCONFIRMEDWORKQUANTITY2,
    OPCONFIRMEDWORKQUANTITY3,
    OPCONFIRMEDWORKQUANTITY4,
    OPCONFIRMEDWORKQUANTITY5,
    OPCONFIRMEDWORKQUANTITY6,
    OPENRESERVATIONSISCLEARED,
    OPWORKQUANTITYUNIT1,
    OPWORKQUANTITYUNIT2,
    OPWORKQUANTITYUNIT3,
    OPWORKQUANTITYUNIT4,
    OPWORKQUANTITYUNIT5,
    OPWORKQUANTITYUNIT6,
    ORDERINTBILLOFOPERATIONSITEM,
    ORDERINTERNALBILLOFOPERATIONS,
    PERSONNEL,
    PLANT,
    POSTINGDATE,
    PRODUCTCOSTCOLLECTOR,
    PRODUCTIONPLANT,
    PRODUCTIONSUPERVISOR,
    PRODUCTIONUNIT,
    TIMERECORDING,
    VARIANCEREASONCODE,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    PRIMARY KEY (MANUFACTURINGORDER, MANUFACTURINGORDERCATEGORY, MANUFACTURINGORDEROPERATION, MFGORDERCONFIRMATION, MFGORDERCONFIRMATIONCOUNT)
);

Learn More