C_EarmarkedFundsPredecessorDoc

DDL: C_EARMARKEDFUNDSPREDECESSORDOC SQL: CEFPRDOC Type: view CONSUMPTION
19 Fields 2 Data Sources

Auxiliary Cosumption View for Object Page

C_EarmarkedFundsPredecessorDoc is a Consumption CDS View that provides data about "Auxiliary Cosumption View for Object Page" in SAP S/4HANA. It reads from 2 data sources (I_EarmarkedFundsDocumentItem, I_EarmarkedFundsDocumentItem) and exposes 19 fields with key fields EarmarkedFundsDocument, EarmarkedFundsDocumentItem.

Data Sources (2)

SourceAliasJoin Type
I_EarmarkedFundsDocumentItem OriginalItem from
I_EarmarkedFundsDocumentItem PredecessorItem inner

Annotations (9)

NameValueLevelField
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CEFPRDOC 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 (19)

KeyFieldSource TableSource FieldDescription
KEY EarmarkedFundsDocument I_EarmarkedFundsDocumentItem EarmarkedFundsDocument Earmarked Funds
KEY EarmarkedFundsDocumentItem I_EarmarkedFundsDocumentItem EarmarkedFundsDocumentItem Document Item
EmrkdFndsItmPredecessor I_EarmarkedFundsDocumentItem EmrkdFndsItmPredecessor Ref. Document
EmrkdFndsItmPrdcssrItem I_EarmarkedFundsDocumentItem EmrkdFndsItmPrdcssrItem Reference Item
CompanyCode I_EarmarkedFundsDocumentItem CompanyCode Receiver Company Code
CompanyCodeCurrency I_EarmarkedFundsDocumentItem CompanyCodeCurrency Local Currency
EarmarkedFundsDocumentCategory
EarmarkedFundsDocCategoryText
PostingDate I_EarmarkedFundsDocumentItem PostingDate Posting Date for GR
EarmarkedFundsDocumentType
EarmarkedFundsDocTypeText
CreatedByUser I_EarmarkedFundsDocumentItem EmrkdFndsDocItmCreatedByUser Entered By
TransactionCurrency I_EarmarkedFundsDocumentItem TransactionCurrency Transaction Currency
EmrkdFndsAmountInCCCrcy I_EarmarkedFundsDocumentItem EmrkdFndsAmountInCCCrcy Total Amount in Local Currency
EmrkdFndsChgdAmtInCCCrcy I_EarmarkedFundsDocumentItem EmrkdFndsChgdAmtInCCCrcy Amount Changed
EmrkdFndsAmountInTransCrcy I_EarmarkedFundsDocumentItem EmrkdFndsAmountInTransCrcy Grand Total Amount(TC)
EmrkdFndsChgdAmtInTransCrcy I_EarmarkedFundsDocumentItem EmrkdFndsChgdAmtInTransCrcy Amount Changed
EmrkdFndsOpenAmtInTransCrcy I_EarmarkedFundsDocumentItem EmrkdFndsOpenAmtInTransCrcy Open Amount(TC)
EmrkdFndsOpenAmtInCCCrcy I_EarmarkedFundsDocumentItem EmrkdFndsOpenAmtInCCCrcy Open Amount in Local Currency

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_EarmarkedFundsPredecessorDoc.
-- 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: CEFPRDOC

CREATE VIEW C_EarmarkedFundsPredecessorDoc AS
SELECT
  OriginalItem.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  OriginalItem.EarmarkedFundsDocumentItem AS EarmarkedFundsDocumentItem,
  OriginalItem.EmrkdFndsItmPredecessor AS EmrkdFndsItmPredecessor,
  OriginalItem.EmrkdFndsItmPrdcssrItem AS EmrkdFndsItmPrdcssrItem,
  PredecessorItem.CompanyCode AS CompanyCode,
  PredecessorItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  PredecessorItem._EarmarkedFundsDocument.EarmarkedFundsDocumentCategory AS EarmarkedFundsDocumentCategory,
  PredecessorItem._EarmarkedFundsDocument._EarmarkedFundsDocCategory._Text[1: Language = $session.system_language ].EarmarkedFundsDocCategoryText AS EarmarkedFundsDocCategoryText,
  PredecessorItem.PostingDate AS PostingDate,
  PredecessorItem._EarmarkedFundsDocument.EarmarkedFundsDocumentType AS EarmarkedFundsDocumentType,
  PredecessorItem._EarmarkedFundsDocument._EarmarkedFundsDocType._Text[1: Language = $session.system_language ].EarmarkedFundsDocTypeText AS EarmarkedFundsDocTypeText,
  PredecessorItem.EmrkdFndsDocItmCreatedByUser AS CreatedByUser,
  PredecessorItem.TransactionCurrency AS TransactionCurrency,
  PredecessorItem.EmrkdFndsAmountInCCCrcy AS EmrkdFndsAmountInCCCrcy,
  PredecessorItem.EmrkdFndsChgdAmtInCCCrcy AS EmrkdFndsChgdAmtInCCCrcy,
  PredecessorItem.EmrkdFndsAmountInTransCrcy AS EmrkdFndsAmountInTransCrcy,
  PredecessorItem.EmrkdFndsChgdAmtInTransCrcy AS EmrkdFndsChgdAmtInTransCrcy,
  PredecessorItem.EmrkdFndsOpenAmtInTransCrcy AS EmrkdFndsOpenAmtInTransCrcy,
  PredecessorItem.EmrkdFndsOpenAmtInCCCrcy AS EmrkdFndsOpenAmtInCCCrcy
FROM I_EarmarkedFundsDocumentItem AS OriginalItem
INNER JOIN I_EarmarkedFundsDocumentItem AS PredecessorItem ON /* join condition not captured in parsed metadata */
;

Learn More