C_EarmarkedFundsWST

DDL: C_EARMARKEDFUNDSWST SQL: CEFDOCWST Type: view CONSUMPTION
39 Fields 1 Data Sources 2 Associations

Earmarked Funds Document

C_EarmarkedFundsWST is a Consumption CDS View that provides data about "Earmarked Funds Document" in SAP S/4HANA. It reads from 1 data source (I_EarmarkedFundsDocument) and exposes 39 fields with key field EarmarkedFundsDocument. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_EarmarkedFundsDocument I_EarmarkedFundsDocument from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_EarmarkedFunds_DocCatText _EarmarkedFunds_DocCatText $projection.EarmarkedFundsDocumentCategory = _EarmarkedFunds_DocCatText.EarmarkedFundsDocumentCategory and _EarmarkedFunds_DocCatText.Language = $session.system_language
[0..1] I_EarmarkedFunds_DocTypeText _EarmarkedFunds_DocTypeText $projection.EarmarkedFundsDocumentType = _EarmarkedFunds_DocTypeText.EarmarkedFundsDocumentType and $projection.EarmarkedFundsDocumentCategory = _EarmarkedFunds_DocTypeText.EarmarkedFundsDocumentCategory and _EarmarkedFunds_DocTypeText.Language = $session.system_language

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CEFDOCWST view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Earmarked Funds Document view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #CLIENT_DEPENDENT view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY EarmarkedFundsDocument EarmarkedFundsDocument Earmarked Funds
EarmarkedFundsDocumentCategory EarmarkedFundsDocumentCategory Document Category
EarmarkedFundsDocCategoryText _EarmarkedFunds_DocCatText EarmarkedFundsDocCategoryText
EarmarkedFundsDocumentType EarmarkedFundsDocumentType Document Type
EarmarkedFundsDocTypeText _EarmarkedFunds_DocTypeText EarmarkedFundsDocTypeText
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName
FinancialManagementArea FinancialManagementArea FM Area
ControllingArea ControllingArea Controlling Area
TransactionCurrency TransactionCurrency Transaction Currency
CompanyCodeCurrency CompanyCodeCurrency Local Currency
EarmarkedFundsDocReference EarmarkedFundsDocReference Reference
EarmarkedFundsHeaderText EarmarkedFundsHeaderText Document Text
EarmarkedFundsHasLongText EarmarkedFundsHasLongText Long Txt Exists
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
ExchangeRateDate ExchangeRateDate Translatn Date
AbsoluteExchangeRate AbsoluteExchangeRate Absolute Exchange Rate
ExchRateIsIndirectQuotation ExchRateIsIndirectQuotation Exchange Rate Is Indirect Quotation
CreatedByUser EmrkdFndsDocCreatedByUser Entered By
CreationDate EmrkdFndsDocCreationDate Entered On
LastChangeUser EmrkdFndsDocLastChangedByUser Last Changed By
LastChangeDate EmrkdFndsDocLastChangeDate Changed On
ReferenceDocumentType ReferenceDocumentType Reference Document Type
ReferenceDocument ReferenceDocument Reference Document
ReferenceDocumentContext ReferenceDocumentContext Reference Document Context
ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem Ref. Doc. Lgcl Syst.
EmrkdFndsIsMarkedForArchiving EmrkdFndsIsMarkedForArchiving Can Be Archived
EmrkdFndsHasNegativeAmounts EmrkdFndsHasNegativeAmounts Neg.Values
EmrkdFndsIsBlockedAgainstUsage EmrkdFndsIsBlockedAgainstUsage Doc.Blocked
EarmarkedFundsIsCompleted EarmarkedFundsIsCompleted Doc.Completed
EarmarkedFundsIsApproved EarmarkedFundsIsApproved Doc. Approved
EmrkdFndsWasAlreadyAprvdOnce EmrkdFndsWasAlreadyAprvdOnce Already Apprvd
EmrkdFndsHasAddlCnsmpnLogic EmrkdFndsHasAddlCnsmpnLogic Add. Rdctn Logic
EarmarkedFundsDecisionReason EarmarkedFundsDecisionReason Decision Reason
EarmarkedFundsStartWorkflow EarmarkedFundsStartWorkflow Start Approval by Workflow
EarmarkedFundsManualEditBlock EarmarkedFundsManualEditBlock Document Block
EmrkdFndsHasValueAdjustments EmrkdFndsHasValueAdjustments Value Adjustmts
EarmarkedFundsDocEntryStatus EarmarkedFundsDocEntryStatus Status

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_EarmarkedFundsWST.
-- 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: CEFDOCWST

CREATE VIEW C_EarmarkedFundsWST AS
SELECT
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentCategory,
  _EarmarkedFunds_DocCatText.EarmarkedFundsDocCategoryText AS EarmarkedFundsDocCategoryText,
  EarmarkedFundsDocumentType,
  _EarmarkedFunds_DocTypeText.EarmarkedFundsDocTypeText AS EarmarkedFundsDocTypeText,
  CompanyCode,
  I_EarmarkedFundsDocument._CompanyCode.CompanyCodeName AS CompanyCodeName,
  FinancialManagementArea,
  ControllingArea,
  TransactionCurrency,
  CompanyCodeCurrency,
  EarmarkedFundsDocReference,
  EarmarkedFundsHeaderText,
  EarmarkedFundsHasLongText,
  PostingDate,
  DocumentDate,
  ExchangeRateDate,
  AbsoluteExchangeRate,
  ExchRateIsIndirectQuotation,
  EmrkdFndsDocCreatedByUser AS CreatedByUser,
  EmrkdFndsDocCreationDate AS CreationDate,
  EmrkdFndsDocLastChangedByUser AS LastChangeUser,
  EmrkdFndsDocLastChangeDate AS LastChangeDate,
  ReferenceDocumentType,
  ReferenceDocument,
  ReferenceDocumentContext,
  ReferenceDocumentLogicalSystem,
  EmrkdFndsIsMarkedForArchiving,
  EmrkdFndsHasNegativeAmounts,
  EmrkdFndsIsBlockedAgainstUsage,
  EarmarkedFundsIsCompleted,
  EarmarkedFundsIsApproved,
  EmrkdFndsWasAlreadyAprvdOnce,
  EmrkdFndsHasAddlCnsmpnLogic,
  EarmarkedFundsDecisionReason,
  EarmarkedFundsStartWorkflow,
  EarmarkedFundsManualEditBlock,
  EmrkdFndsHasValueAdjustments,
  EarmarkedFundsDocEntryStatus
FROM I_EarmarkedFundsDocument
LEFT OUTER JOIN I_EarmarkedFunds_DocCatText AS _EarmarkedFunds_DocCatText ON EarmarkedFundsDocumentCategory = _EarmarkedFunds_DocCatText.EarmarkedFundsDocumentCategory AND _EarmarkedFunds_DocCatText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_EarmarkedFunds_DocTypeText AS _EarmarkedFunds_DocTypeText ON EarmarkedFundsDocumentType = _EarmarkedFunds_DocTypeText.EarmarkedFundsDocumentType AND EarmarkedFundsDocumentCategory = _EarmarkedFunds_DocTypeText.EarmarkedFundsDocumentCategory AND _EarmarkedFunds_DocTypeText.Language = $session.system_language  -- association [0..1]
;

Learn More