R_EarmarkedFundsDocumentTP

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_EarmarkedFundsDocumentTP.
-- 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 R_EarmarkedFundsDocumentTP AS
SELECT
  cast( EarmarkedFundsDocument as kblnr_dy preserving type ) AS EarmarkedFundsDocument,
  cast( EarmarkedFundsDocument as fmis_earmarkedfundsdocext preserving type ) AS EarmarkedFundsDocumentForEdit,
  EarmarkedFundsDocumentCategory,
  EarmarkedFundsDocumentType,
  CompanyCode,
  FinancialManagementArea,
  ControllingArea,
  TransactionCurrency,
  CompanyCodeCurrency,
  EarmarkedFundsDocReference,
  EarmarkedFundsDocReference2,
  EarmarkedFundsDocReference3,
  EarmarkedFundsHeaderText,
  EarmarkedFundsHasLongText,
  PostingDate,
  DocumentDate,
  ExchangeRateDate,
  AbsoluteExchangeRate,
  ExchRateIsIndirectQuotation,
  EmrkdFndsDocCreatedByUser,
  EmrkdFndsDocCreationDate,
  EmrkdFndsDocLastChangedByUser,
  EmrkdFndsDocLastChangeDate,
  EmrkdFndsDocLastChangeDateTime,
  OrgnlBusinessTransactionType,
  ReferenceDocumentType,
  ReferenceDocument,
  ReferenceDocumentContext,
  ReferenceDocumentLogicalSystem,
  EmrkdFndsIsMarkedForArchiving,
  EmrkdFndsHasNegativeAmounts,
  EmrkdFndsIsBlockedAgainstUsage,
  EarmarkedFundsIsCompleted,
  EarmarkedFundsIsApproved,
  EmrkdFndsWasAlreadyAprvdOnce,
  EmrkdFndsHasAddlCnsmpnLogic,
  EarmarkedFundsDecisionReason,
  EarmarkedFundsStartWorkflow,
  EarmarkedFundsManualEditBlock,
  EarmarkedFundsManualEditBlock AS EmrkdFndsMnlEditBlkForEdit,
  EmrkdFndsHasValueAdjustments,
  EarmarkedFundsDocEntryStatus,
  _EarmarkedFundsDocTotals.EmrkdFndsTotalInTransCrcy AS EmrkdFndsTotalInTransCrcy,
  _EarmarkedFundsDocTotals.EmrkdFndsRelTotalInTransCrcy AS EmrkdFndsRelTotalInTransCrcy,
  _EarmarkedFundsDocTotals.EmrkdFndsOpenTotalInTransCrcy AS EmrkdFndsOpenTotalInTransCrcy,
  _EarmarkedFundsDocTotals.EmrkdFndsChgdTotalInTransCrcy AS EmrkdFndsChgdTotalInTransCrcy,
  _EarmarkedFundsDocTotals.EmrkdFndsCnsmdTotalInTransCrcy AS EmrkdFndsCnsmdTotalInTransCrcy,
  _EarmarkedFundsDocTotals.EmrkdFndsOriglTotalInTransCrcy AS EmrkdFndsOriglTotalInTransCrcy,
  _EarmarkedFundsDocTotals.EmrkdFndsTotalInCCCrcy AS EmrkdFndsTotalInCCCrcy,
  _EarmarkedFundsDocTotals.EmrkdFndsRelTotalInCCCrcy AS EmrkdFndsRelTotalInCCCrcy,
  _EarmarkedFundsDocTotals.EmrkdFndsOpenTotalInCCCrcy AS EmrkdFndsOpenTotalInCCCrcy,
  _EarmarkedFundsDocTotals.EmrkdFndsChgdTotalInCCCrcy AS EmrkdFndsChgdTotalInCCCrcy,
  _EarmarkedFundsDocTotals.EmrkdFndsCnsmdTotalInCCCrcy AS EmrkdFndsCnsmdTotalInCCCrcy,
  _EarmarkedFundsDocTotals.EmrkdFndsOriglTotalInCCCrcy AS EmrkdFndsOriglTotalInCCCrcy
FROM I_EarmarkedFundsDocument AS efdoc
LEFT OUTER JOIN E_EarmarkedFundsDocument AS _Extension ON EarmarkedFundsDocument = _Extension.EarmarkedFundsDocument  -- association [1]
LEFT OUTER JOIN R_EarmarkedFundsDocumentItemTP AS _EarmarkedFundsDocumentItem ON /* condition not available in parsed metadata */  -- association [0..*]
;