I_CostCenterCommitmentLineItem

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_CostCenterCommitmentLineItem.
-- 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: ICCNTRCMTLNITM
-- Parameters: P_KeyDate : sydatum, P_DisplayCurrency : vdm_v_display_currency, P_StartDate : fis_period_date_from, P_EndDate : fis_period_date_to

CREATE VIEW I_CostCenterCommitmentLineItem AS
SELECT
  _glItems.ControllingArea AS ControllingArea,
  _glItems.CompanyCode AS CompanyCode,
  _glItems.FiscalYear AS FiscalYear,
  _glItems.FiscalYearVariant AS FiscalYearVariant,
  _glItems.FiscalPeriod AS FiscalPeriod,
  _glItems.CostCenter AS CostCenter,
  _glItems.CostElement AS CostElement,
  _glItems.Ledger AS Ledger,
  _glItems.SourceLedger AS SourceLedger,
  _glItems.LedgerGLLineItem AS LedgerGLLineItem,
  _glItems.ValidityEndDate AS ValidityEndDate,
  _glItems.ValidityStartDate AS ValidityStartDate,
  _glItems.PurchasingDocument AS PurchasingDocument,
  _glItems.AccountingDocument AS AccountingDocument,
  _glItems.PostingDate AS PostingDate,
  _glItems.IsCommitment AS IsCommitment,
  _CostCenter._Text[1:Language = $session.system_language].CostCenterName AS CostCenterName,
  _CostElement._Text[1:Language = $session.system_language].CostElementDescription AS CostElementDescription,
  :P_DisplayCurrency AS DisplayCurrency,
  _glItems.StartDate AS StartDate,
  _glItems.EndDate AS EndDate
FROM P_GLItemPurchasingByCostCenter
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDocument ON PurchasingDocument = _PurchasingDocument.PurchasingDocument  -- association [1]
LEFT OUTER JOIN P_PurRequisitionForCommitment AS _PurRequisitionForCommitment ON PurchasingDocument = _PurRequisitionForCommitment.PurchaseRequisition  -- association [1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON _CostCenter.ControllingArea = ControllingArea AND _CostCenter.CostCenter = CostCenter AND _CostCenter.ValidityEndDate = ValidityEndDate  -- association [1]
LEFT OUTER JOIN I_CostElement AS _CostElement ON _CostElement.ControllingArea = ControllingArea AND _CostElement.CostElement = CostElement  -- association [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]
;