I_CostCenterCommitment

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_CostCenterCommitment.
-- 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: ICSTCNTRCMMTMT
-- Parameters: P_DisplayCurrency : vdm_v_display_currency, P_StartDate : datum, P_EndDate : datum, P_PlanningCategory : fis_category

CREATE VIEW I_CostCenterCommitment 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,
  sum(_GLItemByCostCenter.ActualAmountInCompanyCodeCrcy) AS TotActlAmtInCoCodeCurrency,
  sum(_GLItemByCostCenter.CmtmtAmtInCompanyCodeCurrency) AS TotCmtmtAmtInCoCodeCurrency,
  sum(_GLItemByCostCenter.AssgdAmtInCompanyCodeCurrency) AS TotAssgdAmtInCoCodeCurrency,
  _FinPlngEntryItemByCostCenter(P_PlanningCategory : $parameters.P_PlanningCategory).TotPlndAmountInGlobalCurrency AS TotPlndAmountInGlobalCurrency,
  _GLItemByCostCenter.CompanyCodeCurrency AS CompanyCodeCurrency,
  _FinPlngEntryItemByCostCenter(P_PlanningCategory : $parameters.P_PlanningCategory).GlobalCurrency AS GlobalCurrency,
  :P_DisplayCurrency AS DisplayCurrency,
  :P_StartDate AS StartDate,
  :P_EndDate AS EndDate,
  :P_PlanningCategory AS PlanningCategory
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 P_FinPlngEntryItemByCostCenter AS _FinPlngEntryItemByCostCenter ON _FinPlngEntryItemByCostCenter.CompanyCode = CompanyCode AND _FinPlngEntryItemByCostCenter.FiscalYear = FiscalYear AND _FinPlngEntryItemByCostCenter.FiscalYearVariant = FiscalYearVariant AND _FinPlngEntryItemByCostCenter.FiscalPeriod = FiscalPeriod AND _FinPlngEntryItemByCostCenter.CostCenter = CostCenter AND _FinPlngEntryItemByCostCenter.GLAccount = CostElement AND _FinPlngEntryItemByCostCenter.ControllingArea = ControllingArea AND LedgerGLLineItem = 'PLAN' AND AccountingDocument = 'PLAN' AND SourceLedger = 'NA' AND Ledger = 'NA'  -- association [0..1]
LEFT OUTER JOIN I_GLAccountLineItem AS _GLAccountLineItem ON _GLAccountLineItem.CompanyCode = CompanyCode AND _GLAccountLineItem.FiscalYear = FiscalYear AND _GLAccountLineItem.AccountingDocument = AccountingDocument AND _GLAccountLineItem.LedgerGLLineItem = LedgerGLLineItem AND _GLAccountLineItem.Ledger = Ledger AND _GLAccountLineItem.SourceLedger = SourceLedger  -- association [1..1]
;