C_SA_StRpTaxItemCube

DDL: C_SA_STRPTAXITEMCUBE SQL: CSASRTAXITEMC Type: view CONSUMPTION
85 Fields 2 Data Sources

Tax Item view for ACR Saudi Arabia

C_SA_StRpTaxItemCube is a Consumption CDS View (Cube) that provides data about "Tax Item view for ACR Saudi Arabia" in SAP S/4HANA. It reads from 2 data sources (C_SA_StRpTaxItemGrouping, C_SA_StRpTaxItemWthRefAcctgDoc) and exposes 85 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem, StatryRptgEntity.

Data Sources (2)

SourceAliasJoin Type
C_SA_StRpTaxItemGrouping C_SA_StRpTaxItemGrouping inner
C_SA_StRpTaxItemWthRefAcctgDoc C_SA_StRpTaxItemWthRefAcctgDoc from

Parameters (2)

NameTypeDefault
P_TaxReportingFromDate vatdate
P_AdjustmentDocumentIsDerived glo_derive_adjustment

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CSASRTAXITEMC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
Analytics.dataCategory #CUBE 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
EndUserText.label Tax Item view for ACR Saudi Arabia view
Metadata.allowExtensions true view

Fields (85)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode C_SA_StRpTaxItemWthRefAcctgDoc CompanyCode Receiver Company Code
KEY AccountingDocument C_SA_StRpTaxItemWthRefAcctgDoc AccountingDocument Journal Entry
KEY FiscalYear C_SA_StRpTaxItemWthRefAcctgDoc FiscalYear G/L Fiscal Year
KEY TaxItem C_SA_StRpTaxItemWthRefAcctgDoc TaxItem Tax Item
KEY StatryRptgEntity
KEY StatryRptCategory
KEY StatryRptRunID
KEY DebitCreditCode C_SA_StRpTaxItemWthRefAcctgDoc DebitCreditCode Single-Character Flag
KEY TaxBoxendasTaxBox
KEY TaxDeclnAmountType C_SA_StRpTaxItemGrouping TaxDeclnAmountType
KEY TaxItemGroupingVersion C_SA_StRpTaxItemGrouping TaxItemGroupingVersion Tax Grping Ver.
KEY TransactionTypeDetermination C_SA_StRpTaxItemWthRefAcctgDoc TransactionTypeDetermination Transaction Key
KEY SupplierAccountGroup C_SA_StRpTaxItemGrouping SupplierAccountGroup Account group
TaxCode C_SA_StRpTaxItemWthRefAcctgDoc TaxCode Tax Code
TaxType C_SA_StRpTaxItemWthRefAcctgDoc TaxType Tax Type
TaxRate
GLAccount C_SA_StRpTaxItemWthRefAcctgDoc GLAccount General Ledger
TaxItemGroup C_SA_StRpTaxItemWthRefAcctgDoc TaxItemGroup Tax doc. item number
BusinessPlace C_SA_StRpTaxItemWthRefAcctgDoc BusinessPlace Business place
TaxJurisdiction C_SA_StRpTaxItemWthRefAcctgDoc TaxJurisdiction Tax Jurisdiction
LowestLevelTaxJurisdiction C_SA_StRpTaxItemWthRefAcctgDoc LowestLevelTaxJurisdiction Jurisdict. Code
AccountingDocumentType C_SA_StRpTaxItemWthRefAcctgDoc AccountingDocumentType Journal Entry Type
ReferenceDocumentType C_SA_StRpTaxItemWthRefAcctgDoc ReferenceDocumentType Reference Document Type
ReverseDocument C_SA_StRpTaxItemWthRefAcctgDoc ReverseDocument Reversed With
ReverseDocumentFiscalYear C_SA_StRpTaxItemWthRefAcctgDoc ReverseDocumentFiscalYear Year
DocumentReferenceID C_SA_StRpTaxItemWthRefAcctgDoc DocumentReferenceID Reference
Ledger C_SA_StRpTaxItemWthRefAcctgDoc Ledger Ledger
LedgerGroup C_SA_StRpTaxItemWthRefAcctgDoc LedgerGroup Ledger Group
PostingDate C_SA_StRpTaxItemWthRefAcctgDoc PostingDate Posting Date for GR
ReportingDate C_SA_StRpTaxItemWthRefAcctgDoc ReportingDate
DocumentDate C_SA_StRpTaxItemWthRefAcctgDoc DocumentDate Journal Entry Date
TaxReportingDate C_SA_StRpTaxItemWthRefAcctgDoc TaxReportingDate Tax Reporting Date
FiscalPeriod C_SA_StRpTaxItemWthRefAcctgDoc FiscalPeriod Tax period
ExchangeRate C_SA_StRpTaxItemWthRefAcctgDoc ExchangeRate Exchange rate
IsReversal C_SA_StRpTaxItemWthRefAcctgDoc IsReversal Reversal doc.
IsReversed C_SA_StRpTaxItemWthRefAcctgDoc IsReversed Reversed?
AccountingDocumentHeaderText C_SA_StRpTaxItemWthRefAcctgDoc AccountingDocumentHeaderText Doc.Header Text
CompanyCodeCountry C_SA_StRpTaxItemWthRefAcctgDoc CompanyCodeCountry Reporting Ctry/Reg.
ReportingCountry C_SA_StRpTaxItemWthRefAcctgDoc ReportingCountry
TaxReturnCountry C_SA_StRpTaxItemWthRefAcctgDoc TaxReturnCountry Reporting C/R
CompanyCodeCurrency C_SA_StRpTaxItemWthRefAcctgDoc CompanyCodeCurrency Local Currency
CountryCurrency C_SA_StRpTaxItemWthRefAcctgDoc CountryCurrency Currency
DocumentCurrency C_SA_StRpTaxItemWthRefAcctgDoc DocumentCurrency Document Currency
ReportingCurrency C_SA_StRpTaxItemWthRefAcctgDoc ReportingCurrency Currency
AdditionalCurrency1 C_SA_StRpTaxItemWthRefAcctgDoc AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 C_SA_StRpTaxItemWthRefAcctgDoc AdditionalCurrency2 Local curr. 3
TaxBaseAmountInRptgCrcy TaxBaseAmountInRptgCrcy Base Amount
TaxAmountInRptgCrcy TaxAmountInRptgCrcy Tax Rept. Crcy
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy Value-Added Tax
TaxAmount 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
TaxCalculationProcedure TaxCalculationProcedure Tax Procedure
TargetTaxCode TargetTaxCode
TaxNumber1 TaxNumber1 VAT Reg. No.
TaxNumber2 TaxNumber2 Tax Number 2
BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerName BusinessPartnerName Extracted Customer Name
CustomerSupplierAddress CustomerSupplierAddress
ReferenceDocumentNumber ReferenceDocumentNumber
ReferenceDocumentFiscalYear ReferenceDocumentFiscalYear Year Cur.Period
BillingDocument BillingDocument SD Document
ReferenceSDDocument ReferenceSDDocument Reference Doc.
RefAccountingDocument RefAccountingDocument Document Number
RefAccountingDocumentPostgDate RefAccountingDocumentPostgDate
TaxCountry TaxCountry Tax Ctry/Reg.
TaxBoxStrucValidityStartDate C_SA_StRpTaxItemGrouping TaxBoxStrucValidityStartDate Vers.Valid From
TaxBoxStrucValidityEndDate C_SA_StRpTaxItemGrouping TaxBoxStrucValidityEndDate Vers.Valid To
TaxRateValidityStartDate C_SA_StRpTaxItemGrouping TaxRateValidityStartDate Tax Rate Validity Start Date
TaxRateValidityEndDate C_SA_StRpTaxItemGrouping TaxRateValidityEndDate
_ReportingCurrency _ReportingCurrency
_AccountingDocument _AccountingDocument
_TaxJurisdiction _TaxJurisdiction
_DebtorCreditorRblsPyblsItem _DebtorCreditorRblsPyblsItem
_ReceivablesPayablesItem _ReceivablesPayablesItem
_TaxReceivablesPayablesItem _TaxReceivablesPayablesItem
_TaxTypeText _TaxTypeText
_ReportedItemsLog _ReportedItemsLog
_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 C_SA_StRpTaxItemCube.
-- 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: CSASRTAXITEMC
-- Parameters: P_TaxReportingFromDate : vatdate, P_AdjustmentDocumentIsDerived : glo_derive_adjustment

