I_MFGORDERCONFIRMATION

CDS View
97 Fields 13 CDS Views

Manufacturing Order Confirmation

I_MFGORDERCONFIRMATION is a CDS View in S/4HANA. Manufacturing Order Confirmation. It contains 97 fields. 13 CDS views read from this table.

CDS Views using this table (13)

ViewTypeJoinVDMDescription
A_ProcOrdConfirmation_2 view_entity from COMPOSITE Process Order Confirmation
A_ProductionOrderConf_2 view_entity from COMPOSITE Production Order Confirmation
C_MfgOrderConfirmation view_entity from CONSUMPTION Manufacturing Order Confirmation
ESH_N_PROCESSORDERCONF view from
ESH_N_PRODNORDERCONF view from
I_MfgOrderConfMatlDocItem view from COMPOSITE Material Document Items of Mfg Order Confirmation
I_MfgOrderConfMatlDocItem view union_all COMPOSITE Material Document Items of Mfg Order Confirmation
I_MfgOrderObjPgConfAll view_entity from COMPOSITE Manufacturing order confirmations
I_ProcOrdMgmtConfirmation view from COMPOSITE Process Order Confirmation
I_ProcOrdOpsMgmtConfirmation view from COMPOSITE Process order operation confirmations
P_ProcOrdOpLatestConfAggrgn view from COMPOSITE
R_ProcessOrderConfirmationTP view_entity from TRANSACTIONAL Process Order Confirmation
R_ProductionOrdConfirmationTP view_entity from TRANSACTIONAL Production Order Confirmation

Fields (97)

