I_ORDERCONFIRMATION
Order Confirmation
I_ORDERCONFIRMATION is a CDS View in S/4HANA. Order Confirmation. It contains 154 fields. 6 CDS views read from this table.
CDS Views using this table (6)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_DspDocFlwProdnConfAttrib | view | from | CONSUMPTION | Prodn/Proc Ord Conf Attributes for DDF |
| I_MaintOrderConfActivityTypeVH | view | inner | COMPOSITE | Activity types for Order confirmation |
| I_MfgOrderConfirmation | view | from | BASIC | Manufacturing Order Confirmation |
| I_MfgOrderConfirmationLongText | view_entity | inner | COMPOSITE | Manufacturing Order Confirmation - Text |
| I_MfgOrderHeaderConfirmation | view | from | BASIC | Manufacturing Order Header Confirmation |
| P_DspDocFlwProdnConfCount | view | from | CONSUMPTION |
Fields (154)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ConfirmationGroup | MfgOrderConfirmationGroup | 1 |
| KEY | OrderConfirmation | MfgOrderConfirmation | 1 |
| _BreakDurationUnit | _BreakDurationUnit | 1 | |
| _BusinessArea | _BusinessArea | 1 | |
| _BusinessProcess | _BusinessProcess | 1 | |
| _BusinessProcessUnit | _BusinessProcessUnit | 1 | |
| _Capacity | _Capacity | 1 | |
| _CompanyCode | _CompanyCode | 1 | |
| _ConfirmationApplOrigin | _ConfirmationApplOrigin | 1 | |
| _ConfirmationGroup | _ConfirmationGroup | 1 | |
| _ConfirmationRecordType | _ConfirmationRecordType | 1 | |
| _ConfirmationType | _ConfirmationType | 1 | |
| _ConfirmationUnit | _ConfirmationUnit | 1 | |
| _ControllingArea | _ControllingArea | 1 | |
| _Employee | _Employee | 1 | |
| _EmployeeSuitability | _EmployeeSuitability | 1 | |
| _EmployeeWageGroup | _EmployeeWageGroup | 1 | |
| _FinalConfIndicator | _FinalConfIndicator | 1 | |
| _FinalConfirmationType | _FinalConfirmationType | 1 | |
| _Language | _Language | 1 | |
| _LongText | _LongText | 1 | |
| _LongTextIndicator | _LongTextIndicator | 1 | |
| _MaterialDocument | _MaterialDocument | 1 | |
| _MaterialDocument3 | _MaterialDocument3 | 1 | |
| _MaterialDocumentYear | _MaterialDocumentYear | 1 | |
| _MilestoneConfirmation | _MilestoneConfirmation | 1 | |
| _MilestoneConfirmationGroup | _MilestoneConfirmationGroup | 1 | |
| _OperationUnit | _OperationUnit | 1 | |
| _OrderInternalID | _OrderInternalID | 1 | |
| _PersonWorkAgreement | _PersonWorkAgreement | 1 | |
| _Plant | _Plant | 1 | |
| _PostingDate | _PostingDate | 1 | |
| _PostingDateYear | _PostingDateYear | 1 | |
| _ProductCostCollector | _ProductCostCollector | 1 | |
| _ReversalIndicator | _ReversalIndicator | 1 | |
| _ReversedIndicator | _ReversedIndicator | 1 | |
| _ShiftDefinition | _ShiftDefinition | 1 | |
| _ShiftGrouping | _ShiftGrouping | 1 | |
| _User | _User | 1 | |
| _UserContactCard | _UserContactCard | 1 | |
| _VarianceReason | _VarianceReason | 1 | |
| _WorkCenter | _WorkCenter | 1 | |
| _WorkCenterType | _WorkCenterType | 1 | |
| _WorkQuantityUnit1 | _WorkQuantityUnit1 | 1 | |
| _WorkQuantityUnit2 | _WorkQuantityUnit2 | 1 | |
| _WorkQuantityUnit3 | _WorkQuantityUnit3 | 1 | |
| _WorkQuantityUnit4 | _WorkQuantityUnit4 | 1 | |
| _WorkQuantityUnit5 | _WorkQuantityUnit5 | 1 | |
| _WorkQuantityUnit6 | _WorkQuantityUnit6 | 1 | |
| ActualForecastEndDate | ActualForecastEndDate | 1 | |
| ActualForecastEndTime | ActualForecastEndTime | 1 | |
| APIConfHasNoGoodsMovements | APIConfHasNoGoodsMovements | 1 | |
| BatchBySupplier | BatchBySupplier | 1 | |
| BreakDurationUnit | BreakDurationUnit | 1 | |
| BusinessArea | BusinessArea | 1 | |
| BusinessProcess | BusinessProcess | 1 | |
| BusinessProcessConfirmedQty | BusinessProcessConfirmedQty | 1 | |
| BusinessProcessEntryUnit | BusinessProcessEntryUnit | 1 | |
| BusinessProcessRemainingQty | BusinessProcessRemainingQty | 1 | |
| BusinessProcRemainingQtyUnit | BusinessProcRemainingQtyUnit | 1 | |
| CancldMfgOrderConfCount | CancldMfgOrderConfCount | 1 | |
| CapacityInternalID | CapacityInternalID | 1 | |
| CapacityRequirementSplit | CapacityRequirementSplit | 1 | |
| CompanyCode | CompanyCode | 1 | |
| ConfirmationApplicationOrigin | ConfirmationApplicationOrigin | 1 | |
| ConfirmationEntryDate | MfgOrderConfirmationEntryDate | 1 | |
| ConfirmationEntryTime | MfgOrderConfirmationEntryTime | 1 | |
| ConfirmationExternalEntryDate | ConfirmationExternalEntryDate | 1 | |
| ConfirmationExternalEntryTime | ConfirmationExternalEntryTime | 1 | |
| ConfirmationReworkQuantity | ConfirmationReworkQuantity | 1 | |
| ConfirmationScrapQuantity | ConfirmationScrapQuantity | 1 | |
| ConfirmationText | ConfirmationText,MfgOrderConfirmationText | 2 | |
| ConfirmationTotalQuantity | ConfirmationTotalQuantity | 1 | |
| ConfirmationUnit | ConfirmationUnit | 1 | |
| ConfirmationYieldQuantity | ConfirmationYieldQuantity | 1 | |
| ConfirmedBreakDuration | ConfirmedBreakDuration | 1 | |
| ConfirmedExecutionEndDate | ConfirmedExecutionEndDate | 1 | |
| ConfirmedExecutionEndTime | ConfirmedExecutionEndTime | 1 | |
| ConfirmedExecutionStartDate | ConfirmedExecutionStartDate | 1 | |
| ConfirmedExecutionStartTime | ConfirmedExecutionStartTime | 1 | |
| ConfirmedProcessingEndDate | ConfirmedProcessingEndDate | 1 | |
| ConfirmedProcessingEndTime | ConfirmedProcessingEndTime | 1 | |
| ConfirmedProcessingStartDate | ConfirmedProcessingStartDate | 1 | |
| ConfirmedProcessingStartTime | ConfirmedProcessingStartTime | 1 | |
| ConfirmedSetupEndDate | ConfirmedSetupEndDate | 1 | |
| ConfirmedSetupEndTime | ConfirmedSetupEndTime | 1 | |
| ConfirmedTeardownStartDate | ConfirmedTeardownStartDate | 1 | |
| ConfirmedTeardownStartTime | ConfirmedTeardownStartTime | 1 | |
| ControllingArea | ControllingArea | 1 | |
| EmployeeSuitability | EmployeeSuitability | 1 | |
| EmployeeWageGroup | EmployeeWageGroup | 1 | |
| EmployeeWageType | EmployeeWageType | 1 | |
| EnteredByExternalUser | EnteredByExternalUser | 1 | |
| EnteredByUser | EnteredByUser | 1 | |
| ExternalSystemConfirmation | ExternalSystemConfirmation | 1 | |
| FailedGoodsMovement | FailedGoodsMovement | 1 | |
| FinalConfirmationType | FinalConfirmationType | 1 | |
| IsConfirmedByMilestoneConf | IsConfirmedByMilestoneConf | 1 | |
| IsFinalConfirmation | IsFinalConfirmation | 1 | |
| IsReversal | IsReversal | 1 | |
| IsReversed | IsReversed | 1 | |
| Language | Language | 1 | |
| LastChangeDate | LastChangeDate | 1 | |
| LastChangedByUser | LastChangedByUser | 1 | |
| LongTextExists | LongTextExists | 1 | |
| MaterialDocument | MaterialDocument | 1 | |
| MaterialDocumentYear | MaterialDocumentYear | 1 | |
| MilestoneConfirmation | MilestoneConfirmation | 1 | |
| MilestoneConfirmationGroup | MilestoneConfirmationGroup | 1 | |
| MilestoneConfirmationType | MilestoneConfirmationType | 1 | |
| MilestoneIsConfirmed | MilestoneIsConfirmed | 1 | |
| NoFurtherBusinessProcQtyIsExpd | NoFurtherBusinessProcQtyIsExpd | 1 | |
| NoFurtherOpWorkQuantity1IsExpd | NoFurtherOpWorkQuantity1IsExpd | 1 | |
| NoFurtherOpWorkQuantity2IsExpd | NoFurtherOpWorkQuantity2IsExpd | 1 | |
| NoFurtherOpWorkQuantity3IsExpd | NoFurtherOpWorkQuantity3IsExpd | 1 | |
| NoFurtherOpWorkQuantity4IsExpd | NoFurtherOpWorkQuantity4IsExpd | 1 | |
| NoFurtherOpWorkQuantity5IsExpd | NoFurtherOpWorkQuantity5IsExpd | 1 | |
| NoFurtherOpWorkQuantity6IsExpd | NoFurtherOpWorkQuantity6IsExpd | 1 | |
| NumberOfEmployees | NumberOfEmployees | 1 | |
| OpConfirmedWorkQuantity1 | OpConfirmedWorkQuantity1 | 1 | |
| OpConfirmedWorkQuantity2 | OpConfirmedWorkQuantity2 | 1 | |
| OpConfirmedWorkQuantity3 | OpConfirmedWorkQuantity3 | 1 | |
| OpConfirmedWorkQuantity4 | OpConfirmedWorkQuantity4 | 1 | |
| OpConfirmedWorkQuantity5 | OpConfirmedWorkQuantity5 | 1 | |
| OpConfirmedWorkQuantity6 | OpConfirmedWorkQuantity6 | 1 | |
| OpenReservationsIsCleared | OpenReservationsIsCleared | 1 | |
| OperationUnit | OperationUnit | 1 | |
| OpPlannedTotalQuantity | OpPlannedTotalQuantity | 1 | |
| OpWorkQuantityUnit1 | OpWorkQuantityUnit1 | 1 | |
| OpWorkQuantityUnit2 | OpWorkQuantityUnit2 | 1 | |
| OpWorkQuantityUnit3 | OpWorkQuantityUnit3 | 1 | |
| OpWorkQuantityUnit4 | OpWorkQuantityUnit4 | 1 | |
| OpWorkQuantityUnit5 | OpWorkQuantityUnit5 | 1 | |
| OpWorkQuantityUnit6 | OpWorkQuantityUnit6 | 1 | |
| OrderConfirmationRecordType | OrderConfirmationRecordType | 1 | |
| OrderConfirmationType | OrderConfirmationType | 1 | |
| OrderInternalID | OrderInternalID | 1 | |
| OrderOperation_2 | ManufacturingOrderOperation_2 | 1 | |
| OrderOperationInternalID | OrderOperationInternalID | 1 | |
| OriginalBatch | OriginalBatch | 1 | |
| Personnel | Personnel | 1 | |
| Plant | Plant | 1 | |
| PlantDataCollectionID | PlantDataCollectionID | 1 | |
| PostingDate | PostingDate | 1 | |
| PostingDateYear | PostingDateYear | 1 | |
| ProductCostCollector | ProductCostCollector | 1 | |
| ProfitCenter | ProfitCenter | 1 | |
| SenderCostCenter | SenderCostCenter | 1 | |
| ShiftGrouping | ShiftGrouping | 1 | |
| SuperiorOperationInternalID | SuperiorOperationInternalID | 1 | |
| TimeRecording | TimeRecording | 1 | |
| VarianceReasonCode | VarianceReasonCode | 1 | |
| WorkCenterInternalID | WorkCenterInternalID | 1 | |
| WorkCenterTypeCode | WorkCenterTypeCode | 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.
-- Order Confirmation
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ORDERCONFIRMATION (
CONFIRMATIONGROUP,
ORDERCONFIRMATION,
_BREAKDURATIONUNIT,
_BUSINESSAREA,
_BUSINESSPROCESS,
_BUSINESSPROCESSUNIT,
_CAPACITY,
_COMPANYCODE,
_CONFIRMATIONAPPLORIGIN,
_CONFIRMATIONGROUP,
_CONFIRMATIONRECORDTYPE,
_CONFIRMATIONTYPE,
_CONFIRMATIONUNIT,
_CONTROLLINGAREA,
_EMPLOYEE,
_EMPLOYEESUITABILITY,
_EMPLOYEEWAGEGROUP,
_FINALCONFINDICATOR,
_FINALCONFIRMATIONTYPE,
_LANGUAGE,
_LONGTEXT,
_LONGTEXTINDICATOR,
_MATERIALDOCUMENT,
_MATERIALDOCUMENT3,
_MATERIALDOCUMENTYEAR,
_MILESTONECONFIRMATION,
_MILESTONECONFIRMATIONGROUP,
_OPERATIONUNIT,
_ORDERINTERNALID,
_PERSONWORKAGREEMENT,
_PLANT,
_POSTINGDATE,
_POSTINGDATEYEAR,
_PRODUCTCOSTCOLLECTOR,
_REVERSALINDICATOR,
_REVERSEDINDICATOR,
_SHIFTDEFINITION,
_SHIFTGROUPING,
_USER,
_USERCONTACTCARD,
_VARIANCEREASON,
_WORKCENTER,
_WORKCENTERTYPE,
_WORKQUANTITYUNIT1,
_WORKQUANTITYUNIT2,
_WORKQUANTITYUNIT3,
_WORKQUANTITYUNIT4,
_WORKQUANTITYUNIT5,
_WORKQUANTITYUNIT6,
ACTUALFORECASTENDDATE,
ACTUALFORECASTENDTIME,
APICONFHASNOGOODSMOVEMENTS,
BATCHBYSUPPLIER,
BREAKDURATIONUNIT,
BUSINESSAREA,
BUSINESSPROCESS,
BUSINESSPROCESSCONFIRMEDQTY,
BUSINESSPROCESSENTRYUNIT,
BUSINESSPROCESSREMAININGQTY,
BUSINESSPROCREMAININGQTYUNIT,
CANCLDMFGORDERCONFCOUNT,
CAPACITYINTERNALID,
CAPACITYREQUIREMENTSPLIT,
COMPANYCODE,
CONFIRMATIONAPPLICATIONORIGIN,
CONFIRMATIONENTRYDATE,
CONFIRMATIONENTRYTIME,
CONFIRMATIONEXTERNALENTRYDATE,
CONFIRMATIONEXTERNALENTRYTIME,
CONFIRMATIONREWORKQUANTITY,
CONFIRMATIONSCRAPQUANTITY,
CONFIRMATIONTEXT,
CONFIRMATIONTOTALQUANTITY,
CONFIRMATIONUNIT,
CONFIRMATIONYIELDQUANTITY,
CONFIRMEDBREAKDURATION,
CONFIRMEDEXECUTIONENDDATE,
CONFIRMEDEXECUTIONENDTIME,
CONFIRMEDEXECUTIONSTARTDATE,
CONFIRMEDEXECUTIONSTARTTIME,
CONFIRMEDPROCESSINGENDDATE,
CONFIRMEDPROCESSINGENDTIME,
CONFIRMEDPROCESSINGSTARTDATE,
CONFIRMEDPROCESSINGSTARTTIME,
CONFIRMEDSETUPENDDATE,
CONFIRMEDSETUPENDTIME,
CONFIRMEDTEARDOWNSTARTDATE,
CONFIRMEDTEARDOWNSTARTTIME,
CONTROLLINGAREA,
EMPLOYEESUITABILITY,
EMPLOYEEWAGEGROUP,
EMPLOYEEWAGETYPE,
ENTEREDBYEXTERNALUSER,
ENTEREDBYUSER,
EXTERNALSYSTEMCONFIRMATION,
FAILEDGOODSMOVEMENT,
FINALCONFIRMATIONTYPE,
ISCONFIRMEDBYMILESTONECONF,
ISFINALCONFIRMATION,
ISREVERSAL,
ISREVERSED,
LANGUAGE,
LASTCHANGEDATE,
LASTCHANGEDBYUSER,
LONGTEXTEXISTS,
MATERIALDOCUMENT,
MATERIALDOCUMENTYEAR,
MILESTONECONFIRMATION,
MILESTONECONFIRMATIONGROUP,
MILESTONECONFIRMATIONTYPE,
MILESTONEISCONFIRMED,
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,
ORDEROPERATION_2,
ORDEROPERATIONINTERNALID,
ORIGINALBATCH,
PERSONNEL,
PLANT,
PLANTDATACOLLECTIONID,
POSTINGDATE,
POSTINGDATEYEAR,
PRODUCTCOSTCOLLECTOR,
PROFITCENTER,
SENDERCOSTCENTER,
SHIFTGROUPING,
SUPERIOROPERATIONINTERNALID,
TIMERECORDING,
VARIANCEREASONCODE,
WORKCENTERINTERNALID,
WORKCENTERTYPECODE,
PRIMARY KEY (CONFIRMATIONGROUP, ORDERCONFIRMATION)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA