What is P_EG_StRpTaxItemBox in SAP S/4HANA?

P_EG_StRpTaxItemBox is a composite CDS view in SAP S/4HANA. It contains 149 fields.

Which tables does P_EG_StRpTaxItemBox read from?

P_EG_StRpTaxItemBox reads data from: P_EG_StRpBillingItem, P_EG_StRpBillingItem, I_EG_StRpTaxItemGrouping, I_EG_StRpTaxItemGrouping, P_EG_StRpTaxItem and more.

What VDM layer is P_EG_StRpTaxItemBox?

P_EG_StRpTaxItemBox is classified as a Composite view that combines data from multiple basic views.

P_EG_StRpTaxItemBox

DDL: P_EG_STRPTAXITEMBOX SQL: PSRTAXITEMBOXEG Type: view COMPOSITE

149 Fields 6 Data Sources

P_EG_StRpTaxItemBox is a Composite CDS View in SAP S/4HANA. It reads from 6 data sources and exposes 149 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem, DebitCreditCode.

Data Sources (6)

Source	Alias	Join Type
P_EG_StRpBillingItem	_BillingDoc	left_outer
P_EG_StRpBillingItem	_BillingDoc	left_outer
I_EG_StRpTaxItemGrouping	I_EG_StRpTaxItemGrouping	inner
I_EG_StRpTaxItemGrouping	I_EG_StRpTaxItemGrouping	inner
P_EG_StRpTaxItem	P_EG_StRpTaxItem	from
P_EG_StRpTaxItem	P_EG_StRpTaxItem	union_all

Annotations (9)

Name	Value	Level
AbapCatalog.sqlViewName	PSRTAXITEMBOXEG	view
VDM.viewType	#COMPOSITE	view
VDM.private	true	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.dataClass	#MIXED	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view

