C_CFinRpldPurchaseOrderHistory

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_CFinRpldPurchaseOrderHistory.
-- 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 C_CFinRpldPurchaseOrderHistory AS
SELECT
  History.SenderLogicalSystem AS SenderLogicalSystem,
  cast( History.CFinRpldPurchasingDocument as fins_cfin_av_rpld_purord preserving type ) AS CFinReplicatedPurchaseOrder,
  cast( History.CFinRpldPurchasingDocumentItem as fins_cfin_av_rpld_purord_item preserving type ) AS CFinRpldPurchaseOrderItem,
  cast( History.CFinRpldPurgDocAcctAssgmt as dzekkn preserving type ) AS CFinRpldPurgDocAcctAssgmt,
  History.PurchaseOrderTransactionType AS PurchaseOrderTransactionType,
  History.MaterialDocumentYear AS MaterialDocumentYear,
  History.CFinSourceMaterialDocument AS CFinSourceMaterialDocument,
  History.CFinSourceMaterialDocumentItem AS CFinSourceMaterialDocumentItem,
  History.PostingDate AS PostingDate,
  History.Material AS Material,
  History.Currency AS Currency,
  History.DebitCreditCode AS DebitCreditCode,
  cast( case History.DebitCreditCode when 'H' then History.Quantity * -1 else History.Quantity end as mengv13 ) as Quantity AS Quantityendasmengv13asQuantity,
  History.CompanyCodeCurrency AS CompanyCodeCurrency,
  History.ReferenceDocument AS ReferenceDocument,
  History.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  History.TimeEntry AS TimeEntry,
  History.PurchasingDocumentIsAged AS PurchasingDocumentIsAged,
  History.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  History.OrderQuantityUnit AS OrderQuantityUnit
FROM I_CFinRpldPurgDocHistory AS History
LEFT OUTER JOIN C_CFinRpldPurchaseOrder AS _CFinRpldPurchaseOrder ON SenderLogicalSystem = _CFinRpldPurchaseOrder.SenderLogicalSystem AND CFinReplicatedPurchaseOrder = _CFinRpldPurchaseOrder.CFinReplicatedPurchaseOrder  -- association [1..1]
LEFT OUTER JOIN C_CFinRpldPurchaseOrderItem AS _CFinRpldPurchaseOrderItem ON SenderLogicalSystem = _CFinRpldPurchaseOrderItem.SenderLogicalSystem AND CFinReplicatedPurchaseOrder = _CFinRpldPurchaseOrderItem.CFinReplicatedPurchaseOrder AND CFinRpldPurchaseOrderItem = _CFinRpldPurchaseOrderItem.CFinRpldPurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN E_CFinRpldPurchasingDocHistory AS _Extension ON SenderLogicalSystem = _Extension.SourceSystemLogicalSystem AND CFinReplicatedPurchaseOrder = _Extension.CFinRpldPurchasingDocument AND CFinRpldPurchaseOrderItem = _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]
;