P_PH_PaymentReceiptTaxItem

DDL: P_PH_PAYMENTRECEIPTTAXITEM SQL: PPHPRTAXITEM Type: view COMPOSITE Package: GLO_FIN_PAYMENT_RECEIPT
21 Fields 1 Data Sources

PH Payment Receipt Tax Items

P_PH_PaymentReceiptTaxItem is a Composite CDS View that provides data about "PH Payment Receipt Tax Items" in SAP S/4HANA. It reads from 1 data source (P_PH_StRpTaxItemBoxCube) and exposes 21 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem, TaxItemGroupingVersion. Part of development package GLO_FIN_PAYMENT_RECEIPT.

Data Sources (1)

SourceAliasJoin Type
P_PH_StRpTaxItemBoxCube TaxItem from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PPHPRTAXITEM 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 (21)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_PH_StRpTaxItemBoxCube CompanyCode Receiver Company Code
KEY AccountingDocument P_PH_StRpTaxItemBoxCube AccountingDocument Journal Entry
KEY FiscalYear P_PH_StRpTaxItemBoxCube FiscalYear G/L Fiscal Year
KEY TaxItem P_PH_StRpTaxItemBoxCube TaxItem Tax Item
KEY TaxItemGroupingVersion P_PH_StRpTaxItemBoxCube TaxItemGroupingVersion Tax Grping Ver.
KEY TransactionTypeDetermination P_PH_StRpTaxItemBoxCube TransactionTypeDetermination Transaction Key
KEY TaxCode P_PH_StRpTaxItemBoxCube TaxCode Tax Code
KEY TaxBox P_PH_StRpTaxItemBoxCube TaxBox Tax.Bs.Gp.No.
KEY TaxGroup P_PH_StRpTaxItemBoxCube TaxGroup Tax Group
PostingDate P_PH_StRpTaxItemBoxCube PostingDate Posting Date for GR
ReportingDate P_PH_StRpTaxItemBoxCube ReportingDate
DocumentDate P_PH_StRpTaxItemBoxCube DocumentDate Journal Entry Date
TaxReportingDate P_PH_StRpTaxItemBoxCube TaxReportingDate Tax Reporting Date
TaxRate P_PH_StRpTaxItemBoxCube TaxRate Tax Rate
GLAccount P_PH_StRpTaxItemBoxCube GLAccount General Ledger
BusinessPlace P_PH_StRpTaxItemBoxCube BusinessPlace Business place
Customer P_PH_StRpTaxItemBoxCube Customer Sold-to Party
Supplier P_PH_StRpTaxItemBoxCube Supplier Supplier
TaxAmountInCoCodeCrcy P_PH_StRpTaxItemBoxCube TaxAmountInRptgCrcy Tax Rept. Crcy
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
currency P_PH_StRpTaxItemBoxCube ReportingCurrency Currency

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_PaymentReceiptTaxItem.
-- 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: PPHPRTAXITEM

CREATE VIEW P_PH_PaymentReceiptTaxItem AS
SELECT
  TaxItem.CompanyCode AS CompanyCode,
  TaxItem.AccountingDocument AS AccountingDocument,
  TaxItem.FiscalYear AS FiscalYear,
  TaxItem.TaxItem AS TaxItem,
  TaxItem.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  TaxItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  TaxItem.TaxCode AS TaxCode,
  TaxItem.TaxBox AS TaxBox,
  TaxItem.TaxGroup AS TaxGroup,
  TaxItem.PostingDate AS PostingDate,
  TaxItem.ReportingDate AS ReportingDate,
  TaxItem.DocumentDate AS DocumentDate,
  TaxItem.TaxReportingDate AS TaxReportingDate,
  TaxItem.TaxRate AS TaxRate,
  TaxItem.GLAccount AS GLAccount,
  TaxItem.BusinessPlace AS BusinessPlace,
  TaxItem.Customer AS Customer,
  TaxItem.Supplier AS Supplier,
  TaxItem.TaxAmountInRptgCrcy AS TaxAmountInCoCodeCrcy,
  AmountInTransactionCurrency,
  TaxItem.ReportingCurrency AS currency
FROM P_PH_StRpTaxItemBoxCube AS TaxItem
;

Learn More