C_EmrkdFundsPredecessorDocBsc

DDL: C_EMRKDFUNDSPREDECESSORDOCBSC Type: view CONSUMPTION
15 Fields 1 Data Sources 3 Associations

Auxiliary Cosumption view for Object Page

C_EmrkdFundsPredecessorDocBsc 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 (I_EarmarkedFundsDocumentItem) and exposes 15 fields with key fields EarmarkedFundsDocument, EmrkdFndsItmPredecessor. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_EarmarkedFundsDocumentItem PredecessorItem from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_EarmarkedFundsDocument _PredecessorHeader $projection.EmrkdFndsItmPredecessor = _PredecessorHeader.EarmarkedFundsDocument
[0..*] I_EarmarkedFundsDocumentItem _PredecessorItem $projection.EmrkdFndsItmPredecessor = _PredecessorItem.EarmarkedFundsDocument
[0..1] I_EarmarkedFunds_DocCatText _EFDocCatText $projection.earmarkedfundsdocumentcategory = _EFDocCatText.EarmarkedFundsDocumentCategory and _EFDocCatText.Language = $session.system_language

Annotations (8)

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

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY EarmarkedFundsDocument I_EarmarkedFundsDocumentItem EarmarkedFundsDocument Earmarked Funds
KEY EmrkdFndsItmPredecessor I_EarmarkedFundsDocumentItem EmrkdFndsItmPredecessor Ref. Document
CompanyCode I_EarmarkedFundsDocumentItem CompanyCode Receiver Company Code
CompanyCodeCurrency
EarmarkedFundsDocumentCategory _PredecessorHeader EarmarkedFundsDocumentCategory Document Category
PostingDate _PredecessorHeader PostingDate Posting Date for GR
EarmarkedFundsDocumentType _PredecessorHeader EarmarkedFundsDocumentType Document Type
CreatedByUser _PredecessorHeader EmrkdFndsDocCreatedByUser Entered By
TransactionCurrency I_EarmarkedFundsDocumentItem TransactionCurrency Transaction Currency
EmrkdFndsAmountInCCCrcy
EmrkdFndsChgdAmtInCCCrcy
EmrkdFndsAmountInTransCrcy
EmrkdFndsChgdAmtInTransCrcy
EmrkdFndsOpenAmtInTransCrcy
EmrkdFndsOpenAmtInCCCrcy

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_EmrkdFundsPredecessorDocBsc.
-- 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_EmrkdFundsPredecessorDocBsc AS
SELECT
  PredecessorItem.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  PredecessorItem.EmrkdFndsItmPredecessor AS EmrkdFndsItmPredecessor,
  PredecessorItem.CompanyCode AS CompanyCode,
  PredecessorItem._CompanyCode.Currency AS CompanyCodeCurrency,
  _PredecessorHeader.EarmarkedFundsDocumentCategory AS EarmarkedFundsDocumentCategory,
  _PredecessorHeader.PostingDate AS PostingDate,
  _PredecessorHeader.EarmarkedFundsDocumentType AS EarmarkedFundsDocumentType,
  _PredecessorHeader.EmrkdFndsDocCreatedByUser AS CreatedByUser,
  PredecessorItem.TransactionCurrency AS TransactionCurrency,
  sum( _PredecessorItem.EmrkdFndsAmountInCCCrcy ) AS EmrkdFndsAmountInCCCrcy,
  sum( _PredecessorItem.EmrkdFndsChgdAmtInCCCrcy ) AS EmrkdFndsChgdAmtInCCCrcy,
  sum( _PredecessorItem.EmrkdFndsAmountInTransCrcy ) AS EmrkdFndsAmountInTransCrcy,
  sum( _PredecessorItem.EmrkdFndsChgdAmtInTransCrcy ) AS EmrkdFndsChgdAmtInTransCrcy,
  sum( _PredecessorItem.EmrkdFndsOpenAmtInTransCrcy ) AS EmrkdFndsOpenAmtInTransCrcy,
  sum( _PredecessorItem.EmrkdFndsOpenAmtInCCCrcy ) AS EmrkdFndsOpenAmtInCCCrcy
FROM I_EarmarkedFundsDocumentItem AS PredecessorItem
LEFT OUTER JOIN I_EarmarkedFundsDocument AS _PredecessorHeader ON EmrkdFndsItmPredecessor = _PredecessorHeader.EarmarkedFundsDocument  -- association [1..1]
LEFT OUTER JOIN I_EarmarkedFundsDocumentItem AS _PredecessorItem ON EmrkdFndsItmPredecessor = _PredecessorItem.EarmarkedFundsDocument  -- association [0..*]
LEFT OUTER JOIN I_EarmarkedFunds_DocCatText AS _EFDocCatText ON earmarkedfundsdocumentcategory = _EFDocCatText.EarmarkedFundsDocumentCategory AND _EFDocCatText.Language = $session.system_language  -- association [0..1]
;

Learn More