I_MFGORDERCONFIRMATION

CDS View

Manufacturing Order Confirmation

I_MFGORDERCONFIRMATION is a CDS View in S/4HANA. Manufacturing Order Confirmation. It contains 91 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 (91)

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
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
OpWorkQuantityUnit1 OpWorkQuantityUnit1 6
OpWorkQuantityUnit2 OpWorkQuantityUnit2 6
OpWorkQuantityUnit3 OpWorkQuantityUnit3 6
OpWorkQuantityUnit4 OpWorkQuantityUnit4 6
OpWorkQuantityUnit5 OpWorkQuantityUnit5 6
OpWorkQuantityUnit6 OpWorkQuantityUnit6 6
OrderConfirmationRecordType OrderConfirmationRecordType 4
OrderInternalID OrderInternalBillOfOperations 2
OrderOperationInternalID OrderIntBillOfOperationsItem,OrderOperationInternalID 6
Personnel Personnel 4
Plant ConfirmationPlant,Plant 7
PostingDate PostingDate 4
ShiftDefinition ShiftDefinition 4
ShiftGrouping ShiftGrouping 4
SuperiorOperationInternalID SuperiorOperationInternalID 2
TimeRecording TimeRecording 4
VarianceReasonCode VarianceReasonCode 4
WorkCenterInternalID WorkCenterInternalID 2
WorkCenterTypeCode WorkCenterTypeCode 4
@AbapCatalog.sqlViewName: 'IPPMFGORDCONF'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@AccessControl.privilegedAssociations: ['_User', '_UserContactCard', '_LongText']
@Analytics.dataCategory: #DIMENSION
@Analytics.dataExtraction: { enabled: true,
                             delta.changeDataCapture:
                                    { mapping:
                                      [ { role: #MAIN,
                                          table: 'afru',
                                          tableElement: ['rueck'                    , 'rmzhl'],
                                          viewElement:  ['MfgOrderConfirmationGroup', 'MfgOrderConfirmation']
                                        },
                                        { role: #LEFT_OUTER_TO_ONE_JOIN,
                                          table: 'aufk',
                                          tableElement: ['aufnr'],
                                          viewElement:  ['ManufacturingOrder']
                                        },
                                        { role: #LEFT_OUTER_TO_ONE_JOIN,
                                          table: 'afvv',
                                          tableElement: ['aufpl'          , 'aplzl'],
                                          viewElement:  ['OrderInternalID', 'OrderOperationInternalID']
                                        } ] } }
