C_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 C_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 C_EarmarkedFundsDocumentTP AS
SELECT
  EarmarkedFundsDocument.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  virtual EarmarkedFundsDocIntNumber : char10 AS virtualEarmarkedFundsDocIntNumberchar10,
  EarmarkedFundsDocument.EarmarkedFundsDocumentForEdit AS EarmarkedFundsDocumentForEdit,
  EarmarkedFundsDocument.EarmarkedFundsDocumentCategory AS EarmarkedFundsDocumentCategory,
  EarmarkedFundsDocument.EarmarkedFundsDocumentType AS EarmarkedFundsDocumentType,
  EarmarkedFundsDocument.CompanyCode AS CompanyCode,
  EarmarkedFundsDocument._CompanyCode.CompanyCodeName AS CompanyCodeName,
  virtual Ledger : fins_ledger AS virtualLedgerfins_ledger,
  virtual SourceLedger : fins_ledger_pers AS virtualSourceLedgerfins_ledger_pers,
  virtual IsCommitment : fis_xcommitment AS virtualIsCommitmentfis_xcommitment,
  EarmarkedFundsDocument.TransactionCurrency AS TransactionCurrency,
  EarmarkedFundsDocument.CompanyCodeCurrency AS CompanyCodeCurrency,
  EarmarkedFundsDocument.ControllingArea AS ControllingArea,
  EarmarkedFundsDocument.FinancialManagementArea AS FinancialManagementArea,
  virtual EmrkdFndsFldReferenceIsHid : boolean AS virtualEmrkdFndsFldReferenceIsHidboolean,
  EarmarkedFundsDocument.EarmarkedFundsDocReference AS EarmarkedFundsDocReference,
  EarmarkedFundsDocument.EarmarkedFundsDocReference2 AS EarmarkedFundsDocReference2,
  EarmarkedFundsDocument.EarmarkedFundsDocReference3 AS EarmarkedFundsDocReference3,
  EarmarkedFundsDocument.EarmarkedFundsHeaderText AS EarmarkedFundsHeaderText,
  EarmarkedFundsDocument.PostingDate AS PostingDate,
  EarmarkedFundsDocument.DocumentDate AS DocumentDate,
  virtual EmrkdFndsFldExchDataIsHid : boolean AS virtualEmrkdFndsFldExchDataIsHidboolean,
  EarmarkedFundsDocument.ExchangeRateDate AS ExchangeRateDate,
  EarmarkedFundsDocument.AbsoluteExchangeRate AS AbsoluteExchangeRate,
  EarmarkedFundsDocument.ExchRateIsIndirectQuotation AS ExchRateIsIndirectQuotation,
  EarmarkedFundsDocument.EmrkdFndsDocCreatedByUser AS EmrkdFndsDocCreatedByUser,
  cast( EarmarkedFundsDocument._EmrkdFndsDocCreatedByUser.UserDescription as vdm_createdbyuserdescription preserving type ) AS CreatedByUserDescription,
  EarmarkedFundsDocument.EmrkdFndsDocCreationDate AS EmrkdFndsDocCreationDate,
  EarmarkedFundsDocument.EmrkdFndsDocLastChangedByUser AS EmrkdFndsDocLastChangedByUser,
  cast( EarmarkedFundsDocument._EmrkdFndsDocLastChangedByUser.UserDescription as vdm_lastchangedbyuserdescripti preserving type ) AS LastChangedByUserDescription,
  EarmarkedFundsDocument.EmrkdFndsDocLastChangeDate AS EmrkdFndsDocLastChangeDate,
  EarmarkedFundsDocument.EmrkdFndsDocLastChangeDateTime AS EmrkdFndsDocLastChangeDateTime,
  EarmarkedFundsDocument.EmrkdFndsIsMarkedForArchiving AS EmrkdFndsIsMarkedForArchiving,
  EarmarkedFundsDocument.EmrkdFndsIsBlockedAgainstUsage AS EmrkdFndsIsBlockedAgainstUsage,
  EarmarkedFundsDocument.EarmarkedFundsIsCompleted AS EarmarkedFundsIsCompleted,
  EarmarkedFundsDocument.EarmarkedFundsManualEditBlock AS EarmarkedFundsManualEditBlock,
  EarmarkedFundsDocument.EarmarkedFundsStartWorkflow AS EarmarkedFundsStartWorkflow,
  EarmarkedFundsDocument.EarmarkedFundsIsApproved AS EarmarkedFundsIsApproved,
  EarmarkedFundsDocument.EmrkdFndsWasAlreadyAprvdOnce AS EmrkdFndsWasAlreadyAprvdOnce,
  EarmarkedFundsDocument.EmrkdFndsTotalInTransCrcy AS EmrkdFndsTotalInTransCrcy,
  EarmarkedFundsDocument.EmrkdFndsChgdTotalInTransCrcy AS EmrkdFndsChgdTotalInTransCrcy,
  EarmarkedFundsDocument.EmrkdFndsOpenTotalInTransCrcy AS EmrkdFndsOpenTotalInTransCrcy,
  EarmarkedFundsDocument.EmrkdFndsTotalInCCCrcy AS EmrkdFndsTotalInCCCrcy,
  EarmarkedFundsDocument.EmrkdFndsChgdTotalInCCCrcy AS EmrkdFndsChgdTotalInCCCrcy,
  EarmarkedFundsDocument.EmrkdFndsOpenTotalInCCCrcy AS EmrkdFndsOpenTotalInCCCrcy,
  virtual EmrkdFndsFldGLAccountIsHid : boolean AS virtualEmrkdFndsFldGLAccountIsHidboolean,
  virtual UICT_InternalOrder : boolean AS virtualUICT_InternalOrderboolean,
  virtual EmrkdFndsFldFundIsHid : boolean AS virtualEmrkdFndsFldFundIsHidboolean,
  virtual EmrkdFndsFldBdgtPerdIsHid : boolean AS virtualEmrkdFndsFldBdgtPerdIsHidboolean,
  virtual EmrkdFndsFldGrantIDIsHid : boolean AS virtualEmrkdFndsFldGrantIDIsHidboolean,
  virtual UICT_FundsCenter : boolean AS virtualUICT_FundsCenterboolean,
  virtual UICT_CommitmentItem : boolean AS virtualUICT_CommitmentItemboolean,
  virtual UICT_FundedProgram : boolean AS virtualUICT_FundedProgramboolean,
  virtual EmrkdFndsFldSupplierIsHid : boolean AS virtualEmrkdFndsFldSupplierIsHidboolean,
  virtual EmrkdFndsFldItemTextIsHid : boolean AS virtualEmrkdFndsFldItemTextIsHidboolean,
  virtual EmrkdFndsFldDueDateIsHid : boolean AS virtualEmrkdFndsFldDueDateIsHidboolean,
  virtual EmrkdFndsFldResDocIsHid : boolean AS virtualEmrkdFndsFldResDocIsHidboolean
FROM R_EarmarkedFundsDocumentTP
LEFT OUTER JOIN E_EarmarkedFundsDocument AS _Extension ON EarmarkedFundsDocument = _Extension.EarmarkedFundsDocument  -- association [1]
;