I_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 I_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: IFICOCMTMTITM

CREATE VIEW I_ControllingCommitmentLineItm AS
SELECT
  PurchasingDocument,
  PurchasingDocumentItem,
  ControllingCommitmentCategory,
  _CostCenter.CostCenter AS CostCenter,
  FiscalYear,
  ControllingValueType,
  FiscalPeriod,
  CostElement,
  CompanyCode,
  ControllingArea,
  CommitmentDocumentType,
  Supplier,
  ValidityStartDate,
  ValidityEndDate,
  FiscalYearVariant,
  DebitCreditCode,
  ControllingObject,
  ChartOfAccounts,
  DocumentDate,
  PostingDate,
  FiscalPeriodStartDate,
  FiscalPeriodEndDate,
  Material,
  UnitOfMeasure,
  TransactionCurrency,
  ControllingAreaCurrency,
  CompanyCodeCurrency,
  TotalQuantity,
  AmountInTransactionCurrency,
  AmountInCtrlgAreaCrcy,
  AmountInCompanyCodeCurrency
FROM P_ControllingCommitmentLineItm
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] to I_CompanyCode as _CompanyCode on CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearVariant AS _FiscalYearVariant ON FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- association [1..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_DebitCreditCode AS _DebitCreditCode ON DebitCreditCode = _DebitCreditCode.DebitCreditCode  -- 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_ControllingValueType AS _ControllingValueType ON ControllingValueType = _ControllingValueType.ControllingValueType  -- association [0..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]
;