P_TH_StRpTaxItems
P_TH_StRpTaxItems is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_OperationalAcctgDocItem, I_StRpBPTaxItem) and exposes 75 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem, StatryRptgEntity. It has 1 association to related views.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| I_OperationalAcctgDocItem | I_OperationalAcctgDocItem | left_outer |
| I_StRpBPTaxItem | I_StRpBPTaxItem | left_outer |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_SDDocumentPartner | _SDDocumentPartner | ( $projection.SalesDocument = _SDDocumentPartner.SDDocument or $projection.BillingDocument = _SDDocumentPartner.SDDocument ) and _SDDocumentPartner.PartnerFunction = 'RE' |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | PTHSTRPTAXITEMS | view | |
| VDM.viewType | #COMPOSITE | view | |
| VDM.private | true | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.serviceQuality | #X | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| AccessControl.personalData.blocking | #BLOCKED_DATA_INCLUDED | view |
Fields (75)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CompanyCode | TaxItem | CompanyCode | Receiver Company Code |
| KEY | AccountingDocument | TaxItem | AccountingDocument | Journal Entry |
| KEY | FiscalYear | TaxItem | FiscalYear | G/L Fiscal Year |
| KEY | TaxItem | TaxItem | TaxItem | Tax Item |
| KEY | StatryRptgEntity | TaxItem | StatryRptgEntity | Reporting Entity |
| KEY | StatryRptCategory | TaxItem | StatryRptCategory | Report ID |
| KEY | StatryRptRunID | TaxItem | StatryRptRunID | Report Run ID |
| KEY | TaxCode | TaxItem | TaxCode | Tax Code |
| KEY | TransactionTypeDetermination | TaxItem | TransactionTypeDetermination | Transaction Key |
| KEY | TaxBox | TaxBox | Tax.Bs.Gp.No. | |
| KEY | TaxDeclnAmountType | TaxDeclnAmountType | ||
| KEY | TaxItemGroupingVersion | TaxItemGroupingVersion | Tax Grping Ver. | |
| KEY | ValidFrom | ValidFrom | Vers.Valid From | |
| KEY | TaxBoxStructureType | TaxBoxStructureType | ||
| KEY | TaxGroup | TaxGroup | Tax Group | |
| BranchCode | I_OperationalAcctgDocItem | BranchCode | Branch Code | |
| SalesDocument | TaxItem | SalesDocument | SD Document | |
| BillingDocument | TaxItem | BillingDocument | SD Document | |
| Customer | I_StRpBPTaxItem | Customer | Sold-to Party | |
| Supplier | I_StRpBPTaxItem | Supplier | Supplier | |
| ReportingDate | TaxItem | ReportingDate | ||
| PostingDate | TaxItem | PostingDate | Posting Date for GR | |
| DocumentDate | TaxItem | DocumentDate | Journal Entry Date | |
| TaxReportingDate | TaxItem | TaxReportingDate | Tax Reporting Date | |
| FiscalPeriod | TaxItem | FiscalPeriod | Tax period | |
| IsReversal | IsReversal | Reversal doc. | ||
| IsReversed | IsReversed | Reversed? | ||
| AccountingDocumentHeaderText | AccountingDocumentHeaderText | Doc.Header Text | ||
| AccountingDocumentType | TaxItem | AccountingDocumentType | Journal Entry Type | |
| TaxCalculationProcedure | TaxItem | TaxCalculationProcedure | Tax Procedure | |
| DocumentReferenceID | TaxItem | DocumentReferenceID | Reference | |
| CompanyCodeCountry | TaxItem | CompanyCodeCountry | Reporting Ctry/Reg. | |
| ReportingCountry | TaxItem | ReportingCountry | ||
| TaxReturnCountry | TaxItem | TaxReturnCountry | Reporting C/R | |
| ExchangeRate | ExchangeRate | Exchange rate | ||
| TaxRate | TaxItem | TaxRate | Tax Rate | |
| GLAccount | TaxItem | GLAccount | General Ledger | |
| BusinessPlace | TaxItem | BusinessPlace | Business place | |
| TaxJurisdiction | TaxItem | TaxJurisdiction | Tax Jurisdiction | |
| LowestLevelTaxJurisdiction | LowestLevelTaxJurisdiction | Jurisdict. Code | ||
| TaxNumber1endasTaxNumber1 | ||||
| TaxNumber2endasTaxNumber2 | ||||
| TaxNumber3endasTaxNumber3 | ||||
| SupplierendasBusinessPartner | ||||
| CountryendasBusinessPartnerCountry | ||||
| SupplierNameendasBusinessPartnerName | ||||
| TaxType | TaxItem | TaxType | Tax Type | |
| CompanyCodeCurrency | TaxItem | CompanyCodeCurrency | Local Currency | |
| CountryCurrency | TaxItem | CountryCurrency | Currency | |
| DocumentCurrency | TaxItem | DocumentCurrency | Document Currency | |
| ReportingCurrency | ReportingCurrency | Currency | ||
| AdditionalCurrency1 | TaxItem | AdditionalCurrency1 | Local curr. 2 | |
| AdditionalCurrency2 | TaxItem | AdditionalCurrency2 | Local curr. 3 | |
| AmountInReportingCurrency | ||||
| AmountInTransactionCurrency | TaxItem | AmountInTransactionCurrency | Pt Crcy Amt | |
| TaxBaseAmountInCoCodeCrcy | TaxItem | TaxBaseAmountInCoCodeCrcy | TxBaseAmt CoCodeCrcy | |
| TaxAmountInCoCodeCrcy | TaxItem | TaxAmountInCoCodeCrcy | Tax Amount in Company Code Currency | |
| TaxBaseAmountInTransCrcy | TaxItem | TaxBaseAmountInTransCrcy | Value-Added Tax | |
| TaxAmount | TaxItem | TaxAmount | Tax Amt in Rptg Crcy | |
| TaxBaseAmountInRptgCrcy | TaxBaseAmountInRptgCrcy | Base Amount | ||
| TaxAmountInRptgCrcy | TaxAmountInRptgCrcy | Tax Rept. Crcy | ||
| AmountInAdditionalCurrency1 | TaxItem | AmountInAdditionalCurrency1 | Amount in Additional Currency 1 | |
| AmountInAdditionalCurrency2 | TaxItem | AmountInAdditionalCurrency2 | LC2 Amount | |
| TaxBaseAmtInAdditionalCrcy1 | TaxItem | TaxBaseAmtInAdditionalCrcy1 | LC 2 Base | |
| TaxBaseAmtInAdditionalCrcy2 | TaxItem | TaxBaseAmtInAdditionalCrcy2 | LC 3 Base | |
| TaxAmountInAdditionalCurrency1 | TaxItem | TaxAmountInAdditionalCurrency1 | LC 2 Tax | |
| TaxAmountInAdditionalCurrency2 | TaxItem | TaxAmountInAdditionalCurrency2 | LC 3 Tax | |
| TaxIsNotDeductible | TaxIsNotDeductible | Non-Deductible | ||
| _ReportingCurrency | _ReportingCurrency | |||
| _AccountingDocument | TaxItem | _AccountingDocument | ||
| _TaxJurisdiction | TaxItem | _TaxJurisdiction | ||
| _ReceivablesPayablesItem | TaxItem | _ReceivablesPayablesItem | ||
| _SDDocumentPartner | _SDDocumentPartner | |||
| _TaxTypeText | _TaxTypeText | |||
| _TaxCodeText | _TaxCodeText |
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_TH_StRpTaxItems.
-- 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: PTHSTRPTAXITEMS
CREATE VIEW P_TH_StRpTaxItems AS
SELECT
TaxItem.CompanyCode AS CompanyCode,
TaxItem.AccountingDocument AS AccountingDocument,
TaxItem.FiscalYear AS FiscalYear,
TaxItem.TaxItem AS TaxItem,
TaxItem.StatryRptgEntity AS StatryRptgEntity,
TaxItem.StatryRptCategory AS StatryRptCategory,
TaxItem.StatryRptRunID AS StatryRptRunID,
TaxItem.TaxCode AS TaxCode,
TaxItem.TransactionTypeDetermination AS TransactionTypeDetermination,
TaxBox,
TaxDeclnAmountType,
TaxItemGroupingVersion,
ValidFrom,
TaxBoxStructureType,
TaxGroup,
I_OperationalAcctgDocItem.BranchCode AS BranchCode,
TaxItem.SalesDocument AS SalesDocument,
TaxItem.BillingDocument AS BillingDocument,
I_StRpBPTaxItem.Customer AS Customer,
I_StRpBPTaxItem.Supplier AS Supplier,
TaxItem.ReportingDate AS ReportingDate,
TaxItem.PostingDate AS PostingDate,
TaxItem.DocumentDate AS DocumentDate,
TaxItem.TaxReportingDate AS TaxReportingDate,
TaxItem.FiscalPeriod AS FiscalPeriod,
IsReversal,
IsReversed,
AccountingDocumentHeaderText,
TaxItem.AccountingDocumentType AS AccountingDocumentType,
TaxItem.TaxCalculationProcedure AS TaxCalculationProcedure,
TaxItem.DocumentReferenceID AS DocumentReferenceID,
TaxItem.CompanyCodeCountry AS CompanyCodeCountry,
TaxItem.ReportingCountry AS ReportingCountry,
TaxItem.TaxReturnCountry AS TaxReturnCountry,
ExchangeRate,
TaxItem.TaxRate AS TaxRate,
TaxItem.GLAccount AS GLAccount,
TaxItem.BusinessPlace AS BusinessPlace,
TaxItem.TaxJurisdiction AS TaxJurisdiction,
LowestLevelTaxJurisdiction,
case when I_StRpBPTaxItem.Customer <> '' then coalesce(coalesce(I_StRpBPTaxItem._OneTimeDefTaxAccountBP.TaxID1, I_StRpBPTaxItem._OneTimeAccountBP.TaxID1), I_StRpBPTaxItem._Customer.TaxNumber1) when I_StRpBPTaxItem.Supplier <> '' then coalesce(coalesce(I_StRpBPTaxItem._OneTimeDefTaxAccountBP.TaxID1, I_StRpBPTaxItem._OneTimeAccountBP.TaxID1), I_StRpBPTaxItem._Supplier.TaxNumber1) end as TaxNumber1 AS TaxNumber1endasTaxNumber1,
case when I_StRpBPTaxItem.Customer <> '' then coalesce(coalesce(I_StRpBPTaxItem._OneTimeDefTaxAccountBP.TaxID2, I_StRpBPTaxItem._OneTimeAccountBP.TaxID2), I_StRpBPTaxItem._Customer.TaxNumber2) when I_StRpBPTaxItem.Supplier <> '' then coalesce(coalesce(I_StRpBPTaxItem._OneTimeDefTaxAccountBP.TaxID2, I_StRpBPTaxItem._OneTimeAccountBP.TaxID2), I_StRpBPTaxItem._Supplier.TaxNumber2) end as TaxNumber2 AS TaxNumber2endasTaxNumber2,
case when I_StRpBPTaxItem.Customer <> '' then coalesce(coalesce(I_StRpBPTaxItem._OneTimeDefTaxAccountBP.TaxID3, I_StRpBPTaxItem._OneTimeAccountBP.TaxID3), I_StRpBPTaxItem._Customer.TaxNumber3) when I_StRpBPTaxItem.Supplier <> '' then coalesce(coalesce(I_StRpBPTaxItem._OneTimeDefTaxAccountBP.TaxID3, I_StRpBPTaxItem._OneTimeAccountBP.TaxID3), I_StRpBPTaxItem._Supplier.TaxNumber3) end as TaxNumber3 AS TaxNumber3endasTaxNumber3,
case when I_StRpBPTaxItem.Customer <> '' then I_StRpBPTaxItem.Customer when I_StRpBPTaxItem.Supplier <> '' then I_StRpBPTaxItem.Supplier end as BusinessPartner AS SupplierendasBusinessPartner,
case when I_StRpBPTaxItem.Customer <> '' then coalesce(coalesce(I_StRpBPTaxItem._OneTimeDefTaxAccountBP.Country, I_StRpBPTaxItem._OneTimeAccountBP.Country), I_StRpBPTaxItem._Customer.Country) when I_StRpBPTaxItem.Supplier <> '' then coalesce(coalesce(I_StRpBPTaxItem._OneTimeDefTaxAccountBP.Country, I_StRpBPTaxItem._OneTimeAccountBP.Country), I_StRpBPTaxItem._Supplier.Country) end as BusinessPartnerCountry AS CountryendasBusinessPartnerCountry,
case when I_StRpBPTaxItem.Customer <> '' then coalesce(coalesce(I_StRpBPTaxItem._OneTimeDefTaxAccountBP.BusinessPartnerName1, I_StRpBPTaxItem._OneTimeAccountBP.BusinessPartnerName1), I_StRpBPTaxItem._Customer.CustomerName) when I_StRpBPTaxItem.Supplier <> '' then coalesce(coalesce(I_StRpBPTaxItem._OneTimeDefTaxAccountBP.BusinessPartnerName1, I_StRpBPTaxItem._OneTimeAccountBP.BusinessPartnerName1), I_StRpBPTaxItem._Supplier.SupplierName) end as BusinessPartnerName AS SupplierNameendasBusinessPartnerName,
TaxItem.TaxType AS TaxType,
TaxItem.CompanyCodeCurrency AS CompanyCodeCurrency,
TaxItem.CountryCurrency AS CountryCurrency,
TaxItem.DocumentCurrency AS DocumentCurrency,
ReportingCurrency,
TaxItem.AdditionalCurrency1 AS AdditionalCurrency1,
TaxItem.AdditionalCurrency2 AS AdditionalCurrency2,
cast ( AmountInReportingCurrency as glo_amount_rptg_crcy ) AS AmountInReportingCurrency,
TaxItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
TaxItem.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
TaxItem.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
TaxItem.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
TaxItem.TaxAmount AS TaxAmount,
TaxBaseAmountInRptgCrcy,
TaxAmountInRptgCrcy,
TaxItem.AmountInAdditionalCurrency1 AS AmountInAdditionalCurrency1,
TaxItem.AmountInAdditionalCurrency2 AS AmountInAdditionalCurrency2,
TaxItem.TaxBaseAmtInAdditionalCrcy1 AS TaxBaseAmtInAdditionalCrcy1,
TaxItem.TaxBaseAmtInAdditionalCrcy2 AS TaxBaseAmtInAdditionalCrcy2,
TaxItem.TaxAmountInAdditionalCurrency1 AS TaxAmountInAdditionalCurrency1,
TaxItem.TaxAmountInAdditionalCurrency2 AS TaxAmountInAdditionalCurrency2,
TaxIsNotDeductible,
TaxItem._AccountingDocument AS _AccountingDocument,
TaxItem._TaxJurisdiction AS _TaxJurisdiction,
TaxItem._ReceivablesPayablesItem AS _ReceivablesPayablesItem
LEFT OUTER JOIN I_OperationalAcctgDocItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_StRpBPTaxItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SDDocumentPartner AS _SDDocumentPartner ON ( SalesDocument = _SDDocumentPartner.SDDocument OR BillingDocument = _SDDocumentPartner.SDDocument ) AND _SDDocumentPartner.PartnerFunction = 'RE' -- association [0..1]
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA