P_GLItemPurchasingByCostCenter

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 P_GLItemPurchasingByCostCenter.
-- 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: PGLITMPURCC
-- Parameters: P_StartDate : fis_period_date_from, P_EndDate : fis_period_date_to

CREATE VIEW P_GLItemPurchasingByCostCenter AS
SELECT
  _CommitmentKey.ControllingArea AS ControllingArea,
  _CommitmentKey.CompanyCode AS CompanyCode,
  _CommitmentKey.FiscalYear AS FiscalYear,
  _CommitmentKey.FiscalYearVariant AS FiscalYearVariant,
  _CommitmentKey.FiscalPeriod AS FiscalPeriod,
  _CommitmentKey.CostCenter AS CostCenter,
  _CommitmentKey.CostElement AS CostElement,
  _CommitmentKey.ValidityEndDate AS ValidityEndDate,
  _CommitmentKey.ValidityStartDate AS ValidityStartDate,
  _CommitmentKey.LedgerGLLineItem AS LedgerGLLineItem,
  _CommitmentKey.SourceLedger AS SourceLedger,
  _CommitmentKey.AccountingDocument AS AccountingDocument,
  _CommitmentKey.Ledger AS Ledger,
  _GLItemByCostCenter.PurchasingDocument AS PurchasingDocument,
  _GLItemByCostCenter.PostingDate AS PostingDate,
  _GLItemByCostCenter.IsCommitment AS IsCommitment,
  sum(_GLItemByCostCenter.CmtmtAmtInCompanyCodeCurrency) AS CmtmtAmtInCompanyCodeCurrency,
  sum(_GLItemByCostCenter.ActualAmountInCompanyCodeCrcy) AS ActAmtInCompanyCodeCurrency,
  _CompanyCode.Currency AS CompanyCodeCurrency,
  :P_StartDate AS StartDate,
  :P_EndDate AS EndDate
FROM P_CommitmentKey
LEFT OUTER JOIN I_GLCmtmtLineItemByCostCenter AS _GLItemByCostCenter ON _GLItemByCostCenter.CompanyCode = CompanyCode AND _GLItemByCostCenter.LedgerGLLineItem = LedgerGLLineItem AND _GLItemByCostCenter.Ledger = Ledger AND _GLItemByCostCenter.SourceLedger = SourceLedger AND _GLItemByCostCenter.AccountingDocument = AccountingDocument AND _GLItemByCostCenter.FiscalYear = FiscalYear AND _GLItemByCostCenter.FiscalYearVariant = FiscalYearVariant AND _GLItemByCostCenter.FiscalPeriod = FiscalPeriod AND _GLItemByCostCenter.CostCenter = CostCenter AND _GLItemByCostCenter.GLAccount = CostElement AND _GLItemByCostCenter.ControllingArea = ControllingArea AND _GLItemByCostCenter.PostingDate >= ValidityStartDate AND _GLItemByCostCenter.PostingDate <= ValidityEndDate AND _GLItemByCostCenter.PostingDate >= $parameters.P_StartDate AND _GLItemByCostCenter.PostingDate <= $parameters.P_EndDate AND ( _GLItemByCostCenter.PurchaseOrderStatus = '01' OR _GLItemByCostCenter.PurchaseOrderStatus = '02' OR _GLItemByCostCenter.PurchaseOrderStatus = '03' OR _GLItemByCostCenter.PurchaseOrderStatus = '04' OR _GLItemByCostCenter.PurchaseOrderStatus = '05' OR _GLItemByCostCenter.PurchaseOrderStatus = '37' OR _GLItemByCostCenter.PurchaseOrderStatus = 'NA' )  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON _CompanyCode.CompanyCode = CompanyCode  -- association [1]
;