What is P_StRpTaxReturnBox in SAP S/4HANA?

P_StRpTaxReturnBox is a composite CDS view in SAP S/4HANA. It contains 87 fields.

Which tables does P_StRpTaxReturnBox read from?

P_StRpTaxReturnBox reads data from: P_GetNonDeductibleDocItem, I_BillingDocument, P_ConditionsItem, P_CountCountry.

What VDM layer is P_StRpTaxReturnBox?

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

P_StRpTaxReturnBox

DDL: P_STRPTAXRETURNBOX SQL: PSRTAXRETBOX Type: view COMPOSITE

87 Fields 4 Data Sources

P_StRpTaxReturnBox is a Composite CDS View in SAP S/4HANA. It reads from 4 data sources (P_GetNonDeductibleDocItem, I_BillingDocument, P_ConditionsItem, P_CountCountry) and exposes 87 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem, TaxCode.

Data Sources (4)

Source	Alias	Join Type
P_GetNonDeductibleDocItem	_GetNVV	left_outer
I_BillingDocument	I_BillingDocument	left_outer
P_ConditionsItem	P_ConditionsItem	left_outer
P_CountCountry	P_CountCountry	left_outer

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	PSRTAXRETBOX	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
VDM.viewType	#COMPOSITE	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.dataClass	#MIXED	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
VDM.private	true	view
AccessControl.blocking	#BLOCKED_DATA_INCLUDED	view

