R_DspDocFlwEmrkdFundsDocument

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 R_DspDocFlwEmrkdFundsDocument.
-- 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: RDDFEMRKDFNDDOC

CREATE VIEW R_DspDocFlwEmrkdFundsDocument AS
SELECT
  cast ( belnr as fmis_earmarkedfundsdoc preserving type ) AS EarmarkedFundsDocument,
  kvrgng AS BusinessTransactionCategory,
  bltyp AS EarmarkedFundsDocumentCategory,
  cast ( blart as fmre_blart preserving type ) AS EarmarkedFundsDocumentType,
  bukrs AS CompanyCode,
  fikrs AS FinancialManagementArea,
  kokrs AS ControllingArea,
  waers AS TransactionCurrency,
  _EarmarkedFundsDocTotals.EmrkdFndsTotalInTransCrcy AS EmrkdFndsTotalInTransCrcy,
  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,
  kerfas AS EmrkdFndsDocCreatedByUser,
  kerdat AS EmrkdFndsDocCreationDate,
  kaende AS EmrkdFndsDocLastChangedByUser,
  kaedat AS EmrkdFndsDocLastChangeDate,
  orgvg AS OrgnlBusinessTransactionType,
  cast ( kloekz as kblkloekz preserving type ) AS EmrkdFndsIsMarkedForArchiving,
  blkkz AS IsEndOfPurposeBlocked
FROM kblk
LEFT OUTER JOIN I_EarmarkedFunds_DocCategory AS _EarmarkedFundsDocCategory ON EarmarkedFundsDocumentCategory = _EarmarkedFundsDocCategory.EarmarkedFundsDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_EarmarkedFunds_DocType AS _EarmarkedFundsDocType ON EarmarkedFundsDocumentCategory = _EarmarkedFundsDocType.EarmarkedFundsDocumentCategory AND EarmarkedFundsDocumentType = _EarmarkedFundsDocType.EarmarkedFundsDocumentType  -- association [0..1]
LEFT OUTER JOIN I_EarmarkedFundsDocTotals AS _EarmarkedFundsDocTotals ON EarmarkedFundsDocument = _EarmarkedFundsDocTotals.EarmarkedFundsDocument  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.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]
;