A_ProcessOrder_2

DDL: A_PROCESSORDER_2 Type: view_entity COMPOSITE Package: ODATA_PP_API_PROCORDER_2

Process Order

A_ProcessOrder_2 is a Composite CDS View that provides data about "Process Order" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderWithStatus) and exposes 77 fields with key field ManufacturingOrder. It has 6 associations to related views. Part of development package ODATA_PP_API_PROCORDER_2.

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderWithStatus I_MfgOrderWithStatus from

Associations (6)

CardinalityTargetAliasCondition
[0..*] A_ProcessOrderOperation_2 _ProcessOrderOperation $projection.ManufacturingOrder = _ProcessOrderOperation.ManufacturingOrder
[0..*] A_ProcessOrderComponent_2 _ProcessOrderComponent $projection.ManufacturingOrder = _ProcessOrderComponent.ManufacturingOrder
[0..*] A_ProcessOrderItem_2 _ProcessOrderItem $projection.ManufacturingOrder = _ProcessOrderItem.ManufacturingOrder
[0..*] A_ProcessOrderStatus_2 _ProcessOrderStatus $projection.ManufacturingOrder = _ProcessOrderStatus.ManufacturingOrder
[0..*] A_ProcessOrderProdnRsceTools_2 _ProcessProdnRsceTools $projection.ManufacturingOrder = _ProcessProdnRsceTools.ManufacturingOrder
[1..1] E_LogisticsOrder _Extension $projection.ManufacturingOrder = _Extension.OrderID

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Process Order view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey ManufacturingOrder view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled 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 (77)

KeyFieldSource TableSource FieldDescription
KEY ManufacturingOrder
ManufacturingOrderCategory ManufacturingOrderCategory
ManufacturingOrderType ManufacturingOrderType
OrderLongText _LongText PlainLongText
ManufacturingOrderImportance ManufacturingOrderImportance
OrderIsCreated OrderIsCreated
OrderIsReleased OrderIsReleased
OrderIsPrinted OrderIsPrinted
OrderIsConfirmed OrderIsConfirmed
OrderIsPartiallyConfirmed OrderIsPartiallyConfirmed
OrderIsDelivered OrderIsDelivered
OrderIsDeleted OrderIsDeleted
OrderIsPreCosted OrderIsPreCosted
SettlementRuleIsCreated SettlementRuleIsCreated
OrderIsPartiallyReleased OrderIsPartiallyReleased
OrderIsLocked OrderIsLocked
OrderIsTechnicallyCompleted OrderIsTechnicallyCompleted
OrderIsClosed OrderIsClosed
OrderIsPartiallyDelivered OrderIsPartiallyDelivered
OrderIsMarkedForDeletion OrderIsMarkedForDeletion
SettlementRuleIsCrtedManually SettlementRuleIsCrtedManually
OrderIsScheduled OrderIsScheduled
OrderHasGeneratedOperations OrderHasGeneratedOperations
OrderIsToBeHandledInBatches OrderIsToBeHandledInBatches
MaterialAvailyIsNotChecked MaterialAvailyIsNotChecked
MfgOrderCreationDate CreationDate
MfgOrderCreationTime CreationTime
Material Material
StorageLocation StorageLocation
GoodsRecipientName GoodsRecipientName
UnloadingPointName UnloadingPointName
InventoryUsabilityCode InventoryUsabilityCode
MaterialGoodsReceiptDuration MaterialGoodsReceiptDuration
QuantityDistributionKey QuantityDistributionKey
StockSegment StockSegment
OrderInternalBillOfOperations MfgOrderInternalID
ProductionPlant ProductionPlant
Plant PlanningPlant
MRPArea MRPArea
MRPController MRPController
ProductionSupervisor ProductionSupervisor
ProductionVersion ProductionVersion
PlannedOrder PlannedOrder
SalesOrder SalesOrder
SalesOrderItem SalesOrderItem
BasicSchedulingType BasicSchedulingType
ManufacturingObject ManufacturingObject
ProductConfiguration ProductConfiguration
OrderSequenceNumber OrderSequenceNumber
BusinessArea BusinessArea
CompanyCode CompanyCode
ProfitCenter ProfitCenter
ActualCostsCostingVariant ActualCostsCostingVariant Actual Costing Variant
PlannedCostsCostingVariant PlannedCostsCostingVariant Planned Costing Variant
FunctionalArea FunctionalArea
MfgOrderPlannedStartDate MfgOrderPlannedStartDate
MfgOrderPlannedStartTime MfgOrderPlannedStartTime
MfgOrderPlannedEndDate MfgOrderPlannedEndDate
MfgOrderPlannedEndTime MfgOrderPlannedEndTime
MfgOrderScheduledStartDate MfgOrderScheduledStartDate
MfgOrderScheduledStartTime MfgOrderScheduledStartTime
MfgOrderScheduledEndDate MfgOrderScheduledEndDate
MfgOrderScheduledEndTime MfgOrderScheduledEndTime
MfgOrderActualReleaseDate MfgOrderActualReleaseDate
ProductionUnit ProductionUnit
ProductionUnitISOCode _ProductionUnit UnitOfMeasureISOCode
ProductionUnitSAPCode _ProductionUnit UnitOfMeasureSAPCode
TotalQuantity MfgOrderPlannedTotalQty
MfgOrderPlannedScrapQty MfgOrderPlannedScrapQty
MfgOrderConfirmedYieldQty MfgOrderConfirmedYieldQty
CustomerName
WBSElementExternalID _WBSElementBasicData WBSElementExternalID
_ProcessOrderOperation _ProcessOrderOperation
_ProcessOrderComponent _ProcessOrderComponent
_ProcessOrderStatus _ProcessOrderStatus
_ProcessOrderItem _ProcessOrderItem
_ProcessProdnRsceTools _ProcessProdnRsceTools
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Process Order'
@VDM.viewType: #COMPOSITE
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.representativeKey: 'ManufacturingOrder'
@ObjectModel.createEnabled: true
@ObjectModel.updateEnabled: true
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED}
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API

