A_ProductionOrderItem

DDL: A_PRODUCTIONORDERITEM Type: view_entity COMPOSITE Package: ODATA_PP_API_PRODORDER
23 Fields 1 Data Sources

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. Part of development package ODATA_PP_API_PRODORDER.

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 Order
KEY ManufacturingOrderItem ManufacturingOrderItem Manufacturing Order Item
ManufacturingOrderCategory ManufacturingOrderCategory
ManufacturingOrderType ManufacturingOrderType
ProductionPlant ProductionPlant Prod plnt
Material Material Vehicle Model
MRPPlant MRPPlant Plant
MfgOrderItemActualDeliveryDate MfgOrderItemActualDeliveryDate Delivery Date
MfgOrderItemPlannedTotalQty MfgOrderItemPlannedTotalQty
MfgOrderItemPlannedScrapQty MfgOrderItemPlannedScrapQty
MfgOrderItemGoodsReceiptQty MfgOrderItemGoodsReceiptQty Goods Receipt Quantity
MfgOrderItemActualDeviationQty MfgOrderItemActualDeviationQty
ProductionUnit ProductionUnit
MRPArea MRPArea MRP Area
StorageLocation StorageLocation StorageLocation
MfgOrderItemPlndDeliveryDate MfgOrderItemPlndDeliveryDate
GoodsRecipientName GoodsRecipientName Recipient Name
MaterialGoodsReceiptDuration MaterialGoodsReceiptDuration GR proc. time
InventoryUsabilityCode InventoryUsabilityCode Stock Type
UnloadingPointName UnloadingPointName Unloading Point Name
QuantityDistributionKey QuantityDistributionKey Distribution
StockSegment StockSegment Stock Segment
Batch Batch Lot No.

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view A_ProductionOrderItem.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW A_ProductionOrderItem AS
SELECT
  ManufacturingOrder,
  ManufacturingOrderItem,
  ManufacturingOrderCategory,
  ManufacturingOrderType,
  ProductionPlant,
  Material,
  MRPPlant,
  MfgOrderItemActualDeliveryDate,
  MfgOrderItemPlannedTotalQty,
  MfgOrderItemPlannedScrapQty,
  MfgOrderItemGoodsReceiptQty,
  MfgOrderItemActualDeviationQty,
  ProductionUnit,
  MRPArea,
  StorageLocation,
  MfgOrderItemPlndDeliveryDate,
  GoodsRecipientName,
  MaterialGoodsReceiptDuration,
  InventoryUsabilityCode,
  UnloadingPointName,
  QuantityDistributionKey,
  StockSegment,
  Batch
FROM I_MfgOrderItem
;

Learn More