I_EmrkdFndsValueAdjustmentDoc

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_EmrkdFndsValueAdjustmentDoc.
-- 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_EmrkdFndsValueAdjustmentDoc AS
SELECT
  cast ( belnr as fmis_earmarkedfundsdoc preserving type ) AS EarmarkedFundsDocument,
  cast ( blpos as fmis_earmarkedfundsdocitem preserving type ) AS EarmarkedFundsDocumentItem,
  bpent AS EmrkdFndsValueAdjustmentDoc,
  xplus AS EmrkdFndsValAdjmtDocIsIncrease,
  xminus AS EmrkdFndsValAdjmtDocIsDecrease,
  bldat AS DocumentDate,
  erfas AS CreatedByUser,
  erdat AS CreationDate,
  aende AS LastChangedByUser,
  aedat AS LastChangeDate,
  btext AS EmrkdFndsValAdjmtDocText,
  wtsupp AS EmrkdFndsValAdjAmtInTransCrcy,
  hwsupp AS EmrkdFndsValAdjmtAmtInCCCrcy,
  appstatus AS EmrkdFndsValAdjmtAuthznStatus,
  suppapp AS EmrkdFndsValAdjmtDocIsApproved,
  reason AS EarmarkedFundsDecisionReason,
  pmlock AS EmrkdFndsValAdjmtDocMnlEditBlk,
  waers AS TransactionCurrency,
  hwaer AS CompanyCodeCurrency,
  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
FROM kblps
LEFT OUTER JOIN I_EarmarkedFundsDocument AS _EarmarkedFundsDocument ON EarmarkedFundsDocument = _EarmarkedFundsDocument.EarmarkedFundsDocument  -- association [1..1]
LEFT OUTER JOIN I_EarmarkedFundsDocumentItem AS _EarmarkedFundsDocumentItem ON EarmarkedFundsDocument = _EarmarkedFundsDocumentItem.EarmarkedFundsDocument AND EarmarkedFundsDocumentItem = _EarmarkedFundsDocumentItem.EarmarkedFundsDocumentItem  -- association [1..1]
LEFT OUTER JOIN I_EarmarkedFunds_MnlEditBlk AS _EarmarkedFundsMnlEditBlk ON EmrkdFndsValAdjmtDocMnlEditBlk = _EarmarkedFundsMnlEditBlk.EarmarkedFundsManualEditBlock  -- association [0..1]
LEFT OUTER JOIN I_EarmarkedFunds_DcsnReason AS _EarmarkedFundsDcsnReason ON EarmarkedFundsDecisionReason = _EarmarkedFundsDcsnReason.EarmarkedFundsDecisionReason  -- association [0..1]
LEFT OUTER JOIN I_EmrkdFndsValAdjmtAuthznSts AS _EmrkdFndsValAdjmtAuthznSts ON EmrkdFndsValAdjmtAuthznStatus = _EmrkdFndsValAdjmtAuthznSts.EmrkdFndsValAdjmtAuthznStatus  -- association [0..1]
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_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
;