I_EarmarkedFunds_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_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: IEFDOCUMENTB

CREATE VIEW I_EarmarkedFunds_Basic AS
SELECT
  Header.belnr AS EarmarkedFunds,
  Header.bltyp AS EarmarkedFundsDocumentCategory,
  cast ( Header.blart as fmre_blart ) AS EarmarkedFundsDocumentType,
  Header.bukrs AS CompanyCode,
  Header.fikrs AS FinancialManagementArea,
  Header.kokrs AS ControllingArea,
  Header.waers AS TransactionCurrency,
  Header.hwaer AS CompanyCodeCurrency,
  Header.xblnr AS DocumentReferenceID,
  Header.ktext AS EarmarkedFundsHeaderText,
  Header.ltext AS EarmarkedFundsHasLongText,
  Header.budat AS PostingDate,
  Header.bldat AS DocumentDate,
  Header.wwert AS ExchangeRateDate,
  Header.kursf AS ExchangeRate,
  Header.kvrgng AS BusinessTransactionType,
  Header.kerfas AS CreatedByUser,
  Header.kerdat AS CreationDate,
  Header.kaende AS LastChangeUser,
  Header.kaedat AS LastChangeDate,
  Header.rftyp AS ReferenceDocumentType,
  Header.rfblnr AS ReferenceDocument,
  Header.rforg AS ReferenceDocumentContext,
  Header.rfsys AS ReferenceDocumentLogicalSystem,
  cast ( Header.kloekz as kblkloekz ) AS EmrkdFndsIsMarkedForArchiving,
  Header.negval AS EmrkdFndsHasNegativeAmounts,
  Header.blkkz AS EmrkdFndsIsBlockedAgainstUsage,
  Header.fexec AS EarmarkedFundsIsCompleted,
  Header.wkapk AS EarmarkedFundsIsApproved,
  Header.wkaok AS EmrkdFndsWasAlreadyAprvdOnce,
  Header.additiv_cons_log AS EmrkdFndsHasAddlCnsmpnLogic,
  Header.fmreason AS EarmarkedFundsDecisionReason,
  Header.wf_start AS EarmarkedFundsStartWorkflow,
  Header.doclock AS EarmarkedFundsManualEditBlock,
  Header.pmdocs AS EmrkdFndsHasValueAdjustments,
  Header.mvstat AS EarmarkedFundsEntryStatus
FROM kblk AS Header
LEFT OUTER JOIN I_EarmarkedFunds_DocCategory AS _EarmarkedFunds_DocCategory ON EarmarkedFundsDocumentCategory = _EarmarkedFunds_DocCategory.EarmarkedFundsDocumentCategory  -- association [1..1]
LEFT OUTER JOIN I_EarmarkedFunds_DocType AS _EarmarkedFunds_DocType ON EarmarkedFundsDocumentType = _EarmarkedFunds_DocType.EarmarkedFundsDocumentType AND EarmarkedFundsDocumentCategory = _EarmarkedFunds_DocType.EarmarkedFundsDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_EarmarkedFunds_MnlEditBlk AS _EarmarkedFunds_MnlEditBlk ON EarmarkedFundsManualEditBlock = _EarmarkedFunds_MnlEditBlk.EarmarkedFundsManualEditBlock  -- association [0..1]
LEFT OUTER JOIN I_EarmarkedFunds_DcsnReason AS _EarmarkedFunds_DcsnReason ON EarmarkedFundsDecisionReason = _EarmarkedFunds_DcsnReason.EarmarkedFundsDecisionReason  -- association [0..1]
LEFT OUTER JOIN I_ReferenceDocumentType AS _ReferenceDocumentType ON ReferenceDocumentType = _ReferenceDocumentType.ReferenceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransCurrency ON TransactionCurrency = _TransCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CCCurrency ON CompanyCodeCurrency = _CCCurrency.Currency  -- association [0..1]
;