A_ProcessOrderItem

DDL: A_PROCESSORDERITEM Type: view_entity COMPOSITE Package: ODATA_PP_API_PROCORDER
23 Fields 1 Data Sources

API Process Order Items

A_ProcessOrderItem is a Composite CDS View that provides data about "API Process 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_PROCORDER.

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderItem I_MfgOrderItem from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label API Process Order Items 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

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_ProcessOrderItem.
-- 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_ProcessOrderItem 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