What is P_PH_PRTaxItemNew in SAP S/4HANA?

P_PH_PRTaxItemNew is a composite CDS view in SAP S/4HANA. Payment Receipt tax item It contains 33 fields.

What VDM layer is P_PH_PRTaxItemNew?

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

P_PH_PRTaxItemNew

Q: Which tables does P_PH_PRTaxItemNew read from?

P_PH_PRTaxItemNew reads data from: P_TimeDepdntVersAssgmtNext, P_PH_PaymentReceiptTaxItem, P_PH_PaymentReceiptTaxItem.

DDL: P_PH_PRTAXITEMNEW SQL: PPHPRTAXITMN Type: view COMPOSITE Package: GLO_FIN_PAYMENT_RECEIPT

33 Fields 3 Data Sources

Payment Receipt tax item

P_PH_PRTaxItemNew is a Composite CDS View that provides data about "Payment Receipt tax item" in SAP S/4HANA. It reads from 3 data sources (P_TimeDepdntVersAssgmtNext, P_PH_PaymentReceiptTaxItem, P_PH_PaymentReceiptTaxItem) and exposes 33 fields with key fields CompanyCode, AccountingDocument, TaxItem, FiscalYear, TaxItemGroupingVersion. Part of development package GLO_FIN_PAYMENT_RECEIPT.

Data Sources (3)

Source	Alias	Join Type
P_TimeDepdntVersAssgmtNext	_version	inner
P_PH_PaymentReceiptTaxItem	TaxItem	from
P_PH_PaymentReceiptTaxItem	TaxItem	union

Annotations (6)

Name	Value	Level
AbapCatalog.sqlViewName	PPHPRTAXITMN	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
VDM.viewType	#COMPOSITE	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.compiler.compareFilter	true	view
VDM.private	true	view

Fields (33)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	P_PH_PaymentReceiptTaxItem	CompanyCode	Receiver Company Code
KEY	AccountingDocument	P_PH_PaymentReceiptTaxItem	AccountingDocument	Journal Entry
KEY	TaxItem	P_PH_PaymentReceiptTaxItem	TaxItem	Tax Item
KEY	FiscalYear	P_PH_PaymentReceiptTaxItem	FiscalYear	G/L Fiscal Year
KEY	TaxItemGroupingVersion	P_PH_PaymentReceiptTaxItem	TaxItemGroupingVersion	Tax Grping Ver.
KEY	TransactionTypeDetermination	P_PH_PaymentReceiptTaxItem	TransactionTypeDetermination	Transaction Key
KEY	TaxCode	P_PH_PaymentReceiptTaxItem	TaxCode	Tax Code
KEY	TaxBox	P_PH_PaymentReceiptTaxItem	TaxBox	Tax.Bs.Gp.No.
KEY	TaxGroup	P_PH_PaymentReceiptTaxItem	TaxGroup	Tax Group
	Customer	P_PH_PaymentReceiptTaxItem	Customer	Sold-to Party
	Supplier	P_PH_PaymentReceiptTaxItem	Supplier	Supplier
	ExemptTaxBaseAmtInCoCodeCrcy	P_PH_PaymentReceiptTaxItem	ExemptTaxBaseAmtInCoCodeCrcy
	ZeroTaxBaseAmountInCoCodeCrcy	P_PH_PaymentReceiptTaxItem	ZeroTaxBaseAmountInCoCodeCrcy
	TaxBaseAmountInCoCodeCrcy	P_PH_PaymentReceiptTaxItem	TaxBaseAmountInCoCodeCrcy	TxBaseAmt CoCodeCrcy
	TaxAmountInCoCodeCrcy	P_PH_PaymentReceiptTaxItem	TaxAmountInCoCodeCrcy	Tax Amount in Company Code Currency
	AmountInTransactionCurrency	P_PH_PaymentReceiptTaxItem	AmountInTransactionCurrency	Pt Crcy Amt
	CompanyCode			Receiver Company Code
KEY	AccountingDocument	P_PH_PaymentReceiptTaxItem	AccountingDocument	Journal Entry
KEY	TaxItem	P_PH_PaymentReceiptTaxItem	TaxItem	Tax Item
KEY	FiscalYear	P_PH_PaymentReceiptTaxItem	FiscalYear	G/L Fiscal Year
KEY	TaxItemGroupingVersion	P_PH_PaymentReceiptTaxItem	TaxItemGroupingVersion	Tax Grping Ver.
KEY	TransactionTypeDetermination	P_PH_PaymentReceiptTaxItem	TransactionTypeDetermination	Transaction Key
KEY	TaxCode	P_PH_PaymentReceiptTaxItem	TaxCode	Tax Code
KEY	TaxBox	P_PH_PaymentReceiptTaxItem	TaxBox	Tax.Bs.Gp.No.
KEY	TaxGroup	P_PH_PaymentReceiptTaxItem	TaxGroup	Tax Group
	Customer	P_PH_PaymentReceiptTaxItem	Customer	Sold-to Party
	Supplier	P_PH_PaymentReceiptTaxItem	Supplier	Supplier
	ExemptTaxBaseAmtInCoCodeCrcy	P_PH_PaymentReceiptTaxItem	ExemptTaxBaseAmtInCoCodeCrcy
	ZeroTaxBaseAmountInCoCodeCrcy	P_PH_PaymentReceiptTaxItem	ZeroTaxBaseAmountInCoCodeCrcy
	TaxBaseAmountInCoCodeCrcy	P_PH_PaymentReceiptTaxItem	TaxBaseAmountInCoCodeCrcy	TxBaseAmt CoCodeCrcy
	TaxAmountInCoCodeCrcy	P_PH_PaymentReceiptTaxItem	TaxAmountInCoCodeCrcy	Tax Amount in Company Code Currency
	AmountInTransactionCurrency	P_PH_PaymentReceiptTaxItem	AmountInTransactionCurrency	Pt Crcy Amt
	currency	P_PH_PaymentReceiptTaxItem	currency	Valuation Crcy

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_PH_PRTaxItemNew.
-- 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: PPHPRTAXITMN

CREATE VIEW P_PH_PRTaxItemNew AS
SELECT
  TaxItem.CompanyCode AS CompanyCode,
  TaxItem.AccountingDocument AS AccountingDocument,
  TaxItem.TaxItem AS TaxItem,
  TaxItem.FiscalYear AS FiscalYear,
  TaxItem.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  TaxItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  TaxItem.TaxCode AS TaxCode,
  TaxItem.TaxBox AS TaxBox,
  TaxItem.TaxGroup AS TaxGroup,
  TaxItem.Customer AS Customer,
  TaxItem.Supplier AS Supplier,
  TaxItem.ExemptTaxBaseAmtInCoCodeCrcy AS ExemptTaxBaseAmtInCoCodeCrcy,
  TaxItem.ZeroTaxBaseAmountInCoCodeCrcy AS ZeroTaxBaseAmountInCoCodeCrcy,
  TaxItem.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  TaxItem.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  TaxItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  TaxItem.currency AS currency
FROM P_PH_PaymentReceiptTaxItem AS TaxItem
INNER JOIN P_TimeDepdntVersAssgmtNext AS _version ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): P_PH_PaymentReceiptTaxItem
;

Depth:

P_PH_PRTaxItemNew view