I_EarmarkedFundsDocument

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_EarmarkedFundsDocument.
-- 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.

CREATE VIEW I_EarmarkedFundsDocument AS
SELECT
  cast ( belnr as fmis_earmarkedfundsdoc preserving type ) AS EarmarkedFundsDocument,
  cast ( bltyp as fmis_efd_doccategory preserving type ) AS EarmarkedFundsDocumentCategory,
  cast ( blart as fmre_blart preserving type ) AS EarmarkedFundsDocumentType,
  bukrs AS CompanyCode,
  fikrs AS FinancialManagementArea,
  kokrs AS ControllingArea,
  waers AS TransactionCurrency,
  hwaer AS CompanyCodeCurrency,
  xblnr AS EarmarkedFundsDocReference,
  fmre_xblnr2 AS EarmarkedFundsDocReference2,
  fmre_xblnr3 AS EarmarkedFundsDocReference3,
  ktext AS EarmarkedFundsHeaderText,
  ltext AS EarmarkedFundsHasLongText,
  budat AS PostingDate,
  bldat AS DocumentDate,
  wwert AS ExchangeRateDate,
  cast( abs ( kursf ) as fis_absolute_exchangerate preserving type) AS AbsoluteExchangeRate,
  cast( case when kursf < 0 then 'X' else ' ' end as fis_indirect_quotation preserving type) AS ExchRateIsIndirectQuotation,
  kerfas AS EmrkdFndsDocCreatedByUser,
  kerdat AS EmrkdFndsDocCreationDate,
  kaende AS EmrkdFndsDocLastChangedByUser,
  kaedat AS EmrkdFndsDocLastChangeDate,
  lastchangedatetime AS EmrkdFndsDocLastChangeDateTime,
  orgvg AS OrgnlBusinessTransactionType,
  rftyp AS ReferenceDocumentType,
  rfblnr AS ReferenceDocument,
  rforg AS ReferenceDocumentContext,
  rfsys AS ReferenceDocumentLogicalSystem,
  cast ( kloekz as kblkloekz preserving type ) AS EmrkdFndsIsMarkedForArchiving,
  negval AS EmrkdFndsHasNegativeAmounts,
  blkkz AS EmrkdFndsIsBlockedAgainstUsage,
  fexec AS EarmarkedFundsIsCompleted,
  wkapk AS EarmarkedFundsIsApproved,
  wkaok AS EmrkdFndsWasAlreadyAprvdOnce,
  additiv_cons_log AS EmrkdFndsHasAddlCnsmpnLogic,
  fmreason AS EarmarkedFundsDecisionReason,
  cast ( wf_start as fmis_efd_start_approval_wf preserving type ) AS EarmarkedFundsStartWorkflow,
  doclock AS EarmarkedFundsManualEditBlock,
  pmdocs AS EmrkdFndsHasValueAdjustments,
  mvstat AS EarmarkedFundsDocEntryStatus
FROM kblk AS efdoc
LEFT OUTER JOIN I_EarmarkedFundsDocTotals AS _EarmarkedFundsDocTotals ON EarmarkedFundsDocument = _EarmarkedFundsDocTotals.EarmarkedFundsDocument  -- association [0..1]
LEFT OUTER JOIN I_FiscalCalDateForFinMgmtArea AS _FiscalCalDateForFinMgmtArea ON FinancialManagementArea = _FiscalCalDateForFinMgmtArea.FinancialManagementArea AND PostingDate = _FiscalCalDateForFinMgmtArea.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForFinMgmtArea AS _FiscalYearForFinMgmtArea ON FinancialManagementArea = _FiscalYearForFinMgmtArea.FinancialManagementArea AND _FiscalYearForFinMgmtArea.FinMgmtAreaFiscalYearStartDate <= PostingDate AND _FiscalYearForFinMgmtArea.FinMgmtAreaFiscalYearEndDate >= PostingDate  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYearForCompanyCode ON CompanyCode = _FiscalYearForCompanyCode.CompanyCode AND _FiscalYearForCompanyCode.FiscalYearStartDate <= PostingDate AND _FiscalYearForCompanyCode.FiscalYearEndDate >= PostingDate  -- association [0..1]
LEFT OUTER JOIN I_EarmarkedFunds_DocCategory AS _EarmarkedFundsDocCategory ON EarmarkedFundsDocumentCategory = _EarmarkedFundsDocCategory.EarmarkedFundsDocumentCategory  -- association [1..1]
LEFT OUTER JOIN I_EarmarkedFunds_DocCatText AS _EarmarkedFundsDocCatText ON EarmarkedFundsDocumentCategory = _EarmarkedFundsDocCatText.EarmarkedFundsDocumentCategory  -- association [0..*]
LEFT OUTER JOIN I_EarmarkedFunds_DocType AS _EarmarkedFundsDocType ON EarmarkedFundsDocumentType = _EarmarkedFundsDocType.EarmarkedFundsDocumentType AND EarmarkedFundsDocumentCategory = _EarmarkedFundsDocType.EarmarkedFundsDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_EarmarkedFunds_DocTypeText AS _EarmarkedFundsDocTypeText ON EarmarkedFundsDocumentCategory = _EarmarkedFundsDocTypeText.EarmarkedFundsDocumentCategory AND EarmarkedFundsDocumentType = _EarmarkedFundsDocTypeText.EarmarkedFundsDocumentType  -- association [0..*]
LEFT OUTER JOIN I_EarmarkedFunds_MnlEditBlk AS _EarmarkedFundsMnlEditBlk ON EarmarkedFundsManualEditBlock = _EarmarkedFundsMnlEditBlk.EarmarkedFundsManualEditBlock  -- association [0..1]
LEFT OUTER JOIN I_EarmarkedFunds_DcsnReason AS _EarmarkedFundsDcsnReason ON EarmarkedFundsDecisionReason = _EarmarkedFundsDcsnReason.EarmarkedFundsDecisionReason  -- association [0..1]
LEFT OUTER JOIN I_EarmarkedFundsDocEntryStatus AS _EarmarkedFundsDocEntryStatus ON EarmarkedFundsDocEntryStatus = _EarmarkedFundsDocEntryStatus.EarmarkedFundsDocEntryStatus  -- association [0..1]
LEFT OUTER JOIN I_ReferenceDocumentType AS _ReferenceDocumentType ON ReferenceDocumentType = _ReferenceDocumentType.ReferenceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_ReferenceDocumentTypeText AS _ReferenceDocumentTypeText ON ReferenceDocumentType = _ReferenceDocumentTypeText.ReferenceDocumentType  -- association [0..*]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_FinancialManagementArea AS _FinancialManagementArea ON FinancialManagementArea = _FinancialManagementArea.FinancialManagementArea  -- association [0..1]
LEFT OUTER JOIN I_User AS _EmrkdFndsDocCreatedByUser ON EmrkdFndsDocCreatedByUser = _EmrkdFndsDocCreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _EmrkdFndsDocLastChangedByUser ON EmrkdFndsDocLastChangedByUser = _EmrkdFndsDocLastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_LogicalSystem AS _RefDocumentLogicalSystem ON ReferenceDocumentLogicalSystem = _RefDocumentLogicalSystem.LogicalSystem  -- association [0..1]
LEFT OUTER JOIN E_EarmarkedFundsDocument AS _Extension ON EarmarkedFundsDocument = _Extension.EarmarkedFundsDocument  -- association [1]
LEFT OUTER JOIN I_EarmarkedFundsDocumentItem AS _EarmarkedFundsDocumentItem ON /* condition not available in parsed metadata */  -- association [0..*]
;