C_EarmarkedFundssucessorDoc

DDL: C_EARMARKEDFUNDSSUCESSORDOC SQL: CEFSUCDOC Type: view CONSUMPTION
21 Fields 1 Data Sources 2 Associations

Auxiliary Cosumption View for Object Page

C_EarmarkedFundssucessorDoc is a Consumption CDS View that provides data about "Auxiliary Cosumption View for Object Page" in SAP S/4HANA. It reads from 1 data source (C_EarmarkedFundssucessorDocBsc) and exposes 21 fields with key fields EarmarkedFundsDocument, EarmarkedFundsDocumentItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
C_EarmarkedFundssucessorDocBsc C_EarmarkedFundssucessorDocBsc from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_EarmarkedFunds_DocCatText _EFDocCatText $projection.EarmarkedFundsDocumentCategory = _EFDocCatText.EarmarkedFundsDocumentCategory and _EFDocCatText.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 (9)

NameValueLevelField
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CEFSUCDOC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Auxiliary Cosumption View for Object Page view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY EarmarkedFundsDocument EarmarkedFundsDocument Earmarked Funds
KEY EarmarkedFundsDocumentItem EarmarkedFundsDocumentItem Document Item
EmrkdFndsItmPredecessor EmrkdFndsItmPredecessor Ref. Document
EmrkdFndsItmPrdcssrItem EmrkdFndsItmPrdcssrItem Reference Item
CompanyCode CompanyCode Receiver Company Code
CompanyCodeCurrency CompanyCodeCurrency Local Currency
EarmarkedFundsDocumentCategory EarmarkedFundsDocumentCategory Document Category
EarmarkedFundsDocCategoryText _EFDocCatText EarmarkedFundsDocCategoryText
PostingDate PostingDate Posting Date for GR
EarmarkedFundsDocumentType EarmarkedFundsDocumentType Document Type
EarmarkedFundsDocTypeText _EarmarkedFunds_DocTypeText EarmarkedFundsDocTypeText
CreatedByUser CreatedByUser User Name
TransactionCurrency TransactionCurrency Transaction Currency
EmrkdFndsAmountInCCCrcy EmrkdFndsAmountInCCCrcy Total Amount in Local Currency
EmrkdFndsChgdAmtInCCCrcy EmrkdFndsChgdAmtInCCCrcy Amount Changed
EmrkdFndsAmountInTransCrcy EmrkdFndsAmountInTransCrcy Total Amount
EmrkdFndsChgdAmtInTransCrcy EmrkdFndsChgdAmtInTransCrcy Amount Changed
EmrkdFndsOpenAmtInTransCrcy EmrkdFndsOpenAmtInTransCrcy Open Amount
EmrkdFndsOpenAmtInCCCrcy EmrkdFndsOpenAmtInCCCrcy Open Amount in Local Currency
EmrkdFndsCnsmdAmtInTransCrcy EmrkdFndsCnsmdAmtInTransCrcy Amount Consumed (TC)
EmrkdFndsCnsmdAmtInCCCrcy EmrkdFndsCnsmdAmtInCCCrcy Reduced Amount

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_EarmarkedFundssucessorDoc.
-- 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: CEFSUCDOC

CREATE VIEW C_EarmarkedFundssucessorDoc AS
SELECT
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  EmrkdFndsItmPredecessor,
  EmrkdFndsItmPrdcssrItem,
  CompanyCode,
  CompanyCodeCurrency,
  EarmarkedFundsDocumentCategory,
  _EFDocCatText.EarmarkedFundsDocCategoryText AS EarmarkedFundsDocCategoryText,
  PostingDate,
  EarmarkedFundsDocumentType,
  _EarmarkedFunds_DocTypeText.EarmarkedFundsDocTypeText AS EarmarkedFundsDocTypeText,
  CreatedByUser,
  TransactionCurrency,
  EmrkdFndsAmountInCCCrcy,
  EmrkdFndsChgdAmtInCCCrcy,
  EmrkdFndsAmountInTransCrcy,
  EmrkdFndsChgdAmtInTransCrcy,
  EmrkdFndsOpenAmtInTransCrcy,
  EmrkdFndsOpenAmtInCCCrcy,
  EmrkdFndsCnsmdAmtInTransCrcy,
  EmrkdFndsCnsmdAmtInCCCrcy
FROM C_EarmarkedFundssucessorDocBsc
LEFT OUTER JOIN I_EarmarkedFunds_DocCatText AS _EFDocCatText ON EarmarkedFundsDocumentCategory = _EFDocCatText.EarmarkedFundsDocumentCategory AND _EFDocCatText.Language = $session.system_language  -- association [0..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