What is P_RO_SAFTJournalEntryItemExc in SAP S/4HANA?

P_RO_SAFTJournalEntryItemExc is a consumption CDS view in SAP S/4HANA. Acdoca Exclude 8/9 GL accounts It contains 67 fields.

Which tables does P_RO_SAFTJournalEntryItemExc read from?

P_RO_SAFTJournalEntryItemExc reads data from: I_RO_SAFTAccountMapping, P_RO_SAFTJournalEntryItemBase.

What VDM layer is P_RO_SAFTJournalEntryItemExc?

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

P_RO_SAFTJournalEntryItemExc

DDL: P_RO_SAFTJOURNALENTRYITEMEXC SQL: PROSAFTJRNENITME Type: view CONSUMPTION

67 Fields 2 Data Sources

Acdoca Exclude 8/9 GL accounts

P_RO_SAFTJournalEntryItemExc is a Consumption CDS View that provides data about "Acdoca Exclude 8/9 GL accounts" in SAP S/4HANA. It reads from 2 data sources (I_RO_SAFTAccountMapping, P_RO_SAFTJournalEntryItemBase) and exposes 67 fields with key fields SourceLedger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem.

Data Sources (2)

Source	Alias	Join Type
I_RO_SAFTAccountMapping	Account	inner
P_RO_SAFTJournalEntryItemBase	P_RO_SAFTJournalEntryItemBase	from

Parameters (1)

Name	Type	Default
P_AlternativeGLAccountIsUsed	saft_ro_alt_gl_account_flag

Annotations (12)

Name	Value	Level
AbapCatalog.sqlViewName	PROSAFTJRNENITME	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
VDM.viewType	#CONSUMPTION	view
VDM.private	true	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AccessControl.personalData.blocking	#BLOCKED_DATA_INCLUDED	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
EndUserText.label	Acdoca Exclude 8/9 GL accounts	view

Fields (67)

Key	Field	Source Table	Source Field	Description
KEY	SourceLedger	Item	SourceLedger	Source Ledger
KEY	CompanyCode	Item	CompanyCode	Receiver Company Code
KEY	FiscalYear	Item	FiscalYear	G/L Fiscal Year
KEY	AccountingDocument	Item	AccountingDocument	Journal Entry
KEY	LedgerGLLineItem	Item	LedgerGLLineItem	Journal Entry Item
KEY	Ledger	Item	Ledger	Ledger
	AccountingDocumentCategory	Item	AccountingDocumentCategory	Journal Entry Category
	AccountingDocumentItem	Item	AccountingDocumentItem	Posting View Item
	FinancialAccountType	Item	FinancialAccountType	Fin. Account Type
	Customer	Item	Customer	Sold-to Party
	Supplier	Item	Supplier	Supplier
	DebitCreditCode	Item	DebitCreditCode	Single-Character Flag
	Product	Item	Product	Product Sold
	Plant	Item	Plant	Valuation Area
	TaxCode	Item	TaxCode	Tax Code
	TaxCountry	Item	TaxCountry	Tax Ctry/Reg.
	ChartOfAccounts	Item	ChartOfAccounts	Node Class
	ActiveChartOfAccounts	Item	ActiveChartOfAccounts
	GLAccount	Item	GLAccount	General Ledger
	ActiveGLAccount	Item	ActiveGLAccount
	GLAccountType	Item	GLAccountType	G/L Account Type
	CountryChartOfAccounts	Item	CountryChartOfAccounts	Chart of Accts
	AlternativeGLAccount	Item	AlternativeGLAccount	Group Account
	PostingDate	Item	PostingDate	Posting Date for GR
	DocumentDate	Item	DocumentDate	Journal Entry Date
	AccountingDocumentCreationDate
	AccountingDocCreatedByUser
	AccountingDocumentType	Item	AccountingDocumentType	Journal Entry Type
	ValueDate	Item	ValueDate	Value Date
	DocumentItemText	Item	DocumentItemText	Text
	BaseUnit	Item	BaseUnit	Unit of Measure
	ControllingArea	Item	ControllingArea	Controlling Area
	ProfitCenter	Item	ProfitCenter	Profit Center
	_ProfitCenterTxt	Item	_ProfitCenterTxt
	Segment	Item	Segment	Segment number
	_SegmentText	Item	_SegmentText
	CostCenter	Item	CostCenter	Cost Center
	_CostCenterTxt	Item	_CostCenterTxt
	OrderID	Item	OrderID	Order ID
	_Order	Item	_Order
	WBSElement	Item	WBSElement	WBS Internal ID
	WBSElementInternalID	Item	WBSElementInternalID	WBS Internal ID
	_WBSElementBasicDataText	Item	_WBSElementBasicDataText
	TransactionTypeDetermination	Item	TransactionTypeDetermination	Transaction Key
	_AccountingDocumentTypeText	Item	_AccountingDocumentTypeText
	_Customer	Item	_Customer
	_Supplier	Item	_Supplier
	AmountInCompanyCodeCurrency	Item	AmountInCompanyCodeCurrency	Local Crcy Amt
	CompanyCodeCurrency	Item	CompanyCodeCurrency	Local Currency
	AmountInTransactionCurrency	Item	AmountInTransactionCurrency	Pt Crcy Amt
	TransactionCurrency	Item	TransactionCurrency	Transaction Currency
	LogicalSystem	Item	LogicalSystem	Logical System
	Quantity	Item	Quantity	Value
	ReferenceQuantity	Item	ReferenceQuantity	Comm Refer Quantity
	ReferenceQuantityUnit	Item	ReferenceQuantityUnit
	SpecialGLCode	Item	SpecialGLCode	Special G/L Ind
	DebitAmountInCoCodeCrcy	Item	DebitAmountInCoCodeCrcy	Debit Amount in Company Code Currency
	CreditAmountInCoCodeCrcy	Item	CreditAmountInCoCodeCrcy	Credit Amount in Company Code Currency
	_JournalEntry	Item	_JournalEntry
	ReferenceDocument	Item	ReferenceDocument	Reference Document
	ReferenceDocumentContext	Item	ReferenceDocumentContext	Reference Document Context
	ReferenceDocumentItem	Item	ReferenceDocumentItem	Reference item
	ReferenceDocumentItemGroup	Item	ReferenceDocumentItemGroup	Reference Document Item Group
	ReferenceDocumentType	Item	ReferenceDocumentType	Reference Document Type
	BillingDocumentType	Item	BillingDocumentType	Billing Type
	RO_SAFTStandardAccount	I_RO_SAFTAccountMapping	RO_SAFTStandardAccount	St. Account ID
	RO_SAFTIsDefaultZeroQuantity	I_RO_SAFTAccountMapping	RO_SAFTIsDefaultZeroQuantity	Def Zero Quantity

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_RO_SAFTJournalEntryItemExc.
-- 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: PROSAFTJRNENITME
-- Parameters: P_AlternativeGLAccountIsUsed : saft_ro_alt_gl_account_flag

