A_ProductionOrderItem

DDL: A_PRODUCTIONORDERITEM Type: view_entity COMPOSITE

API Production Order Items

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

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderItem I_MfgOrderItem from

Annotations (9)

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

Fields (23)

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

define view entity A_ProductionOrderItem
  as select from I_MfgOrderItem
{
       //ITEMS


  key  ManufacturingOrder,
  key  ManufacturingOrderItem,         // ProductionOrderItem,

       ManufacturingOrderCategory,
       ManufacturingOrderType,
       ProductionPlant,
       Material,                       // Material,

       MRPPlant,                       // PlanningPlant,

       MfgOrderItemActualDeliveryDate, // DeliveryDate,

       @Semantics.quantity.unitOfMeasure: 'ProductionUnit'
       MfgOrderItemPlannedTotalQty,    // TotalQuantity,

       @Semantics.quantity.unitOfMeasure: 'ProductionUnit'
       MfgOrderItemPlannedScrapQty,    // ScrapQuantity,

       @EndUserText.label: 'Goods Receipt Quantity'
       @Semantics.quantity.unitOfMeasure: 'ProductionUnit'
       MfgOrderItemGoodsReceiptQty,    // ReceiptQuantity,

       @Semantics.quantity.unitOfMeasure: 'ProductionUnit'
       MfgOrderItemActualDeviationQty, // ExpectedVariance,

       ProductionUnit,
       MRPArea,
       StorageLocation,
       MfgOrderItemPlndDeliveryDate,
       
       // added for extension of API_PRODUCION_ORDERS

       GoodsRecipientName,
       MaterialGoodsReceiptDuration,
       InventoryUsabilityCode,
       UnloadingPointName,
       QuantityDistributionKey,
       StockSegment,    
       Batch                           // extended in CE1911

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