A_PlannedOrderComponent_2

DDL: A_PLANNEDORDERCOMPONENT_2 Type: view_entity CONSUMPTION
39 Fields 1 Data Sources

Planned Order Component

A_PlannedOrderComponent_2 is a Consumption CDS View that provides data about "Planned Order Component" in SAP S/4HANA. It reads from 1 data source (R_PlannedOrderComponentTP) and exposes 39 fields with key fields PlannedOrder, Reservation, ReservationItem.

Data Sources (1)

SourceAliasJoin Type
R_PlannedOrderComponentTP R_PlannedOrderComponentTP projection

Annotations (8)

NameValueLevelField
EndUserText.label Planned Order Component view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY PlannedOrder PlannedOrderComponent PlannedOrder
KEY Reservation PlannedOrderComponent Reservation Reservation
KEY ReservationItem PlannedOrderComponent ReservationItem Reservation Item
BOMItem PlannedOrderComponent BOMItem
BOMItemDescription PlannedOrderComponent BOMItemDescription Item Text
BOMItemDescriptionLine2 PlannedOrderComponent BOMItemDescriptionLine2 Item Text
BillOfMaterialCategory PlannedOrderComponent BillOfMaterialCategory BOM category
BOMItemSorter PlannedOrderComponent BOMItemSorter Sort String
BillOfMaterialItemNumber PlannedOrderComponent BillOfMaterialItemNumber Item
BillOfMaterialInternalID PlannedOrderComponent BillOfMaterialInternalID
BillOfMaterialVariant PlannedOrderComponent BillOfMaterialVariant AlternativeBOM
BOMItemCategory PlannedOrderComponent BOMItemCategory Item Category
Material PlannedOrderComponent Material Vehicle Model
MatlCompRequirementDate PlannedOrderComponent MatlCompRequirementDate Reqmts date
GoodsMovementEntryQty PlannedOrderComponent GoodsMovementEntryQty
EntryUnit PlannedOrderComponent EntryUnit Unit of Entry
RequiredQuantity PlannedOrderComponent RequiredQuantity Requirement qty
BaseUnit PlannedOrderComponent BaseUnit Unit of Measure
WithdrawnQuantity PlannedOrderComponent WithdrawnQuantity Withdrawn Quantity
DebitCreditCode PlannedOrderComponent DebitCreditCode Single-Character Flag
ComponentScrapInPercent PlannedOrderComponent ComponentScrapInPercent Component Scrap
QuantityIsFixed PlannedOrderComponent QuantityIsFixed Qty. is fixed
MaterialComponentIsPhantomItem PlannedOrderComponent MaterialComponentIsPhantomItem Phantom Item
Plant PlannedOrderComponent Plant Valuation Area
StorageLocation PlannedOrderComponent StorageLocation StorageLocation
SupplyArea PlannedOrderComponent SupplyArea Supply Area
MRPController PlannedOrderComponent MRPController MRP Controller
OrderPathValue PlannedOrderComponent OrderPathValue Order path
OrderLevelValue PlannedOrderComponent OrderLevelValue Order level
Assembly PlannedOrderComponent Assembly Pegged Reqmt
AssemblyOrderPathValue PlannedOrderComponent AssemblyOrderPathValue
AssemblyOrderLevelValue PlannedOrderComponent AssemblyOrderLevelValue
DiscontinuationGroup PlannedOrderComponent DiscontinuationGroup Discont. group
MatlCompDiscontinuationType PlannedOrderComponent MatlCompDiscontinuationType
MatlCompIsFollowUpMaterial PlannedOrderComponent MatlCompIsFollowUpMaterial
FollowUpGroup PlannedOrderComponent FollowUpGroup Follow-up group
FollowUpMaterial PlannedOrderComponent FollowUpMaterial
FollowUpMaterialIsNotActive PlannedOrderComponent FollowUpMaterialIsNotActive
PlannedOrderLastChangeDateTime PlannedOrderComponent PlannedOrderLastChangeDateTime

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_PlannedOrderComponent_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_PlannedOrderComponent_2 AS
SELECT
  PlannedOrderComponent.PlannedOrder AS PlannedOrder,
  PlannedOrderComponent.Reservation AS Reservation,
  PlannedOrderComponent.ReservationItem AS ReservationItem,
  PlannedOrderComponent.BOMItem AS BOMItem,
  PlannedOrderComponent.BOMItemDescription AS BOMItemDescription,
  PlannedOrderComponent.BOMItemDescriptionLine2 AS BOMItemDescriptionLine2,
  PlannedOrderComponent.BillOfMaterialCategory AS BillOfMaterialCategory,
  PlannedOrderComponent.BOMItemSorter AS BOMItemSorter,
  PlannedOrderComponent.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
  PlannedOrderComponent.BillOfMaterialInternalID AS BillOfMaterialInternalID,
  PlannedOrderComponent.BillOfMaterialVariant AS BillOfMaterialVariant,
  PlannedOrderComponent.BOMItemCategory AS BOMItemCategory,
  PlannedOrderComponent.Material AS Material,
  PlannedOrderComponent.MatlCompRequirementDate AS MatlCompRequirementDate,
  PlannedOrderComponent.GoodsMovementEntryQty AS GoodsMovementEntryQty,
  PlannedOrderComponent.EntryUnit AS EntryUnit,
  PlannedOrderComponent.RequiredQuantity AS RequiredQuantity,
  PlannedOrderComponent.BaseUnit AS BaseUnit,
  PlannedOrderComponent.WithdrawnQuantity AS WithdrawnQuantity,
  PlannedOrderComponent.DebitCreditCode AS DebitCreditCode,
  PlannedOrderComponent.ComponentScrapInPercent AS ComponentScrapInPercent,
  PlannedOrderComponent.QuantityIsFixed AS QuantityIsFixed,
  PlannedOrderComponent.MaterialComponentIsPhantomItem AS MaterialComponentIsPhantomItem,
  PlannedOrderComponent.Plant AS Plant,
  PlannedOrderComponent.StorageLocation AS StorageLocation,
  PlannedOrderComponent.SupplyArea AS SupplyArea,
  PlannedOrderComponent.MRPController AS MRPController,
  PlannedOrderComponent.OrderPathValue AS OrderPathValue,
  PlannedOrderComponent.OrderLevelValue AS OrderLevelValue,
  PlannedOrderComponent.Assembly AS Assembly,
  PlannedOrderComponent.AssemblyOrderPathValue AS AssemblyOrderPathValue,
  PlannedOrderComponent.AssemblyOrderLevelValue AS AssemblyOrderLevelValue,
  PlannedOrderComponent.DiscontinuationGroup AS DiscontinuationGroup,
  PlannedOrderComponent.MatlCompDiscontinuationType AS MatlCompDiscontinuationType,
  PlannedOrderComponent.MatlCompIsFollowUpMaterial AS MatlCompIsFollowUpMaterial,
  PlannedOrderComponent.FollowUpGroup AS FollowUpGroup,
  PlannedOrderComponent.FollowUpMaterial AS FollowUpMaterial,
  PlannedOrderComponent.FollowUpMaterialIsNotActive AS FollowUpMaterialIsNotActive,
  PlannedOrderComponent.PlannedOrderLastChangeDateTime AS PlannedOrderLastChangeDateTime
FROM R_PlannedOrderComponentTP
;

Learn More