I_PlannedOrderComponentTP

DDL: I_PLANNEDORDERCOMPONENTTP Type: view_entity TRANSACTIONAL Package: PPH_PLANNED_ORDER
48 Fields 1 Data Sources

Interface for Component entity of BO PlannedOrder - TP

I_PlannedOrderComponentTP is a Transactional CDS View that provides data about "Interface for Component entity of BO PlannedOrder - TP" in SAP S/4HANA. It reads from 1 data source (R_PlannedOrderComponentTP) and exposes 48 fields with key fields PlannedOrder, Reservation, ReservationItem. Part of development package PPH_PLANNED_ORDER.

Data Sources (1)

SourceAliasJoin Type
R_PlannedOrderComponentTP R_PlannedOrderComponentTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Interface for Component entity of BO PlannedOrder - TP view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
Metadata.ignorePropagatedAnnotations true view

Fields (48)

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
DebitCreditCode PlannedOrderComponent DebitCreditCode Single-Character Flag
ComponentScrapInPercent PlannedOrderComponent ComponentScrapInPercent Component Scrap
QuantityIsFixed PlannedOrderComponent QuantityIsFixed Qty. is fixed
Plant PlannedOrderComponent Plant Valuation Area
StorageLocation PlannedOrderComponent StorageLocation StorageLocation
SupplyArea PlannedOrderComponent SupplyArea Supply Area
MRPController PlannedOrderComponent MRPController MRP Controller
MaterialComponentIsPhantomItem PlannedOrderComponent MaterialComponentIsPhantomItem Phantom Item
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
ProductName PlannedOrderComponent ProductName Description
MRPControllerName PlannedOrderComponent MRPControllerName Controller name
StorageLocationName PlannedOrderComponent StorageLocationName Storage Loc. Name
ProductionSupplyAreaName PlannedOrderComponent ProductionSupplyAreaName Production Supply Area Name
PlantName PlannedOrderComponent PlantName Plant Name
FollowUpMaterialText PlannedOrderComponent FollowUpMaterialText Follow Up Product Description
DebitCreditCodeName PlannedOrderComponent DebitCreditCodeName
AssemblyProductText PlannedOrderComponent AssemblyProductText Assembly Product Description
BillOfMaterialItemCategoryDesc PlannedOrderComponent BillOfMaterialItemCategoryDesc Item Category
BillOfMaterialCategoryDesc PlannedOrderComponent BillOfMaterialCategoryDesc

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 I_PlannedOrderComponentTP.
-- 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 I_PlannedOrderComponentTP 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.DebitCreditCode AS DebitCreditCode,
  PlannedOrderComponent.ComponentScrapInPercent AS ComponentScrapInPercent,
  PlannedOrderComponent.QuantityIsFixed AS QuantityIsFixed,
  PlannedOrderComponent.Plant AS Plant,
  PlannedOrderComponent.StorageLocation AS StorageLocation,
  PlannedOrderComponent.SupplyArea AS SupplyArea,
  PlannedOrderComponent.MRPController AS MRPController,
  PlannedOrderComponent.MaterialComponentIsPhantomItem AS MaterialComponentIsPhantomItem,
  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,
  PlannedOrderComponent.ProductName AS ProductName,
  PlannedOrderComponent.MRPControllerName AS MRPControllerName,
  PlannedOrderComponent.StorageLocationName AS StorageLocationName,
  PlannedOrderComponent.ProductionSupplyAreaName AS ProductionSupplyAreaName,
  PlannedOrderComponent.PlantName AS PlantName,
  PlannedOrderComponent.FollowUpMaterialText AS FollowUpMaterialText,
  PlannedOrderComponent.DebitCreditCodeName AS DebitCreditCodeName,
  PlannedOrderComponent.AssemblyProductText AS AssemblyProductText,
  PlannedOrderComponent.BillOfMaterialItemCategoryDesc AS BillOfMaterialItemCategoryDesc,
  PlannedOrderComponent.BillOfMaterialCategoryDesc AS BillOfMaterialCategoryDesc
FROM R_PlannedOrderComponentTP
;

Learn More