@Analytics.internalName: #LOCAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@ClientHandling.type: #CLIENT_DEPENDENT
@Metadata.allowExtensions: true
@ObjectModel.compositionRoot: true
@ObjectModel.modelingPattern: #NONE
@ObjectModel.supportedCapabilities: [#CDS_MODELING_ASSOCIATION_TARGET, #CDS_MODELING_DATA_SOURCE, #SQL_DATA_SOURCE, #EXTRACTION_DATA_SOURCE, #ANALYTICAL_DIMENSION]
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.representativeKey: 'MfgOrderConfirmation'
@ObjectModel.semanticKey: ['MfgOrderConfirmationGroup', 'MfgOrderConfirmation']
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #BASIC
@EndUserText.label: 'Manufacturing Order Confirmation'

/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ]  } */
define view I_MfgOrderConfirmation
  as select from I_OrderConfirmation as conf

  association [1..1] to I_ManufacturingOrder           as _MfgOrder             on  $projection.ManufacturingOrder = _MfgOrder.ManufacturingOrder
  association [1..1] to I_MfgOrder                     as _MfgOrder2            on  $projection.ManufacturingOrder = _MfgOrder2.ManufacturingOrder  // for ODP reasons

  association [0..1] to I_MfgOrderSequence             as _MfgOrderSequence     on  $projection.ManufacturingOrder         = _MfgOrderSequence.ManufacturingOrder
                                                                                and $projection.ManufacturingOrderSequence = _MfgOrderSequence.ManufacturingOrderSequence
  association [0..1] to I_ManufacturingOrderSequence   as _MfgOrderSequence2    on  $projection.ManufacturingOrder         = _MfgOrderSequence2.ManufacturingOrder
                                                                                and $projection.ManufacturingOrderSequence = _MfgOrderSequence2.ManufacturingOrderSequence
  association [1..1] to I_MfgOrderOperationBySemanKey  as _MfgOrderOperation    on  $projection.ManufacturingOrder          = _MfgOrderOperation.ManufacturingOrder
                                                                                and $projection.ManufacturingOrderSequence  = _MfgOrderOperation.ManufacturingOrderSequence
                                                                                and $projection.ManufacturingOrderOperation = _MfgOrderOperation.ManufacturingOrderOperation
  association [1..1] to I_MfgOrderOperationBySemKey    as _MfgOrderOperation2   on  $projection.ManufacturingOrder            = _MfgOrderOperation2.ManufacturingOrder
                                                                                and $projection.ManufacturingOrderSequence    = _MfgOrderOperation2.ManufacturingOrderSequence
                                                                                and $projection.ManufacturingOrderOperation_2 = _MfgOrderOperation2.ManufacturingOrderOperation
  association [1..1] to I_MfgOrderCategory             as _MfgOrderCategory     on  $projection.ManufacturingOrderCategory = _MfgOrderCategory.ManufacturingOrderCategory
  association [1..1] to I_MfgOrderType                 as _MfgOrderType         on  $projection.ManufacturingOrderType = _MfgOrderType.ManufacturingOrderType
  association [1..1] to I_UnitOfMeasure                as _ProductionUnit       on  $projection.ProductionUnit = _ProductionUnit.UnitOfMeasure
  association [0..1] to I_MaterialDocumentHeader       as _MaterialDocument2    on  $projection.MaterialDocument     = _MaterialDocument2.MaterialDocument
                                                                                and $projection.MaterialDocumentYear = _MaterialDocument2.MaterialDocumentYear
  association [0..1] to I_FailedGoodsMovement          as _FailedGoodsMovement  on  $projection.FailedGoodsMovement = _FailedGoodsMovement.FailedGoodsMovement
-- To child Long text
  association [0..*] to I_MfgOrderConfirmationLongText as _MfgOrderConfLongText on  $projection.MfgOrderConfirmationGroup = _MfgOrderConfLongText.MfgOrderConfirmationGroup
                                                                                and $projection.MfgOrderConfirmation      = _MfgOrderConfLongText.MfgOrderConfirmationCount
-- To child Material Document Items
  association [0..*] to I_MfgOrderConfMatlDocItem      as _ConfMatlDocItem      on  $projection.MfgOrderConfirmationGroup = _ConfMatlDocItem.MfgOrderConfirmationGroup
                                                                                and $projection.MfgOrderConfirmation      = _ConfMatlDocItem.MfgOrderConfirmation
-- To child Failed Goods Movements
  association [0..*] to I_FailedGoodsMovementItem      as _ConfFailedGdsMvtItem on  $projection.MfgOrderConfirmationGroup = _ConfFailedGdsMvtItem.ConfirmationGroup
                                                                                and $projection.MfgOrderConfirmation      = _ConfFailedGdsMvtItem.ConfirmationCount
-- To child Failed Actual Costs
  association [0..*] to I_ConfFailedActualCostCalc     as _ConfFailedActualCost on  $projection.MfgOrderConfirmationGroup = _ConfFailedActualCost.ConfirmationGroup
                                                                                and $projection.MfgOrderConfirmation      = _ConfFailedActualCost.OrderConfirmation
