Which tables does P_RevnRecgnJournalEntryItem read from?

P_RevnRecgnJournalEntryItem reads data from: I_GLAccountLineItem.

What VDM layer is P_RevnRecgnJournalEntryItem?

P_RevnRecgnJournalEntryItem is classified as a Consumption view optimized for specific business scenarios and reporting.

P_RevnRecgnJournalEntryItem

Q: What is P_RevnRecgnJournalEntryItem in SAP S/4HANA?

P_RevnRecgnJournalEntryItem is a consumption CDS view in SAP S/4HANA. It contains 51 fields.

DDL: P_REVNRECGNJOURNALENTRYITEM SQL: PIRRJRNENTRITEM Type: view CONSUMPTION

51 Fields 1 Data Sources 3 Associations

P_RevnRecgnJournalEntryItem is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_GLAccountLineItem) and exposes 51 fields with key fields Ledger, SourceLedger, CompanyCode, FiscalYear, AccountingDocument. It has 3 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_GLAccountLineItem	I_GLAccountLineItem	from

Parameters (1)

Name	Type	Default
P_Language	sylangu

Associations (3)

Cardinality	Target	Alias	Condition
[1..1]	I_GLAccountLineItem	_GLAccountLineItem	`$projection.Ledger = _GLAccountLineItem.Ledger and $projection.SourceLedger = _GLAccountLineItem.SourceLedger and $projection.CompanyCode = _GLAccountLineItem.CompanyCode and $projection.FiscalYear = _GLAccountLineItem.FiscalYear and $projection.AccountingDocument = _GLAccountLineItem.AccountingDocument and $projection.LedgerGLLineItem = _GLAccountLineItem.LedgerGLLineItem`
[0..1]	I_ProfitCenterText	_ProfitCenterText	`$projection.ControllingArea = _ProfitCenterText.ControllingArea and $projection.ProfitCenter = _ProfitCenterText.ProfitCenter and $projection.PostingDate >= _ProfitCenterText.ValidityStartDate and $projection.PostingDate <= _ProfitCenterText.ValidityEndDate`
[0..1]	I_CostCenterText	_CostCenterText	`$projection.ControllingArea = _CostCenterText.ControllingArea and $projection.CostCenter = _CostCenterText.CostCenter and $projection.PostingDate >= _CostCenterText.ValidityStartDate and $projection.PostingDate <= _CostCenterText.ValidityEndDate`

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	PIRRJRNENTRITEM	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
VDM.private	true	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.serviceQuality	#C	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view

Fields (51)

Key	Field	Source Table	Source Field	Description
KEY	Ledger		Ledger	Ledger
KEY	SourceLedger		SourceLedger	Source Ledger
KEY	CompanyCode		CompanyCode	Receiver Company Code
KEY	FiscalYear		FiscalYear	G/L Fiscal Year
KEY	AccountingDocument		AccountingDocument	Journal Entry
KEY	LedgerGLLineItem		LedgerGLLineItem	Journal Entry Item
	ReferenceDocument		ReferenceDocument	Reference Document
	BusinessTransactionType		BusinessTransactionType	Bus.transaction
	FiscalPeriod		FiscalPeriod	Tax period
	FiscalYearPeriod		FiscalYearPeriod	Period/Year
	GLAccount		GLAccount	General Ledger
	GLAccountType		GLAccountType	G/L Account Type
	DebitCreditCode		DebitCreditCode	Single-Character Flag
	ChartOfAccounts		ChartOfAccounts	Node Class
	Project		Project	WBS Element
	ProjectInternalID		ProjectInternalID	Project Def.
	WBSElement		WBSElement	WBS Internal ID
	WBSElementInternalID		WBSElementInternalID	WBS Internal ID
	SalesOrder		SalesOrder	SD Document
	SalesOrderItem		SalesOrderItem	Sales Order Item
	BalanceTransactionCurrency		BalanceTransactionCurrency	Currency
	AmountInBalanceTransacCrcy		AmountInBalanceTransacCrcy	Amount in Balance Transaction Currency
	TransactionCurrency		TransactionCurrency	Transaction Currency
	AmountInTransactionCurrency		AmountInTransactionCurrency	Pt Crcy Amt
	CompanyCodeCurrency		CompanyCodeCurrency	Local Currency
	AmountInCompanyCodeCurrency		AmountInCompanyCodeCurrency	Local Crcy Amt
	GlobalCurrency		GlobalCurrency	GM Billing Element: Global Currency
	AmountInGlobalCurrency		AmountInGlobalCurrency	Amount in Global Currency
	ProfitCenter		ProfitCenter	Profit Center
	ProfitCenterName
	OriginProfitCenter		OriginProfitCenter
	CostCenter		CostCenter	Cost Center
	CostCenterName
	CostCtrActivityType		CostCtrActivityType	Activity Type
	CompanyCodeName	_CompanyCodeText	CompanyCodeName	Company Name
	AccountingDocCreatedByUser		AccountingDocCreatedByUser	User which created overhead document
	AccountingDocumentType		AccountingDocumentType	Journal Entry Type
	DocumentDate		DocumentDate	Journal Entry Date
	PostingDate		PostingDate	Posting Date for GR
	CreationDateTime		CreationDateTime	Timestamp
	AccountingDocumentCategory		AccountingDocumentCategory	Journal Entry Category
	GLAccountName
	PartnerWBSElementInternalID		PartnerWBSElementInternalID	Partner WBS Element Internal ID
	ControllingArea		ControllingArea	Controlling Area
	_Ledger		_Ledger
	_SourceLedger		_SourceLedger
	_CompanyCode		_CompanyCode
	_FiscalYear		_FiscalYear
	_JournalEntry		_JournalEntry
	_GLAccountInChartOfAccounts		_GLAccountInChartOfAccounts
	_GLAccountLineItem		_GLAccountLineItem

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_RevnRecgnJournalEntryItem.
-- 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: PIRRJRNENTRITEM
-- Parameters: P_Language : sylangu

