C_EarmarkedFundsDocumentTP

DDL: C_EARMARKEDFUNDSDOCUMENTTP Type: view_entity CONSUMPTION
66 Fields 1 Data Sources 1 Associations

Manage Earmarked Funds

C_EarmarkedFundsDocumentTP is a Consumption CDS View that provides data about "Manage Earmarked Funds" in SAP S/4HANA. It reads from 1 data source (R_EarmarkedFundsDocumentTP) and exposes 66 fields with key field EarmarkedFundsDocument. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_EarmarkedFundsDocumentTP R_EarmarkedFundsDocumentTP projection

Associations (1)

CardinalityTargetAliasCondition
[1] E_EarmarkedFundsDocument _Extension $projection.EarmarkedFundsDocument = _Extension.EarmarkedFundsDocument

Annotations (10)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey EarmarkedFundsDocument view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Search.searchable true view
EndUserText.label Manage Earmarked Funds view

Fields (66)

KeyFieldSource TableSource FieldDescription
KEY EarmarkedFundsDocument EarmarkedFundsDocument EarmarkedFundsDocument Earmarked Funds
virtualEarmarkedFundsDocIntNumberchar10
EarmarkedFundsDocumentForEdit EarmarkedFundsDocument EarmarkedFundsDocumentForEdit External Document Number
EarmarkedFundsDocumentCategory EarmarkedFundsDocument EarmarkedFundsDocumentCategory Document Category
EarmarkedFundsDocumentType EarmarkedFundsDocument EarmarkedFundsDocumentType Document Type
CompanyCode EarmarkedFundsDocument CompanyCode Receiver Company Code
CompanyCodeName
virtualLedgerfins_ledger
virtualSourceLedgerfins_ledger_pers
virtualIsCommitmentfis_xcommitment
TransactionCurrency EarmarkedFundsDocument TransactionCurrency Transaction Currency
CompanyCodeCurrency EarmarkedFundsDocument CompanyCodeCurrency Local Currency
ControllingArea EarmarkedFundsDocument ControllingArea Controlling Area
FinancialManagementArea EarmarkedFundsDocument FinancialManagementArea FM Area
virtualEmrkdFndsFldReferenceIsHidboolean
EarmarkedFundsDocReference EarmarkedFundsDocument EarmarkedFundsDocReference Reference
EarmarkedFundsDocReference2 EarmarkedFundsDocument EarmarkedFundsDocReference2 Reference 2
EarmarkedFundsDocReference3 EarmarkedFundsDocument EarmarkedFundsDocReference3 Reference 3
EarmarkedFundsHeaderText EarmarkedFundsDocument EarmarkedFundsHeaderText Document Text
PostingDate EarmarkedFundsDocument PostingDate Posting Date for GR
DocumentDate EarmarkedFundsDocument DocumentDate Journal Entry Date
virtualEmrkdFndsFldExchDataIsHidboolean
ExchangeRateDate EarmarkedFundsDocument ExchangeRateDate Translatn Date
AbsoluteExchangeRate EarmarkedFundsDocument AbsoluteExchangeRate Absolute Exchange Rate
ExchRateIsIndirectQuotation EarmarkedFundsDocument ExchRateIsIndirectQuotation Exchange Rate Is Indirect Quotation
EmrkdFndsDocCreatedByUser EarmarkedFundsDocument EmrkdFndsDocCreatedByUser Entered By
CreatedByUserDescription
EmrkdFndsDocCreationDate EarmarkedFundsDocument EmrkdFndsDocCreationDate Entered On
EmrkdFndsDocLastChangedByUser EarmarkedFundsDocument EmrkdFndsDocLastChangedByUser Last Changed By
LastChangedByUserDescription
EmrkdFndsDocLastChangeDate EarmarkedFundsDocument EmrkdFndsDocLastChangeDate Changed On
EmrkdFndsDocLastChangeDateTime EarmarkedFundsDocument EmrkdFndsDocLastChangeDateTime Last Changed On
EmrkdFndsIsMarkedForArchiving EarmarkedFundsDocument EmrkdFndsIsMarkedForArchiving Can Be Archived
EmrkdFndsIsBlockedAgainstUsage EarmarkedFundsDocument EmrkdFndsIsBlockedAgainstUsage Doc.Blocked
EarmarkedFundsIsCompleted EarmarkedFundsDocument EarmarkedFundsIsCompleted Doc.Completed
EarmarkedFundsManualEditBlock EarmarkedFundsDocument EarmarkedFundsManualEditBlock Document Block
EarmarkedFundsStartWorkflow EarmarkedFundsDocument EarmarkedFundsStartWorkflow Start Approval by Workflow
EarmarkedFundsIsApproved EarmarkedFundsDocument EarmarkedFundsIsApproved Doc. Approved
EmrkdFndsWasAlreadyAprvdOnce EarmarkedFundsDocument EmrkdFndsWasAlreadyAprvdOnce Already Apprvd
EmrkdFndsTotalInTransCrcy EarmarkedFundsDocument EmrkdFndsTotalInTransCrcy Total Amount
EmrkdFndsChgdTotalInTransCrcy EarmarkedFundsDocument EmrkdFndsChgdTotalInTransCrcy Amount Changed
EmrkdFndsOpenTotalInTransCrcy EarmarkedFundsDocument EmrkdFndsOpenTotalInTransCrcy Open Amount
EmrkdFndsTotalInCCCrcy EarmarkedFundsDocument EmrkdFndsTotalInCCCrcy Total Amount in Local Currency
EmrkdFndsChgdTotalInCCCrcy EarmarkedFundsDocument EmrkdFndsChgdTotalInCCCrcy Amount Changed in Local Currency
EmrkdFndsOpenTotalInCCCrcy EarmarkedFundsDocument EmrkdFndsOpenTotalInCCCrcy Open Amount in Local Currency
virtualEmrkdFndsFldGLAccountIsHidboolean
virtualUICT_InternalOrderboolean
virtualEmrkdFndsFldFundIsHidboolean
virtualEmrkdFndsFldBdgtPerdIsHidboolean
virtualEmrkdFndsFldGrantIDIsHidboolean
virtualUICT_FundsCenterboolean
virtualUICT_CommitmentItemboolean
virtualUICT_FundedProgramboolean
virtualEmrkdFndsFldSupplierIsHidboolean
virtualEmrkdFndsFldItemTextIsHidboolean
virtualEmrkdFndsFldDueDateIsHidboolean
virtualEmrkdFndsFldResDocIsHidboolean
_FiscalYearForCompanyCode _FiscalYearForCompanyCode
_EarmarkedFundsDocCategory _EarmarkedFundsDocCategory
_EarmarkedFundsDocType _EarmarkedFundsDocType
_EarmarkedFundsMnlEditBlk _EarmarkedFundsMnlEditBlk
_CompanyCodeCurrency _CompanyCodeCurrency
_TransactionCurrency _TransactionCurrency
_CompanyCode _CompanyCode
_EmrkdFndsDocLastChangedByUser _EmrkdFndsDocLastChangedByUser
_EmrkdFndsDocCreatedByUser _EmrkdFndsDocCreatedByUser

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]
;

Learn More