KeyField CDS FieldsUsed in Views
KEY MfgOrderConfirmation ConfirmationCount,MfgOrderConfirmation 5
KEY MfgOrderConfirmationGroup ConfirmationGroup,MfgOrderConfirmationGroup 5
_ConfirmationGroup _ConfirmationGroup 1
_FinalConfirmationType _FinalConfirmationType 1
_MfgOrderCategory _MfgOrderCategory 1
_MfgOrderOperation _MfgOrderOperation 1
_MfgOrderOperation2 _MfgOrderOperation2 1
_MfgOrderType _MfgOrderType 1
_Plant _ConfirmationPlant 1
_ReversalIndicator _ReversalIndicator 1
_ReversedIndicator _ReversedIndicator 1
APIConfHasNoGoodsMovements APIConfHasNoGoodsMovements 4
BreakDurationUnit BreakDurationUnit 4
BusinessProcessConfirmedQty BusinessProcessConfirmedQty 4
BusinessProcessEntryUnit BusinessProcessEntryUnit 4
CapacityRequirementSplit CapacityRequirementSplit 2
ConfirmationExternalEntryDate ConfirmationExternalEntryDate 4
ConfirmationExternalEntryTime ConfirmationExternalEntryTime 4
ConfirmationReworkQuantity ConfirmationReworkQuantity 3
ConfirmationScrapQuantity ConfirmationScrapQuantity 4
ConfirmationText ConfirmationText 7
ConfirmationUnit ConfirmationUnit 4
ConfirmationYieldQuantity ConfirmationYieldQuantity 4
ConfirmedBreakDuration ConfirmedBreakDuration 4
ConfirmedExecutionEndDate ConfirmedExecutionEndDate 4
ConfirmedExecutionEndTime ConfirmedExecutionEndTime 4
ConfirmedExecutionStartDate ConfirmedExecutionStartDate 4
ConfirmedExecutionStartTime ConfirmedExecutionStartTime 4
ConfirmedProcessingEndDate ConfirmedProcessingEndDate 4
ConfirmedProcessingEndTime ConfirmedProcessingEndTime 4
ConfirmedProcessingStartDate ConfirmedProcessingStartDate 4
ConfirmedProcessingStartTime ConfirmedProcessingStartTime 4
ConfirmedSetupEndDate ConfirmedSetupEndDate 4
ConfirmedSetupEndTime ConfirmedSetupEndTime 4
ConfirmedTeardownStartDate ConfirmedTeardownStartDate 4
ConfirmedTeardownStartTime ConfirmedTeardownStartTime 4
ConfYieldQtyInProductionUnit ConfYieldQtyInProductionUnit 2
EmployeeSuitability EmployeeSuitability 4
EmployeeWageGroup EmployeeWageGroup 4
EmployeeWageType EmployeeWageType 4
EnteredByExternalUser EnteredByExternalUser 4
EnteredByUser EnteredByUser 4
ExternalSystemConfirmation ExternalSystemConfirmation 4
FinalConfirmationType FinalConfirmationType 5
IsFinalConfirmation IsFinalConfirmation 3
IsReversal IsReversal 5
IsReversed IsReversed 5
Language Language 6
LastChangeDate LastChangeDate 4
LastChangedByUser LastChangedByUser 4
ManufacturingOrder ManufacturingOrder,OrderID,ProcessOrder 7
ManufacturingOrderCategory ManufacturingOrderCategory 1
ManufacturingOrderOperation ManufacturingOrderOperation 1
ManufacturingOrderOperation_2 ManufacturingOrderOperation_2 1
ManufacturingOrderSequence ManufacturingOrderSequence,Sequence 3
ManufacturingOrderType ManufacturingOrderType,OrderType 7
MfgOrderConfirmationEntryDate ConfirmationEntryDate 4
MfgOrderConfirmationEntryTime ConfirmationEntryTime 4
NoFurtherBusinessProcQtyIsExpd NoFurtherBusinessProcQtyIsExpd 4
NoFurtherOpWorkQuantity1IsExpd NoFurtherOpWorkQuantity1IsExpd 4
NoFurtherOpWorkQuantity2IsExpd NoFurtherOpWorkQuantity2IsExpd 4
NoFurtherOpWorkQuantity3IsExpd NoFurtherOpWorkQuantity3IsExpd 4
NoFurtherOpWorkQuantity4IsExpd NoFurtherOpWorkQuantity4IsExpd 3
NoFurtherOpWorkQuantity5IsExpd NoFurtherOpWorkQuantity5IsExpd 4
NoFurtherOpWorkQuantity6IsExpd NoFurtherOpWorkQuantity6IsExpd 4
NumberOfEmployees NumberOfEmployees 4
OpConfirmedWorkQuantity1 OpConfirmedWorkQuantity1 6
OpConfirmedWorkQuantity2 OpConfirmedWorkQuantity2 6
OpConfirmedWorkQuantity3 OpConfirmedWorkQuantity3 6
OpConfirmedWorkQuantity4 OpConfirmedWorkQuantity4 6
OpConfirmedWorkQuantity5 OpConfirmedWorkQuantity5 6
OpConfirmedWorkQuantity6 OpConfirmedWorkQuantity6 6
OpenReservationsIsCleared OpenReservationsIsCleared 5
OperationUnit OperationUnit 2
OpPlannedTotalQuantity OpPlannedTotalQuantity 2
OpWorkQuantityUnit1 OpWorkQuantityUnit1 6
OpWorkQuantityUnit2 OpWorkQuantityUnit2 6
OpWorkQuantityUnit3 OpWorkQuantityUnit3 6
OpWorkQuantityUnit4 OpWorkQuantityUnit4 6
OpWorkQuantityUnit5 OpWorkQuantityUnit5 6
OpWorkQuantityUnit6 OpWorkQuantityUnit6 6
OrderConfirmationRecordType OrderConfirmationRecordType 4
OrderConfirmationType OrderConfirmationType 2
OrderInternalID OrderInternalBillOfOperations 2
OrderOperationInternalID OrderIntBillOfOperationsItem,OrderOperationInternalID 6
OriginalBatch OriginalBatch 2
Personnel Personnel 4
Plant ConfirmationPlant,Plant 7
PostingDate PostingDate 4
SenderCostCenter SenderCostCenter 2
ShiftDefinition ShiftDefinition 4
ShiftGrouping ShiftGrouping 4
SuperiorOperationInternalID SuperiorOperationInternalID 2
TimeRecording TimeRecording 4
VarianceReasonCode VarianceReasonCode 4
WorkCenterInternalID WorkCenterInternalID 2
WorkCenterTypeCode WorkCenterTypeCode 4

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 Confirmation
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MFGORDERCONFIRMATION (
    MFGORDERCONFIRMATION,
    MFGORDERCONFIRMATIONGROUP,
    _CONFIRMATIONGROUP,
    _FINALCONFIRMATIONTYPE,
    _MFGORDERCATEGORY,
    _MFGORDEROPERATION,
    _MFGORDEROPERATION2,
    _MFGORDERTYPE,
    _PLANT,
    _REVERSALINDICATOR,
    _REVERSEDINDICATOR,
    APICONFHASNOGOODSMOVEMENTS,
    BREAKDURATIONUNIT,
    BUSINESSPROCESSCONFIRMEDQTY,
    BUSINESSPROCESSENTRYUNIT,
    CAPACITYREQUIREMENTSPLIT,
    CONFIRMATIONEXTERNALENTRYDATE,
    CONFIRMATIONEXTERNALENTRYTIME,
    CONFIRMATIONREWORKQUANTITY,
    CONFIRMATIONSCRAPQUANTITY,
    CONFIRMATIONTEXT,
    CONFIRMATIONUNIT,
    CONFIRMATIONYIELDQUANTITY,
    CONFIRMEDBREAKDURATION,
    CONFIRMEDEXECUTIONENDDATE,
    CONFIRMEDEXECUTIONENDTIME,
    CONFIRMEDEXECUTIONSTARTDATE,
    CONFIRMEDEXECUTIONSTARTTIME,
    CONFIRMEDPROCESSINGENDDATE,
    CONFIRMEDPROCESSINGENDTIME,
    CONFIRMEDPROCESSINGSTARTDATE,
    CONFIRMEDPROCESSINGSTARTTIME,
    CONFIRMEDSETUPENDDATE,
    CONFIRMEDSETUPENDTIME,
    CONFIRMEDTEARDOWNSTARTDATE,
    CONFIRMEDTEARDOWNSTARTTIME,
    CONFYIELDQTYINPRODUCTIONUNIT,
    EMPLOYEESUITABILITY,
    EMPLOYEEWAGEGROUP,
    EMPLOYEEWAGETYPE,
    ENTEREDBYEXTERNALUSER,
    ENTEREDBYUSER,
    EXTERNALSYSTEMCONFIRMATION,
    FINALCONFIRMATIONTYPE,
    ISFINALCONFIRMATION,
    ISREVERSAL,
    ISREVERSED,
    LANGUAGE,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    MANUFACTURINGORDER,
    MANUFACTURINGORDERCATEGORY,
    MANUFACTURINGORDEROPERATION,
    MANUFACTURINGORDEROPERATION_2,
    MANUFACTURINGORDERSEQUENCE,
    MANUFACTURINGORDERTYPE,
    MFGORDERCONFIRMATIONENTRYDATE,
    MFGORDERCONFIRMATIONENTRYTIME,
    NOFURTHERBUSINESSPROCQTYISEXPD,
    NOFURTHEROPWORKQUANTITY1ISEXPD,
    NOFURTHEROPWORKQUANTITY2ISEXPD,
    NOFURTHEROPWORKQUANTITY3ISEXPD,
    NOFURTHEROPWORKQUANTITY4ISEXPD,
    NOFURTHEROPWORKQUANTITY5ISEXPD,
    NOFURTHEROPWORKQUANTITY6ISEXPD,
    NUMBEROFEMPLOYEES,
    OPCONFIRMEDWORKQUANTITY1,
    OPCONFIRMEDWORKQUANTITY2,
    OPCONFIRMEDWORKQUANTITY3,
    OPCONFIRMEDWORKQUANTITY4,
    OPCONFIRMEDWORKQUANTITY5,
    OPCONFIRMEDWORKQUANTITY6,
    OPENRESERVATIONSISCLEARED,
    OPERATIONUNIT,
    OPPLANNEDTOTALQUANTITY,
    OPWORKQUANTITYUNIT1,
    OPWORKQUANTITYUNIT2,
    OPWORKQUANTITYUNIT3,
    OPWORKQUANTITYUNIT4,
    OPWORKQUANTITYUNIT5,
    OPWORKQUANTITYUNIT6,
    ORDERCONFIRMATIONRECORDTYPE,
    ORDERCONFIRMATIONTYPE,
    ORDERINTERNALID,
    ORDEROPERATIONINTERNALID,
    ORIGINALBATCH,
    PERSONNEL,
    PLANT,
    POSTINGDATE,
    SENDERCOSTCENTER,
    SHIFTDEFINITION,
    SHIFTGROUPING,
    SUPERIOROPERATIONINTERNALID,
    TIMERECORDING,
    VARIANCEREASONCODE,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    PRIMARY KEY (MFGORDERCONFIRMATION, MFGORDERCONFIRMATIONGROUP)
);

Learn More