CREATE VIEW P_RO_SAFTJournalEntryItemExc AS
SELECT
  Item.SourceLedger AS SourceLedger,
  Item.CompanyCode AS CompanyCode,
  Item.FiscalYear AS FiscalYear,
  Item.AccountingDocument AS AccountingDocument,
  Item.LedgerGLLineItem AS LedgerGLLineItem,
  Item.Ledger AS Ledger,
  Item.AccountingDocumentCategory AS AccountingDocumentCategory,
  Item.AccountingDocumentItem AS AccountingDocumentItem,
  Item.FinancialAccountType AS FinancialAccountType,
  Item.Customer AS Customer,
  Item.Supplier AS Supplier,
  Item.DebitCreditCode AS DebitCreditCode,
  Item.Product AS Product,
  Item.Plant AS Plant,
  Item.TaxCode AS TaxCode,
  Item.TaxCountry AS TaxCountry,
  Item.ChartOfAccounts AS ChartOfAccounts,
  Item.ActiveChartOfAccounts AS ActiveChartOfAccounts,
  Item.GLAccount AS GLAccount,
  Item.ActiveGLAccount AS ActiveGLAccount,
  Item.GLAccountType AS GLAccountType,
  Item.CountryChartOfAccounts AS CountryChartOfAccounts,
  Item.AlternativeGLAccount AS AlternativeGLAccount,
  Item.PostingDate AS PostingDate,
  Item.DocumentDate AS DocumentDate,
  Item._JournalEntry.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  Item._JournalEntry.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  Item.AccountingDocumentType AS AccountingDocumentType,
  Item.ValueDate AS ValueDate,
  Item.DocumentItemText AS DocumentItemText,
  Item.BaseUnit AS BaseUnit,
  Item.ControllingArea AS ControllingArea,
  Item.ProfitCenter AS ProfitCenter,
  Item._ProfitCenterTxt AS _ProfitCenterTxt,
  Item.Segment AS Segment,
  Item._SegmentText AS _SegmentText,
  Item.CostCenter AS CostCenter,
  Item._CostCenterTxt AS _CostCenterTxt,
  Item.OrderID AS OrderID,
  Item._Order AS _Order,
  Item.WBSElement AS WBSElement,
  Item.WBSElementInternalID AS WBSElementInternalID,
  Item._WBSElementBasicDataText AS _WBSElementBasicDataText,
  Item.TransactionTypeDetermination AS TransactionTypeDetermination,
  Item._AccountingDocumentTypeText AS _AccountingDocumentTypeText,
  Item._Customer AS _Customer,
  Item._Supplier AS _Supplier,
  Item.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  Item.CompanyCodeCurrency AS CompanyCodeCurrency,
  Item.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  Item.TransactionCurrency AS TransactionCurrency,
  Item.LogicalSystem AS LogicalSystem,
  Item.Quantity AS Quantity,
  Item.ReferenceQuantity AS ReferenceQuantity,
  Item.ReferenceQuantityUnit AS ReferenceQuantityUnit,
  Item.SpecialGLCode AS SpecialGLCode,
  Item.DebitAmountInCoCodeCrcy AS DebitAmountInCoCodeCrcy,
  Item.CreditAmountInCoCodeCrcy AS CreditAmountInCoCodeCrcy,
  Item._JournalEntry AS _JournalEntry,
  Item.ReferenceDocument AS ReferenceDocument,
  Item.ReferenceDocumentContext AS ReferenceDocumentContext,
  Item.ReferenceDocumentItem AS ReferenceDocumentItem,
  Item.ReferenceDocumentItemGroup AS ReferenceDocumentItemGroup,
  Item.ReferenceDocumentType AS ReferenceDocumentType,
  Item.BillingDocumentType AS BillingDocumentType,
  Account.RO_SAFTStandardAccount AS RO_SAFTStandardAccount,
  Account.RO_SAFTIsDefaultZeroQuantity AS RO_SAFTIsDefaultZeroQuantity
FROM P_RO_SAFTJournalEntryItemBase
INNER JOIN I_RO_SAFTAccountMapping AS Account ON /* join condition not captured in parsed metadata */
;

Depth:

P_RO_SAFTJournalEntryItemExc view

P_RO_SAFTJournalEntryItemBase view
I_RO_SAFTAccountMapping view