Fields (149)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	P_EG_StRpTaxItem	CompanyCode	Receiver Company Code
KEY	AccountingDocument	P_EG_StRpTaxItem	AccountingDocument	Journal Entry
KEY	FiscalYear	P_EG_StRpTaxItem	FiscalYear	G/L Fiscal Year
KEY	TaxItem	P_EG_StRpTaxItem	TaxItem	Tax Item
KEY	DebitCreditCode	P_EG_StRpTaxItem	DebitCreditCode	Single-Character Flag
KEY	TaxBox	I_EG_StRpTaxItemGrouping	TaxBox	Tax.Bs.Gp.No.
KEY	TaxDeclnAmountType	I_EG_StRpTaxItemGrouping	TaxDeclnAmountType
KEY	TaxItemGroupingVersion	I_EG_StRpTaxItemGrouping	TaxItemGroupingVersion	Tax Grping Ver.
KEY	TransactionTypeDetermination	P_EG_StRpTaxItem	TransactionTypeDetermination	Transaction Key
KEY	SupplierAccountGroup	I_EG_StRpTaxItemGrouping	SupplierAccountGroup	Account group
	TaxCode	P_EG_StRpTaxItem	TaxCode	Tax Code
	TaxType	P_EG_StRpTaxItem	TaxType	Tax Type
	TaxRate			Tax Rate
	GLAccount
	TaxItemGroup	P_EG_StRpTaxItem	TaxItemGroup	Tax doc. item number
	BusinessPlace		BusinessPlace	Business place
	TaxJurisdiction		TaxJurisdiction	Tax Jurisdiction
	LowestLevelTaxJurisdiction		LowestLevelTaxJurisdiction	Jurisdict. Code
	AccountingDocumentType	P_EG_StRpTaxItem	AccountingDocumentType	Journal Entry Type
	ReferenceDocumentType		ReferenceDocumentType	Reference Document Type
	ReverseDocument		ReverseDocument	Reversed With
	ReverseDocumentFiscalYear		ReverseDocumentFiscalYear	Year
	DocumentReferenceID		DocumentReferenceID	Reference
	Ledger		Ledger	Ledger
	LedgerGroup		LedgerGroup	Ledger Group
	PostingDate		PostingDate	Posting Date for GR
	DocumentDate		DocumentDate	Journal Entry Date
	ReportingDate		ReportingDate
	TaxReportingDate		TaxReportingDate	Tax Reporting Date
	FiscalPeriod		FiscalPeriod	Tax period
	ExchangeRate		ExchangeRate	Exchange rate
	IsReversal		IsReversal	Reversal doc.
	IsReversed		IsReversed	Reversed?
	AccountingDocumentHeaderText		AccountingDocumentHeaderText	Doc.Header Text
	CompanyCodeCountry		CompanyCodeCountry	Reporting Ctry/Reg.
	ReportingCountry		ReportingCountry
	TaxReturnCountry	P_EG_StRpTaxItem	TaxReturnCountry	Reporting C/R
	CompanyCodeCurrency
	CountryCurrency		CountryCurrency	Currency
	DocumentCurrency
	ReportingCurrency		ReportingCurrency	Currency
	AdditionalCurrency1		AdditionalCurrency1	Local curr. 2
	AdditionalCurrency2		AdditionalCurrency2	Local curr. 3
	TaxAmountInRptgCrcy
	TaxBaseAmountInCoCodeCrcy
	TaxAmountInCoCodeCrcy
	TaxBaseAmountInTransCrcy
	TaxAmount
	TaxBaseAmountInCountryCrcy		TaxBaseAmountInCountryCrcy	Base Amount
	TaxAmountInCountryCrcy		TaxAmountInCountryCrcy	Tax Rept. Crcy
	TaxBaseAmtInAdditionalCrcy1		TaxBaseAmtInAdditionalCrcy1	LC 2 Base
	TaxBaseAmtInAdditionalCrcy2		TaxBaseAmtInAdditionalCrcy2	LC 3 Base
	TaxAmountInAdditionalCurrency1		TaxAmountInAdditionalCurrency1	LC 2 Tax
	TaxAmountInAdditionalCurrency2		TaxAmountInAdditionalCurrency2	LC 3 Tax
	TaxCalculationProcedure	P_EG_StRpTaxItem	TaxCalculationProcedure	Tax Procedure
	TargetTaxCode	P_EG_StRpTaxItem	TargetTaxCode
	TaxNumber1		TaxNumber1	VAT Reg. No.
	TaxNumber2		TaxNumber2	Tax Number 2
	BusinessPartner		BusinessPartner	Issuing Authority
	BusinessPartnerName		BusinessPartnerName	Extracted Customer Name
	CustomerSupplierAddress		CustomerSupplierAddress
	BillingDocumentItem	P_EG_StRpBillingItem	BillingDocumentItem	Item
	PricingDocument	P_EG_StRpBillingItem	PricingDocument	Document Condition
	PricingDocumentItem	P_EG_StRpBillingItem	PricingDocumentItem	Item
	PriceDetnExchangeRate	P_EG_StRpBillingItem	PriceDetnExchangeRate	Exchange Rate
	Material	P_EG_StRpBillingItem	Material	Vehicle Model
	MaterialName	P_EG_StRpBillingItem	MaterialName	Material Description
	BillingDocumentItemText	P_EG_StRpBillingItem	BillingDocumentItemText	Item Descr.
	BillingQuantityUnit	P_EG_StRpBillingItem	BillingQuantityUnit	Sales Unit
	BillingQuantity	P_EG_StRpBillingItem	BillingQuantity	Invoiced Qty
	BillingDocument	P_EG_StRpTaxItem	BillingDocument	SD Document
	AccountingDocumentNumberRange
	TaxCountry		TaxCountry	Tax Ctry/Reg.
	_ReportingCurrency	P_EG_StRpTaxItem	_ReportingCurrency
	CompanyCode			Receiver Company Code
