A_ProductionOrderItem_2

DDL: A_PRODUCTIONORDERITEM_2 Type: view_entity COMPOSITE Package: ODATA_PP_API_PRODORDER_2
27 Fields 1 Data Sources 1 Associations 1 OData Services

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 27 fields with key fields ManufacturingOrder, ManufacturingOrderItem. It has 1 association to related views. It is exposed through 1 OData service (ASQL_F8950). Part of development package ODATA_PP_API_PRODORDER_2.

Data Sources (1)

SourceAliasJoin Type
I_ManufacturingOrderItem I_ManufacturingOrderItem from

Associations (1)

CardinalityTargetAliasCondition
[0..*] A_ProdnOrderItemSerialNumber _ProdnOrderItemSerialNumber $projection.ManufacturingOrder = _ProdnOrderItemSerialNumber.ManufacturingOrder and $projection.ManufacturingOrderItem = _ProdnOrderItemSerialNumber.ManufacturingOrderItem

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

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F8950 ASQL_F8950 C2 NOT_RELEASED

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY ManufacturingOrder Order
KEY ManufacturingOrderItem ManufacturingOrderItem Manufacturing Order Item
ManufacturingOrderCategory ManufacturingOrderCategory
ManufacturingOrderType ManufacturingOrderType
IsCompletelyDelivered IsCompletelyDelivered Is completely delivered
Material Material Vehicle Model
ProductionPlant ProductionPlant Prod plnt
Plant PlanningPlant
MRPArea MRPArea MRP Area
QuantityDistributionKey QuantityDistributionKey Distribution
MaterialGoodsReceiptDuration MaterialGoodsReceiptDuration GR proc. time
StorageLocation StorageLocation StorageLocation
Batch Batch Lot No.
InventoryUsabilityCode InventoryUsabilityCode Stock Type
GoodsRecipientName GoodsRecipientName Recipient Name
UnloadingPointName UnloadingPointName Unloading Point Name
StockSegment StockSegment Stock Segment
MfgOrderItemPlndDeliveryDate MfgOrderItemPlndDeliveryDate
MfgOrderItemActualDeliveryDate MfgOrderItemActualDeliveryDate Delivery Date
ProductionUnit ProductionUnit
ProductionUnitISOCode _ProductionUnit UnitOfMeasureISOCode
ProductionUnitSAPCode _ProductionUnit UnitOfMeasureSAPCode
MfgOrderItemPlannedTotalQty MfgOrderItemPlannedTotalQty
MfgOrderItemPlannedScrapQty MfgOrderItemPlannedScrapQty
MfgOrderItemGoodsReceiptQty MfgOrderItemGoodsReceiptQty Goods Receipt Quantity
MfgOrderItemActualDeviationQty MfgOrderItemActualDeviationQty
_ProdnOrderItemSerialNumber _ProdnOrderItemSerialNumber

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_2.
-- 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_2 AS
SELECT
  cast(ManufacturingOrder as vdm_manufacturingorder preserving type) AS ManufacturingOrder,
  ManufacturingOrderItem,
  ManufacturingOrderCategory,
  ManufacturingOrderType,
  IsCompletelyDelivered,
  Material,
  ProductionPlant,
  PlanningPlant AS Plant,
  MRPArea,
  QuantityDistributionKey,
  MaterialGoodsReceiptDuration,
  StorageLocation,
  Batch,
  InventoryUsabilityCode,
  GoodsRecipientName,
  UnloadingPointName,
  StockSegment,
  MfgOrderItemPlndDeliveryDate,
  MfgOrderItemActualDeliveryDate,
  ProductionUnit,
  _ProductionUnit.UnitOfMeasureISOCode AS ProductionUnitISOCode,
  _ProductionUnit.UnitOfMeasureSAPCode AS ProductionUnitSAPCode,
  MfgOrderItemPlannedTotalQty,
  MfgOrderItemPlannedScrapQty,
  MfgOrderItemGoodsReceiptQty,
  MfgOrderItemActualDeviationQty
FROM I_ManufacturingOrderItem
LEFT OUTER JOIN A_ProdnOrderItemSerialNumber AS _ProdnOrderItemSerialNumber ON ManufacturingOrder = _ProdnOrderItemSerialNumber.ManufacturingOrder AND ManufacturingOrderItem = _ProdnOrderItemSerialNumber.ManufacturingOrderItem  -- association [0..*]
;

Learn More