C_EarmarkedFundsJournal

DDL: C_EARMARKEDFUNDSJOURNAL SQL: CEFACDOADOC Type: view CONSUMPTION
28 Fields 1 Data Sources 1 Associations

Auxiliary Consumption view for Obj. Page

C_EarmarkedFundsJournal is a Consumption CDS View that provides data about "Auxiliary Consumption view for Obj. Page" in SAP S/4HANA. It reads from 1 data source (C_JrnlEntrItmByLeadingLdgr_FM) and exposes 28 fields with key fields CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
C_JrnlEntrItmByLeadingLdgr_FM _Item from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_JournalEntry _Header $projection.CompanyCode = _Header.CompanyCode and $projection.FiscalYear = _Header.FiscalYear and $projection.AccountingDocument = _Header.AccountingDocument

Annotations (9)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CEFACDOADOC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Auxiliary Consumption view for Obj. Page view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode C_JrnlEntrItmByLeadingLdgr_FM CompanyCode Receiver Company Code
KEY FiscalYear C_JrnlEntrItmByLeadingLdgr_FM FiscalYear G/L Fiscal Year
KEY AccountingDocument C_JrnlEntrItmByLeadingLdgr_FM AccountingDocument Journal Entry
KEY LedgerGLLineItem C_JrnlEntrItmByLeadingLdgr_FM LedgerGLLineItem Journal Entry Item
IsLeadingLedger C_JrnlEntrItmByLeadingLdgr_FM IsLeadingLedger
AccountingDocumentType C_JrnlEntrItmByLeadingLdgr_FM AccountingDocumentType Journal Entry Type
AccountingDocumentTypeName C_JrnlEntrItmByLeadingLdgr_FM AccountingDocumentTypeName
ReferenceDocumentType _Header ReferenceDocumentType Reference Document Type
OriginalReferenceDocument _Header OriginalReferenceDocument Reference Key
PostingDate _Header PostingDate Posting Date for GR
AccountingDocCreatedByUser _Header AccountingDocCreatedByUser User which created overhead document
SourceLedger C_JrnlEntrItmByLeadingLdgr_FM SourceLedger Source Ledger
DebitCreditCode C_JrnlEntrItmByLeadingLdgr_FM DebitCreditCode Single-Character Flag
Fund C_JrnlEntrItmByLeadingLdgr_FM Fund Fund
GrantID C_JrnlEntrItmByLeadingLdgr_FM GrantID Grant
BudgetPeriod C_JrnlEntrItmByLeadingLdgr_FM BudgetPeriod Budget Period
FundsCenter C_JrnlEntrItmByLeadingLdgr_FM FundsCenter Funds Center
FundedProgram C_JrnlEntrItmByLeadingLdgr_FM FundedProgram Funded Program
FunctionalArea C_JrnlEntrItmByLeadingLdgr_FM FunctionalArea Functional Area
EarmarkedFundsDocument C_JrnlEntrItmByLeadingLdgr_FM EarmarkedFundsDocument Earmarked Funds
EarmarkedFundsDocumentItem C_JrnlEntrItmByLeadingLdgr_FM EarmarkedFundsDocumentItem Document Item
EarmarkedFundsDocumentCategory C_JrnlEntrItmByLeadingLdgr_FM EarmarkedFundsDocumentCategory Document Category
EarmarkedFundsDocCategoryText C_JrnlEntrItmByLeadingLdgr_FM EarmarkedFundsDocCategoryText Document Category
EmrkdFndsDocCategoryExtdText C_JrnlEntrItmByLeadingLdgr_FM EmrkdFndsDocCategoryExtdText
AmountInCompanyCodeCurrency
CompanyCodeCurrency C_JrnlEntrItmByLeadingLdgr_FM CompanyCodeCurrency Company Code Currency
TransactionCurrency C_JrnlEntrItmByLeadingLdgr_FM TransactionCurrency Transaction Currency
AmountInTransactionCurrency Amount Consumed (TC)

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_EarmarkedFundsJournal.
-- 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: CEFACDOADOC

CREATE VIEW C_EarmarkedFundsJournal AS
SELECT
  _Item.CompanyCode AS CompanyCode,
  _Item.FiscalYear AS FiscalYear,
  _Item.AccountingDocument AS AccountingDocument,
  _Item.LedgerGLLineItem AS LedgerGLLineItem,
  _Item.IsLeadingLedger AS IsLeadingLedger,
  _Item.AccountingDocumentType AS AccountingDocumentType,
  _Item.AccountingDocumentTypeName AS AccountingDocumentTypeName,
  _Header.ReferenceDocumentType AS ReferenceDocumentType,
  _Header.OriginalReferenceDocument AS OriginalReferenceDocument,
  _Header.PostingDate AS PostingDate,
  _Header.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  _Item.SourceLedger AS SourceLedger,
  _Item.DebitCreditCode AS DebitCreditCode,
  _Item.Fund AS Fund,
  _Item.GrantID AS GrantID,
  _Item.BudgetPeriod AS BudgetPeriod,
  _Item.FundsCenter AS FundsCenter,
  _Item.FundedProgram AS FundedProgram,
  _Item.FunctionalArea AS FunctionalArea,
  _Item.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  _Item.EarmarkedFundsDocumentItem AS EarmarkedFundsDocumentItem,
  _Item.EarmarkedFundsDocumentCategory AS EarmarkedFundsDocumentCategory,
  _Item.EarmarkedFundsDocCategoryText AS EarmarkedFundsDocCategoryText,
  _Item.EmrkdFndsDocCategoryExtdText AS EmrkdFndsDocCategoryExtdText,
  sum( _Item.AmountInCompanyCodeCurrency ) AS AmountInCompanyCodeCurrency,
  _Item.CompanyCodeCurrency AS CompanyCodeCurrency,
  _Item.TransactionCurrency AS TransactionCurrency,
  sum( _Item.AmountInTransactionCurrency ) AS AmountInTransactionCurrency
FROM C_JrnlEntrItmByLeadingLdgr_FM AS _Item
LEFT OUTER JOIN I_JournalEntry AS _Header ON CompanyCode = _Header.CompanyCode AND FiscalYear = _Header.FiscalYear AND AccountingDocument = _Header.AccountingDocument  -- association [1..1]
;

Learn More