KEY	AccountingDocument	P_EG_StRpTaxItem	AccountingDocument	Journal Entry
KEY	FiscalYear	P_EG_StRpTaxItem	FiscalYear	G/L Fiscal Year
KEY	TaxItem	P_EG_StRpTaxItem	TaxItem	Tax Item
KEY	DebitCreditCode	P_EG_StRpTaxItem	DebitCreditCode	Single-Character Flag
KEY	TaxBox	I_EG_StRpTaxItemGrouping	TaxBox	Tax.Bs.Gp.No.
KEY	TaxDeclnAmountType	I_EG_StRpTaxItemGrouping	TaxDeclnAmountType
KEY	TaxItemGroupingVersion	I_EG_StRpTaxItemGrouping	TaxItemGroupingVersion	Tax Grping Ver.
KEY	TransactionTypeDetermination	P_EG_StRpTaxItem	TransactionTypeDetermination	Transaction Key
KEY	SupplierAccountGroup	I_EG_StRpTaxItemGrouping	SupplierAccountGroup	Account group
	TaxCode	P_EG_StRpTaxItem	TaxCode	Tax Code
	TaxType	P_EG_StRpTaxItem	TaxType	Tax Type
	TaxRate			Tax Rate
	GLAccount
	TaxItemGroup	P_EG_StRpTaxItem	TaxItemGroup	Tax doc. item number
	BusinessPlace		BusinessPlace	Business place
	TaxJurisdiction		TaxJurisdiction	Tax Jurisdiction
	LowestLevelTaxJurisdiction		LowestLevelTaxJurisdiction	Jurisdict. Code
	AccountingDocumentType	P_EG_StRpTaxItem	AccountingDocumentType	Journal Entry Type
	ReferenceDocumentType		ReferenceDocumentType	Reference Document Type
	ReverseDocument		ReverseDocument	Reversed With
	ReverseDocumentFiscalYear		ReverseDocumentFiscalYear	Year
	DocumentReferenceID		DocumentReferenceID	Reference
	Ledger		Ledger	Ledger
	LedgerGroup		LedgerGroup	Ledger Group
	PostingDate		PostingDate	Posting Date for GR
	DocumentDate		DocumentDate	Journal Entry Date
	ReportingDate		ReportingDate
	TaxReportingDate		TaxReportingDate	Tax Reporting Date
	FiscalPeriod		FiscalPeriod	Tax period
	ExchangeRate		ExchangeRate	Exchange rate
	IsReversal		IsReversal	Reversal doc.
	IsReversed		IsReversed	Reversed?
	AccountingDocumentHeaderText		AccountingDocumentHeaderText	Doc.Header Text
	CompanyCodeCountry		CompanyCodeCountry	Reporting Ctry/Reg.
	ReportingCountry		ReportingCountry
	TaxReturnCountry	P_EG_StRpTaxItem	TaxReturnCountry	Reporting C/R
	CompanyCodeCurrency
	CountryCurrency		CountryCurrency	Currency
	DocumentCurrency
	ReportingCurrency		ReportingCurrency	Currency
	AdditionalCurrency1		AdditionalCurrency1	Local curr. 2
	AdditionalCurrency2		AdditionalCurrency2	Local curr. 3
	TaxAmountInRptgCrcy
	TaxBaseAmountInCoCodeCrcy
	TaxAmountInCoCodeCrcy
	TaxBaseAmountInTransCrcy
	TaxAmount
	TaxBaseAmountInCountryCrcy		TaxBaseAmountInCountryCrcy	Base Amount
	TaxAmountInCountryCrcy		TaxAmountInCountryCrcy	Tax Rept. Crcy
	TaxBaseAmtInAdditionalCrcy1		TaxBaseAmtInAdditionalCrcy1	LC 2 Base
	TaxBaseAmtInAdditionalCrcy2		TaxBaseAmtInAdditionalCrcy2	LC 3 Base
	TaxAmountInAdditionalCurrency1		TaxAmountInAdditionalCurrency1	LC 2 Tax
	TaxAmountInAdditionalCurrency2		TaxAmountInAdditionalCurrency2	LC 3 Tax
	TaxCalculationProcedure	P_EG_StRpTaxItem	TaxCalculationProcedure	Tax Procedure
	TargetTaxCode	P_EG_StRpTaxItem	TargetTaxCode
	TaxNumber1		TaxNumber1	VAT Reg. No.
	TaxNumber2		TaxNumber2	Tax Number 2
	BusinessPartner		BusinessPartner	Issuing Authority
	BusinessPartnerName		BusinessPartnerName	Extracted Customer Name
	CustomerSupplierAddress		CustomerSupplierAddress
	BillingDocumentItem	P_EG_StRpBillingItem	BillingDocumentItem	Item
	PricingDocument	P_EG_StRpBillingItem	PricingDocument	Document Condition
	PricingDocumentItem	P_EG_StRpBillingItem	PricingDocumentItem	Item
	PriceDetnExchangeRate	P_EG_StRpBillingItem	PriceDetnExchangeRate	Exchange Rate
	Material	P_EG_StRpBillingItem	Material	Vehicle Model
	MaterialName	P_EG_StRpBillingItem	MaterialName	Material Description
	BillingDocumentItemText	P_EG_StRpBillingItem	BillingDocumentItemText	Item Descr.
	BillingQuantityUnit	P_EG_StRpBillingItem	BillingQuantityUnit	Sales Unit
	BillingQuantity	P_EG_StRpBillingItem	BillingQuantity	Invoiced Qty
	BillingDocument	P_EG_StRpTaxItem	BillingDocument	SD Document
	AccountingDocumentNumberRange
	TaxCountry		TaxCountry	Tax Ctry/Reg.
	_ReportingCurrency	P_EG_StRpTaxItem	_ReportingCurrency
	_AccountingDocument	P_EG_StRpTaxItem	_AccountingDocument

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_EG_StRpTaxItemBox.
-- 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: PSRTAXITEMBOXEG