CREATE VIEW C_SA_StRpTaxItemCube AS
SELECT
  C_SA_StRpTaxItemWthRefAcctgDoc.CompanyCode AS CompanyCode,
  C_SA_StRpTaxItemWthRefAcctgDoc.AccountingDocument AS AccountingDocument,
  C_SA_StRpTaxItemWthRefAcctgDoc.FiscalYear AS FiscalYear,
  C_SA_StRpTaxItemWthRefAcctgDoc.TaxItem AS TaxItem,
  C_SA_StRpTaxItemWthRefAcctgDoc._ReportedItemsLog.StatryRptgEntity AS StatryRptgEntity,
  C_SA_StRpTaxItemWthRefAcctgDoc._ReportedItemsLog.StatryRptCategory AS StatryRptCategory,
  C_SA_StRpTaxItemWthRefAcctgDoc._ReportedItemsLog.StatryRptRunID AS StatryRptRunID,
  C_SA_StRpTaxItemWthRefAcctgDoc.DebitCreditCode AS DebitCreditCode,
  case $parameters.P_AdjustmentDocumentIsDerived when 'X' then case when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '12' then '22' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '14' then '24' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '32' then '42' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '34' then '44' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '05' then '06' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '11' then '21' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '13' then '23' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '31' then '41' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '33' then '43' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '15' then '25' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '16' then '26' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '17' then '27' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '18' then '28' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '35' then '45' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '36' then '46' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '37' then '47' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '38' then '48' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '10' then '20' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '30' then '40' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '52' then '62' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '54' then '64' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '72' then '82' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '74' then '84' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '56' then '66' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '76' then '86' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '55' then '65' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '75' then '85' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '51' then '61' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '53' then '63' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '71' then '81' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '73' then '83' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '50' then '60' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '70' then '80' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '01' then '03' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '02' then '04' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '90' then '91' when C_SA_StRpTaxItemWthRefAcctgDoc.RefAccountingDocumentPostgDate < $parameters.P_TaxReportingFromDate and C_SA_StRpTaxItemGrouping.TaxBox = '92' then '93' else C_SA_StRpTaxItemGrouping.TaxBox end else C_SA_StRpTaxItemGrouping.TaxBox end as TaxBox AS TaxBoxendasTaxBox,
  C_SA_StRpTaxItemGrouping.TaxDeclnAmountType AS TaxDeclnAmountType,
  C_SA_StRpTaxItemGrouping.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  C_SA_StRpTaxItemWthRefAcctgDoc.TransactionTypeDetermination AS TransactionTypeDetermination,
  C_SA_StRpTaxItemGrouping.SupplierAccountGroup AS SupplierAccountGroup,
  C_SA_StRpTaxItemWthRefAcctgDoc.TaxCode AS TaxCode,
  C_SA_StRpTaxItemWthRefAcctgDoc.TaxType AS TaxType,
  cast(cast(C_SA_StRpTaxItemWthRefAcctgDoc.TaxRate as abap.dec(11,2)) as char13) AS TaxRate,
  C_SA_StRpTaxItemWthRefAcctgDoc.GLAccount AS GLAccount,
  C_SA_StRpTaxItemWthRefAcctgDoc.TaxItemGroup AS TaxItemGroup,
  C_SA_StRpTaxItemWthRefAcctgDoc.BusinessPlace AS BusinessPlace,
  C_SA_StRpTaxItemWthRefAcctgDoc.TaxJurisdiction AS TaxJurisdiction,
  C_SA_StRpTaxItemWthRefAcctgDoc.LowestLevelTaxJurisdiction AS LowestLevelTaxJurisdiction,
  C_SA_StRpTaxItemWthRefAcctgDoc.AccountingDocumentType AS AccountingDocumentType,
  C_SA_StRpTaxItemWthRefAcctgDoc.ReferenceDocumentType AS ReferenceDocumentType,
  C_SA_StRpTaxItemWthRefAcctgDoc.ReverseDocument AS ReverseDocument,
  C_SA_StRpTaxItemWthRefAcctgDoc.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  C_SA_StRpTaxItemWthRefAcctgDoc.DocumentReferenceID AS DocumentReferenceID,
  C_SA_StRpTaxItemWthRefAcctgDoc.Ledger AS Ledger,
  C_SA_StRpTaxItemWthRefAcctgDoc.LedgerGroup AS LedgerGroup,
  C_SA_StRpTaxItemWthRefAcctgDoc.PostingDate AS PostingDate,
  C_SA_StRpTaxItemWthRefAcctgDoc.ReportingDate AS ReportingDate,
  C_SA_StRpTaxItemWthRefAcctgDoc.DocumentDate AS DocumentDate,
  C_SA_StRpTaxItemWthRefAcctgDoc.TaxReportingDate AS TaxReportingDate,
  C_SA_StRpTaxItemWthRefAcctgDoc.FiscalPeriod AS FiscalPeriod,
  C_SA_StRpTaxItemWthRefAcctgDoc.ExchangeRate AS ExchangeRate,
  C_SA_StRpTaxItemWthRefAcctgDoc.IsReversal AS IsReversal,
  C_SA_StRpTaxItemWthRefAcctgDoc.IsReversed AS IsReversed,
  C_SA_StRpTaxItemWthRefAcctgDoc.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  C_SA_StRpTaxItemWthRefAcctgDoc.CompanyCodeCountry AS CompanyCodeCountry,
  C_SA_StRpTaxItemWthRefAcctgDoc.ReportingCountry AS ReportingCountry,
  C_SA_StRpTaxItemWthRefAcctgDoc.TaxReturnCountry AS TaxReturnCountry,
  C_SA_StRpTaxItemWthRefAcctgDoc.CompanyCodeCurrency AS CompanyCodeCurrency,
  C_SA_StRpTaxItemWthRefAcctgDoc.CountryCurrency AS CountryCurrency,
  C_SA_StRpTaxItemWthRefAcctgDoc.DocumentCurrency AS DocumentCurrency,
  C_SA_StRpTaxItemWthRefAcctgDoc.ReportingCurrency AS ReportingCurrency,
  C_SA_StRpTaxItemWthRefAcctgDoc.AdditionalCurrency1 AS AdditionalCurrency1,
  C_SA_StRpTaxItemWthRefAcctgDoc.AdditionalCurrency2 AS AdditionalCurrency2,
  TaxBaseAmountInRptgCrcy,
  TaxAmountInRptgCrcy,
  TaxBaseAmountInCoCodeCrcy,
  TaxAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  TaxAmount,
  TaxBaseAmountInCountryCrcy,
  TaxAmountInCountryCrcy,
  TaxBaseAmtInAdditionalCrcy1,
  TaxBaseAmtInAdditionalCrcy2,
  TaxAmountInAdditionalCurrency1,
  TaxAmountInAdditionalCurrency2,
  TaxCalculationProcedure,
  TargetTaxCode,
  TaxNumber1,
  TaxNumber2,
  BusinessPartner,
  BusinessPartnerName,
  CustomerSupplierAddress,
  ReferenceDocumentNumber,
  ReferenceDocumentFiscalYear,
  BillingDocument,
  ReferenceSDDocument,
  RefAccountingDocument,
  RefAccountingDocumentPostgDate,
  TaxCountry,
  C_SA_StRpTaxItemGrouping.TaxBoxStrucValidityStartDate AS TaxBoxStrucValidityStartDate,
  C_SA_StRpTaxItemGrouping.TaxBoxStrucValidityEndDate AS TaxBoxStrucValidityEndDate,
  C_SA_StRpTaxItemGrouping.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  C_SA_StRpTaxItemGrouping.TaxRateValidityEndDate AS TaxRateValidityEndDate
FROM C_SA_StRpTaxItemWthRefAcctgDoc
INNER JOIN C_SA_StRpTaxItemGrouping ON /* join condition not captured in parsed metadata */
;

Learn More