C_APProcFlowPurOrdHist

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_APProcFlowPurOrdHist.
-- 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: CAPPRCFEKBE

CREATE VIEW C_APProcFlowPurOrdHist AS
SELECT
  purgDocHist.PurchaseOrder AS PurchaseOrder,
  purgDocHist.PurchaseOrderItem AS PurchaseOrderItem,
  purgDocHist.MaterialDocument AS ProcessFlowNodeDocument,
  purgDocHist.MaterialDocumentYear AS FiscalYear,
  purgDocHist.MaterialDocumentItem AS ProcessFlowNodeDocumentItem,
  purgDocHist.PurchaseOrderTransactionType AS ProcessFlowNodeDocCategory,
  concat(purgDocHist.MaterialDocument,concat(concat(concat('00',purgDocHist.MaterialDocumentItem),'____'),concat(purgDocHist.MaterialDocumentYear,purgDocHist.PurchaseOrderTransactionType))) AS ProcessFlowNode,
  purgDocHist.ReferenceDocument AS ParentProcessFlowNodeDocument,
  purgDocHist.ReferenceDocumentItem AS ParentProcessFlowNodeDocItem,
  _parentPurgDocHist.PurchaseOrderTransactionType AS ParentProcFlwNodeDocCategory,
  purgDocHist.ReferenceDocumentFiscalYear AS ParentProcFlowNodeFiscalYear,
  cast('' as bukrs) AS ParentProcFlowNodeCompanyCode,
  _purgDocItem.CompanyCode AS CompanyCode,
  _purgDocItem._CompanyCode.CompanyCodeName AS CompanyCodeName,
  purgDocHist.PostingDate AS PostingDate,
  case purgDocHist.DebitCreditCode when 'S' then purgDocHist.Quantity else (purgDocHist.Quantity * (-1) ) end as Quantity AS Quantity1endasQuantity,
  purgDocHist._PurchaseOrderItem.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  cast( '' as ebeln) AS ReferenceDocument,
  purgDocHist.Currency AS Currency,
  purgDocHist.DocumentDate AS DocumentDate,
  purgDocHist.CreatedByUser AS CreatedByUser,
  purgDocHist._UserContactCard.FullName AS FullName,
  purgDocHist.PurchaseOrderHistCategory AS PurchaseOrderHistCategory,
  _purgDocItem.PurchasingDocument AS PurchasingDocument,
  _purgDocItem._PurchasingDocument AS _PurchasingDocument,
  purgDocHist.AuthorizationGroup AS AuthorizationGroup
FROM P_PurchaseOrderHistory_Basic AS purgDocHist
LEFT OUTER JOIN I_PurchasingDocumentItem AS _purgDocItem ON _purgDocItem.PurchasingDocument = purgDocHist.PurchaseOrder AND _purgDocItem.PurchasingDocumentItem = purgDocHist.PurchaseOrderItem  -- association [1..1]
;