CREATE VIEW P_EG_StRpTaxItemBox AS
SELECT
  P_EG_StRpTaxItem.CompanyCode AS CompanyCode,
  P_EG_StRpTaxItem.AccountingDocument AS AccountingDocument,
  P_EG_StRpTaxItem.FiscalYear AS FiscalYear,
  P_EG_StRpTaxItem.TaxItem AS TaxItem,
  P_EG_StRpTaxItem.DebitCreditCode AS DebitCreditCode,
  I_EG_StRpTaxItemGrouping.TaxBox AS TaxBox,
  I_EG_StRpTaxItemGrouping.TaxDeclnAmountType AS TaxDeclnAmountType,
  I_EG_StRpTaxItemGrouping.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  P_EG_StRpTaxItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  I_EG_StRpTaxItemGrouping.SupplierAccountGroup AS SupplierAccountGroup,
  P_EG_StRpTaxItem.TaxCode AS TaxCode,
  P_EG_StRpTaxItem.TaxType AS TaxType,
  cast(cast(TaxRate as abap.dec(11,2)) as char13) AS TaxRate,
  coalesce( _BillingDoc.GLAccount, P_EG_StRpTaxItem.GLAccount) AS GLAccount,
  P_EG_StRpTaxItem.TaxItemGroup AS TaxItemGroup,
  BusinessPlace,
  TaxJurisdiction,
  LowestLevelTaxJurisdiction,
  P_EG_StRpTaxItem.AccountingDocumentType AS AccountingDocumentType,
  ReferenceDocumentType,
  ReverseDocument,
  ReverseDocumentFiscalYear,
  DocumentReferenceID,
  Ledger,
  LedgerGroup,
  PostingDate,
  DocumentDate,
  ReportingDate,
  TaxReportingDate,
  FiscalPeriod,
  ExchangeRate,
  IsReversal,
  IsReversed,
  AccountingDocumentHeaderText,
  CompanyCodeCountry,
  ReportingCountry,
  P_EG_StRpTaxItem.TaxReturnCountry AS TaxReturnCountry,
  coalesce( _BillingDoc.CompanyCodeCurrency, P_EG_StRpTaxItem.CompanyCodeCurrency) AS CompanyCodeCurrency,
  CountryCurrency,
  coalesce( _BillingDoc.DocumentCurrency, P_EG_StRpTaxItem.DocumentCurrency) AS DocumentCurrency,
  ReportingCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  coalesce( _BillingDoc.TaxAmountInRptgCrcy, P_EG_StRpTaxItem.TaxAmountInRptgCrcy) AS TaxAmountInRptgCrcy,
  coalesce( _BillingDoc.TaxBaseAmountInRptgCrcy, P_EG_StRpTaxItem.TaxBaseAmountInCoCodeCrcy) AS TaxBaseAmountInCoCodeCrcy,
  coalesce( _BillingDoc.TaxAmountInRptgCrcy, P_EG_StRpTaxItem.TaxAmountInCoCodeCrcy) AS TaxAmountInCoCodeCrcy,
  coalesce( _BillingDoc.TaxBaseAmountInTransCrcy, P_EG_StRpTaxItem.TaxBaseAmountInTransCrcy) AS TaxBaseAmountInTransCrcy,
  coalesce( _BillingDoc.TaxAmount, P_EG_StRpTaxItem.TaxAmount) AS TaxAmount,
  TaxBaseAmountInCountryCrcy,
  TaxAmountInCountryCrcy,
  TaxBaseAmtInAdditionalCrcy1,
  TaxBaseAmtInAdditionalCrcy2,
  TaxAmountInAdditionalCurrency1,
  TaxAmountInAdditionalCurrency2,
  P_EG_StRpTaxItem.TaxCalculationProcedure AS TaxCalculationProcedure,
  P_EG_StRpTaxItem.TargetTaxCode AS TargetTaxCode,
  TaxNumber1,
  TaxNumber2,
  BusinessPartner,
  BusinessPartnerName,
  CustomerSupplierAddress,
  _BillingDoc.BillingDocumentItem AS BillingDocumentItem,
  _BillingDoc.PricingDocument AS PricingDocument,
  _BillingDoc.PricingDocumentItem AS PricingDocumentItem,
  _BillingDoc.PriceDetnExchangeRate AS PriceDetnExchangeRate,
  _BillingDoc.Material AS Material,
  _BillingDoc.MaterialName AS MaterialName,
  _BillingDoc.BillingDocumentItemText AS BillingDocumentItemText,
  _BillingDoc.BillingQuantityUnit AS BillingQuantityUnit,
  _BillingDoc.BillingQuantity AS BillingQuantity,
  P_EG_StRpTaxItem.BillingDocument AS BillingDocument,
  _AccountingDocument._AccountingDocumentType.AccountingDocumentNumberRange AS AccountingDocumentNumberRange,
  TaxCountry,
  P_EG_StRpTaxItem._ReportingCurrency AS _ReportingCurrency,
  P_EG_StRpTaxItem._AccountingDocument AS _AccountingDocument
FROM P_EG_StRpTaxItem
INNER JOIN I_EG_StRpTaxItemGrouping ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_EG_StRpBillingItem AS _BillingDoc ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_EG_StRpTaxItem
;

Depth:

P_EG_StRpTaxItemBox view