What is P_TH_StRpTaxPaymentReturn in SAP S/4HANA?

P_TH_StRpTaxPaymentReturn is a composite CDS view in SAP S/4HANA. For Thailand PP36 Tax Return Report It contains 164 fields.

Which tables does P_TH_StRpTaxPaymentReturn read from?

P_TH_StRpTaxPaymentReturn reads data from: I_StRpTaxReturnBoxCube, I_OperationalAcctgDocItem, P_TH_StRpDeferTaxPayment.

What VDM layer is P_TH_StRpTaxPaymentReturn?

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

P_TH_StRpTaxPaymentReturn

DDL: P_TH_STRPTAXPAYMENTRETURN SQL: PTHSTRPTAXPRET Type: view COMPOSITE Package: GLO_FIN_IS_VAT_TH

164 Fields 3 Data Sources

For Thailand PP36 Tax Return Report

P_TH_StRpTaxPaymentReturn is a Composite CDS View that provides data about "For Thailand PP36 Tax Return Report" in SAP S/4HANA. It reads from 3 data sources (I_StRpTaxReturnBoxCube, I_OperationalAcctgDocItem, P_TH_StRpDeferTaxPayment) and exposes 164 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem, TaxCode. Part of development package GLO_FIN_IS_VAT_TH.

Data Sources (3)

Source	Alias	Join Type
I_StRpTaxReturnBoxCube	I_StRpTaxReturnBoxCube	from
I_OperationalAcctgDocItem	P_DebtorCreditorRblsPyblsItem	inner
P_TH_StRpDeferTaxPayment	P_TH_StRpDeferTaxPayment	union_all

Parameters (5)

Name	Type	Default
P_RelevantAmountPosition	relevantamountposition
P_StatryRptgEntity	srf_reporting_entity
P_StatryRptCategory	srf_rep_cat_id
P_StatryRptRunID	srf_report_run_id
P_ReportingCountry	land1

Annotations (10)

Name	Value	Level
AbapCatalog.sqlViewName	PTHSTRPTAXPRET	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	#D	view
ObjectModel.usageType.dataClass	#MIXED	view
AccessControl.personalData.blocking	#BLOCKED_DATA_INCLUDED	view