define view entity A_ProcessOrder_2 as select from I_MfgOrderWithStatus

  association [0..*] to A_ProcessOrderOperation_2      as _ProcessOrderOperation             // Operations

                                                       on  $projection.ManufacturingOrder = _ProcessOrderOperation.ManufacturingOrder
                                                      
  association [0..*] to A_ProcessOrderComponent_2      as _ProcessOrderComponent             // Components

                                                       on  $projection.ManufacturingOrder = _ProcessOrderComponent.ManufacturingOrder
                                                      
  association [0..*] to A_ProcessOrderItem_2           as _ProcessOrderItem                  // Items

                                                       on  $projection.ManufacturingOrder = _ProcessOrderItem.ManufacturingOrder
                                                      
  association [0..*] to A_ProcessOrderStatus_2         as _ProcessOrderStatus                // Status

                                                       on  $projection.ManufacturingOrder = _ProcessOrderStatus.ManufacturingOrder
                                                      
  association [0..*] to A_ProcessOrderProdnRsceTools_2 as _ProcessProdnRsceTools             // PRT

                                                       on  $projection.ManufacturingOrder = _ProcessProdnRsceTools.ManufacturingOrder
                                                     
  association [1..1] to E_LogisticsOrder               as _Extension                         // Extensibility

                                                       on  $projection.ManufacturingOrder = _Extension.OrderID
                                                                                                                                                     
