P_JournalEntryItemBrowser

DDL: P_JOURNALENTRYITEMBROWSER SQL: PFIJELITBROWS Type: view CONSUMPTION
18 Fields 1 Data Sources 1 Associations

Accounting Journal Entry Item Cube

P_JournalEntryItemBrowser is a Consumption CDS View that provides data about "Accounting Journal Entry Item Cube" in SAP S/4HANA. It reads from 1 data source (I_JournalEntryItemCube) and exposes 18 fields with key fields SourceLedger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_JournalEntryItemCube I_JournalEntryItemCube from

Parameters (1)

NameTypeDefault
P_ClearingStatusSelection fis_clearingstatusselection

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_JournalEntryItem _Extension $projection.SourceLedger = _Extension.SourceLedger and $projection.CompanyCode = _Extension.CompanyCode and $projection.FiscalYear = _Extension.FiscalYear and $projection.AccountingDocument = _Extension.AccountingDocument and $projection.LedgerGLLineItem = _Extension.LedgerGLLineItem

Annotations (11)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName PFIJELITBROWS view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Accounting Journal Entry Item Cube view
ObjectModel.representativeKey LedgerGLLineItem view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
Metadata.ignorePropagatedAnnotations true view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger SourceLedger Source Ledger
KEY CompanyCode I_JournalEntryItemCube CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
KEY Ledger I_JournalEntryItemCube Ledger Ledger
ChartOfAccounts ChartOfAccounts Node Class
GLAccount GLAccount General Ledger
GLAccountName GLAccountName Short Text
GLAccountLongName GLAccountLongName Long Text
ReferencePurchaseOrderCategory ReferencePurchaseOrderCategory
ClearingStatusSelection
_SourceLedger _SourceLedger
_CompanyCode _CompanyCode
_FiscalYear _FiscalYear
_JournalEntry _JournalEntry
_Ledger _Ledger
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts

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_JournalEntryItemBrowser.
-- 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: PFIJELITBROWS
-- Parameters: P_ClearingStatusSelection : fis_clearingstatusselection

CREATE VIEW P_JournalEntryItemBrowser AS
SELECT
  SourceLedger,
  I_JournalEntryItemCube.CompanyCode AS CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  I_JournalEntryItemCube.Ledger AS Ledger,
  ChartOfAccounts,
  GLAccount,
  GLAccountName,
  GLAccountLongName,
  ReferencePurchaseOrderCategory,
  cast($parameters.P_ClearingStatusSelection as fis_clearingstatusselection preserving type ) AS ClearingStatusSelection
FROM I_JournalEntryItemCube
LEFT OUTER JOIN E_JournalEntryItem AS _Extension ON SourceLedger = _Extension.SourceLedger AND CompanyCode = _Extension.CompanyCode AND FiscalYear = _Extension.FiscalYear AND AccountingDocument = _Extension.AccountingDocument AND LedgerGLLineItem = _Extension.LedgerGLLineItem  -- association [1..1]
;

Learn More