Fields (164)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	I_StRpTaxReturnBoxCube	CompanyCode	Receiver Company Code
KEY	AccountingDocument	I_StRpTaxReturnBoxCube	AccountingDocument	Journal Entry
KEY	FiscalYear	I_StRpTaxReturnBoxCube	FiscalYear	G/L Fiscal Year
KEY	TaxItem	I_StRpTaxReturnBoxCube	TaxItem	Tax Item
KEY	TaxCode	I_StRpTaxReturnBoxCube	TaxCode	Tax Code
KEY	TransactionTypeDetermination	I_StRpTaxReturnBoxCube	TransactionTypeDetermination	Transaction Key
KEY	TaxBox	I_StRpTaxReturnBoxCube	TaxBox	Tax.Bs.Gp.No.
KEY	TaxDeclnAmountType	I_StRpTaxReturnBoxCube	TaxDeclnAmountType
KEY	TaxItemGroupingVersion	I_StRpTaxReturnBoxCube	TaxItemGroupingVersion	Tax Grping Ver.
KEY	TaxBoxStrucValidityStartDate	I_StRpTaxReturnBoxCube	TaxBoxStrucValidityStartDate
KEY	TaxBoxStructureType	I_StRpTaxReturnBoxCube	TaxBoxStructureType
KEY	TaxGroup	I_StRpTaxReturnBoxCube	TaxGroup	Tax Group
KEY	StatryRptgEntity	I_StRpTaxReturnBoxCube	StatryRptgEntity	Reporting Entity
KEY	StatryRptCategory	I_StRpTaxReturnBoxCube	StatryRptCategory	Report ID
KEY	StatryRptRunID	I_StRpTaxReturnBoxCube	StatryRptRunID	Report Run ID
	TaxBoxStructure	I_StRpTaxReturnBoxCube	TaxBoxStructure
	TaxCalculationProcedure	I_StRpTaxReturnBoxCube	TaxCalculationProcedure	Tax Procedure
	ReportingDate	I_StRpTaxReturnBoxCube	ReportingDate
	PostingDate	I_StRpTaxReturnBoxCube	PostingDate	Posting Date for GR
	DocumentDate	I_StRpTaxReturnBoxCube	DocumentDate	Journal Entry Date
	TaxReportingDate	I_StRpTaxReturnBoxCube	TaxReportingDate	Tax Reporting Date
	FiscalPeriod	I_StRpTaxReturnBoxCube	FiscalPeriod	Tax period
	TaxItemGroup	I_StRpTaxReturnBoxCube	TaxItemGroup	Tax doc. item number
	AccountingDocumentType	I_StRpTaxReturnBoxCube	AccountingDocumentType	Journal Entry Type
	ExchangeRate	I_StRpTaxReturnBoxCube	ExchangeRate	Exchange rate
	ClearingDocFiscalYear	I_OperationalAcctgDocItem	ClearingDocFiscalYear	Fiscal Year of Clearing Journal Entry
	ClearingAccountingDocument	I_OperationalAcctgDocItem	ClearingAccountingDocument	Clearing Journal Entry
	ClearingJournalEntry	I_OperationalAcctgDocItem	ClearingJournalEntry	Clrng doc.
	ClearingJournalEntryFiscalYear	I_OperationalAcctgDocItem	ClearingJournalEntryFiscalYear	Fiscal Year of Clearing Journal Entry
	PaymentDate			Payment Date
	SupplierPaytCurrencyExchRate			Supp. Payt Currency Exch. Rate
	PaymentNote	I_OperationalAcctgDocItem	DocumentItemText	Text
	DocumentReferenceID			Reference
	CompanyCodeCountry	I_StRpTaxReturnBoxCube	CompanyCodeCountry	Reporting Ctry/Reg.
	ReportingCountry	I_StRpTaxReturnBoxCube	ReportingCountry
	BusinessPartnerCountry	I_StRpTaxReturnBoxCube	BusinessPartnerCountry	BP Ctry/Reg.
	TaxRate			Tax Rate
	TaxRateValidityStartDate	I_StRpTaxReturnBoxCube	TaxRateValidityStartDate	Tax Rate Validity Start Date
	IsReversal	I_StRpTaxReturnBoxCube	IsReversal	Reversal doc.
	IsReversed	I_StRpTaxReturnBoxCube	IsReversed	Reversed?
	AccountingDocumentHeaderText	I_StRpTaxReturnBoxCube	AccountingDocumentHeaderText	Doc.Header Text
	GLAccount	I_StRpTaxReturnBoxCube	GLAccount	General Ledger
	BusinessPlace	I_StRpTaxReturnBoxCube	BusinessPlace	Business place
	TaxJurisdiction	I_StRpTaxReturnBoxCube	TaxJurisdiction	Tax Jurisdiction
	LowestLevelTaxJurisdiction	I_StRpTaxReturnBoxCube	LowestLevelTaxJurisdiction	Jurisdict. Code
	TaxNumber1	I_StRpTaxReturnBoxCube	TaxNumber1	VAT Reg. No.
	TaxNumber2	I_StRpTaxReturnBoxCube	TaxNumber2	Tax Number 2
	TaxNumber3	I_StRpTaxReturnBoxCube	TaxNumber3
	BusinessPartner	I_StRpTaxReturnBoxCube	BusinessPartner	Issuing Authority
	BusinessPartnerName	I_StRpTaxReturnBoxCube	BusinessPartnerName	Extracted Customer Name
	CustomerSupplierAddress	I_StRpTaxReturnBoxCube	CustomerSupplierAddress
	AddressIDendasAddressID
	SupplierendasSupplier
	BusinessPartnerName411asTaxPayerName
	CityName			Name
	Region			Venue Region
	PostalCode			Postal Code
	StreetName			Text
	Country			Venue: Ctry/Reg
	TaxType	I_StRpTaxReturnBoxCube	TaxType	Tax Type
	CompanyCodeCurrency	I_StRpTaxReturnBoxCube	CompanyCodeCurrency	Local Currency
	CountryCurrency	I_StRpTaxReturnBoxCube	CountryCurrency	Currency
	DocumentCurrency	I_StRpTaxReturnBoxCube	DocumentCurrency	Document Currency
	ReportingCurrencyendasReportingCurrency
	AdditionalCurrency1	I_StRpTaxReturnBoxCube	AdditionalCurrency1	Local curr. 2
	AdditionalCurrency2	I_StRpTaxReturnBoxCube	AdditionalCurrency2	Local curr. 3
	AmountInTransactionCurrency			Pt Crcy Amt
	TaxBaseAmountInCoCodeCrcy			TxBaseAmt CoCodeCrcy
	TaxAmountInCoCodeCrcy			Tax Amount in Company Code Currency
	TaxBaseAmountInTransCrcy			Value-Added Tax
	TaxAmount			Tax Amt in Rptg Crcy
	AmountInAdditionalCurrency1	I_StRpTaxReturnBoxCube	AmountInAdditionalCurrency1	Amount in Additional Currency 1
	AmountInAdditionalCurrency2	I_StRpTaxReturnBoxCube	AmountInAdditionalCurrency2	LC2 Amount
	TaxBaseAmtInAdditionalCrcy1	I_StRpTaxReturnBoxCube	TaxBaseAmtInAdditionalCrcy1	LC 2 Base
	TaxBaseAmtInAdditionalCrcy2	I_StRpTaxReturnBoxCube	TaxBaseAmtInAdditionalCrcy2	LC 3 Base
	TaxAmountInAdditionalCurrency1	I_StRpTaxReturnBoxCube	TaxAmountInAdditionalCurrency1	LC 2 Tax
	TaxAmountInAdditionalCurrency2	I_StRpTaxReturnBoxCube	TaxAmountInAdditionalCurrency2	LC 3 Tax
	TaxIsNotDeductible	I_StRpTaxReturnBoxCube	TaxIsNotDeductible	Non-Deductible
	P_RelevantAmountPosition
	P_StatryRptgEntity
	P_StatryRptCategory
	P_StatryRptRunID
	CompanyCode			Receiver Company Code
