R_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 R_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.

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