A_ProcessOrderOperation_2

DDL: A_PROCESSORDEROPERATION_2 Type: view_entity COMPOSITE

Process Order Operations

A_ProcessOrderOperation_2 is a Composite CDS View that provides data about "Process Order Operations" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderOperationDurn) and exposes 51 fields with key fields OrderInternalBillOfOperations, OrderIntBillOfOperationsItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderOperationDurn I_MfgOrderOperationDurn from

Associations (2)

CardinalityTargetAliasCondition
[1..1] E_OrderOperation _Extension $projection.OrderInternalBillOfOperations = _Extension.OrderInternalID and $projection.OrderIntBillOfOperationsItem = _Extension.OrderOperationInternalID
[1..1] I_MfgOrderSequence _OrderSequence $projection.ManufacturingOrder = _OrderSequence.ManufacturingOrder and $projection.ManufacturingOrderSequence = _OrderSequence.ManufacturingOrderSequence and $projection.OrderInternalBillOfOperations = _OrderSequence.OrderInternalID

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Process Order Operations view
VDM.viewType #COMPOSITE view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (51)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalBillOfOperations OrderInternalBillOfOperations
KEY OrderIntBillOfOperationsItem OrderIntBillOfOperationsItem
ManufacturingOrder
ManufacturingOrderSequence ManufacturingOrderSequence
MfgOrderSequenceText
ManufacturingOrderOperation ManufacturingOrderOperation
ManufacturingOrderSubOperation ManufacturingOrderSubOperation
ManufacturingOrderCategory ManufacturingOrderCategory
ManufacturingOrderType ManufacturingOrderType
MfgOrderOperationText MfgOrderOperationText
OrderOperationLongText _LongText OrderOperationLongText
MfgOrderOperationIsPhase MfgOrderOperationIsPhase
MfgOrderPhaseSuperiorOperation MfgOrdPhaseSuperiorOperation_2
OperationIsCreated OperationIsCreated
OperationIsReleased OperationIsReleased
OperationIsPrinted OperationIsPrinted
OperationIsConfirmed OperationIsConfirmed
OperationIsPartiallyConfirmed OperationIsPartiallyConfirmed
OperationIsDeleted OperationIsDeleted
OperationIsTechlyCompleted OperationIsTechlyCompleted
OperationIsClosed OperationIsClosed
OperationIsScheduled OperationIsScheduled
OperationIsPartiallyDelivered OperationIsPartiallyDelivered
OperationIsDelivered OperationIsDelivered
ProductionPlant ProductionPlant
WorkCenterInternalID WorkCenterInternalID
WorkCenterTypeCode WorkCenterTypeCode Work Center Type Code
WorkCenter WorkCenter
OperationControlProfile OperationControlProfile
OpExternalProcessingPriceUnit OpExternalProcessingPriceUnit
OpErlstSchedldExecStrtDte OpErlstSchedldExecStrtDte
OpErlstSchedldExecStrtTme OpErlstSchedldExecStrtTme
OpErlstSchedldExecEndDte OpErlstSchedldExecEndDte
OpErlstSchedldExecEndTme OpErlstSchedldExecEndTme
OpActualExecutionStartDate OpActualExecutionStartDate
OpActualExecutionStartTime OpActualExecutionStartTime
OpActualExecutionEndDate OpActualExecutionEndDate
OpActualExecutionEndTime OpActualExecutionEndTime
ErlstSchedldExecDurnInWorkdays ErlstSchedldExecDurnInWorkdays Scheduled Execution Duration
OpActualExecutionDays OpActualExecutionDays Actual Execution Duration
MinimumProcessingDuration MinimumProcessingDuration
MinimumProcessingDurationUnit MinimumProcessingDurationUnit
OperationUnit OperationUnit
OperationUnitISOCode _OperationUnit UnitOfMeasureISOCode
OperationUnitSAPCode _OperationUnit UnitOfMeasureSAPCode
OpPlannedTotalQuantity OpPlannedTotalQuantity
OpTotalConfirmedYieldQty OpTotalConfirmedYieldQty
OpTotalConfirmedScrapQty OpTotalConfirmedScrapQty
OpPlannedScrapQuantity OpPlannedScrapQuantity
OperationReferenceQuantity OperationReferenceQuantity
LastChangeTimeendasLastChangeDateTime
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Process Order Operations'
@VDM.viewType: #COMPOSITE
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED}
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API

define view entity A_ProcessOrderOperation_2
  as select from I_MfgOrderOperationDurn
  association [1..1] to E_OrderOperation   as _Extension // Extensibility

                                                             on  $projection.OrderInternalBillOfOperations = _Extension.OrderInternalID
                                                             and $projection.OrderIntBillOfOperationsItem  = _Extension.OrderOperationInternalID
  association [1..1] to I_MfgOrderSequence as _OrderSequence on  $projection.ManufacturingOrder            = _OrderSequence.ManufacturingOrder
                                                             and $projection.ManufacturingOrderSequence    = _OrderSequence.ManufacturingOrderSequence
                                                             and $projection.OrderInternalBillOfOperations = _OrderSequence.OrderInternalID