Fields (87)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	P_StRpTaxReturn	CompanyCode	Receiver Company Code
KEY	AccountingDocument	P_StRpTaxReturn	AccountingDocument	Journal Entry
KEY	FiscalYear	P_StRpTaxReturn	FiscalYear	G/L Fiscal Year
KEY	TaxItem	P_StRpTaxReturn	TaxItem	Tax Item
KEY	TaxCode	P_StRpTaxReturn	TaxCode	Tax Code
KEY	TransactionTypeDetermination	P_StRpTaxReturn	TransactionTypeDetermination	Transaction Key
KEY	StatryRptgEntity	_ReportedItemsLog	StatryRptgEntity	Reporting Entity
KEY	StatryRptCategory	_ReportedItemsLog	StatryRptCategory	Report ID
KEY	StatryRptRunID	_ReportedItemsLog	StatryRptRunID	Report Run ID
	DebitCreditCode	P_StRpTaxReturn	DebitCreditCode	Single-Character Flag
	TaxCalculationProcedure		TaxCalculationProcedure	Tax Procedure
	TaxRate	P_StRpTaxReturn	TaxRate	Tax Rate
	dec112aschar16endendendasIPITaxRate
	AdditionalTax1Rate	P_StRpTaxReturn	TaxRate	Tax Rate
	ConditionAmount	P_ConditionsItem	ConditionAmount	Condition Value
	PayerPartyendasCustomer
	GLAccount		GLAccount	General Ledger
	TaxItemGroup		TaxItemGroup	Tax doc. item number
	BusinessPlace		BusinessPlace	Business place
	TaxJurisdiction		TaxJurisdiction	Tax Jurisdiction
	LowestLevelTaxJurisdiction		LowestLevelTaxJurisdiction	Jurisdict. Code
	AccountingDocumentType	P_StRpTaxReturn	AccountingDocumentType	Journal Entry Type
	ReferenceDocumentType		ReferenceDocumentType	Reference Document Type
	ReverseDocument		ReverseDocument	Reversed With
	ReverseDocumentFiscalYear		ReverseDocumentFiscalYear	Year
	ConditionRecord	P_StRpTaxReturn	ConditionRecord	Cond.Record No.
	RoundingDecimalPlaces		RoundingDecimalPlaces
	DocumentReferenceID	P_StRpTaxReturn	DocumentReferenceID	Reference
	Ledger		Ledger	Ledger
	LedgerGroup		LedgerGroup	Ledger Group
	PostingDate		PostingDate	Posting Date for GR
	DocumentDate		DocumentDate	Journal Entry Date
	TaxReportingDate		TaxReportingDate	Tax Reporting Date
	ReportingDate	P_StRpTaxReturn	ReportingDate
	FiscalPeriod	P_StRpTaxReturn	FiscalPeriod	Tax period
	ExchangeRate		ExchangeRate	Exchange rate
	IsReversal		IsReversal	Reversal doc.
	IsReversed		IsReversed	Reversed?
	AccountingDocumentHeaderText		AccountingDocumentHeaderText	Doc.Header Text
	CompanyCodeCountry		CompanyCodeCountry	Reporting Ctry/Reg.
	ReportingCountry		ReportingCountry
	TaxReturnCountry		TaxReturnCountry	Reporting C/R
	TaxCountry		TaxCountry	Tax Ctry/Reg.
	CompanyCodeCurrency		CompanyCodeCurrency	Local Currency
	CountryCurrency		CountryCurrency	Currency
	DocumentCurrency		DocumentCurrency	Document Currency
	ReportingCurrency		ReportingCurrency	Currency
	AdditionalCurrency1		AdditionalCurrency1	Local curr. 2
	AdditionalCurrency2		AdditionalCurrency2	Local curr. 3
	TaxBaseAmountInRptgCrcy		TaxBaseAmountInRptgCrcy	Base Amount
	TaxAmountInRptgCrcy		TaxAmountInRptgCrcy	Tax Rept. Crcy
	TaxBaseAmountInCoCodeCrcy	P_StRpTaxReturn	TaxBaseAmountInCoCodeCrcy	TxBaseAmt CoCodeCrcy
	TaxAmountInCoCodeCrcy	P_StRpTaxReturn	TaxAmountInCoCodeCrcy	Tax Amount in Company Code Currency
	TaxBaseAmountInTransCrcy	P_StRpTaxReturn	TaxBaseAmountInTransCrcy	Value-Added Tax
	TaxAmount	P_StRpTaxReturn	TaxAmount	Tax Amt in Rptg Crcy
	TaxBaseAmountInCountryCrcy		TaxBaseAmountInCountryCrcy	Base Amount
	TaxAmountInCountryCrcy		TaxAmountInCountryCrcy	Tax Rept. Crcy
	TaxBaseAmtInAdditionalCrcy1		TaxBaseAmtInAdditionalCrcy1	LC 2 Base
	TaxBaseAmtInAdditionalCrcy2		TaxBaseAmtInAdditionalCrcy2	LC 3 Base
	TaxAmountInAdditionalCurrency1		TaxAmountInAdditionalCurrency1	LC 2 Tax
	TaxAmountInAdditionalCurrency2		TaxAmountInAdditionalCurrency2	LC 3 Tax
	DifferenceTaxAmtInCoCodeCrcy
	DiffTaxBaseAmountInCoCodeCrcy
	TaxType		TaxType	Tax Type
	TargetTaxCode		TargetTaxCode
	TaxNumber1		TaxNumber1	VAT Reg. No.
	TaxNumber2		TaxNumber2	Tax Number 2
	ActiveTaxType		ActiveTaxType
	TaxNumber3		TaxNumber3
	NmbrOfChmlCmplncMktCountries		NmbrOfChmlCmplncMktCountries
	BusinessPartner		BusinessPartner	Issuing Authority
	DcblVATIncrdCostInRptgCrcy
	BusinessPartnerName		BusinessPartnerName	Extracted Customer Name
	CustomerSupplierAddress		CustomerSupplierAddress
	TaxIsNotDeductible	P_StRpTaxReturn	TaxIsNotDeductible	Non-Deductible
	SupplierAccountGroup		SupplierAccountGroup	Account group
	ConditionType		ConditionType	Condition type
	_ReportingCurrency		_ReportingCurrency
	_AccountingDocument	P_StRpTaxReturn	_AccountingDocument
	_GLAccount		_GLAccount
	_TaxJurisdiction		_TaxJurisdiction
	_DebtorCreditorRblsPyblsItem		_DebtorCreditorRblsPyblsItem
	_ReceivablesPayablesItem		_ReceivablesPayablesItem
	_TaxReceivablesPayablesItem		_TaxReceivablesPayablesItem
	_TaxTypeText		_TaxTypeText
	_TaxCodeText		_TaxCodeText
	_ReportedItemsLog		_ReportedItemsLog

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_StRpTaxReturnBox.
-- 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: PSRTAXRETBOX

