I_POSubcontractingComponentTP

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_POSubcontractingComponentTP.
-- 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.
-- SQL view name: IMMPOSUBCOMPTP

CREATE VIEW I_POSubcontractingComponentTP AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  PurchaseOrderScheduleLine AS ScheduleLine,
  ReservationItem,
  RecordType,
  Reservation,
  Material,
  BaseUnit,
  RequirementDate,
  RequirementTime,
  Plant,
  LatestRequirementDate,
  OrderLevelValue,
  OrderPathValue,
  cast (BillOfMaterialItemNumber as aposn preserving type ) AS BillOfMaterialItemNumber,
  SortField,
  BOMItemCategory,
  MaterialComponentIsPhantomItem,
  IsBulkMaterialComponent,
  AccountAssignmentCategory,
  InventorySpecialStockType,
  ConsumptionPosting,
  InventorySpecialStockValnType,
  IsMaterialProvision,
  DebitCreditCode,
  ReservationIsFinallyIssued,
  EntryUnit,
  MaterialQtyToBaseQtyNmrtr,
  MaterialQtyToBaseQtyDnmntr,
  WithdrawnQuantity,
  QuantityIsFixed,
  ComponentScrapInPercent,
  OperationScrapInPercent,
  IsNetScrap,
  LeadTimeOffset,
  QuantityDistributionKey,
  cast (MaterialRevisionLevel as revlv preserving type ) AS MaterialRevisionLevel,
  MaterialCompIsVariableSized,
  NumberOfVariableSizeComponents,
  VariableSizeComponentQuantity,
  VariableSizeComponentUnit,
  UnitOfMeasureForSize1To3,
  Size1,
  Size2,
  Size3,
  FormulaKey,
  StorageLocation,
  ProductionSupplyArea,
  Batch,
  BOMItemDescription,
  BOMItemText2,
  ChangeNumber
FROM R_POSubcontractingComponent
LEFT OUTER JOIN I_PurchaseOrderTP AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN I_PurchaseOrderItemTP AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN I_PurOrdScheduleLineTP AS _ScheduleLine ON PurchaseOrder = _ScheduleLine.PurchaseOrder AND PurchaseOrderItem = _ScheduleLine.PurchaseOrderItem AND ScheduleLine = _ScheduleLine.ScheduleLine  -- association [1..1]
;