P_SAFTSumJournalLineItem

DDL: P_SAFTSUMJOURNALLINEITEM SQL: PSAFTSUMJRNLITEM Type: view COMPOSITE
27 Fields 3 Data Sources

P_SAFTSumJournalLineItem is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_GLAccountInChartOfAccounts, I_JournalEntryItem, I_JournalEntryItem) and exposes 27 fields with key fields SourceLedger, CompanyCode, FiscalYear, AccountingDocument, Ledger.

Data Sources (3)

SourceAliasJoin Type
I_GLAccountInChartOfAccounts glItem inner
I_JournalEntryItem I_JournalEntryItem from
I_JournalEntryItem jItem union_all

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PSAFTSUMJRNLITEM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger SourceLedger Source Ledger
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY Ledger Ledger Ledger
PostingDate PostingDate Posting Date for GR
CompanyCodeCurrency CompanyCodeCurrency Local Currency
TotalGrossAmountInCoCodeCrcy
_SourceLedger _SourceLedger
_CompanyCode _CompanyCode
_FiscalYear _FiscalYear
_JournalEntry _JournalEntry
_Ledger _Ledger
SourceLedgerasSourceLedger
KEY CompanyCode I_JournalEntryItem CompanyCode Receiver Company Code
KEY FiscalYear I_JournalEntryItem FiscalYear G/L Fiscal Year
KEY AccountingDocument I_JournalEntryItem AccountingDocument Journal Entry
KEY Ledger I_JournalEntryItem Ledger Ledger
PostingDate I_JournalEntryItem PostingDate Posting Date for GR
CompanyCodeCurrency I_JournalEntryItem CompanyCodeCurrency Local Currency
TotalGrossAmountInCoCodeCrcy
_SourceLedger I_JournalEntryItem _SourceLedger
_CompanyCode I_JournalEntryItem _CompanyCode
_FiscalYear I_JournalEntryItem _FiscalYear
_JournalEntry I_JournalEntryItem _JournalEntry
_Ledger I_JournalEntryItem _Ledger
_CompanyCodeCurrency I_JournalEntryItem _CompanyCodeCurrency

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 P_SAFTSumJournalLineItem.
-- 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: PSAFTSUMJRNLITEM

CREATE VIEW P_SAFTSumJournalLineItem AS
SELECT
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  Ledger,
  PostingDate,
  CompanyCodeCurrency,
  sum(AmountInCompanyCodeCurrency) AS TotalGrossAmountInCoCodeCrcy,
  jItem._SourceLedger AS _SourceLedger,
  jItem._CompanyCode AS _CompanyCode,
  jItem._FiscalYear AS _FiscalYear,
  jItem._JournalEntry AS _JournalEntry,
  jItem._Ledger AS _Ledger,
  jItem._CompanyCodeCurrency AS _CompanyCodeCurrency
FROM I_JournalEntryItem
INNER JOIN I_GLAccountInChartOfAccounts AS glItem ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_JournalEntryItem
;

Learn More