R_ProcessOrderOperationTP

DDL: R_PROCESSORDEROPERATIONTP Type: view_entity TRANSACTIONAL

Process Order Operation - TP

R_ProcessOrderOperationTP is a Transactional CDS View that provides data about "Process Order Operation - TP" in SAP S/4HANA. It reads from 1 data source (I_ManufacturingOrderOperation) and exposes 128 fields with key fields OrderInternalID, OrderOperationInternalID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ManufacturingOrderOperation Operation from

Associations (3)

CardinalityTargetAliasCondition
[0..*] R_ProcessOrderComponentTP _Component _Component.ProcessOrder = $projection.ProcessOrder and _Component.OrderOperationInternalID = $projection.OrderOperationInternalID
[1..1] E_ProcessOrderOperation _Extension _Extension.OrderInternalID = $projection.OrderInternalID and _Extension.OrderOperationInternalID = $projection.OrderOperationInternalID
[0..*] R_ProcessOrderPhaseTP _Phase

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
EndUserText.label Process Order Operation - TP view

Fields (128)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalID MfgOrderInternalID
KEY OrderOperationInternalID OrderOperationInternalID
ProcessOrder
ProcessOrderSequence
ProcessOrderOperation
OperationText
OperationStandardTextCode OperationStandardTextCode
OperationHasLongText OperationHasLongText
LongTextLanguage Language
OperationIsToBeDeleted OperationIsToBeDeleted
Plant Plant
ProductionResource
ProductionResourceInternalID WorkCenterInternalID
OperationControlProfile OperationControlProfile
FactoryCalendar FactoryCalendar
ConfirmationGroup OperationConfirmation
NumberOfOperationConfirmations NumberOfOperationConfirmations
NumberOfCapacities NumberOfCapacities
ChangeNumber ChangeNumber
ObjectInternalID ObjectInternalID
Reservation _Order Reservation
NumberOfConfirmationSlips NumberOfConfirmationSlips
CostElement
EmployeeWageType EmployeeWageType
EmployeeWageGroup EmployeeWageGroup
EmployeeSuitability EmployeeSuitability
NumberOfTimeTickets NumberOfTimeTickets
NumberOfEmployees NumberOfEmployees
OperationSetupGroupCategory OperationSetupGroupCategory
OperationSetupGroup OperationSetupGroup
OperationSetupType OperationSetupType
BillOfOperationsType BillOfOperationsType
MasterRecipeGroup BillOfOperationsGroup
MasterRecipe BillOfOperationsVariant
MasterRecipeOperationIntID BOOOperationInternalID
ExtProcgOperationHasSubcontrg ExtProcgOperationHasSubcontrg
PurchasingOrganization PurchasingOrganization
PurchasingGroup PurchasingGroup
PurchaseRequisition PurchaseRequisition
PurchaseRequisitionItem PurchaseRequisitionItem
PurchaseOrder PurchaseOrder
PurchaseOrderItem PurchaseOrderItem
PurchasingInfoRecord PurchasingInfoRecord
PurgInfoRecdDataIsFixed PurgInfoRecdDataIsFixed
PurchasingInfoRecordCategory PurchasingInfoRecordCategory
Supplier Supplier
GoodsRecipientName GoodsRecipientName
UnloadingPointName UnloadingPointName
MaterialGroup MaterialGroup
OpExternalProcessingCurrency OpExternalProcessingCurrency
OpExternalProcessingPrice OpExternalProcessingPrice
NumberOfOperationPriceUnits NumberOfOperationPriceUnits
CompanyCode CompanyCode
BusinessArea BusinessArea
ProfitCenter ProfitCenter
RequestingCostCenter RequestingCostCenter
CostingVariant CostingVariant
CostingSheet CostingSheet
FunctionalArea FunctionalArea
ErlstSchedldExecStrtDte OpErlstSchedldExecStrtDte
ErlstSchedldExecStrtTime OpErlstSchedldExecStrtTme
ErlstSchedldExecEndDte OpErlstSchedldExecEndDte
ErlstSchedldExecEndTime OpErlstSchedldExecEndTme
LtstSchedldExecStrtDte OpLtstSchedldExecStrtDte
LtstSchedldExecStrtTime OpLtstSchedldExecStrtTme
LtstSchedldExecEndDte OpLtstSchedldExecEndDte
LtstSchedldExecEndTime OpLtstSchedldExecEndTme
ActualExecutionStartDate OpActualExecutionStartDate
ActualExecutionStartTime OpActualExecutionStartTime
ActualProcessingStartDate OpActualProcessingStartDate
ActualProcessingStartTime OpActualProcessingStartTime
ActualProcessingEndDate OpActualProcessingEndDate
ActualProcessingEndTime OpActualProcessingEndTime
ActualExecutionEndDate OpActualExecutionEndDate
ActualExecutionEndTime OpActualExecutionEndTime
StandardWorkQuantity1 WorkCenterStandardWorkQty1
CostCtrActivityType1 CostCtrActivityType1
StandardWorkQuantityUnit2 WorkCenterStandardWorkQtyUnit2
StandardWorkQuantity2 WorkCenterStandardWorkQty2
CostCtrActivityType2 CostCtrActivityType2
StandardWorkQuantityUnit3 WorkCenterStandardWorkQtyUnit3
StandardWorkQuantity3 WorkCenterStandardWorkQty3
CostCtrActivityType3 CostCtrActivityType3
StandardWorkQuantityUnit4 WorkCenterStandardWorkQtyUnit4
StandardWorkQuantity4 WorkCenterStandardWorkQty4
CostCtrActivityType4 CostCtrActivityType4
StandardWorkQuantityUnit5 WorkCenterStandardWorkQtyUnit5
StandardWorkQuantity5 WorkCenterStandardWorkQty5
CostCtrActivityType5 CostCtrActivityType5
StandardWorkQuantityUnit6 WorkCenterStandardWorkQtyUnit6
StandardWorkQuantity6 WorkCenterStandardWorkQty6
CostCtrActivityType6 CostCtrActivityType6
OperationUnit OperationUnit
OpQtyToBaseQtyDnmntr OpQtyToBaseQtyDnmntr
OpQtyToBaseQtyNmrtr OpQtyToBaseQtyNmrtr
OperationReferenceQuantity OperationReferenceQuantity
OpPlannedTotalQuantity OpPlannedTotalQuantity
OpPlannedScrapQuantity OpPlannedScrapQuantity
OpTotalConfirmedScrapQty OpTotalConfirmedScrapQty
WorkQuantityUnit1 OpWorkQuantityUnit1
ConfirmedWorkQuantity1 OpConfirmedWorkQuantity1
NoFurtherWorkQuantity1IsExpd NoFurtherOpWorkQuantity1IsExpd
WorkQuantityUnit2 OpWorkQuantityUnit2
ConfirmedWorkQuantity2 OpConfirmedWorkQuantity2
NoFurtherWorkQuantity2IsExpd NoFurtherOpWorkQuantity2IsExpd
WorkQuantityUnit3 OpWorkQuantityUnit3
ConfirmedWorkQuantity3 OpConfirmedWorkQuantity3
NoFurtherWorkQuantity3IsExpd NoFurtherOpWorkQuantity3IsExpd
WorkQuantityUnit4 OpWorkQuantityUnit4
ConfirmedWorkQuantity4 OpConfirmedWorkQuantity4
NoFurtherWorkQuantity4IsExpd NoFurtherOpWorkQuantity4IsExpd
WorkQuantityUnit5 OpWorkQuantityUnit5
ConfirmedWorkQuantity5 OpConfirmedWorkQuantity5
NoFurtherWorkQuantity5IsExpd NoFurtherOpWorkQuantity5IsExpd
WorkQuantityUnit6 OpWorkQuantityUnit6
ConfirmedWorkQuantity6 OpConfirmedWorkQuantity6
NoFurtherWorkQuantity6IsExpd NoFurtherOpWorkQuantity6IsExpd
BusinessProcess
BusinessProcessEntryUnit BusinessProcessEntryUnit
BusinessProcessConfirmedQty BusinessProcessConfirmedQty
NoFurtherBusinessProcQtyIsExpd NoFurtherBusinessProcQtyIsExpd
BusinessProcRemainingQtyUnit BusinessProcRemainingQtyUnit
BusinessProcessRemainingQty BusinessProcessRemainingQty
_Phase _Phase
_Order _Order
_Component _Component
_Supplier _Supplier
_SupplierCompanyByPlant _SupplierCompanyByPlant
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.modelingPattern: #NONE
@ObjectModel.supportedCapabilities: [#TRANSACTIONAL_PROVIDER]
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL
@EndUserText.label: 'Process Order Operation - TP'

//      ************************  DO NOT USE  ************************

//      *            This RAP BO is for testing purpose only         *

//      **************************************************************


define view entity R_ProcessOrderOperationTP
  as select from I_ManufacturingOrderOperation as Operation

  association        to parent R_ProcessOrderTP          as _Order on  _Order.ProcessOrder = $projection.ProcessOrder

  // BO relation

  composition [0..*] of R_ProcessOrderPhaseTP     as _Phase

  association [0..*] to R_ProcessOrderComponentTP as _Component    on  _Component.ProcessOrder             = $projection.ProcessOrder
                                                                   and _Component.OrderOperationInternalID = $projection.OrderOperationInternalID

  //  Extension

  association [1..1] to E_ProcessOrderOperation   as _Extension    on  _Extension.OrderInternalID          = $projection.OrderInternalID
                                                                   and _Extension.OrderOperationInternalID = $projection.OrderOperationInternalID
{
      // Technical Key

  key MfgOrderInternalID                                               as OrderInternalID,
  key OrderOperationInternalID,

      // Semantic Key

      cast(ManufacturingOrder as co_bord preserving type)              as ProcessOrder,
      @Consumption.hidden: true
      cast(ManufacturingOrderSequence as plnfolge preserving type)     as ProcessOrderSequence,
      cast(ManufacturingOrderOperation_2 as vdm_vornr preserving type) as ProcessOrderOperation,

      //      cast(ManufacturingOrdSubOperation_2 as vdm_uvorn preserving type) as SecondaryResource,


      // Text

      cast(MfgOrderOperationText as ltxa1 preserving type)             as OperationText,
      OperationStandardTextCode,
      OperationHasLongText,
      Language                                                         as LongTextLanguage,

      // Attributes

      OperationIsToBeDeleted,
      //      OperationImportance, // not relevant for PP orders - only for PS


      // Assignments

      Plant,
      cast(_WorkCenter.WorkCenter as cr_resourc preserving type)       as ProductionResource,
      @Consumption.hidden: true
      WorkCenterInternalID                                             as ProductionResourceInternalID,
//      @Consumption.hidden: true

//      WorkCenterTypeCode_2                                             as ProductionResourceType,

      OperationControlProfile,
      FactoryCalendar,
      OperationConfirmation                                            as ConfirmationGroup,
      NumberOfOperationConfirmations,
      NumberOfCapacities,
//      CapacityRequirement,

//      CapacityRequirementItem,

      ChangeNumber,
      ObjectInternalID,
      _Order.Reservation                                               as Reservation,
      NumberOfConfirmationSlips,
      cast(CostElement as kstar preserving type)                       as CostElement,
      EmployeeWageType,
      EmployeeWageGroup,
      EmployeeSuitability,
      NumberOfTimeTickets,
      NumberOfEmployees,
      OperationSetupGroupCategory,
      OperationSetupGroup,
      OperationSetupType,
      //      OperationSplitIsRequired,

      //      MaximumNumberOfSplits,


      // Assignment Master Recipe

      @Consumption.hidden: true
      BillOfOperationsType,
      BillOfOperationsGroup                                            as MasterRecipeGroup,
      BillOfOperationsVariant                                          as MasterRecipe,
//      @Consumption.hidden: true

//      BillOfOperationsSequence,

      BOOOperationInternalID                                           as MasterRecipeOperationIntID,

      // External processing

      @Semantics.booleanIndicator
      ExtProcgOperationHasSubcontrg,
      PurchasingOrganization,
      PurchasingGroup,
      PurchaseRequisition,
      PurchaseRequisitionItem,
      PurchaseOrder,
      PurchaseOrderItem,
      PurchasingInfoRecord,
      PurgInfoRecdDataIsFixed,
      PurchasingInfoRecordCategory,
      Supplier,
      GoodsRecipientName,
      UnloadingPointName,
      MaterialGroup,
      OpExternalProcessingCurrency,
      @Semantics.amount.currencyCode: 'OpExternalProcessingCurrency'
      OpExternalProcessingPrice,
      NumberOfOperationPriceUnits,

      // Assignments CO

      CompanyCode,
      BusinessArea,
//      ControllingArea,

      ProfitCenter,
      RequestingCostCenter,
      CostingVariant,
      CostingSheet,
      FunctionalArea,

      // Dates and times

      OpErlstSchedldExecStrtDte                                        as ErlstSchedldExecStrtDte,
      OpErlstSchedldExecStrtTme                                        as ErlstSchedldExecStrtTime,
      //      OpErlstSchedldProcgStrtDte, //

      //      OpErlstSchedldProcgStrtTme,

      //      OpErlstSchedldTrdwnStrtDte,

      //      OpErlstSchedldTrdwnStrtTme,

      OpErlstSchedldExecEndDte                                         as ErlstSchedldExecEndDte,
      OpErlstSchedldExecEndTme                                         as ErlstSchedldExecEndTime,
      OpLtstSchedldExecStrtDte                                         as LtstSchedldExecStrtDte,
      OpLtstSchedldExecStrtTme                                         as LtstSchedldExecStrtTime,
      //      OpLtstSchedldProcgStrtDte,

      //      OpLtstSchedldProcgStrtTme,

      //      OpLtstSchedldTrdwnStrtDte,

      //      OpLtstSchedldTrdwnStrtTme,

      OpLtstSchedldExecEndDte                                          as LtstSchedldExecEndDte,
      OpLtstSchedldExecEndTme                                          as LtstSchedldExecEndTime,
      //      SchedldFcstdEarliestStartDate,

      //      SchedldFcstdEarliestStartTime,

      //      SchedldFcstdEarliestEndDate,

      //      SchedldFcstdEarliestEndTime,

      //      LatestSchedldFcstdStartDate,

      //      SchedldFcstdLatestStartTime,

      //      LatestSchedldFcstdEndDate,

      //      SchedldFcstdLatestEndTime,

      //      OperationConfirmedStartDate,

      //      OperationConfirmedEndDate,


      OpActualExecutionStartDate                                       as ActualExecutionStartDate,
      OpActualExecutionStartTime                                       as ActualExecutionStartTime,
      //      OpActualSetupEndDate,

      //      OpActualSetupEndTime,

      OpActualProcessingStartDate                                      as ActualProcessingStartDate,
      OpActualProcessingStartTime                                      as ActualProcessingStartTime,
      OpActualProcessingEndDate                                        as ActualProcessingEndDate,
      OpActualProcessingEndTime                                        as ActualProcessingEndTime,
      //      OpActualTeardownStartDate,

      //      OpActualTeardownStartTme,

      OpActualExecutionEndDate                                         as ActualExecutionEndDate,
      OpActualExecutionEndTime                                         as ActualExecutionEndTime,
      //      ActualForecastEndDate,

      //      ActualForecastEndTime,

      //      EarliestScheduledWaitStartDate,

      //      EarliestScheduledWaitStartTime,

      //      EarliestScheduledWaitEndDate,

      //      EarliestScheduledWaitEndTime,

      //      LatestScheduledWaitStartDate,

      //      LatestScheduledWaitStartTime,

      //      LatestScheduledWaitEndDate,

      //      LatestScheduledWaitEndTime,


      //      BreakDurationUnit,

      //      @Semantics.quantity.unitOfMeasure: 'BreakDurationUnit'

      //      PlannedBreakDuration,

      //      @Semantics.quantity.unitOfMeasure: 'BreakDurationUnit'

      //      ConfirmedBreakDuration,

      //      OverlapMinimumDurationUnit,

      //      @Semantics.quantity.unitOfMeasure: 'OverlapMinimumDurationUnit'

      //      OverlapMinimumDuration,

      //      MaximumWaitDurationUnit,

      //      @Semantics.quantity.unitOfMeasure: 'MinimumWaitDurationUnit'

      //      MaximumWaitDuration,

      //      MinimumWaitDurationUnit,

      //      @Semantics.quantity.unitOfMeasure: 'StandardMoveDurationUnit'

      //      MinimumWaitDuration,

      //      StandardMoveDurationUnit,

      //      @Semantics.quantity.unitOfMeasure: 'StandardQueueDurationUnit'

      //      StandardMoveDuration,

      //      StandardQueueDurationUnit,

      //      @Semantics.quantity.unitOfMeasure: 'MinimumQueueDurationUnit'

      //      StandardQueueDuration,

      //      MinimumQueueDurationUnit,

      //      @Semantics.quantity.unitOfMeasure: 'MinimumMoveDurationUnit'

      //      MinimumQueueDuration,

      //      MinimumMoveDurationUnit,

      //      @Semantics.quantity.unitOfMeasure: 'MinimumMoveDurationUnit'

      //      MinimumMoveDuration,

      //      @Semantics.quantity.unitOfMeasure: 'OperationStandardDurationUnit'

      //      OperationStandardDuration,

      //      OperationStandardDurationUnit,

      //      @Semantics.quantity.unitOfMeasure: 'MinimumDurationUnit'

      //      MinimumDuration,

      //      MinimumDurationUnit,

      //      @Semantics.quantity.unitOfMeasure: 'ScheduledMoveDurationUnit'

      //      ScheduledMoveDuration,

      //      ScheduledMoveDurationUnit,

      //      @Semantics.quantity.unitOfMeasure: 'ScheduledQueueDurationUnit'

      //      ScheduledQueueDuration,

      //      ScheduledQueueDurationUnit,

      //      @Semantics.quantity.unitOfMeasure: 'ScheduledWaitDurationUnit'

      //      ScheduledWaitDuration,

      //      ScheduledWaitDurationUnit,

      //      @Semantics.quantity.unitOfMeasure: 'OpPlannedSetupDurnUnit'

      //      OpPlannedSetupDurn,

      //      OpPlannedSetupDurnUnit,

      //      @Semantics.quantity.unitOfMeasure: 'OpPlannedProcessingDurnUnit'

      //      OpPlannedProcessingDurn,

      //      OpPlannedProcessingDurnUnit,

      //      @Semantics.quantity.unitOfMeasure: 'OpPlannedTeardownDurnUnit'

      //      OpPlannedTeardownDurn,

      //      OpPlannedTeardownDurnUnit,

      //      StartDateOffsetReferenceCode,

      //      StartDateOffsetDurationUnit,

      //      @Semantics.quantity.unitOfMeasure: 'StartDateOffsetDurationUnit'

      //      StartDateOffsetDuration,

      //      EndDateOffsetReferenceCode,

      //      EndDateOffsetDurationUnit,

      //      @Semantics.quantity.unitOfMeasure: 'EndDateOffsetDurationUnit'

      //      EndDateOffsetDuration,


      -- Standard Values and activities / required on PI operation level? --
      WorkCenterStandardWorkQtyUnit1                                   as StandardWorkQuantityUnit1,
      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit1' //'WorkCenterStandardWorkQtyUnit1'

      WorkCenterStandardWorkQty1                                       as StandardWorkQuantity1,
      CostCtrActivityType1,
      WorkCenterStandardWorkQtyUnit2                                   as StandardWorkQuantityUnit2,
      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit2' //'WorkCenterStandardWorkQtyUnit2'

      WorkCenterStandardWorkQty2                                       as StandardWorkQuantity2,
      CostCtrActivityType2,
      WorkCenterStandardWorkQtyUnit3                                   as StandardWorkQuantityUnit3,
      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit3' //'WorkCenterStandardWorkQtyUnit3'

      WorkCenterStandardWorkQty3                                       as StandardWorkQuantity3,
      CostCtrActivityType3,
      WorkCenterStandardWorkQtyUnit4                                   as StandardWorkQuantityUnit4,
      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit4' //'WorkCenterStandardWorkQtyUnit4'

      WorkCenterStandardWorkQty4                                       as StandardWorkQuantity4,
      CostCtrActivityType4,
      WorkCenterStandardWorkQtyUnit5                                   as StandardWorkQuantityUnit5,
      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit5' //'WorkCenterStandardWorkQtyUnit5'

      WorkCenterStandardWorkQty5                                       as StandardWorkQuantity5,
      CostCtrActivityType5,
      WorkCenterStandardWorkQtyUnit6                                   as StandardWorkQuantityUnit6,
      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit6' //'WorkCenterStandardWorkQtyUnit6'

      WorkCenterStandardWorkQty6                                       as StandardWorkQuantity6,
      CostCtrActivityType6,

      // Quantities and UoM

      OperationUnit,
      OpQtyToBaseQtyDnmntr,
      OpQtyToBaseQtyNmrtr,


//      phase scrap only per MQC

//      OperationScrapPercent,

      @Semantics.quantity.unitOfMeasure: 'OperationUnit'
      OperationReferenceQuantity,
      @Semantics.quantity.unitOfMeasure: 'OperationUnit'
      OpPlannedTotalQuantity,
      @Semantics.quantity.unitOfMeasure: 'OperationUnit'
      OpPlannedScrapQuantity,

      -- Confirmed Work Quantities --
      @Semantics.quantity.unitOfMeasure: 'OperationUnit'
      OpTotalConfirmedYieldQty,
      @Semantics.quantity.unitOfMeasure: 'OperationUnit'
      OpTotalConfirmedScrapQty,

      OpWorkQuantityUnit1                                              as WorkQuantityUnit1,
      @Semantics.quantity.unitOfMeasure: 'WorkQuantityUnit1' //'OpWorkQuantityUnit1'

      OpConfirmedWorkQuantity1                                         as ConfirmedWorkQuantity1,
      NoFurtherOpWorkQuantity1IsExpd                                   as NoFurtherWorkQuantity1IsExpd,
      OpWorkQuantityUnit2                                              as WorkQuantityUnit2,
      @Semantics.quantity.unitOfMeasure: 'WorkQuantityUnit2' //'OpWorkQuantityUnit2'

      OpConfirmedWorkQuantity2                                         as ConfirmedWorkQuantity2,
      NoFurtherOpWorkQuantity2IsExpd                                   as NoFurtherWorkQuantity2IsExpd,
      OpWorkQuantityUnit3                                              as WorkQuantityUnit3,
      @Semantics.quantity.unitOfMeasure: 'WorkQuantityUnit3' //'OpWorkQuantityUnit3'

      OpConfirmedWorkQuantity3                                         as ConfirmedWorkQuantity3,
      NoFurtherOpWorkQuantity3IsExpd                                   as NoFurtherWorkQuantity3IsExpd,
      OpWorkQuantityUnit4                                              as WorkQuantityUnit4,
      @Semantics.quantity.unitOfMeasure: 'WorkQuantityUnit4' //'OpWorkQuantityUnit4'

      OpConfirmedWorkQuantity4                                         as ConfirmedWorkQuantity4,
      NoFurtherOpWorkQuantity4IsExpd                                   as NoFurtherWorkQuantity4IsExpd,
      OpWorkQuantityUnit5                                              as WorkQuantityUnit5,
      @Semantics.quantity.unitOfMeasure: 'WorkQuantityUnit5' //'OpWorkQuantityUnit5'

      OpConfirmedWorkQuantity5                                         as ConfirmedWorkQuantity5,
      NoFurtherOpWorkQuantity5IsExpd                                   as NoFurtherWorkQuantity5IsExpd,
      OpWorkQuantityUnit6                                              as WorkQuantityUnit6,
      @Semantics.quantity.unitOfMeasure: 'WorkQuantityUnit6' //'OpWorkQuantityUnit6'

      OpConfirmedWorkQuantity6                                         as ConfirmedWorkQuantity6,
      NoFurtherOpWorkQuantity6IsExpd                                   as NoFurtherWorkQuantity6IsExpd,

      // Business process

      cast(BusinessProcess as co_prznr preserving type)                as BusinessProcess,
      BusinessProcessEntryUnit,
      @Semantics.quantity.unitOfMeasure: 'BusinessProcessEntryUnit'
      BusinessProcessConfirmedQty,
      NoFurtherBusinessProcQtyIsExpd,
      BusinessProcRemainingQtyUnit,
      @Semantics.quantity.unitOfMeasure: 'BusinessProcRemainingQtyUnit'
      BusinessProcessRemainingQty,

      // relations

      _Phase, // composition

      _Order, // to-parent association

      _Component,

      @Consumption.hidden: true
      _Supplier,              // for DCLS

      @Consumption.hidden: true
      _SupplierCompanyByPlant // for DCLS

}
where
      ManufacturingOrderCategory     = '40'
  and MfgOrderOperationIsPhase       is initial // no phases

  and ManufacturingOrdSubOperation_2 is initial // no secondary resources