A_ProcessOrderItem_2

DDL: A_PROCESSORDERITEM_2 Type: view_entity COMPOSITE Package: ODATA_PP_API_PROCORDER_2
26 Fields 1 Data Sources 1 OData Services

Process Order Items

A_ProcessOrderItem_2 is a Composite CDS View that provides data about "Process Order Items" in SAP S/4HANA. It reads from 1 data source (I_ManufacturingOrderItem) and exposes 26 fields with key fields ManufacturingOrder, ManufacturingOrderItem. It is exposed through 1 OData service (ASQL_F8950). Part of development package ODATA_PP_API_PROCORDER_2.

Data Sources (1)

SourceAliasJoin Type
I_ManufacturingOrderItem I_ManufacturingOrderItem from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Process 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 (26)

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

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_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_ProcessOrderItem_2 AS
SELECT
  cast(ManufacturingOrder as co_bid 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
;

Learn More