KEY	AccountingDocument	P_TH_StRpDeferTaxPayment	AccountingDocument	Journal Entry
KEY	FiscalYear	P_TH_StRpDeferTaxPayment	FiscalYear	G/L Fiscal Year
KEY	TaxItem	P_TH_StRpDeferTaxPayment	TaxItem	Tax Item
KEY	TaxCode	P_TH_StRpDeferTaxPayment	TaxCode	Tax Code
KEY	TransactionTypeDetermination	P_TH_StRpDeferTaxPayment	TransactionTypeDetermination	Transaction Key
KEY	TaxBox	P_TH_StRpDeferTaxPayment	TaxBox	Tax.Bs.Gp.No.
KEY	TaxDeclnAmountType	P_TH_StRpDeferTaxPayment	TaxDeclnAmountType
KEY	TaxItemGroupingVersion	P_TH_StRpDeferTaxPayment	TaxItemGroupingVersion	Tax Grping Ver.
KEY	TaxBoxStrucValidityStartDate	P_TH_StRpDeferTaxPayment	TaxBoxStrucValidityStartDate
KEY	TaxBoxStructureType	P_TH_StRpDeferTaxPayment	TaxBoxStructureType
KEY	TaxGroup	P_TH_StRpDeferTaxPayment	TaxGroup	Tax Group
KEY	StatryRptgEntity	P_TH_StRpDeferTaxPayment	StatryRptgEntity	Reporting Entity
KEY	StatryRptCategory	P_TH_StRpDeferTaxPayment	StatryRptCategory	Report ID
KEY	StatryRptRunID	P_TH_StRpDeferTaxPayment	StatryRptRunID	Report Run ID
	TaxBoxStructure	P_TH_StRpDeferTaxPayment	TaxBoxStructure
	TaxCalculationProcedure	P_TH_StRpDeferTaxPayment	TaxCalculationProcedure	Tax Procedure
	ReportingDate	P_TH_StRpDeferTaxPayment	ReportingDate
	PostingDate	P_TH_StRpDeferTaxPayment	PostingDate	Posting Date for GR
	DocumentDate	P_TH_StRpDeferTaxPayment	DocumentDate	Journal Entry Date
	TaxReportingDate	P_TH_StRpDeferTaxPayment	TaxReportingDate	Tax Reporting Date
	FiscalPeriod	P_TH_StRpDeferTaxPayment	FiscalPeriod	Tax period
	TaxItemGroup	P_TH_StRpDeferTaxPayment	TaxItemGroup	Tax doc. item number
	AccountingDocumentType	P_TH_StRpDeferTaxPayment	AccountingDocumentType	Journal Entry Type
	ExchangeRate	P_TH_StRpDeferTaxPayment	ExchangeRate	Exchange rate
	ClearingDocFiscalYear	P_TH_StRpDeferTaxPayment	ClearingDocFiscalYear	Fiscal Year of Clearing Journal Entry
	ClearingAccountingDocument	P_TH_StRpDeferTaxPayment	ClearingAccountingDocument	Clearing Journal Entry
	ClearingJournalEntry	P_TH_StRpDeferTaxPayment	ClearingJournalEntry	Clrng doc.
	ClearingJournalEntryFiscalYear	P_TH_StRpDeferTaxPayment	ClearingJournalEntryFiscalYear	Fiscal Year of Clearing Journal Entry
	PaymentDate	P_TH_StRpDeferTaxPayment	PaymentDate	Payment Date
	SupplierPaytCurrencyExchRate	P_TH_StRpDeferTaxPayment	SupplierPaytCurrencyExchRate	Supp. Payt Currency Exch. Rate
	PaymentNote	P_TH_StRpDeferTaxPayment	PaymentNote	Text
	DocumentReferenceID	P_TH_StRpDeferTaxPayment	DocumentReferenceID	Reference
	CompanyCodeCountry	P_TH_StRpDeferTaxPayment	CompanyCodeCountry	Reporting Ctry/Reg.
	ReportingCountry	P_TH_StRpDeferTaxPayment	ReportingCountry
	BusinessPartnerCountry	P_TH_StRpDeferTaxPayment	BusinessPartnerCountry	BP Ctry/Reg.
	TaxRate	P_TH_StRpDeferTaxPayment	TaxRate	Tax Rate
	TaxRateValidityStartDate	P_TH_StRpDeferTaxPayment	TaxRateValidityStartDate	Tax Rate Validity Start Date
	IsReversal	P_TH_StRpDeferTaxPayment	IsReversal	Reversal doc.
	IsReversed	P_TH_StRpDeferTaxPayment	IsReversed	Reversed?
	AccountingDocumentHeaderText	P_TH_StRpDeferTaxPayment	AccountingDocumentHeaderText	Doc.Header Text
	GLAccount	P_TH_StRpDeferTaxPayment	GLAccount	General Ledger
	BusinessPlace	P_TH_StRpDeferTaxPayment	BusinessPlace	Business place
	TaxJurisdiction	P_TH_StRpDeferTaxPayment	TaxJurisdiction	Tax Jurisdiction
	LowestLevelTaxJurisdiction	P_TH_StRpDeferTaxPayment	LowestLevelTaxJurisdiction	Jurisdict. Code
	TaxNumber1	P_TH_StRpDeferTaxPayment	TaxNumber1	VAT Reg. No.
	TaxNumber2	P_TH_StRpDeferTaxPayment	TaxNumber2	Tax Number 2
	TaxNumber3	P_TH_StRpDeferTaxPayment	TaxNumber3
	BusinessPartner	P_TH_StRpDeferTaxPayment	BusinessPartner	Issuing Authority
	BusinessPartnerName	P_TH_StRpDeferTaxPayment	BusinessPartnerName	Extracted Customer Name
	CustomerSupplierAddress	P_TH_StRpDeferTaxPayment	CustomerSupplierAddress
	AddressID	P_TH_StRpDeferTaxPayment	AddressID	Ship-to address
	Supplier	P_TH_StRpDeferTaxPayment	Supplier	Supplier
	TaxPayerName	P_TH_StRpDeferTaxPayment	TaxPayerName
	CityName	P_TH_StRpDeferTaxPayment	CityName	Name
	Region	P_TH_StRpDeferTaxPayment	Region	Venue Region
	PostalCode	P_TH_StRpDeferTaxPayment	PostalCode	Postal Code
	StreetName	P_TH_StRpDeferTaxPayment	StreetName	Text
	Country	P_TH_StRpDeferTaxPayment	Country	Venue: Ctry/Reg
	TaxType	P_TH_StRpDeferTaxPayment	TaxType	Tax Type
	CompanyCodeCurrency	P_TH_StRpDeferTaxPayment	CompanyCodeCurrency	Local Currency
	CountryCurrency	P_TH_StRpDeferTaxPayment	CountryCurrency	Currency
	DocumentCurrency	P_TH_StRpDeferTaxPayment	DocumentCurrency	Document Currency
	ReportingCurrency	P_TH_StRpDeferTaxPayment	ReportingCurrency	Currency
	AdditionalCurrency1	P_TH_StRpDeferTaxPayment	AdditionalCurrency1	Local curr. 2
	AdditionalCurrency2	P_TH_StRpDeferTaxPayment	AdditionalCurrency2	Local curr. 3
	AmountInReportingCurrency	P_TH_StRpDeferTaxPayment	AmountInReportingCurrency
	AmountInTransactionCurrency	P_TH_StRpDeferTaxPayment	AmountInTransactionCurrency	Pt Crcy Amt
	TaxBaseAmountInCoCodeCrcy	P_TH_StRpDeferTaxPayment	TaxBaseAmountInCoCodeCrcy	TxBaseAmt CoCodeCrcy
	TaxAmountInCoCodeCrcy	P_TH_StRpDeferTaxPayment	TaxAmountInCoCodeCrcy	Tax Amount in Company Code Currency
	TaxBaseAmountInTransCrcy	P_TH_StRpDeferTaxPayment	TaxBaseAmountInTransCrcy	Value-Added Tax
	TaxAmount	P_TH_StRpDeferTaxPayment	TaxAmount	Tax Amt in Rptg Crcy
	TaxBaseAmountInRptgCrcy	P_TH_StRpDeferTaxPayment	TaxBaseAmountInRptgCrcy	Base Amount
	TaxAmountInRptgCrcy	P_TH_StRpDeferTaxPayment	TaxAmountInRptgCrcy	Tax Rept. Crcy
	AmountInAdditionalCurrency1	P_TH_StRpDeferTaxPayment	AmountInAdditionalCurrency1	Amount in Additional Currency 1
	AmountInAdditionalCurrency2	P_TH_StRpDeferTaxPayment	AmountInAdditionalCurrency2	LC2 Amount
	TaxBaseAmtInAdditionalCrcy1	P_TH_StRpDeferTaxPayment	TaxBaseAmtInAdditionalCrcy1	LC 2 Base
	TaxBaseAmtInAdditionalCrcy2	P_TH_StRpDeferTaxPayment	TaxBaseAmtInAdditionalCrcy2	LC 3 Base
	TaxAmountInAdditionalCurrency1	P_TH_StRpDeferTaxPayment	TaxAmountInAdditionalCurrency1	LC 2 Tax
	TaxAmountInAdditionalCurrency2	P_TH_StRpDeferTaxPayment	TaxAmountInAdditionalCurrency2	LC 3 Tax
	TaxIsNotDeductible	P_TH_StRpDeferTaxPayment	TaxIsNotDeductible	Non-Deductible
	_TaxTypeText	P_TH_StRpDeferTaxPayment	_TaxTypeText

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_StRpTaxPaymentReturn.
-- 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: PTHSTRPTAXPRET
-- Parameters: P_RelevantAmountPosition : relevantamountposition, P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_ReportingCountry : land1