{
      // Key

  @ObjectModel.sapObjectNodeTypeReference: 'ProductionOrder'    
  key cast(ManufacturingOrder                          as co_bid preserving type) as ManufacturingOrder,

      // Category and Type

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

      @Semantics.text:true
      _LongText.PlainLongText                            as OrderLongText,                     // New field in CE2008


      // Attributes

      @ObjectModel.sapObjectNodeTypeReference: 'ManufacturingOrderImportance'
      ManufacturingOrderImportance,                                                            // New change field in CE2008      


      // Status

      OrderIsCreated,
      OrderIsReleased,
      OrderIsPrinted,
      OrderIsConfirmed,
      OrderIsPartiallyConfirmed,
      OrderIsDelivered,
      OrderIsDeleted,
      OrderIsPreCosted,
      SettlementRuleIsCreated,
      OrderIsPartiallyReleased,
      OrderIsLocked,
      OrderIsTechnicallyCompleted,
      OrderIsClosed,
      OrderIsPartiallyDelivered,
      OrderIsMarkedForDeletion,
      SettlementRuleIsCrtedManually,
      OrderIsScheduled,
      OrderHasGeneratedOperations,
      OrderIsToBeHandledInBatches,
      MaterialAvailyIsNotChecked,

      // Admin

      CreationDate as MfgOrderCreationDate,
      CreationTime as MfgOrderCreationTime,
      case LastChangeDate
        when '00000000' then                                                                   // not changed yet, use create

          concat(CreationDate,CreationTime)
        else
          concat(LastChangeDate,LastChangeTime)
      end                                                as LastChangeDateTime,                // eTag


      // Header Material data          

      Material,
      @ObjectModel.sapObjectNodeTypeReference: 'StorageLocation'
      StorageLocation,                                                                         // New change field in CE2008

      @Semantics.text: true         
      GoodsRecipientName,                                                                      // New change field in CE2008

      @Semantics.text: true  
      UnloadingPointName,                                                                      // New change field in CE2008

      @ObjectModel.sapObjectNodeTypeReference: 'InventoryUsabilityCode'
      InventoryUsabilityCode,                                                                  // New change field in CE2008       

      MaterialGoodsReceiptDuration,                                                            // New change field in CE2008

      QuantityDistributionKey,                                                                 // New change field in CE2008

      StockSegment,                                                                            // New change field in CE2008

                    
      // Assignments

      MfgOrderInternalID                                 as OrderInternalBillOfOperations,  
      ProductionPlant,
      PlanningPlant                                      as Plant,
      @ObjectModel.sapObjectNodeTypeReference: 'MRPArea'
      MRPArea,
      @ObjectModel.sapObjectNodeTypeReference: 'MRPController'
      MRPController,                                                                           // New change field in CE2008    

      @ObjectModel.sapObjectNodeTypeReference: 'ProductionSupervisor'
      ProductionSupervisor,
      ProductionVersion,                                                                       // New change field in CE2008  

      @ObjectModel.sapObjectNodeTypeReference: 'PlannedOrder'
      PlannedOrder,
      @ObjectModel.sapObjectNodeTypeReference: 'SalesOrder'
      SalesOrder,
      SalesOrderItem,
      @ObjectModel.sapObjectNodeTypeReference: 'SchedulingType'
      BasicSchedulingType,
      ManufacturingObject,
      ProductConfiguration,                                                                    // New field in CE2008

      OrderSequenceNumber,                                                                     // New change field in CE2008

 
      // Assignments FI/CO

      @ObjectModel.sapObjectNodeTypeReference: 'BusinessArea'
      BusinessArea,                                                                            // New change field in CE2008                                                                                                     

      @ObjectModel.sapObjectNodeTypeReference: 'CompanyCode'
      CompanyCode,
      @ObjectModel.sapObjectNodeTypeReference: 'ProfitCenter'
      ProfitCenter,                                                                            // New change field in CE2008

      @EndUserText.label: 'Actual Costing Variant'
      @ObjectModel.sapObjectNodeTypeReference: 'CostingVariant'
      ActualCostsCostingVariant,
      @EndUserText.label: 'Planned Costing Variant'
      PlannedCostsCostingVariant,
      FunctionalArea,                            
                   
      // Dates and Times

      MfgOrderPlannedStartDate,
      MfgOrderPlannedStartTime,
      MfgOrderPlannedEndDate,
      MfgOrderPlannedEndTime,
      MfgOrderScheduledStartDate,
      MfgOrderScheduledStartTime,
      MfgOrderScheduledEndDate,
      MfgOrderScheduledEndTime,
      MfgOrderActualReleaseDate,
                 
      // Quantities and UoM

      ProductionUnit,
      _ProductionUnit.UnitOfMeasureISOCode               as ProductionUnitISOCode,             // CE2105 

      _ProductionUnit.UnitOfMeasureSAPCode               as ProductionUnitSAPCode,             // CE2105      

      @Semantics.quantity.unitOfMeasure: 'ProductionUnit'
      MfgOrderPlannedTotalQty                            as TotalQuantity,
      @Semantics.quantity.unitOfMeasure: 'ProductionUnit'
      MfgOrderPlannedScrapQty,
      @Semantics.quantity.unitOfMeasure: 'ProductionUnit'
      MfgOrderConfirmedYieldQty,
      
      // Associations

      _SalesDocument._SoldToParty.CustomerName           as CustomerName,
      _WBSElementBasicData.WBSElementExternalID,                                               // New field in CE2008

      _ProcessOrderOperation,
      _ProcessOrderComponent,
      _ProcessOrderStatus,
      _ProcessOrderItem,
      _ProcessProdnRsceTools

}
where
  ManufacturingOrderCategory = '40';