P_PH_StRpTaxItemBoxCube

DDL: P_PH_STRPTAXITEMBOXCUBE SQL: PPHSRTAXITEMBOX Type: view COMPOSITE
21 Fields 1 Data Sources

P_PH_StRpTaxItemBoxCube is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_StRpTaxItem) and exposes 21 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem, TaxItemGroupingVersion.

Data Sources (1)

SourceAliasJoin Type
I_StRpTaxItem TaxData from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PPHSRTAXITEMBOX 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 I_StRpTaxItem CompanyCode Receiver Company Code
KEY AccountingDocument I_StRpTaxItem AccountingDocument Journal Entry
KEY FiscalYear I_StRpTaxItem FiscalYear G/L Fiscal Year
KEY TaxItem I_StRpTaxItem TaxItem Tax Item
KEY TaxItemGroupingVersion BoxConfig TaxItemGroupingVersion Tax Grping Ver.
KEY TransactionTypeDetermination I_StRpTaxItem TransactionTypeDetermination Transaction Key
KEY TaxCode I_StRpTaxItem TaxCode Tax Code
KEY TaxBox BoxConfig TaxBox Tax.Bs.Gp.No.
KEY TaxGroup BoxConfig TaxGroup Tax Group
PostingDate I_StRpTaxItem PostingDate Posting Date for GR
ReportingDate I_StRpTaxItem ReportingDate
DocumentDate I_StRpTaxItem DocumentDate Journal Entry Date
TaxReportingDate I_StRpTaxItem TaxReportingDate Tax Reporting Date
TaxRate I_StRpTaxItem TaxRate Tax Rate
GLAccount I_StRpTaxItem GLAccount General Ledger
BusinessPlace I_StRpTaxItem BusinessPlace Business place
Customer I_StRpTaxItem Customer Sold-to Party
Supplier I_StRpTaxItem Supplier Supplier
TaxBaseAmountInTransCrcy I_StRpTaxItem TaxBaseAmountInTransCrcy Value-Added Tax
TaxAmountInRptgCrcy I_StRpTaxItem TaxAmount Tax Amt in Rptg Crcy
ReportingCurrency I_StRpTaxItem 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_StRpTaxItemBoxCube.
-- 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: PPHSRTAXITEMBOX

CREATE VIEW P_PH_StRpTaxItemBoxCube AS
SELECT
  TaxData.CompanyCode AS CompanyCode,
  TaxData.AccountingDocument AS AccountingDocument,
  TaxData.FiscalYear AS FiscalYear,
  TaxData.TaxItem AS TaxItem,
  BoxConfig.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  TaxData.TransactionTypeDetermination AS TransactionTypeDetermination,
  TaxData.TaxCode AS TaxCode,
  BoxConfig.TaxBox AS TaxBox,
  BoxConfig.TaxGroup AS TaxGroup,
  TaxData.PostingDate AS PostingDate,
  TaxData.ReportingDate AS ReportingDate,
  TaxData.DocumentDate AS DocumentDate,
  TaxData.TaxReportingDate AS TaxReportingDate,
  TaxData.TaxRate AS TaxRate,
  TaxData.GLAccount AS GLAccount,
  TaxData.BusinessPlace AS BusinessPlace,
  TaxData.Customer AS Customer,
  TaxData.Supplier AS Supplier,
  TaxData.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  TaxData.TaxAmount AS TaxAmountInRptgCrcy,
  TaxData.ReportingCurrency AS ReportingCurrency
FROM I_StRpTaxItem AS TaxData
;

Learn More