{
      // Technical Key

  key OrderInternalBillOfOperations,
  key OrderIntBillOfOperationsItem,

      // Semantical Key

      @ObjectModel.sapObjectNodeTypeReference: 'ProductionOrder'
      cast(ManufacturingOrder as co_bid preserving type)                                as ManufacturingOrder,
      ManufacturingOrderSequence,
      cast(_OrderSequence.MfgOrderSequenceText as mfgordersequencetext preserving type) as MfgOrderSequenceText,
      @ObjectModel.text.element: ['MfgOrderOperationText']
      ManufacturingOrderOperation,
      ManufacturingOrderSubOperation,

      // Order header data

      @ObjectModel.sapObjectNodeTypeReference: 'ManufacturingOrderCategory'
      ManufacturingOrderCategory,
      @ObjectModel.sapObjectNodeTypeReference: 'ManufacturingOrderType'
      ManufacturingOrderType,

      // Text

      MfgOrderOperationText,
      @Semantics.text:true
      _LongText.OrderOperationLongText,

      // Attributes

      MfgOrderOperationIsPhase, // CE2208

      MfgOrdPhaseSuperiorOperation_2                                                    as MfgOrderPhaseSuperiorOperation, // CE2208 No conv. exit


      // Status

      OperationIsCreated,
      OperationIsReleased,
      OperationIsPrinted,
      OperationIsConfirmed,
      OperationIsPartiallyConfirmed,
      OperationIsDeleted,
      OperationIsTechlyCompleted,
      OperationIsClosed,
      OperationIsScheduled,
      OperationIsPartiallyDelivered,
      OperationIsDelivered,

      // Assignments

      ProductionPlant,
      WorkCenterInternalID,
      @EndUserText.label: 'Work Center Type Code '
      WorkCenterTypeCode,
      WorkCenter,
      OperationControlProfile,

      // Assignments Purchasing

      @Semantics.quantity.unitOfMeasure: 'OperationUnit'
      OpExternalProcessingPriceUnit,                                    // New field in OP2023.FPS03


      // Dates and Times

      OpErlstSchedldExecStrtDte,
      OpErlstSchedldExecStrtTme,
      OpErlstSchedldExecEndDte,
      OpErlstSchedldExecEndTme,
      OpActualExecutionStartDate,
      OpActualExecutionStartTime,
      OpActualExecutionEndDate,
      OpActualExecutionEndTime,

      // Durations

      @EndUserText.label:'Scheduled Execution Duration'
      ErlstSchedldExecDurnInWorkdays,
      @EndUserText.label:'Actual Execution Duration'
      OpActualExecutionDays,
      @Semantics.quantity.unitOfMeasure: 'MinimumProcessingDurationUnit'
      MinimumProcessingDuration,      // New field in OP2023.FPS03

      MinimumProcessingDurationUnit,  // New field in OP2023.FPS03

      @Semantics.quantity.unitOfMeasure: 'ForecastProcessingDurationUnit'
      ForecastProcessingDuration,     // New field in OP2023.FPS03

      ForecastProcessingDurationUnit, // New field in OP2023.FPS03


      // Quantities and UoM

      OperationUnit,
      _OperationUnit.UnitOfMeasureISOCode                                               as OperationUnitISOCode, // CE2105

      _OperationUnit.UnitOfMeasureSAPCode                                               as OperationUnitSAPCode, // CE2105

      @Semantics.quantity.unitOfMeasure: 'OperationUnit'
      OpPlannedTotalQuantity,
      @Semantics.quantity.unitOfMeasure: 'OperationUnit'
      OpTotalConfirmedYieldQty,
      @Semantics.quantity.unitOfMeasure: 'OperationUnit'
      OpTotalConfirmedScrapQty,   // New field in OP2023.FPS03

      @Semantics.quantity.unitOfMeasure: 'OperationUnit'
      OpPlannedScrapQuantity,     // New field in OP2023.FPS03

      @Semantics.quantity.unitOfMeasure: 'OperationUnit'
      OperationReferenceQuantity, // New field in OP2023.FPS03


      // Admin

      case I_MfgOrderOperationDurn._MfgOrder.LastChangeDate
        when '00000000' then  // not changed yet, use create

          concat(I_MfgOrderOperationDurn._MfgOrder.MfgOrderCreationDate , I_MfgOrderOperationDurn._MfgOrder.MfgOrderCreationTime)
        else
          concat(I_MfgOrderOperationDurn._MfgOrder.LastChangeDate,I_MfgOrderOperationDurn._MfgOrder.LastChangeTime)
      end                                                                               as LastChangeDateTime //eTag


}
where
  ManufacturingOrderCategory = '40';