C_PurOrdScheduleLineTP

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 C_PurOrdScheduleLineTP.
-- 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: CPOSCHEDLINETP

CREATE VIEW C_PurOrdScheduleLineTP AS
SELECT
  Document.PurchaseOrderItem AS PurchaseOrderItem,
  Document.PurchaseOrder AS PurchaseOrder,
  Document.ScheduleLine AS ScheduleLine,
  cast (Document.ScheduleLineDeliveryDate as eindt_ll preserving type) AS ScheduleLineDeliveryDate,
  cast (Document.PerformancePeriodStartDate as startdate_ll preserving type) AS PerformancePeriodStartDate,
  cast (Document.PerformancePeriodEndDate as enddate_ll preserving type) AS PerformancePeriodEndDate,
  Document.ScheduleLineOrderQuantity AS ScheduleLineOrderQuantity,
  Document.SchedLineStscDeliveryDate AS SchedLineStscDeliveryDate,
  Document.RoughGoodsReceiptQty AS RoughGoodsReceiptQty,
  Document.PurchaseRequisition AS PurchaseRequisition,
  Document.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  Document.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  Document.Batch AS Batch,
  Document.BatchBySupplier AS BatchBySupplier,
  Document.HighestMessageSeverityLevel AS HighestMessageSeverityLevel,
  _PurchaseOrderItemTP.ManufacturerMaterial AS ManufacturerMaterial,
  _PurchaseOrderItemTP.Plant AS Plant,
  _PurchaseOrderItemTP.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
  _PurchaseOrderItemTP.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseOrderItemTP.CompanyCode AS CompanyCode
FROM I_PurOrdScheduleLineTP AS Document
LEFT OUTER JOIN C_PurchaseOrderTP AS _PurchaseOrderTP ON _PurchaseOrderTP.PurchaseOrder = PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN C_PurchaseOrderItemTP AS _PurchaseOrderItemTP ON _PurchaseOrderItemTP.PurchaseOrder = PurchaseOrder AND _PurchaseOrderItemTP.PurchaseOrderItem = PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN C_POSubcontractingComponentTP AS _SubcontractingComponent ON _SubcontractingComponent.PurchaseOrder = PurchaseOrder AND _SubcontractingComponent.PurchaseOrderItem = PurchaseOrderItem AND _SubcontractingComponent.ScheduleLine = ScheduleLine  -- association [1..*]
LEFT OUTER JOIN C_PurchaseRequisitionValueHelp AS _PurchaseRequisitionItem ON _PurchaseRequisitionItem.PurchaseRequisition = PurchaseRequisition AND _PurchaseRequisitionItem.PurchaseRequisitionItem = PurchaseRequisitionItem  -- association [0..1]
;