I_CFinRpldPurgDocHistAcctAsgt

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_CFinRpldPurgDocHistAcctAsgt.
-- 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_CFinRpldPurgDocHistAcctAsgt AS
SELECT
  cfin_av_po_roacc.fins_logsys AS SenderLogicalSystem,
  cast(cfin_av_po_roacc.ebeln as fins_cfin_av_purchasing_doc preserving type ) AS CFinRpldPurchasingDocument,
  cast(cfin_av_po_roacc.ebelp as fins_cfin_av_purg_document_itm preserving type ) AS CFinRpldPurchasingDocumentItem,
  cast(cfin_av_po_roacc.zekkn as fins_cfin_av_purg_doc_acctasgt preserving type ) AS CFinRpldPurgDocAcctAssgmt,
  cfin_av_po_roacc.vgabe AS PurchaseOrderTransactionType,
  cfin_av_po_roacc.gjahr AS MaterialDocumentYear,
  cast( cfin_av_po_roacc.belnr as fins_cfin_av_matl_doc preserving type ) AS CFinSourceMaterialDocument,
  cast( cfin_av_po_roacc.buzei as fins_cfin_av_matl_doc_item preserving type ) AS CFinSourceMaterialDocumentItem,
  cfin_av_po_roacc.lfbnr AS ReferenceDocument,
  cfin_av_po_roacc.menge AS Quantity,
  cfin_av_po_roacc.wrbtr AS PurchaseOrderAmount,
  cfin_av_po_roacc.xunpl AS AccountAssignmentIsUnplanned,
  cfin_av_po_item.meins AS OrderQuantityUnit,
  cfin_av_po_ro.waers AS DocumentCurrency
FROM cfin_av_po_roacc
INNER JOIN cfin_av_po_ro 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 _DocumentCurrency ON DocumentCurrency = _DocumentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_LogicalSystem AS _LogicalSystem ON SenderLogicalSystem = _LogicalSystem.LogicalSystem  -- association [0..1]
LEFT OUTER JOIN E_CFinRpldPurgDocHistAcctAsgt 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]
;