P_PH_PRGroupTaxItem

DDL: P_PH_PRGROUPTAXITEM SQL: PPHPRGRPTAX Type: view COMPOSITE
31 Fields 3 Data Sources

P_PH_PRGroupTaxItem is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (P_TimeDepdntVersAssgmtNext, P_PH_PaymentReceiptTaxItem, P_PH_PaymentReceiptTaxItem) and exposes 31 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItemGroupingVersion, TransactionTypeDetermination.

Data Sources (3)

SourceAliasJoin Type
P_TimeDepdntVersAssgmtNext _version inner
P_PH_PaymentReceiptTaxItem TaxItem from
P_PH_PaymentReceiptTaxItem TaxItem union_all

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PPHPRGRPTAX view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.private true view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_PH_PaymentReceiptTaxItem CompanyCode Receiver Company Code
KEY AccountingDocument P_PH_PaymentReceiptTaxItem AccountingDocument Journal Entry
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
ZeroTaxBaseAmountInCoCodeCrcy
TaxBaseAmountInCoCodeCrcy
TaxAmountInCoCodeCrcy
AmountInTransactionCurrency
CompanyCode Receiver Company Code
KEY AccountingDocument P_PH_PaymentReceiptTaxItem AccountingDocument Journal Entry
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
ZeroTaxBaseAmountInCoCodeCrcy
TaxBaseAmountInCoCodeCrcy
TaxAmountInCoCodeCrcy
AmountInTransactionCurrency
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_PRGroupTaxItem.
-- 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: PPHPRGRPTAX

CREATE VIEW P_PH_PRGroupTaxItem AS
SELECT
  TaxItem.CompanyCode AS CompanyCode,
  TaxItem.AccountingDocument AS AccountingDocument,
  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,
  sum(TaxItem.ExemptTaxBaseAmtInCoCodeCrcy) AS ExemptTaxBaseAmtInCoCodeCrcy,
  sum(TaxItem.ZeroTaxBaseAmountInCoCodeCrcy) AS ZeroTaxBaseAmountInCoCodeCrcy,
  sum(TaxItem.TaxBaseAmountInCoCodeCrcy) AS TaxBaseAmountInCoCodeCrcy,
  sum(TaxItem.TaxAmountInCoCodeCrcy) AS TaxAmountInCoCodeCrcy,
  sum(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 ALL with additional select branch(es): P_PH_PaymentReceiptTaxItem
;

Learn More