P_TH_STRPTAXCURRADAPT

DDL: P_TH_STRPTAXCURRADAPT Type: view_entity COMPOSITE
71 Fields 1 Data Sources

P_TH_STRPTAXCURRADAPT is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_StRpTaxReturnBoxCube) and exposes 71 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem, TaxCode.

Data Sources (1)

SourceAliasJoin Type
I_StRpTaxReturnBoxCube I_StRpTaxReturnBoxCube from

Parameters (5)

NameTypeDefault
P_RelevantAmountPosition relevantamountposition
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id
P_ReportingCountry land1

Annotations (8)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
Metadata.ignorePropagatedAnnotations true view

Fields (71)

KeyFieldSource TableSource FieldDescription
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 TaxBox Tax.Bs.Gp.No.
KEY TaxDeclnAmountType TaxDeclnAmountType
KEY TaxItemGroupingVersion I_StRpTaxReturnBoxCube TaxItemGroupingVersion Tax Grping Ver.
KEY TaxBoxStrucValidityStartDate TaxBoxStrucValidityStartDate
KEY TaxBoxStructureType TaxBoxStructureType
KEY TaxGroup TaxGroup Tax Group
AlternativeReferenceDocument I_StRpTaxReturnBoxCube AlternativeReferenceDocument Alternative Reference Document
TaxBoxStructure TaxBoxStructure
TaxBoxStrucValidityEndDate TaxBoxStrucValidityEndDate
TaxCalculationProcedure I_StRpTaxReturnBoxCube TaxCalculationProcedure Tax Procedure
ReportingDate 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
DocumentReferenceID I_StRpTaxReturnBoxCube DocumentReferenceID Reference
CompanyCodeCountry CompanyCodeCountry Reporting Ctry/Reg.
ReportingCountry ReportingCountry
TaxReturnCountry TaxReturnCountry Reporting C/R
BusinessPartnerCountry BusinessPartnerCountry BP Ctry/Reg.
ExchangeRate ExchangeRate Exchange rate
TaxRate
TaxRateValidityStartDate I_StRpTaxReturnBoxCube TaxRateValidityStartDate Tax Rate Validity Start Date
IsReversal IsReversal Reversal doc.
IsReversed IsReversed Reversed?
AccountingDocumentHeaderText AccountingDocumentHeaderText Doc.Header Text
GLAccount I_StRpTaxReturnBoxCube GLAccount General Ledger
BusinessPlace I_StRpTaxReturnBoxCube BusinessPlace Business place
TaxJurisdiction I_StRpTaxReturnBoxCube TaxJurisdiction Tax Jurisdiction
LowestLevelTaxJurisdiction LowestLevelTaxJurisdiction Jurisdict. Code
TaxNumber1 TaxNumber1 VAT Reg. No.
TaxNumber2 TaxNumber2 Tax Number 2
TaxNumber3 TaxNumber3
BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerName BusinessPartnerName Extracted Customer Name
CustomerSupplierAddress CustomerSupplierAddress
TaxType I_StRpTaxReturnBoxCube TaxType Tax Type
CompanyCodeCurrency I_StRpTaxReturnBoxCube CompanyCodeCurrency Local Currency
CountryCurrency CountryCurrency Currency
DocumentCurrency DocumentCurrency Document Currency
ReportingCurrencyendasReportingCurrency
NonDeductibleInputTaxAmount I_StRpTaxReturnBoxCube NonDeductibleInputTaxAmount Non-deductible
AdditionalCurrency1 I_StRpTaxReturnBoxCube AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 I_StRpTaxReturnBoxCube AdditionalCurrency2 Local curr. 3
AmountInTransactionCurrency
TaxBaseAmountInCoCodeCrcy
TaxAmountInCoCodeCrcy
TaxBaseAmountInTransCrcy
TaxAmount I_StRpTaxReturnBoxCube TaxAmount Tax Amt in Rptg Crcy
AmountInAdditionalCurrency1 I_StRpTaxReturnBoxCube AmountInAdditionalCurrency1 Amount in Additional Currency 1
AmountInAdditionalCurrency2 I_StRpTaxReturnBoxCube AmountInAdditionalCurrency2 LC2 Amount
TaxBaseAmtInAdditionalCrcy1 TaxBaseAmtInAdditionalCrcy1 LC 2 Base
TaxBaseAmtInAdditionalCrcy2 TaxBaseAmtInAdditionalCrcy2 LC 3 Base
TaxAmountInAdditionalCurrency1 TaxAmountInAdditionalCurrency1 LC 2 Tax
TaxAmountInAdditionalCurrency2 TaxAmountInAdditionalCurrency2 LC 3 Tax
TaxIsNotDeductible TaxIsNotDeductible Non-Deductible
AddressID
_AccountingDocument _AccountingDocument
_GLAccount I_StRpTaxReturnBoxCube _GLAccount
_TaxJurisdiction _TaxJurisdiction
_ReceivablesPayablesItem _ReceivablesPayablesItem
_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_STRPTAXCURRADAPT.
-- 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.
-- 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_STRPTAXCURRADAPT 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,
  TaxBox,
  TaxDeclnAmountType,
  I_StRpTaxReturnBoxCube.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  TaxBoxStrucValidityStartDate,
  TaxBoxStructureType,
  TaxGroup,
  I_StRpTaxReturnBoxCube.AlternativeReferenceDocument AS AlternativeReferenceDocument,
  TaxBoxStructure,
  TaxBoxStrucValidityEndDate,
  I_StRpTaxReturnBoxCube.TaxCalculationProcedure AS TaxCalculationProcedure,
  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.DocumentReferenceID AS DocumentReferenceID,
  CompanyCodeCountry,
  ReportingCountry,
  TaxReturnCountry,
  BusinessPartnerCountry,
  ExchangeRate,
  cast( I_StRpTaxReturnBoxCube.TaxRate as btaux ) AS TaxRate,
  I_StRpTaxReturnBoxCube.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  IsReversal,
  IsReversed,
  AccountingDocumentHeaderText,
  I_StRpTaxReturnBoxCube.GLAccount AS GLAccount,
  I_StRpTaxReturnBoxCube.BusinessPlace AS BusinessPlace,
  I_StRpTaxReturnBoxCube.TaxJurisdiction AS TaxJurisdiction,
  LowestLevelTaxJurisdiction,
  TaxNumber1,
  TaxNumber2,
  TaxNumber3,
  BusinessPartner,
  BusinessPartnerName,
  CustomerSupplierAddress,
  I_StRpTaxReturnBoxCube.TaxType AS TaxType,
  I_StRpTaxReturnBoxCube.CompanyCodeCurrency AS CompanyCodeCurrency,
  CountryCurrency,
  DocumentCurrency,
  case $parameters.P_RelevantAmountPosition when '2' then AdditionalCurrency1 when '3' then AdditionalCurrency2 when 'C' then I_StRpTaxReturnBoxCube.CountryCurrency else I_StRpTaxReturnBoxCube.ReportingCurrency end as ReportingCurrency AS ReportingCurrencyendasReportingCurrency,
  I_StRpTaxReturnBoxCube.NonDeductibleInputTaxAmount AS NonDeductibleInputTaxAmount,
  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,
  I_StRpTaxReturnBoxCube.TaxAmount AS TaxAmount,
  I_StRpTaxReturnBoxCube.AmountInAdditionalCurrency1 AS AmountInAdditionalCurrency1,
  I_StRpTaxReturnBoxCube.AmountInAdditionalCurrency2 AS AmountInAdditionalCurrency2,
  TaxBaseAmtInAdditionalCrcy1,
  TaxBaseAmtInAdditionalCrcy2,
  TaxAmountInAdditionalCurrency1,
  TaxAmountInAdditionalCurrency2,
  TaxIsNotDeductible,
  I_StRpTaxReturnBoxCube._AccountingDocument._CompanyCode.AddressID AS AddressID,
  I_StRpTaxReturnBoxCube._GLAccount AS _GLAccount
FROM I_StRpTaxReturnBoxCube
;

Learn More