CREATE VIEW P_StRpTaxReturnBox AS
SELECT
  P_StRpTaxReturn.CompanyCode AS CompanyCode,
  P_StRpTaxReturn.AccountingDocument AS AccountingDocument,
  P_StRpTaxReturn.FiscalYear AS FiscalYear,
  P_StRpTaxReturn.TaxItem AS TaxItem,
  P_StRpTaxReturn.TaxCode AS TaxCode,
  P_StRpTaxReturn.TransactionTypeDetermination AS TransactionTypeDetermination,
  _ReportedItemsLog.StatryRptgEntity AS StatryRptgEntity,
  _ReportedItemsLog.StatryRptCategory AS StatryRptCategory,
  _ReportedItemsLog.StatryRptRunID AS StatryRptRunID,
  P_StRpTaxReturn.DebitCreditCode AS DebitCreditCode,
  TaxCalculationProcedure,
  P_StRpTaxReturn.TaxRate AS TaxRate,
  case when P_StRpTaxReturn.TransactionTypeDetermination = 'ESE' and ( P_StRpTaxReturn.TaxRate = 100.00 or P_StRpTaxReturn.TaxRate = -100.00 ) then cast(cast(-_NegCharge.TaxRate as abap.dec(11,2)) as char16) when P_StRpTaxReturn.TransactionTypeDetermination = 'ESA' and ( P_StRpTaxReturn.TaxRate = 100.00 or P_StRpTaxReturn.TaxRate = -100.00 ) then cast(cast(-P_StRpTaxReturn.TaxRate as abap.dec(11,2)) as char16) else case when _GetNVV.AccountingDocument is not null or _GetNVV.AccountingDocument <> '' then cast(cast(_GetNVV.TaxRate + P_StRpTaxReturn.TaxRate as abap.dec(11,2)) as char16) else case when P_StRpTaxReturn.TaxRate < 0 then cast(cast(-P_StRpTaxReturn.TaxRate as abap.dec(11,2)) as char16) else cast(cast(P_StRpTaxReturn.TaxRate as abap.dec(11,2)) as char16) end end end as IPITaxRate AS dec112aschar16endendendasIPITaxRate,
  P_StRpTaxReturn.TaxRate AS AdditionalTax1Rate,
  P_ConditionsItem.ConditionAmount AS ConditionAmount,
  case when P_StRpTaxReturn.Customer <> '' and P_StRpTaxReturn.Customer <> ' ' then P_StRpTaxReturn.Customer else I_BillingDocument.PayerParty end as Customer AS PayerPartyendasCustomer,
  GLAccount,
  TaxItemGroup,
  BusinessPlace,
  TaxJurisdiction,
  LowestLevelTaxJurisdiction,
  P_StRpTaxReturn.AccountingDocumentType AS AccountingDocumentType,
  ReferenceDocumentType,
  ReverseDocument,
  ReverseDocumentFiscalYear,
  P_StRpTaxReturn.ConditionRecord AS ConditionRecord,
  RoundingDecimalPlaces,
  P_StRpTaxReturn.DocumentReferenceID AS DocumentReferenceID,
  Ledger,
  LedgerGroup,
  PostingDate,
  DocumentDate,
  TaxReportingDate,
  P_StRpTaxReturn.ReportingDate AS ReportingDate,
  P_StRpTaxReturn.FiscalPeriod AS FiscalPeriod,
  ExchangeRate,
  IsReversal,
  IsReversed,
  AccountingDocumentHeaderText,
  CompanyCodeCountry,
  ReportingCountry,
  TaxReturnCountry,
  TaxCountry,
  CompanyCodeCurrency,
  CountryCurrency,
  DocumentCurrency,
  ReportingCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  TaxBaseAmountInRptgCrcy,
  TaxAmountInRptgCrcy,
  P_StRpTaxReturn.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  P_StRpTaxReturn.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  P_StRpTaxReturn.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  P_StRpTaxReturn.TaxAmount AS TaxAmount,
  TaxBaseAmountInCountryCrcy,
  TaxAmountInCountryCrcy,
  TaxBaseAmtInAdditionalCrcy1,
  TaxBaseAmtInAdditionalCrcy2,
  TaxAmountInAdditionalCurrency1,
  TaxAmountInAdditionalCurrency2,
  CalculatedTxAmtInCoCodeCrcy - P_StRpTaxReturn.TaxAmountInCoCodeCrcy AS DifferenceTaxAmtInCoCodeCrcy,
  CalcdTxBaseAmtInCoCodeCrcy - P_StRpTaxReturn.TaxBaseAmountInCoCodeCrcy AS DiffTaxBaseAmountInCoCodeCrcy,
  TaxType,
  TargetTaxCode,
  TaxNumber1,
  TaxNumber2,
  ActiveTaxType,
  TaxNumber3,
  NmbrOfChmlCmplncMktCountries,
  BusinessPartner,
  cast (P_StRpTaxReturn.TaxAmountInCoCodeCrcy as deductible_amt) AS DcblVATIncrdCostInRptgCrcy,
  BusinessPartnerName,
  CustomerSupplierAddress,
  P_StRpTaxReturn.TaxIsNotDeductible AS TaxIsNotDeductible,
  SupplierAccountGroup,
  ConditionType,
  P_StRpTaxReturn._AccountingDocument AS _AccountingDocument
LEFT OUTER JOIN P_ConditionsItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BillingDocument ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_CountCountry ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_GetNonDeductibleDocItem AS _GetNVV ON /* join condition not captured in parsed metadata */
;

Depth:

P_StRpTaxReturnBox view