I_MFGORDERCONFIRMATION
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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":""
}
}*/