R_PlannedOrderComponentTP

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 R_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 R_PlannedOrderComponentTP AS
SELECT
  PlannedOrder,
  Reservation,
  ReservationItem,
  BOMItem,
  BOMItemText2 AS BOMItemDescriptionLine2,
  BOMItemDescription,
  BillOfMaterialCategory,
  SortField AS BOMItemSorter,
  cast(BillOfMaterialItemNumber as vdm_sposn preserving type ) AS BillOfMaterialItemNumber,
  cast(BillOfMaterialInternalID as pph_stnum preserving type ) AS BillOfMaterialInternalID,
  BillOfMaterialVariant,
  BOMItemCategory,
  Material,
  MatlCompRequirementDate,
  GoodsMovementEntryQty,
  EntryUnit,
  RequiredQuantity,
  BaseUnit,
  WithdrawnQuantity,
  DebitCreditCode,
  ComponentScrapInPercent,
  QuantityIsFixed,
  MaterialComponentIsPhantomItem,
  Plant,
  cast(StorageLocation as pph_lgort preserving type ) AS StorageLocation,
  SupplyArea,
  MRPController,
  OrderPathValue,
  OrderLevelValue,
  Assembly,
  AssemblyOrderPathValue,
  AssemblyOrderLevelValue,
  DiscontinuationGroup,
  MatlCompDiscontinuationType,
  MatlCompIsFollowUpMaterial,
  FollowUpGroup,
  FollowUpMaterial,
  _PlannedOrder.PlannedOrderLastChangeDateTime AS PlannedOrderLastChangeDateTime
FROM I_PlannedOrderComponent
;