P_PlndOrderComponentForPegging

DDL: P_PLNDORDERCOMPONENTFORPEGGING Type: view_entity COMPOSITE
14 Fields 1 Data Sources

Planned Order Component for Pegging

P_PlndOrderComponentForPegging is a Composite CDS View that provides data about "Planned Order Component for Pegging" in SAP S/4HANA. It reads from 1 data source (I_PlannedOrderComponent) and exposes 14 fields with key fields MRPElement, MRPElementItem.

Data Sources (1)

SourceAliasJoin Type
I_PlannedOrderComponent I_PlannedOrderComponent from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Planned Order Component for Pegging view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY MRPElement Reservation
KEY MRPElementItem ReservationItem Reservation Item
MRPElementScheduleLine
MRPElementCategory
ParentMRPElement PlannedOrder
ParentMRPElementCategory
Product Material Vehicle Model
MRPPlant Plant Valuation Area
MRPArea MRPArea MRP Area
StorageLocation StorageLocation StorageLocation
MatlCompRequirementDate MatlCompRequirementDate Reqmts date
MaterialComponentIsMissing MaterialComponentIsMissing Missing Part
MaterialBaseUnit BaseUnit Unit of Measure
MRPRequiredQuantityInBaseUnit

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 P_PlndOrderComponentForPegging.
-- 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 P_PlndOrderComponentForPegging AS
SELECT
  cast (Reservation as pph_del12) AS MRPElement,
  ReservationItem AS MRPElementItem,
  cast ('0000' as delet) AS MRPElementScheduleLine,
  cast ('SB' as delkz ) AS MRPElementCategory,
  PlannedOrder AS ParentMRPElement,
  cast ('PA' as delkz ) AS ParentMRPElementCategory,
  Material AS Product,
  Plant AS MRPPlant,
  MRPArea,
  StorageLocation,
  MatlCompRequirementDate,
  MaterialComponentIsMissing,
  BaseUnit AS MaterialBaseUnit,
  RequiredQuantity - WithdrawnQuantity AS MRPRequiredQuantityInBaseUnit
FROM I_PlannedOrderComponent
;

Learn More