I_EarmarkedFunds_Cons_Basic

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_EarmarkedFunds_Cons_Basic.
-- 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: IEFDCONSB

CREATE VIEW I_EarmarkedFunds_Cons_Basic AS
SELECT
  Consumption.belnr AS EarmarkedFunds,
  Consumption.blpos AS EarmarkedFundsItem,
  Consumption.bpent AS EarmarkedFundsItemProcessing,
  Consumption.rbukrs AS CompanyCode,
  Consumption.vrgng AS BusinessTransactionType,
  Consumption.erfas AS CreatedByUser,
  Consumption.erdat AS CreationDate,
  Consumption.aende AS LastChangeUser,
  Consumption.aedat AS LastChangeDate,
  Consumption.awtyp AS ReferenceDocumentType,
  Consumption.awref AS ReferenceDocument,
  Consumption.aworg AS ReferenceDocumentContext,
  Consumption.awsys AS ReferenceDocumentLogicalSystem,
  Consumption.awpos AS ReferenceDocumentItem,
  Consumption.stats AS EmrkdFndsItmProcgIsStatistical,
  Consumption.stokz AS IsReversed,
  Consumption.atext AS DocumentItemText,
  _header.waers AS TransactionCurrency,
  Consumption.wtabb AS EmrkdFndsCnsmdAmtInTransCrcy
FROM kble AS Consumption
LEFT OUTER JOIN kblk AS _header ON EarmarkedFunds = _header.belnr  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransCurrency ON TransactionCurrency = _TransCurrency.Currency  -- association [0..1]
;