C_PlannedOrderObjPgComp

DDL: C_PLANNEDORDEROBJPGCOMP Type: view_entity CONSUMPTION
21 Fields 1 Data Sources

Planned Order Components : Object Page

C_PlannedOrderObjPgComp is a Consumption CDS View that provides data about "Planned Order Components : Object Page" in SAP S/4HANA. It reads from 1 data source (I_PlannedOrderComponent) and exposes 21 fields with key fields Reservation, ReservationItem.

Data Sources (1)

SourceAliasJoin Type
I_PlannedOrderComponent PlannedOrderComponent from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Planned Order Components : Object Page view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
UI.headerInfo.typeName Component view
UI.headerInfo.typeNamePlural Components view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY Reservation I_PlannedOrderComponent Reservation Reservation
KEY ReservationItem I_PlannedOrderComponent ReservationItem Reservation Item
PlannedOrder I_PlannedOrderComponent PlannedOrder
Material I_PlannedOrderComponent Material Vehicle Model
MatlCompRequirementDate I_PlannedOrderComponent MatlCompRequirementDate Reqmts date
RequiredQuantity I_PlannedOrderComponent RequiredQuantity Requirement qty
BaseUnit I_PlannedOrderComponent BaseUnit Unit of Measure
StorageLocation
SupplyArea I_PlannedOrderComponent SupplyArea Supply Area
BOMItem I_PlannedOrderComponent BOMItem
BOMItemDescription I_PlannedOrderComponent BOMItemDescription Item Text
BillOfMaterialCategory I_PlannedOrderComponent BillOfMaterialCategory BOM category
WithdrawnQuantity I_PlannedOrderComponent WithdrawnQuantity Withdrawn Quantity
Plant I_PlannedOrderComponent Plant Valuation Area
MRPController I_PlannedOrderComponent MRPController MRP Controller
_Plant I_PlannedOrderComponent _Plant
_Reservation I_PlannedOrderComponent _Reservation
_StorageLocation I_PlannedOrderComponent _StorageLocation
_Material I_PlannedOrderComponent _Material
_MRPController I_PlannedOrderComponent _MRPController
_SupplyArea I_PlannedOrderComponent _SupplyArea

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 C_PlannedOrderObjPgComp.
-- 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 C_PlannedOrderObjPgComp AS
SELECT
  PlannedOrderComponent.Reservation AS Reservation,
  PlannedOrderComponent.ReservationItem AS ReservationItem,
  PlannedOrderComponent.PlannedOrder AS PlannedOrder,
  PlannedOrderComponent.Material AS Material,
  PlannedOrderComponent.MatlCompRequirementDate AS MatlCompRequirementDate,
  PlannedOrderComponent.RequiredQuantity AS RequiredQuantity,
  PlannedOrderComponent.BaseUnit AS BaseUnit,
  cast(PlannedOrderComponent.StorageLocation as pph_lgort preserving type ) AS StorageLocation,
  PlannedOrderComponent.SupplyArea AS SupplyArea,
  PlannedOrderComponent.BOMItem AS BOMItem,
  PlannedOrderComponent.BOMItemDescription AS BOMItemDescription,
  PlannedOrderComponent.BillOfMaterialCategory AS BillOfMaterialCategory,
  PlannedOrderComponent.WithdrawnQuantity AS WithdrawnQuantity,
  PlannedOrderComponent.Plant AS Plant,
  PlannedOrderComponent.MRPController AS MRPController,
  PlannedOrderComponent._Plant AS _Plant,
  PlannedOrderComponent._Reservation AS _Reservation,
  PlannedOrderComponent._StorageLocation AS _StorageLocation,
  PlannedOrderComponent._Material AS _Material,
  PlannedOrderComponent._MRPController AS _MRPController,
  PlannedOrderComponent._SupplyArea AS _SupplyArea
FROM I_PlannedOrderComponent AS PlannedOrderComponent
;

Learn More