I_CFinRpldPurgDocScheduleLine

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_CFinRpldPurgDocScheduleLine.
-- 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_CFinRpldPurgDocScheduleLine AS
SELECT
  cfin_av_po_sch.fins_logsys AS SenderLogicalSystem,
  cast( cfin_av_po_sch.ebeln as fins_cfin_av_purchasing_doc preserving type ) AS CFinRpldPurchasingDocument,
  cast( cfin_av_po_sch.ebelp as fins_cfin_av_purg_document_itm preserving type ) AS CFinRpldPurchasingDocumentItem,
  cast( cfin_av_po_sch.etenr as fins_cfin_av_purg_doc_sln preserving type ) AS CFinRpldPurgDocScheduleLine,
  cfin_av_po_sch.eindt AS ScheduleLineDeliveryDate,
  cfin_av_po_sch.slfdt AS SchedLineStscDeliveryDate,
  cfin_av_po_sch.lpein AS DelivDateCategory,
  cfin_av_po_sch.menge AS ScheduleLineOrderQuantity,
  cfin_av_po_sch.wemng AS GoodsReceiptQuantity,
  cfin_av_po_sch.wamng AS ScheduleLineIssuedQuantity,
  cfin_av_po_sch.uzeit AS ScheduleLineDeliveryTime,
  cfin_av_po_sch.mahnz AS PurchasingSchdLnNrOfReminders,
  cfin_av_po_sch.bedat AS ScheduleLineOrderDate,
  cfin_av_po_sch.glmng AS StockTransferDeliveredQuantity,
  cfin_av_po_sch.charg AS Batch,
  cfin_av_po_sch.mng02 AS ScheduleLineCommittedQuantity,
  cfin_av_po_sch.dat01 AS CommittedDeliveryDate,
  cfin_av_po_sch.startdate AS PerformancePeriodStartDate,
  cfin_av_po_sch.enddate AS PerformancePeriodEndDate,
  cfin_av_po_item.meins AS OrderQuantityUnit
FROM cfin_av_po_sch
INNER JOIN cfin_av_po_item ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CFinRpldPurchasingDocument AS _CFinRpldPurchasingDocument ON SenderLogicalSystem = _CFinRpldPurchasingDocument.SenderLogicalSystem AND CFinRpldPurchasingDocument = _CFinRpldPurchasingDocument.CFinRpldPurchasingDocument  -- association [1..1]
LEFT OUTER JOIN I_CFinRpldPurchasingDocItem AS _CFinRpldPurchasingDocItem ON SenderLogicalSystem = _CFinRpldPurchasingDocItem.SenderLogicalSystem AND CFinRpldPurchasingDocument = _CFinRpldPurchasingDocItem.CFinRpldPurchasingDocument AND CFinRpldPurchasingDocumentItem = _CFinRpldPurchasingDocItem.CFinRpldPurchasingDocumentItem  -- association [1..1]
LEFT OUTER JOIN I_Deliverydatecategory AS _DeliveryDateCategory ON DelivDateCategory = _DeliveryDateCategory.DelivDateCategory  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OrderQuantityUnit ON OrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_LogicalSystem AS _LogicalSystem ON SenderLogicalSystem = _LogicalSystem.LogicalSystem  -- association [0..1]
LEFT OUTER JOIN E_CFinRpldPurgDocScheduleLine AS _Extension ON SenderLogicalSystem = _Extension.SourceSystemLogicalSystem AND CFinRpldPurchasingDocument = _Extension.CFinRpldPurchasingDocument AND CFinRpldPurchasingDocumentItem = _Extension.CFinRpldPurchasingDocumentItem AND CFinRpldPurgDocScheduleLine = _Extension.CFinRpldPurgDocScheduleLine  -- association [1..1]
;