-- To extension
  association [0..1] to E_OrderConfirmation            as _Extension            on  $projection.MfgOrderConfirmationGroup = _Extension.ConfirmationGroup
                                                                                and $projection.MfgOrderConfirmation      = _Extension.ConfirmationCount
{
      // Key

      @ObjectModel.foreignKey.association: '_ConfirmationGroup'
  key conf.ConfirmationGroup                                                 as MfgOrderConfirmationGroup,
      @ObjectModel.text.element: ['ConfirmationText']
  key conf.OrderConfirmation                                                 as MfgOrderConfirmation,

      // Order and Operation Data

      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_MfgOrderStdVH', element: 'ManufacturingOrder' } } ]
      @ObjectModel.foreignKey.association: '_MfgOrder'
      cast(conf.OrderID as manufacturingorder preserving type)               as ManufacturingOrder,
      @ObjectModel.foreignKey.association: '_MfgOrderSequence2'
      cast(conf.Sequence as manufacturingordersequence preserving type)      as ManufacturingOrderSequence,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: 'ManufacturingOrderOperation_2'
      @ObjectModel.foreignKey.association: '_MfgOrderOperation'
      cast(conf.OrderOperation as co_vornr preserving type)                  as ManufacturingOrderOperation,   // with conv. exit NUMCV

      @ObjectModel.foreignKey.association: '_MfgOrderOperation2'
      conf.OrderOperation_2                                                  as ManufacturingOrderOperation_2, // w/o conversion exit

      @ObjectModel.foreignKey.association: '_MfgOrderCategory'
      @ObjectModel.sapObjectNodeTypeReference: 'ManufacturingOrderCategory'
      cast(conf.OrderCategory as manufacturingordercategory preserving type) as ManufacturingOrderCategory,
      @ObjectModel.foreignKey.association: '_MfgOrderType'
      @ObjectModel.sapObjectNodeTypeReference: 'ManufacturingOrderType'
      cast(conf.OrderType as manufacturingordertype preserving type)         as ManufacturingOrderType,

      // Internal Keys

      @ObjectModel.foreignKey.association: '_OrderInternalID'
      conf.OrderInternalID,
      conf.OrderOperationInternalID,
      conf.SuperiorOperationInternalID,

      // Text

      @Semantics.text: true
      conf.ConfirmationText,
      @ObjectModel.foreignKey.association: '_Language'
      conf.Language,
      @ObjectModel.foreignKey.association: '_LongTextIndicator'
      conf.LongTextExists,

      // Admin

      @Semantics.systemDate.createdAt: true
      conf.ConfirmationEntryDate                                             as MfgOrderConfirmationEntryDate,
      @Semantics.systemTime.createdAt: true
      conf.ConfirmationEntryTime                                             as MfgOrderConfirmationEntryTime,
      @Semantics.user.createdBy: true
      conf.EnteredByUser,
      @Semantics.systemDate.lastChangedAt: true
      conf.LastChangeDate,
      @Semantics.user.lastChangedBy: true
      conf.LastChangedByUser,
      @Semantics.systemDate.createdAt: true
      conf.ConfirmationExternalEntryDate,
      @Semantics.systemTime.createdAt: true
      conf.ConfirmationExternalEntryTime,
      conf.EnteredByExternalUser,
      conf.ExternalSystemConfirmation,

      // Attributes

      @ObjectModel.foreignKey.association: '_FinalConfirmationType'
      conf.FinalConfirmationType,
      conf.IsFinalConfirmation,
      conf.OpenReservationsIsCleared,
      @ObjectModel.foreignKey.association: '_ReversedIndicator'
      conf.IsReversed,
      @ObjectModel.foreignKey.association: '_ReversalIndicator'
      conf.IsReversal,
      conf.CancldMfgOrderConfCount,
      conf.APIConfHasNoGoodsMovements,
      @ObjectModel.foreignKey.association: '_ConfirmationApplOrigin'
      conf.ConfirmationApplicationOrigin,
      @ObjectModel.foreignKey.association: '_ConfirmationType'
      conf.OrderConfirmationType,
      @ObjectModel.foreignKey.association: '_ConfirmationRecordType'
      conf.OrderConfirmationRecordType,

      // Milestone

      @API.element.releaseState: #DEPRECATED
      @API.element.successor: 'MilestoneConfirmationType'
      conf.MilestoneIsConfirmed,                 // wrong data type for indicators

      conf.MilestoneConfirmationType,
      conf.IsConfirmedByMilestoneConf,
      @ObjectModel.foreignKey.association: '_MilestoneConfirmationGroup'
      conf.MilestoneConfirmationGroup,
      @ObjectModel.foreignKey.association: '_MilestoneConfirmation'
      conf.MilestoneConfirmation,

      // Assignments

      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_PlantStdVH', element: 'Plant' } } ]
      @ObjectModel.foreignKey.association: '_Plant'
      @ObjectModel.sapObjectNodeTypeReference: 'Plant'
      conf.Plant,
      @ObjectModel.foreignKey.association: '_WorkCenterType'
      conf.WorkCenterTypeCode,
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_WorkCenterStdVH', element: 'WorkCenterInternalID' } } ]
      @ObjectModel.foreignKey.association: '_WorkCenter'
      conf.WorkCenterInternalID,
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_CapacityStdVH', element: 'CapacityInternalID' } } ]
      @ObjectModel.foreignKey.association: '_Capacity'
      conf.CapacityInternalID,
      conf.CapacityRequirementSplit,
      @ObjectModel.foreignKey.association: '_ShiftGrouping'
      conf.ShiftGrouping,
--    @ObjectModel.foreignKey.association: '_ShiftDefinition'
      conf.ShiftDefinition,
      @ObjectModel.foreignKey.association: '_MaterialDocument2'
      @ObjectModel.sapObjectNodeTypeReference: 'MaterialDocument'   
      conf.MaterialDocument,
      @ObjectModel.foreignKey.association: '_MaterialDocumentYear'
      conf.MaterialDocumentYear,
      @ObjectModel.foreignKey.association: '_FailedGoodsMovement'
      conf.FailedGoodsMovement,
      conf.PlantDataCollectionID,

      // Assignments FI/CO

      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_BusinessAreaStdVH', element: 'BusinessArea' } } ]
      @ObjectModel.foreignKey.association: '_BusinessArea'
      @ObjectModel.sapObjectNodeTypeReference: 'BusinessArea'
      conf.BusinessArea,
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_CompanyCodeStdVH', element: 'CompanyCode' } } ]
      @ObjectModel.foreignKey.association: '_CompanyCode'
      @ObjectModel.sapObjectNodeTypeReference: 'CompanyCode'
      conf.CompanyCode,
      @ObjectModel.foreignKey.association: '_ControllingArea'
      conf.ControllingArea,
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_ProfitCenterStdVH', element: 'ProfitCenter' } } ]
      @ObjectModel.sapObjectNodeTypeReference: 'ProfitCenter'
      conf.ProfitCenter,
      @ObjectModel.foreignKey.association: '_ProductCostCollector'
      conf.ProductCostCollector,

      // Assignments HR

      @ObjectModel.foreignKey.association: '_PersonWorkAgreement'
      conf.Personnel,
      conf.TimeRecording,
      conf.EmployeeWageType,
      @ObjectModel.foreignKey.association: '_EmployeeWageGroup'
      conf.EmployeeWageGroup,
      @ObjectModel.foreignKey.association: '_EmployeeSuitability'      
      conf.EmployeeSuitability,
      conf.NumberOfEmployees,

      // Dates

      @ObjectModel.foreignKey.association: '_PostingDate'
      @Semantics.businessDate.at: true
      conf.PostingDate,
      @ObjectModel.foreignKey.association: '_PostingDateYear'
      conf.PostingDateYear,

      // Time Events

      conf.ConfirmedExecutionStartDate,
      conf.ConfirmedExecutionStartTime,
      conf.ConfirmedSetupEndDate,
      conf.ConfirmedSetupEndTime,
      conf.ConfirmedProcessingStartDate,
      conf.ConfirmedProcessingStartTime,
      conf.ConfirmedProcessingEndDate,
      conf.ConfirmedProcessingEndTime,
      conf.ConfirmedTeardownStartDate,
      conf.ConfirmedTeardownStartTime,
      conf.ConfirmedExecutionEndDate,
      conf.ConfirmedExecutionEndTime,
      conf.ActualForecastEndDate,
      conf.ActualForecastEndTime,

      // Quantities and UoM

      @Semantics.unitOfMeasure: true
      conf.ConfirmationUnit,
      @Semantics.quantity.unitOfMeasure: 'ConfirmationUnit'
      @Aggregation.default: #SUM
      conf.ConfirmationYieldQuantity,
      @Semantics.quantity.unitOfMeasure: 'ConfirmationUnit'
      @Aggregation.default: #SUM
      conf.ConfirmationScrapQuantity,
      @Semantics.quantity.unitOfMeasure: 'ConfirmationUnit'
      @Aggregation.default: #SUM
      conf.ConfirmationReworkQuantity,
      @Semantics.quantity.unitOfMeasure: 'ConfirmationUnit'
      @Aggregation.default: #SUM
      conf.ConfirmationTotalQuantity,
      @ObjectModel.foreignKey.association: '_VarianceReason'
      conf.VarianceReasonCode,

      @Semantics.unitOfMeasure: true
      cast(OrderQuantityUnit as productionunit preserving type)      as ProductionUnit,
      @Semantics.quantity.unitOfMeasure: 'ProductionUnit'
      @Aggregation.default: #SUM
      cast(ConfirmedYieldQtyInOrderUnit as ru_gmnga preserving type) as ConfYieldQtyInProductionUnit,

      @Semantics.unitOfMeasure: true
      conf.OperationUnit,
      @Semantics.quantity.unitOfMeasure: 'OperationUnit'
      @Aggregation.default: #SUM
      conf.OpPlannedTotalQuantity,

      // Work Quantities and UoM

      @Semantics.unitOfMeasure: true
      conf.OpWorkQuantityUnit1,
      @Semantics.quantity.unitOfMeasure: 'OpWorkQuantityUnit1'
      @Aggregation.default: #SUM
      conf.OpConfirmedWorkQuantity1,
      conf.NoFurtherOpWorkQuantity1IsExpd,
      @Semantics.unitOfMeasure: true
      conf.OpWorkQuantityUnit2,
      @Semantics.quantity.unitOfMeasure: 'OpWorkQuantityUnit2'
      @Aggregation.default: #SUM
      conf.OpConfirmedWorkQuantity2,
      conf.NoFurtherOpWorkQuantity2IsExpd,
      @Semantics.unitOfMeasure: true
      conf.OpWorkQuantityUnit3,
      @Semantics.quantity.unitOfMeasure: 'OpWorkQuantityUnit3'
      @Aggregation.default: #SUM
      conf.OpConfirmedWorkQuantity3,
      conf.NoFurtherOpWorkQuantity3IsExpd,
      @Semantics.unitOfMeasure: true
      conf.OpWorkQuantityUnit4,
      @Semantics.quantity.unitOfMeasure: 'OpWorkQuantityUnit4'
      @Aggregation.default: #SUM
      conf.OpConfirmedWorkQuantity4,
      conf.NoFurtherOpWorkQuantity4IsExpd,
      @Semantics.unitOfMeasure: true
      conf.OpWorkQuantityUnit5,
      @Semantics.quantity.unitOfMeasure: 'OpWorkQuantityUnit5'
      @Aggregation.default: #SUM
      conf.OpConfirmedWorkQuantity5,
      conf.NoFurtherOpWorkQuantity5IsExpd,
      @Semantics.unitOfMeasure: true
      conf.OpWorkQuantityUnit6,
      @Semantics.quantity.unitOfMeasure: 'OpWorkQuantityUnit6'
      @Aggregation.default: #SUM
      conf.OpConfirmedWorkQuantity6,
      conf.NoFurtherOpWorkQuantity6IsExpd,

      // Business Process

      @ObjectModel.foreignKey.association: '_BusinessProcess'
      conf.BusinessProcess,
      @Semantics.unitOfMeasure: true
      conf.BusinessProcessEntryUnit,
      @Semantics.quantity.unitOfMeasure: 'BusinessProcessEntryUnit'
      @Aggregation.default: #SUM
      conf.BusinessProcessConfirmedQty,
      conf.NoFurtherBusinessProcQtyIsExpd,
      @Semantics.unitOfMeasure: true
      conf.BusinessProcRemainingQtyUnit,
      @Semantics.quantity.unitOfMeasure: 'BusinessProcRemainingQtyUnit'
      @Aggregation.default: #SUM
      conf.BusinessProcessRemainingQty,

      // Durations

      @Semantics.unitOfMeasure: true
      conf.BreakDurationUnit,
      conf.ConfirmedBreakDuration,

      // Associations

      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _MfgOrderConfLongText,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _ConfMatlDocItem,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _ConfFailedActualCost,
--    @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _ConfFailedGdsMvtItem,
      conf._ConfirmationGroup,
      _MfgOrder,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: '_MfgOrder'
      _MfgOrder2,         // for ODP reasons

      _MfgOrderSequence,
      _MfgOrderSequence2, // for ODP reasons

      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: '_MfgOrderOperation2'
      _MfgOrderOperation,
      _MfgOrderOperation2,
      _MfgOrderCategory,
      _MfgOrderType,
      @Consumption.hidden: true
      conf._OrderInternalID,
      conf._ConfirmationUnit,
      _ProductionUnit,
      conf._OperationUnit,
      conf._FinalConfirmationType,
      conf._ConfirmationType,
      conf._ConfirmationRecordType,
      conf._ConfirmationApplOrigin,
      conf._MilestoneConfirmationGroup,
      conf._MilestoneConfirmation,
      conf._User,
      conf._UserContactCard,
      conf._Language,
      @Consumption.hidden: true
      conf._WorkCenterType,
      conf._WorkCenter,
      conf._Plant,
      conf._Capacity,
      conf._ShiftGrouping,
      conf._ShiftDefinition,
      conf._BusinessArea,
      conf._CompanyCode,
      conf._ControllingArea,
      conf._ProductCostCollector,
      conf._BusinessProcess,
      conf._BusinessProcessUnit,
      conf._WorkQuantityUnit1,
      conf._WorkQuantityUnit2,
      conf._WorkQuantityUnit3,
      conf._WorkQuantityUnit4,
      conf._WorkQuantityUnit5,
      conf._WorkQuantityUnit6,
      conf._BreakDurationUnit,
      conf._VarianceReason,
      conf._EmployeeWageGroup,
      conf._EmployeeSuitability,
      conf._Employee,
      conf._PersonWorkAgreement,
      _FailedGoodsMovement,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: '_MaterialDocument3'
      conf._MaterialDocument,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: '_MaterialDocument3'
      _MaterialDocument2,
      conf._MaterialDocument3,
      conf._MaterialDocumentYear,
      conf._PostingDate,
      conf._PostingDateYear,
      conf._FinalConfIndicator,
      conf._ReversedIndicator,
      conf._ReversalIndicator,
      conf._LongTextIndicator,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: '_MfgOrderConfLongText'
      conf._LongText
}
where ( conf.ConfirmationApplicationOrigin = '2' or
        conf.ConfirmationApplicationOrigin = '6' or //Manufacturing orders only

        conf.ConfirmationApplicationOrigin = '8' ); //including results recording

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ORDERCONFIRMATION"
],
"ASSOCIATED":
[
"E_ORDERCONFIRMATION",
"I_BUSINESSAREA",
"I_BUSINESSPROCESS",
"I_CALENDARDATE",
"I_CALENDARYEAR",
"I_CAPACITY",
"I_COMPANYCODE",
"I_CONFFAILEDACTUALCOSTCALC",
"I_CONFIRMATIONAPPLORIGIN",
"I_CONFIRMATIONGROUP",
"I_CONFIRMATIONRECORDTYPE",
"I_CONTROLLINGAREA",
"I_EMPLOYEESUITABILITY",
"I_EMPLOYEEWAGEGROUP",
"I_FAILEDGOODSMOVEMENT",
"I_FAILEDGOODSMOVEMENTITEM",
"I_FINALCONFIRMATIONTYPE",
"I_INDICATOR",
"I_LANGUAGE",
"I_MANUFACTURINGORDER",
"I_MANUFACTURINGORDERSEQUENCE",
"I_MATERIALDOCUMENTHEADER",
"I_MATERIALDOCUMENTHEADER_2",
"I_MATERIALDOCUMENTYEAR",
"I_MFGORDER",
"I_MFGORDERCATEGORY",
"I_MFGORDERCONFIRMATIONLONGTEXT",
"I_MFGORDERCONFMATLDOCITEM",
"I_MFGORDEROPERATIONBYSEMANKEY",
"I_MFGORDEROPERATIONBYSEMKEY",
"I_MFGORDERSEQUENCE",
"I_MFGORDERTYPE",
"I_ORDERCONFIRMATION",
"I_ORDERCONFIRMATIONTYPE",
"I_ORDERCONFLONGTEXT",
"I_ORDERINTERNALID",
"I_PERSONWORKAGREEMENT_1",
"I_PLANT",
"I_PRODUCTCOSTCTRLGORDER",
"I_SHIFTDEFINITION",
"I_SHIFTGROUPING",
"I_UNITOFMEASURE",
"I_USER",
"I_USERCONTACTCARD",
"I_VARIANCEREASON",
"I_WORKCENTER",
"I_WORKCENTERTYPE",
"I_WORKFORCEPERSON"
],
"BASE":
[
"I_ORDERCONFIRMATION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/