P_ControllingCommitmentLineItm

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_ControllingCommitmentLineItm.
-- 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: PFICOCMTMTITM

CREATE VIEW P_ControllingCommitmentLineItm AS
SELECT
  PurchasingDocument,
  PurchasingDocumentItem,
  ControllingCommitmentCategory,
  _CostCenter.CostCenter AS CostCenter,
  FiscalYear,
  ControllingValueType,
  FiscalPeriod,
  CostElement,
  CompanyCode,
  ControllingArea,
  CommitmentDocumentType,
  Supplier,
  _CostCenter.ValidityStartDate AS ValidityStartDate,
  _CostCenter.ValidityEndDate AS ValidityEndDate,
  _ControllingArea.FiscalYearVariant AS FiscalYearVariant,
  DebitCreditCode,
  ControllingObject,
  _ControllingArea.ChartOfAccounts AS ChartOfAccounts,
  DocumentDate,
  PostingDate,
  _FiscalPeriod.FiscalPeriodStartDate AS FiscalPeriodStartDate,
  _FiscalPeriod.FiscalPeriodEndDate AS FiscalPeriodEndDate,
  Material,
  UnitOfMeasure,
  TransactionCurrency,
  _ControllingArea.ControllingAreaCurrency AS ControllingAreaCurrency,
  _CompanyCode.Currency AS CompanyCodeCurrency,
  sum(TotalQuantity) AS TotalQuantity,
  sum(AmountInTransactionCurrency) AS AmountInTransactionCurrency,
  sum( AmountInCtrlgAreaCrcy) AS AmountInCtrlgAreaCrcy,
  sum(AmountInCompanyCodeCurrency) AS AmountInCompanyCodeCurrency,
  _CompanyCode._Currency AS _Currency
FROM I_ControllingCommitment
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON ControllingArea = _CostCenter.ControllingArea AND ControllingObject = _CostCenter.ObjectInternalID AND _CostCenter.ValidityStartDate <= $session.system_date AND _CostCenter.ValidityEndDate >= $session.system_date  -- association [0..*]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingAreaText ON ControllingArea = _ControllingAreaText.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_ControllingValueType AS _ControllingValueType ON ControllingValueType = _ControllingValueType.ControllingValueType association[0..1] to I_CompanyCode as _CompanyCode on CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON UnitOfMeasure = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductDescription AS _ProductText ON Material = _ProductText.Product  -- association [0..*]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON FiscalYear = _FiscalYear.FiscalYear AND CompanyCode = _FiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ControllingAreaCurrency ON ControllingAreaCurrency = _ControllingAreaCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CostElement AS _CostElement ON _CostElement.ControllingArea = ControllingArea AND _CostElement.CostElement = CostElement  -- association [1]
LEFT OUTER JOIN I_PurchaseOrderStatus AS _PurchaseOrderStatus ON _PurchaseOrderStatus.PurchaseOrder = PurchasingDocument  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDocument ON _PurchasingDocument.PurchasingDocument = PurchasingDocument  -- association [0..1]
LEFT OUTER JOIN I_ReferenceDocumentType AS _ReferenceDocumentType ON CommitmentDocumentType = _ReferenceDocumentType.ReferenceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts association[0..1] to I_Material as _Material on Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentItem AS _PurchasingDocumentItem ON PurchasingDocument = _PurchasingDocumentItem.PurchasingDocument AND PurchasingDocumentItem = _PurchasingDocumentItem.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearPeriodForCmpnyCode AS _FiscalPeriod ON FiscalYear = _FiscalPeriod.FiscalYear AND FiscalPeriod = _FiscalPeriod.FiscalPeriod AND CompanyCode = _FiscalPeriod.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_DebitCreditCode AS _DebitCreditCode ON DebitCreditCode = _DebitCreditCode.DebitCreditCode  -- association [0..1]
;