A_ProductionOrderItem_2

DDL: A_PRODUCTIONORDERITEM_2 Type: view_entity COMPOSITE

Production Order Items

A_ProductionOrderItem_2 is a Composite CDS View that provides data about "Production Order Items" in SAP S/4HANA. It reads from 1 data source (I_ManufacturingOrderItem) and exposes 26 fields with key fields ManufacturingOrder, ManufacturingOrderItem.

Data Sources (1)

SourceAliasJoin Type
I_ManufacturingOrderItem I_ManufacturingOrderItem from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Production Order Items view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY ManufacturingOrder
KEY ManufacturingOrderItem ManufacturingOrderItem
ManufacturingOrderCategory ManufacturingOrderCategory
ManufacturingOrderType ManufacturingOrderType
IsCompletelyDelivered IsCompletelyDelivered
Material Material
ProductionPlant ProductionPlant
Plant PlanningPlant
MRPArea MRPArea
QuantityDistributionKey QuantityDistributionKey
MaterialGoodsReceiptDuration MaterialGoodsReceiptDuration
StorageLocation StorageLocation
Batch Batch
InventoryUsabilityCode InventoryUsabilityCode
GoodsRecipientName GoodsRecipientName
UnloadingPointName UnloadingPointName
StockSegment StockSegment
MfgOrderItemPlndDeliveryDate MfgOrderItemPlndDeliveryDate
MfgOrderItemActualDeliveryDate MfgOrderItemActualDeliveryDate
ProductionUnit ProductionUnit
ProductionUnitISOCode _ProductionUnit UnitOfMeasureISOCode
ProductionUnitSAPCode _ProductionUnit UnitOfMeasureSAPCode
MfgOrderItemPlannedTotalQty MfgOrderItemPlannedTotalQty
MfgOrderItemPlannedScrapQty MfgOrderItemPlannedScrapQty
MfgOrderItemGoodsReceiptQty MfgOrderItemGoodsReceiptQty Goods Receipt Quantity
MfgOrderItemActualDeviationQty MfgOrderItemActualDeviationQty
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Production Order Items'
@VDM.viewType: #COMPOSITE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@AccessControl.personalData.blocking: #NOT_REQUIRED

define view entity A_ProductionOrderItem_2
  as select from I_ManufacturingOrderItem
{
      // Key

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

      // Category and Type

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

      // Attributes

      IsCompletelyDelivered,                                                        // New field in CE2008

             
      // Assignments      

      Material, 
      ProductionPlant,
      PlanningPlant                                        as Plant,
      @ObjectModel.sapObjectNodeTypeReference: 'MRPArea'                
      MRPArea,
      QuantityDistributionKey,
       
      // Goods Receipt data       

      MaterialGoodsReceiptDuration,
      @ObjectModel.sapObjectNodeTypeReference: 'StorageLocation'
      StorageLocation,
      Batch,
      @ObjectModel.sapObjectNodeTypeReference: 'InventoryUsabilityCode'
      InventoryUsabilityCode,
      @Semantics.text: true     
      GoodsRecipientName,
      @Semantics.text: true  
      UnloadingPointName,       
      StockSegment,  
                           
      // Order Item Dates

      MfgOrderItemPlndDeliveryDate,
      MfgOrderItemActualDeliveryDate,
       
      // Item Quantities and UoM

      ProductionUnit,
      _ProductionUnit.UnitOfMeasureISOCode                 as ProductionUnitISOCode, // CE2105

      _ProductionUnit.UnitOfMeasureSAPCode                 as ProductionUnitSAPCode, // CE2105   

      @Semantics.quantity.unitOfMeasure: 'ProductionUnit'
      MfgOrderItemPlannedTotalQty,    
      @Semantics.quantity.unitOfMeasure: 'ProductionUnit'
      MfgOrderItemPlannedScrapQty,    
      @EndUserText.label: 'Goods Receipt Quantity'
      @Semantics.quantity.unitOfMeasure: 'ProductionUnit'
      MfgOrderItemGoodsReceiptQty,    
      @Semantics.quantity.unitOfMeasure: 'ProductionUnit'
      MfgOrderItemActualDeviationQty 

}
where
  ManufacturingOrderCategory = '10';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MANUFACTURINGORDERITEM",
"I_UNITOFMEASURE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/