I_ControllingCommitment

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_ControllingCommitment.
-- 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: IFICOCMTMT

CREATE VIEW I_ControllingCommitment AS
SELECT
  refbn AS PurchasingDocument,
  rfpos AS PurchasingDocumentItem,
  rfknt AS RefDocAccountAssignment,
  rftrm AS ReferenceDocumentScheduleLine,
  rfart AS CommitmentDocumentType,
  lifnr AS Supplier,
  lednr AS ControllingLedger,
  objnr AS ControllingObject,
  hrkft AS ControllingKeySubNumber,
  rforg AS ReferenceDocumentContext,
  rftyp AS SourceReferenceDocumentType,
  rfsys AS SourceRefDocLogicalSystem,
  gjahr AS FiscalYear,
  wrttp AS ControllingValueType,
  sakto AS CostElement,
  bldat AS DocumentDate,
  budat AS PostingDate,
  perio AS FiscalPeriod,
  bukrs AS CompanyCode,
  kokrs AS ControllingArea,
  matnr AS Material,
  meinh AS UnitOfMeasure,
  beknz AS DebitCreditCode,
  twaer AS TransactionCurrency,
  megbtr AS TotalQuantity,
  wtgbtr AS AmountInTransactionCurrency,
  wkgbtr AS AmountInCtrlgAreaCrcy,
  wogbtr AS AmountInObjectCurrency,
  whgbtr AS AmountInCompanyCodeCurrency
FROM cooi
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON ControllingArea = _CostCenter.ControllingArea AND ControllingObject = _CostCenter.ObjectInternalID  -- association [0..*]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea 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_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_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_PurchasingDocumentItem AS _PurchasingDocumentItem ON PurchasingDocument = _PurchasingDocumentItem.PurchasingDocument AND PurchasingDocumentItem = _PurchasingDocumentItem.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_ControllingValueType AS _ControllingValueType ON ControllingValueType = _ControllingValueType.ControllingValueType  -- 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]
;