I_CFinRpldPurgDocHistory

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_CFinRpldPurgDocHistory.
-- 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_CFinRpldPurgDocHistory AS
SELECT
  cfin_av_po_ro.fins_logsys AS SenderLogicalSystem,
  cast( cfin_av_po_ro.ebeln as fins_cfin_av_purchasing_doc preserving type ) AS CFinRpldPurchasingDocument,
  cast( cfin_av_po_ro.ebelp as fins_cfin_av_purg_document_itm preserving type ) AS CFinRpldPurchasingDocumentItem,
  cast( cfin_av_po_ro.zekkn as fins_cfin_av_purg_doc_acctasgt preserving type ) AS CFinRpldPurgDocAcctAssgmt,
  cfin_av_po_ro.vgabe AS PurchaseOrderTransactionType,
  cfin_av_po_ro.gjahr AS MaterialDocumentYear,
  cast( cfin_av_po_ro.belnr as fins_cfin_av_srce_matl_doc preserving type ) AS CFinSourceMaterialDocument,
  cast( cfin_av_po_ro.buzei as fins_cfin_av_srce_matl_item preserving type ) AS CFinSourceMaterialDocumentItem,
  cfin_av_po_ro.budat AS PostingDate,
  cfin_av_po_ro.menge AS Quantity,
  cfin_av_po_ro.dmbtr AS PurOrdAmountInCompanyCodeCrcy,
  cfin_av_po_ro.wrbtr AS PurchaseOrderAmount,
  cfin_av_po_ro.waers AS Currency,
  cfin_av_po_ro.shkzg AS DebitCreditCode,
  cfin_av_po_ro.cpudt AS AccountingDocumentCreationDate,
  cfin_av_po_ro.cputm AS TimeEntry,
  cfin_av_po_ro.matnr AS Material,
  cfin_av_po_ro.hswae AS CompanyCodeCurrency,
  cfin_av_po_root.isaged AS PurchasingDocumentIsAged,
  cfin_av_po_root.iseopblocked AS IsEndOfPurposeBlocked,
  cfin_av_po_item.meins AS OrderQuantityUnit,
  cfin_av_po_ro.lfbnr AS ReferenceDocument,
  cfin_av_po_ro.lfpos AS ReferenceDocumentItem,
  cfin_av_po_ro.lfgja AS ReferenceDocumentFiscalYear,
  cfin_av_po_ro.bamng AS QuantityInBaseUnit,
  cfin_av_po_item.lmein AS BaseUnit,
  cfin_av_po_ro.bpmng AS QtyInPurchaseOrderPriceUnit,
  cfin_av_po_item.bprme AS OrderPriceUnit,
  cfin_av_po_item.bpumz AS OrderPriceUnitToOrderUnitNmrtr,
  cfin_av_po_ro.elikz AS IsCompletelyDelivered
FROM cfin_av_po_ro
INNER JOIN cfin_av_po_root ON /* join condition not captured in parsed metadata */
INNER JOIN cfin_av_po_item ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CFinRpldPurchasingDocItem AS _CFinRpldPurchasingDocItem ON CFinRpldPurchasingDocument = _CFinRpldPurchasingDocItem.CFinRpldPurchasingDocument AND CFinRpldPurchasingDocumentItem = _CFinRpldPurchasingDocItem.CFinRpldPurchasingDocumentItem AND SenderLogicalSystem = _CFinRpldPurchasingDocItem.SenderLogicalSystem  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OrderQuantityUnit ON OrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_LogicalSystem AS _LogicalSystem ON SenderLogicalSystem = _LogicalSystem.LogicalSystem  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OrderPriceUnit ON OrderPriceUnit = _OrderPriceUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN E_CFinRpldPurchasingDocHistory AS _Extension ON SenderLogicalSystem = _Extension.SourceSystemLogicalSystem AND CFinRpldPurchasingDocument = _Extension.CFinRpldPurchasingDocument AND CFinRpldPurchasingDocumentItem = _Extension.CFinRpldPurchasingDocumentItem AND CFinRpldPurgDocAcctAssgmt = _Extension.CFinRpldPurgDocAcctAssgmt AND PurchaseOrderTransactionType = _Extension.PurchaseOrderTransactionType AND MaterialDocumentYear = _Extension.MaterialDocumentYear AND CFinSourceMaterialDocument = _Extension.CFinSourceMaterialDocument AND CFinSourceMaterialDocumentItem = _Extension.CFinSourceMaterialDocumentItem  -- association [1..1]
;