Deprecated
This CDS view is deprecated in S/4HANA. View all deprecated CDS views →

I_CostCenterCommitmentLineItem

DDL: I_COSTCENTERCOMMITMENTLINEITEM SQL: ICCNTRCMTLNITM Type: view COMPOSITE Package: ODATA_COMMITMENT_REPORTING
23 Fields 1 Data Sources 5 Associations

Accounting Line Item Aggregated By Purchasing Document

I_CostCenterCommitmentLineItem is a Composite CDS View that provides data about "Accounting Line Item Aggregated By Purchasing Document" in SAP S/4HANA. It reads from 1 data source (P_GLItemPurchasingByCostCenter) and exposes 23 fields with key fields ControllingArea, CompanyCode, FiscalYear, FiscalYearVariant, FiscalPeriod. It has 5 associations to related views. Part of development package ODATA_COMMITMENT_REPORTING.

Data Sources (1)

SourceAliasJoin Type
P_GLItemPurchasingByCostCenter P_GLItemPurchasingByCostCenter from

Parameters (4)

NameTypeDefault
P_KeyDate sydatum
P_DisplayCurrency vdm_v_display_currency
P_StartDate fis_period_date_from
P_EndDate fis_period_date_to

Associations (5)

CardinalityTargetAliasCondition
[1] I_PurchasingDocument _PurchasingDocument $projection.PurchasingDocument = _PurchasingDocument.PurchasingDocument
[1] P_PurRequisitionForCommitment _PurRequisitionForCommitment $projection.PurchasingDocument = _PurRequisitionForCommitment.PurchaseRequisition
[1] I_CostCenter _CostCenter _CostCenter.ControllingArea = $projection.ControllingArea and _CostCenter.CostCenter = $projection.CostCenter and _CostCenter.ValidityEndDate = $projection.ValidityEndDate
[1] I_CostElement _CostElement _CostElement.ControllingArea = $projection.ControllingArea and _CostElement.CostElement = $projection.CostElement
[1..1] I_GLAccountLineItem _GLAccountLineItem _GLAccountLineItem.CompanyCode = $projection.CompanyCode and _GLAccountLineItem.FiscalYear = $projection.FiscalYear and _GLAccountLineItem.AccountingDocument = $projection.AccountingDocument and _GLAccountLineItem.LedgerGLLineItem = $projection.LedgerGLLineItem and _GLAccountLineItem.Ledger = $projection.Ledger and _GLAccountLineItem.SourceLedger = $projection.SourceLedger

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICCNTRCMTLNITM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Accounting Line Item Aggregated By Purchasing Document view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #COMPOSITE view
VDM.lifecycle.status #DEPRECATED view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY ControllingArea _glItems ControllingArea Controlling Area
KEY CompanyCode _glItems CompanyCode Receiver Company Code
KEY FiscalYear _glItems FiscalYear G/L Fiscal Year
KEY FiscalYearVariant _glItems FiscalYearVariant FY Variant
KEY FiscalPeriod _glItems FiscalPeriod Tax period
KEY CostCenter _glItems CostCenter Cost Center
KEY CostElement _glItems CostElement G/L Account
KEY Ledger _glItems Ledger Ledger
KEY SourceLedger _glItems SourceLedger Source Ledger
KEY LedgerGLLineItem _glItems LedgerGLLineItem Journal Entry Item
KEY ValidityEndDate _glItems ValidityEndDate ValidTo
KEY ValidityStartDate _glItems ValidityStartDate Validity Start Date
KEY PurchasingDocument _glItems PurchasingDocument Purchasing Document
KEY AccountingDocument _glItems AccountingDocument Journal Entry
PostingDate _glItems PostingDate Posting Date for GR
IsCommitment _glItems IsCommitment
CostCenterName
CostElementDescription
DisplayCurrency
StartDate _glItems StartDate Valid From
EndDate _glItems EndDate Term to
_GLItemByCostCenter _GLItemByCostCenter
_GLAccountLineItem _GLAccountLineItem

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]
;

Learn More