CREATE VIEW P_RevnRecgnJournalEntryItem AS
SELECT
  Ledger,
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  ReferenceDocument,
  BusinessTransactionType,
  FiscalPeriod,
  FiscalYearPeriod,
  GLAccount,
  GLAccountType,
  DebitCreditCode,
  ChartOfAccounts,
  Project,
  ProjectInternalID,
  WBSElement,
  WBSElementInternalID,
  SalesOrder,
  SalesOrderItem,
  BalanceTransactionCurrency,
  AmountInBalanceTransacCrcy,
  TransactionCurrency,
  AmountInTransactionCurrency,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  GlobalCurrency,
  AmountInGlobalCurrency,
  ProfitCenter,
  _ProfitCenterText[1:Language = :P_Language ].ProfitCenterName AS ProfitCenterName,
  OriginProfitCenter,
  CostCenter,
  _CostCenterText[1:Language = :P_Language ].CostCenterName AS CostCenterName,
  CostCtrActivityType,
  _CompanyCodeText.CompanyCodeName AS CompanyCodeName,
  AccountingDocCreatedByUser,
  AccountingDocumentType,
  DocumentDate,
  PostingDate,
  CreationDateTime,
  AccountingDocumentCategory,
  _GLAcctInChartOfAccountsText[1:Language = :P_Language ].GLAccountName AS GLAccountName,
  PartnerWBSElementInternalID,
  ControllingArea
FROM I_GLAccountLineItem
LEFT OUTER JOIN I_GLAccountLineItem AS _GLAccountLineItem ON Ledger = _GLAccountLineItem.Ledger AND SourceLedger = _GLAccountLineItem.SourceLedger AND CompanyCode = _GLAccountLineItem.CompanyCode AND FiscalYear = _GLAccountLineItem.FiscalYear AND AccountingDocument = _GLAccountLineItem.AccountingDocument AND LedgerGLLineItem = _GLAccountLineItem.LedgerGLLineItem  -- association [1..1]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON ControllingArea = _ProfitCenterText.ControllingArea AND ProfitCenter = _ProfitCenterText.ProfitCenter AND PostingDate >= _ProfitCenterText.ValidityStartDate AND PostingDate <= _ProfitCenterText.ValidityEndDate  -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON ControllingArea = _CostCenterText.ControllingArea AND CostCenter = _CostCenterText.CostCenter AND PostingDate >= _CostCenterText.ValidityStartDate AND PostingDate <= _CostCenterText.ValidityEndDate  -- association [0..1]
;

Depth:

P_RevnRecgnJournalEntryItem view

I_GLAccountLineItem view_entity