CREATE VIEW P_TH_StRpTaxPaymentReturn AS
SELECT
  I_StRpTaxReturnBoxCube.CompanyCode AS CompanyCode,
  I_StRpTaxReturnBoxCube.AccountingDocument AS AccountingDocument,
  I_StRpTaxReturnBoxCube.FiscalYear AS FiscalYear,
  I_StRpTaxReturnBoxCube.TaxItem AS TaxItem,
  I_StRpTaxReturnBoxCube.TaxCode AS TaxCode,
  I_StRpTaxReturnBoxCube.TransactionTypeDetermination AS TransactionTypeDetermination,
  I_StRpTaxReturnBoxCube.TaxBox AS TaxBox,
  I_StRpTaxReturnBoxCube.TaxDeclnAmountType AS TaxDeclnAmountType,
  I_StRpTaxReturnBoxCube.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  I_StRpTaxReturnBoxCube.TaxBoxStrucValidityStartDate AS TaxBoxStrucValidityStartDate,
  I_StRpTaxReturnBoxCube.TaxBoxStructureType AS TaxBoxStructureType,
  I_StRpTaxReturnBoxCube.TaxGroup AS TaxGroup,
  I_StRpTaxReturnBoxCube.StatryRptgEntity AS StatryRptgEntity,
  I_StRpTaxReturnBoxCube.StatryRptCategory AS StatryRptCategory,
  I_StRpTaxReturnBoxCube.StatryRptRunID AS StatryRptRunID,
  I_StRpTaxReturnBoxCube.TaxBoxStructure AS TaxBoxStructure,
  I_StRpTaxReturnBoxCube.TaxCalculationProcedure AS TaxCalculationProcedure,
  I_StRpTaxReturnBoxCube.ReportingDate AS ReportingDate,
  I_StRpTaxReturnBoxCube.PostingDate AS PostingDate,
  I_StRpTaxReturnBoxCube.DocumentDate AS DocumentDate,
  I_StRpTaxReturnBoxCube.TaxReportingDate AS TaxReportingDate,
  I_StRpTaxReturnBoxCube.FiscalPeriod AS FiscalPeriod,
  I_StRpTaxReturnBoxCube.TaxItemGroup AS TaxItemGroup,
  I_StRpTaxReturnBoxCube.AccountingDocumentType AS AccountingDocumentType,
  I_StRpTaxReturnBoxCube.ExchangeRate AS ExchangeRate,
  P_DebtorCreditorRblsPyblsItem.ClearingDocFiscalYear AS ClearingDocFiscalYear,
  P_DebtorCreditorRblsPyblsItem.ClearingAccountingDocument AS ClearingAccountingDocument,
  P_DebtorCreditorRblsPyblsItem.ClearingJournalEntry AS ClearingJournalEntry,
  P_DebtorCreditorRblsPyblsItem.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  P_DebtorCreditorRblsPyblsItem._ClearingAccountingDocument.PostingDate AS PaymentDate,
  P_DebtorCreditorRblsPyblsItem._ClearingAccountingDocument.ExchangeRate AS SupplierPaytCurrencyExchRate,
  P_DebtorCreditorRblsPyblsItem.DocumentItemText AS PaymentNote,
  P_DebtorCreditorRblsPyblsItem._ClearingAccountingDocument.DocumentReferenceID AS DocumentReferenceID,
  I_StRpTaxReturnBoxCube.CompanyCodeCountry AS CompanyCodeCountry,
  I_StRpTaxReturnBoxCube.ReportingCountry AS ReportingCountry,
  I_StRpTaxReturnBoxCube.BusinessPartnerCountry AS BusinessPartnerCountry,
  cast( I_StRpTaxReturnBoxCube.TaxRate as btaux ) AS TaxRate,
  I_StRpTaxReturnBoxCube.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  I_StRpTaxReturnBoxCube.IsReversal AS IsReversal,
  I_StRpTaxReturnBoxCube.IsReversed AS IsReversed,
  I_StRpTaxReturnBoxCube.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  I_StRpTaxReturnBoxCube.GLAccount AS GLAccount,
  I_StRpTaxReturnBoxCube.BusinessPlace AS BusinessPlace,
  I_StRpTaxReturnBoxCube.TaxJurisdiction AS TaxJurisdiction,
  I_StRpTaxReturnBoxCube.LowestLevelTaxJurisdiction AS LowestLevelTaxJurisdiction,
  I_StRpTaxReturnBoxCube.TaxNumber1 AS TaxNumber1,
  I_StRpTaxReturnBoxCube.TaxNumber2 AS TaxNumber2,
  I_StRpTaxReturnBoxCube.TaxNumber3 AS TaxNumber3,
  I_StRpTaxReturnBoxCube.BusinessPartner AS BusinessPartner,
  I_StRpTaxReturnBoxCube.BusinessPartnerName AS BusinessPartnerName,
  I_StRpTaxReturnBoxCube.CustomerSupplierAddress AS CustomerSupplierAddress,
  case when P_DebtorCreditorRblsPyblsItem._OneTimeAccountBP.AccountingDocument is null then P_DebtorCreditorRblsPyblsItem._Supplier.AddressID end as AddressID AS AddressIDendasAddressID,
  case when P_DebtorCreditorRblsPyblsItem._OneTimeAccountBP.AccountingDocument is null then P_DebtorCreditorRblsPyblsItem.Supplier end as Supplier AS SupplierendasSupplier,
  concat_with_space(concat_with_space(P_DebtorCreditorRblsPyblsItem._OneTimeAccountBP.BusinessPartnerName1,P_DebtorCreditorRblsPyblsItem._OneTimeAccountBP.BusinessPartnerName2, 1), concat_with_space(P_DebtorCreditorRblsPyblsItem._OneTimeAccountBP.BusinessPartnerName3,P_DebtorCreditorRblsPyblsItem._OneTimeAccountBP.BusinessPartnerName4, 1), 1 ) as TaxPayerName AS BusinessPartnerName411asTaxPayerName,
  P_DebtorCreditorRblsPyblsItem._OneTimeAccountBP.CityName AS CityName,
  P_DebtorCreditorRblsPyblsItem._OneTimeAccountBP.Region AS Region,
  P_DebtorCreditorRblsPyblsItem._OneTimeAccountBP.PostalCode AS PostalCode,
  P_DebtorCreditorRblsPyblsItem._OneTimeAccountBP.StreetAddressName AS StreetName,
  coalesce(P_DebtorCreditorRblsPyblsItem._OneTimeAccountBP.Country, I_StRpTaxReturnBoxCube.BusinessPartnerCountry ) AS Country,
  I_StRpTaxReturnBoxCube.TaxType AS TaxType,
  I_StRpTaxReturnBoxCube.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_StRpTaxReturnBoxCube.CountryCurrency AS CountryCurrency,
  I_StRpTaxReturnBoxCube.DocumentCurrency AS DocumentCurrency,
  case $parameters.P_RelevantAmountPosition when '2' then I_StRpTaxReturnBoxCube.AdditionalCurrency1 when '3' then I_StRpTaxReturnBoxCube.AdditionalCurrency2 when 'C' then I_StRpTaxReturnBoxCube.CountryCurrency else I_StRpTaxReturnBoxCube.ReportingCurrency end as ReportingCurrency AS ReportingCurrencyendasReportingCurrency,
  I_StRpTaxReturnBoxCube.AdditionalCurrency1 AS AdditionalCurrency1,
  I_StRpTaxReturnBoxCube.AdditionalCurrency2 AS AdditionalCurrency2,
  cast( I_StRpTaxReturnBoxCube.AmountInTransactionCurrency as fis_wsl) AS AmountInTransactionCurrency,
  cast ( I_StRpTaxReturnBoxCube.TaxBaseAmountInCoCodeCrcy as hwbas_bses ) AS TaxBaseAmountInCoCodeCrcy,
  cast ( I_StRpTaxReturnBoxCube.TaxAmountInCoCodeCrcy as hwste) AS TaxAmountInCoCodeCrcy,
  cast( I_StRpTaxReturnBoxCube.TaxBaseAmountInTransCrcy as fwbas_bses ) AS TaxBaseAmountInTransCrcy,
  cast( I_StRpTaxReturnBoxCube.TaxAmount as fwste ) AS TaxAmount,
  I_StRpTaxReturnBoxCube.AmountInAdditionalCurrency1 AS AmountInAdditionalCurrency1,
  I_StRpTaxReturnBoxCube.AmountInAdditionalCurrency2 AS AmountInAdditionalCurrency2,
  I_StRpTaxReturnBoxCube.TaxBaseAmtInAdditionalCrcy1 AS TaxBaseAmtInAdditionalCrcy1,
  I_StRpTaxReturnBoxCube.TaxBaseAmtInAdditionalCrcy2 AS TaxBaseAmtInAdditionalCrcy2,
  I_StRpTaxReturnBoxCube.TaxAmountInAdditionalCurrency1 AS TaxAmountInAdditionalCurrency1,
  I_StRpTaxReturnBoxCube.TaxAmountInAdditionalCurrency2 AS TaxAmountInAdditionalCurrency2,
  I_StRpTaxReturnBoxCube.TaxIsNotDeductible AS TaxIsNotDeductible,
  I_StRpTaxReturnBoxCube._TaxTypeText AS P_RelevantAmountPosition,
  P_StatryRptgEntity : $parameters.P_StatryRptgEntity AS P_StatryRptgEntity,
  P_StatryRptCategory : $parameters.P_StatryRptCategory AS P_StatryRptCategory,
  P_StatryRptRunID : $parameters.P_StatryRptRunID AS P_StatryRptRunID,
  P_TH_StRpDeferTaxPayment.AddressID AS AddressID,
  P_TH_StRpDeferTaxPayment.Supplier AS Supplier,
  P_TH_StRpDeferTaxPayment.TaxPayerName AS TaxPayerName,
  P_TH_StRpDeferTaxPayment.ReportingCurrency AS ReportingCurrency,
  P_TH_StRpDeferTaxPayment.AmountInReportingCurrency AS AmountInReportingCurrency,
  P_TH_StRpDeferTaxPayment.TaxBaseAmountInRptgCrcy AS TaxBaseAmountInRptgCrcy,
  P_TH_StRpDeferTaxPayment.TaxAmountInRptgCrcy AS TaxAmountInRptgCrcy,
  P_TH_StRpDeferTaxPayment._TaxTypeText AS _TaxTypeText
FROM I_StRpTaxReturnBoxCube
INNER JOIN I_OperationalAcctgDocItem AS P_DebtorCreditorRblsPyblsItem ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_TH_StRpDeferTaxPayment
;

Depth:

P_TH_StRpTaxPaymentReturn view