A_ProductionOrderComponent_2

DDL: A_PRODUCTIONORDERCOMPONENT_2 Type: view_entity COMPOSITE Package: ODATA_PP_API_PRODORDER_2
58 Fields 1 Data Sources 1 OData Services

Production Order Components

A_ProductionOrderComponent_2 is a Composite CDS View that provides data about "Production Order Components" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderOperationComponent) and exposes 58 fields with key fields Reservation, ReservationItem. It is exposed through 1 OData service (ASQL_F8950). Part of development package ODATA_PP_API_PRODORDER_2.

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderOperationComponent I_MfgOrderOperationComponent from

Annotations (9)

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

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F8950 ASQL_F8950 C2 NOT_RELEASED

Fields (58)

KeyFieldSource TableSource FieldDescription
KEY Reservation Reservation Reservation
KEY ReservationItem ReservationItem Reservation Item
MaterialGroup MaterialGroup Product Group
Material Material Vehicle Model
Plant Plant Valuation Area
ManufacturingOrderCategory ManufacturingOrderCategory
ManufacturingOrderType ManufacturingOrderType
ManufacturingOrder Order
ManufacturingOrderSequence ManufacturingOrderSequence
ManufacturingOrderOperation ManufacturingOrderOperation Activity
ProductionPlant ProductionPlant Prod plnt
OrderInternalBillOfOperations OrderInternalBillOfOperations Order Internal Bill of Operations
MatlCompRequirementDate MatlCompRequirementDate Reqmts date
MatlCompRequirementTime MatlCompRequirementTime
ReservationIsFinallyIssued ReservationIsFinallyIssued Res Final Issue
MatlCompIsMarkedForDeletion
IsBulkMaterialComponent IsBulkMaterialComponent Bulk material
MatlCompIsMarkedForBackflush MatlCompIsMarkedForBackflush Backflush
MaterialCompIsCostRelevant MaterialCompIsCostRelevant CostingRelevncy
OrderComponentLongText _LongText OrderComponentLongText Long Text
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
SortField SortField Sort Field
BillOfMaterialCategory BillOfMaterialCategory BOM category
BOMItem BOMItem
BOMItemCategory BOMItemCategory Item Category
BillOfMaterialItemNumber BillOfMaterialItemNumber Item
BOMItemDescription BOMItemDescription BOM Item Text
StorageLocation StorageLocation StorageLocation
Batch Batch Lot No.
GoodsMovementType GoodsMovementType Movement Type
SupplyArea SupplyArea Supply Area
GoodsRecipientName GoodsRecipientName Recipient Name
UnloadingPointName UnloadingPointName Unloading Point Name
MaterialCompIsAlternativeItem MaterialCompIsAlternativeItem Alternat. item
AlternativeItemGroup AlternativeItemGroup AltItemGroup
AlternativeItemStrategy AlternativeItemStrategy Strategy
AlternativeItemPriority AlternativeItemPriority Priority
UsageProbabilityPercent UsageProbabilityPercent Usage Prob.
MaterialComponentIsPhantomItem MaterialComponentIsPhantomItem Phantom Item
LeadTimeOffset LeadTimeOffset Lead-tm offset
QuantityIsFixed QuantityIsFixed Qty. is fixed
IsNetScrap IsNetScrap Net Indicator
ComponentScrapInPercent ComponentScrapInPercent Component Scrap
OperationScrapInPercent OperationScrapInPercent Operation Scrap
BaseUnit BaseUnit Unit of Measure
BaseUnitISOCode _BaseUnit UnitOfMeasureISOCode
BaseUnitSAPCode _BaseUnit UnitOfMeasureSAPCode
RequiredQuantity RequiredQuantity Requirement qty
WithdrawnQuantity WithdrawnQuantity Withdrawn Quantity
ConfirmedAvailableQuantity ConfirmedAvailableQuantity Available Quantity
MaterialCompOriginalQuantity MaterialCompOriginalQuantity
EntryUnit EntryUnit Unit of Entry
EntryUnitISOCode _EntryUnit UnitOfMeasureISOCode
EntryUnitSAPCode _EntryUnit UnitOfMeasureSAPCode
GoodsMovementEntryQty GoodsMovementEntryQty
Currency Currency Valuation Crcy
WithdrawnQuantityAmount WithdrawnQuantityAmount Withdr. Value

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_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_ProductionOrderComponent_2 AS
SELECT
  Reservation,
  ReservationItem,
  MaterialGroup,
  Material,
  Plant,
  ManufacturingOrderCategory,
  ManufacturingOrderType,
  cast(ManufacturingOrder as vdm_manufacturingorder preserving type) AS ManufacturingOrder,
  ManufacturingOrderSequence,
  ManufacturingOrderOperation,
  ProductionPlant,
  OrderInternalBillOfOperations,
  MatlCompRequirementDate,
  MatlCompRequirementTime,
  ReservationIsFinallyIssued,
  cast( MatlCompIsMarkedForDeletion as /plmb/lkenz preserving type ) AS MatlCompIsMarkedForDeletion,
  IsBulkMaterialComponent,
  MatlCompIsMarkedForBackflush,
  MaterialCompIsCostRelevant,
  _LongText.OrderComponentLongText AS OrderComponentLongText,
  SalesOrder,
  SalesOrderItem,
  SortField,
  BillOfMaterialCategory,
  BOMItem,
  BOMItemCategory,
  BillOfMaterialItemNumber,
  BOMItemDescription,
  StorageLocation,
  Batch,
  GoodsMovementType,
  SupplyArea,
  GoodsRecipientName,
  UnloadingPointName,
  MaterialCompIsAlternativeItem,
  AlternativeItemGroup,
  AlternativeItemStrategy,
  AlternativeItemPriority,
  UsageProbabilityPercent,
  MaterialComponentIsPhantomItem,
  LeadTimeOffset,
  QuantityIsFixed,
  IsNetScrap,
  ComponentScrapInPercent,
  OperationScrapInPercent,
  BaseUnit,
  _BaseUnit.UnitOfMeasureISOCode AS BaseUnitISOCode,
  _BaseUnit.UnitOfMeasureSAPCode AS BaseUnitSAPCode,
  RequiredQuantity,
  WithdrawnQuantity,
  ConfirmedAvailableQuantity,
  MaterialCompOriginalQuantity,
  EntryUnit,
  _EntryUnit.UnitOfMeasureISOCode AS EntryUnitISOCode,
  _EntryUnit.UnitOfMeasureSAPCode AS EntryUnitSAPCode,
  GoodsMovementEntryQty,
  Currency,
  WithdrawnQuantityAmount
FROM I_MfgOrderOperationComponent
;

Learn More