A_ProductionOrderComponent

DDL: A_PRODUCTIONORDERCOMPONENT Type: view_entity COMPOSITE Package: ODATA_PP_API_PRODORDER

API Production Order Components

A_ProductionOrderComponent is a Composite CDS View that provides data about "API Production Order Components" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderOperationComponent) and exposes 28 fields with key fields Reservation, ReservationItem. Part of development package ODATA_PP_API_PRODORDER.

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderOperationComponent I_MfgOrderOperationComponent from

Annotations (8)

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

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY Reservation Reservation Reservation
KEY ReservationItem ReservationItem Reservation Item
BillOfMaterialItemNumber BillOfMaterialItemNumber Item
BOMItemDescription BOMItemDescription BOM Item Text
Material Material Vehicle Model
Plant Plant Valuation Area
ProductionPlant ProductionPlant Prod plnt
MatlCompRequirementDate MatlCompRequirementDate Reqmts date
BaseUnit BaseUnit Unit
RequiredQuantity RequiredQuantity Requirement qty
WithdrawnQuantity WithdrawnQuantity Withdrawn Quantity
BOMItem BOMItem
StorageLocation StorageLocation
SupplyArea SupplyArea Supply Area
ManufacturingOrderSequence ManufacturingOrderSequence
ManufacturingOrder ManufacturingOrder Production Order
ManufacturingOrderOperation ManufacturingOrderOperation Activity
ManufacturingOrderCategory ManufacturingOrderCategory
ManufacturingOrderType ManufacturingOrderType
OrderInternalBillOfOperations OrderInternalBillOfOperations Order Internal Bill of Operations
BOMItemText2 BOMItemText2 Item Text
BOMItemCategory BOMItemCategory Item Category
BillOfMaterialCategory BillOfMaterialCategory BOM category
SortField SortField Sort Field
GoodsRecipientName GoodsRecipientName Recipient Name
UnloadingPointName UnloadingPointName Unloading Point Name
Batch Batch Lot No.
BatchSplitType BatchSplitType Checkbox

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_ProductionOrderComponent.
-- 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_ProductionOrderComponent AS
SELECT
  Reservation,
  ReservationItem,
  BillOfMaterialItemNumber,
  BOMItemDescription,
  Material,
  Plant,
  ProductionPlant,
  MatlCompRequirementDate,
  BaseUnit,
  RequiredQuantity,
  WithdrawnQuantity,
  BOMItem,
  cast(StorageLocation as pph_lgort preserving type ) AS StorageLocation,
  SupplyArea,
  ManufacturingOrderSequence,
  ManufacturingOrder,
  ManufacturingOrderOperation,
  ManufacturingOrderCategory,
  ManufacturingOrderType,
  OrderInternalBillOfOperations,
  BOMItemText2,
  BOMItemCategory,
  BillOfMaterialCategory,
  SortField,
  GoodsRecipientName,
  UnloadingPointName,
  Batch,
  BatchSplitType
FROM I_MfgOrderOperationComponent
;