C_OM_StRpTaxItemCube

DDL: C_OM_STRPTAXITEMCUBE SQL: COMSRTAXITEMCUBE Type: view CONSUMPTION
149 Fields 4 Data Sources

Tax Items With Tax Box Grouping - Cube

C_OM_StRpTaxItemCube is a Consumption CDS View (Cube) that provides data about "Tax Items With Tax Box Grouping - Cube" in SAP S/4HANA. It reads from 4 data sources (I_StRpTaxItemGrouping, I_StRpTaxItemGrouping, C_OM_StRpTaxItemWithRefDoc, C_OM_StRpTaxItemWithRefDoc) and exposes 149 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem, StatryRptgEntity.

Data Sources (4)

SourceAliasJoin Type
I_StRpTaxItemGrouping I_StRpTaxItemGrouping inner
I_StRpTaxItemGrouping I_StRpTaxItemGrouping inner
C_OM_StRpTaxItemWithRefDoc item from
C_OM_StRpTaxItemWithRefDoc item union_all

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName COMSRTAXITEMCUBE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey 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 #X view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
Analytics.internalName #LOCAL view
Metadata.allowExtensions true view
EndUserText.label Tax Items With Tax Box Grouping - Cube view

Fields (149)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode C_OM_StRpTaxItemWithRefDoc CompanyCode Receiver Company Code
KEY AccountingDocument C_OM_StRpTaxItemWithRefDoc AccountingDocument Journal Entry
KEY FiscalYear C_OM_StRpTaxItemWithRefDoc FiscalYear G/L Fiscal Year
KEY TaxItem C_OM_StRpTaxItemWithRefDoc TaxItem Tax Item
KEY StatryRptgEntity
KEY StatryRptCategory
KEY StatryRptRunID
KEY DebitCreditCode C_OM_StRpTaxItemWithRefDoc DebitCreditCode Single-Character Flag
KEY TaxBox I_StRpTaxItemGrouping TaxBox Tax.Bs.Gp.No.
KEY TaxCode C_OM_StRpTaxItemWithRefDoc TaxCode Tax Code
KEY TransactionTypeDetermination C_OM_StRpTaxItemWithRefDoc TransactionTypeDetermination Transaction Key
KEY TaxDeclnAmountType I_StRpTaxItemGrouping TaxDeclnAmountType
KEY TaxItemGroupingVersion I_StRpTaxItemGrouping TaxItemGroupingVersion Tax Grping Ver.
KEY SupplierAccountGroup I_StRpTaxItemGrouping SupplierAccountGroup Account group
TaxBoxthenXendasItemIsReportingRelevant
TaxType C_OM_StRpTaxItemWithRefDoc TaxType Tax Type
TaxRate C_OM_StRpTaxItemWithRefDoc TaxRate Tax Rate
GLAccount C_OM_StRpTaxItemWithRefDoc GLAccount General Ledger
TaxItemGroup C_OM_StRpTaxItemWithRefDoc TaxItemGroup Tax doc. item number
BusinessPlace C_OM_StRpTaxItemWithRefDoc BusinessPlace Business place
TaxJurisdiction C_OM_StRpTaxItemWithRefDoc TaxJurisdiction Tax Jurisdiction
AccountingDocumentType C_OM_StRpTaxItemWithRefDoc AccountingDocumentType Journal Entry Type
FinancialAccountType C_OM_StRpTaxItemWithRefDoc FinancialAccountType Fin. Account Type
ReferenceDocumentType C_OM_StRpTaxItemWithRefDoc ReferenceDocumentType Reference Document Type
ReverseDocument C_OM_StRpTaxItemWithRefDoc ReverseDocument Reversed With
ReverseDocumentFiscalYear C_OM_StRpTaxItemWithRefDoc ReverseDocumentFiscalYear Year
DocumentReferenceID C_OM_StRpTaxItemWithRefDoc DocumentReferenceID Reference
PostingDate C_OM_StRpTaxItemWithRefDoc PostingDate Posting Date for GR
DocumentDate C_OM_StRpTaxItemWithRefDoc DocumentDate Journal Entry Date
TaxReportingDate C_OM_StRpTaxItemWithRefDoc TaxReportingDate Tax Reporting Date
FiscalPeriod C_OM_StRpTaxItemWithRefDoc FiscalPeriod Tax period
IsReversal C_OM_StRpTaxItemWithRefDoc IsReversal Reversal doc.
IsReversed C_OM_StRpTaxItemWithRefDoc IsReversed Reversed?
AccountingDocumentHeaderText C_OM_StRpTaxItemWithRefDoc AccountingDocumentHeaderText Doc.Header Text
CompanyCodeCountry C_OM_StRpTaxItemWithRefDoc CompanyCodeCountry Reporting Ctry/Reg.
ReportingCountry C_OM_StRpTaxItemWithRefDoc ReportingCountry
TaxReturnCountry C_OM_StRpTaxItemWithRefDoc TaxReturnCountry Reporting C/R
ReportingDate C_OM_StRpTaxItemWithRefDoc ReportingDate
CompanyCodeCurrency C_OM_StRpTaxItemWithRefDoc CompanyCodeCurrency Local Currency
CountryCurrency C_OM_StRpTaxItemWithRefDoc CountryCurrency Currency
DocumentCurrency C_OM_StRpTaxItemWithRefDoc DocumentCurrency Document Currency
ReportingCurrency C_OM_StRpTaxItemWithRefDoc ReportingCurrency Currency
AdditionalCurrency1 C_OM_StRpTaxItemWithRefDoc AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 C_OM_StRpTaxItemWithRefDoc AdditionalCurrency2 Local curr. 3
TaxBaseAmountInRptgCrcy C_OM_StRpTaxItemWithRefDoc TaxBaseAmountInRptgCrcy Base Amount
TaxAmountInRptgCrcy C_OM_StRpTaxItemWithRefDoc TaxAmountInRptgCrcy Tax Rept. Crcy
TaxBaseAmountInCoCodeCrcy C_OM_StRpTaxItemWithRefDoc TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxAmountInCoCodeCrcy C_OM_StRpTaxItemWithRefDoc TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxBaseAmountInTransCrcy C_OM_StRpTaxItemWithRefDoc TaxBaseAmountInTransCrcy Value-Added Tax
TaxAmount C_OM_StRpTaxItemWithRefDoc TaxAmount Tax Amt in Rptg Crcy
TaxBaseAmountInCountryCrcy C_OM_StRpTaxItemWithRefDoc TaxBaseAmountInCountryCrcy Base Amount
TaxAmountInCountryCrcy C_OM_StRpTaxItemWithRefDoc TaxAmountInCountryCrcy Tax Rept. Crcy
TaxBaseAmtInAdditionalCrcy1 C_OM_StRpTaxItemWithRefDoc TaxBaseAmtInAdditionalCrcy1 LC 2 Base
TaxBaseAmtInAdditionalCrcy2 C_OM_StRpTaxItemWithRefDoc TaxBaseAmtInAdditionalCrcy2 LC 3 Base
TaxAmountInAdditionalCurrency1 C_OM_StRpTaxItemWithRefDoc TaxAmountInAdditionalCurrency1 LC 2 Tax
TaxAmountInAdditionalCurrency2 C_OM_StRpTaxItemWithRefDoc TaxAmountInAdditionalCurrency2 LC 3 Tax
TaxCalculationProcedure C_OM_StRpTaxItemWithRefDoc TaxCalculationProcedure Tax Procedure
TargetTaxCode C_OM_StRpTaxItemWithRefDoc TargetTaxCode
EUTaxClassification C_OM_StRpTaxItemWithRefDoc EUTaxClassification
TaxNumber1 C_OM_StRpTaxItemWithRefDoc TaxNumber1 VAT Reg. No.
TaxNumber2 C_OM_StRpTaxItemWithRefDoc TaxNumber2 Tax Number 2
TaxNumber3 C_OM_StRpTaxItemWithRefDoc TaxNumber3
BusinessPartner C_OM_StRpTaxItemWithRefDoc BusinessPartner Issuing Authority
BusinessPartnerName C_OM_StRpTaxItemWithRefDoc BusinessPartnerName Extracted Customer Name
TaxIsNotDeductible C_OM_StRpTaxItemWithRefDoc TaxIsNotDeductible Non-Deductible
MiniOneStopShopTxRptgCntry C_OM_StRpTaxItemWithRefDoc MiniOneStopShopTxRptgCntry
RefAccountingDocument C_OM_StRpTaxItemWithRefDoc RefAccountingDocument Document Number
BillingDocument
ReferenceDocumentNumber
DebitCreditCodeIsChanged C_OM_StRpTaxItemWithRefDoc DebitCreditCodeIsChanged
TaxCountry C_OM_StRpTaxItemWithRefDoc TaxCountry Tax Ctry/Reg.
TaxRateValidityStartDate C_OM_StRpTaxItemWithRefDoc TaxRateValidityStartDate Tax Rate Validity Start Date
TaxBoxStrucValidityStartDate I_StRpTaxItemGrouping TaxBoxStrucValidityStartDate Vers.Valid From
TaxBoxStrucValidityEndDate I_StRpTaxItemGrouping TaxBoxStrucValidityEndDate Vers.Valid To
CompanyCode Receiver Company Code
KEY AccountingDocument C_OM_StRpTaxItemWithRefDoc AccountingDocument Journal Entry
KEY FiscalYear C_OM_StRpTaxItemWithRefDoc FiscalYear G/L Fiscal Year
KEY TaxItem C_OM_StRpTaxItemWithRefDoc TaxItem Tax Item
KEY StatryRptgEntity
KEY StatryRptCategory
KEY StatryRptRunID
KEY DebitCreditCode C_OM_StRpTaxItemWithRefDoc DebitCreditCode Single-Character Flag
KEY TaxBoxendasTaxBox
KEY TaxCode C_OM_StRpTaxItemWithRefDoc TaxCode Tax Code
KEY TransactionTypeDetermination C_OM_StRpTaxItemWithRefDoc TransactionTypeDetermination Transaction Key
KEY TaxDeclnAmountType I_StRpTaxItemGrouping TaxDeclnAmountType
KEY TaxItemGroupingVersion I_StRpTaxItemGrouping TaxItemGroupingVersion Tax Grping Ver.
KEY SupplierAccountGroup I_StRpTaxItemGrouping SupplierAccountGroup Account group
TaxBoxthenXendasItemIsReportingRelevant
TaxType C_OM_StRpTaxItemWithRefDoc TaxType Tax Type
TaxRate C_OM_StRpTaxItemWithRefDoc TaxRate Tax Rate
GLAccount C_OM_StRpTaxItemWithRefDoc GLAccount General Ledger
TaxItemGroup C_OM_StRpTaxItemWithRefDoc TaxItemGroup Tax doc. item number
BusinessPlace C_OM_StRpTaxItemWithRefDoc BusinessPlace Business place
TaxJurisdiction C_OM_StRpTaxItemWithRefDoc TaxJurisdiction Tax Jurisdiction
AccountingDocumentType C_OM_StRpTaxItemWithRefDoc AccountingDocumentType Journal Entry Type
FinancialAccountType C_OM_StRpTaxItemWithRefDoc FinancialAccountType Fin. Account Type
ReferenceDocumentType C_OM_StRpTaxItemWithRefDoc ReferenceDocumentType Reference Document Type
ReverseDocument C_OM_StRpTaxItemWithRefDoc ReverseDocument Reversed With
ReverseDocumentFiscalYear C_OM_StRpTaxItemWithRefDoc ReverseDocumentFiscalYear Year
DocumentReferenceID C_OM_StRpTaxItemWithRefDoc DocumentReferenceID Reference
PostingDate C_OM_StRpTaxItemWithRefDoc PostingDate Posting Date for GR
DocumentDate C_OM_StRpTaxItemWithRefDoc DocumentDate Journal Entry Date
TaxReportingDate C_OM_StRpTaxItemWithRefDoc TaxReportingDate Tax Reporting Date
FiscalPeriod C_OM_StRpTaxItemWithRefDoc FiscalPeriod Tax period
IsReversal C_OM_StRpTaxItemWithRefDoc IsReversal Reversal doc.
IsReversed C_OM_StRpTaxItemWithRefDoc IsReversed Reversed?
AccountingDocumentHeaderText C_OM_StRpTaxItemWithRefDoc AccountingDocumentHeaderText Doc.Header Text
CompanyCodeCountry C_OM_StRpTaxItemWithRefDoc CompanyCodeCountry Reporting Ctry/Reg.
ReportingCountry C_OM_StRpTaxItemWithRefDoc ReportingCountry
TaxReturnCountry C_OM_StRpTaxItemWithRefDoc TaxReturnCountry Reporting C/R
ReportingDate C_OM_StRpTaxItemWithRefDoc ReportingDate
CompanyCodeCurrency C_OM_StRpTaxItemWithRefDoc CompanyCodeCurrency Local Currency
CountryCurrency C_OM_StRpTaxItemWithRefDoc CountryCurrency Currency
DocumentCurrency C_OM_StRpTaxItemWithRefDoc DocumentCurrency Document Currency
ReportingCurrency C_OM_StRpTaxItemWithRefDoc ReportingCurrency Currency
AdditionalCurrency1 C_OM_StRpTaxItemWithRefDoc AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 C_OM_StRpTaxItemWithRefDoc AdditionalCurrency2 Local curr. 3
TaxBaseAmountInRptgCrcy C_OM_StRpTaxItemWithRefDoc TaxBaseAmountInRptgCrcy Base Amount
TaxAmountInRptgCrcy C_OM_StRpTaxItemWithRefDoc TaxAmountInRptgCrcy Tax Rept. Crcy
TaxBaseAmountInCoCodeCrcy C_OM_StRpTaxItemWithRefDoc TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxAmountInCoCodeCrcy C_OM_StRpTaxItemWithRefDoc TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxBaseAmountInTransCrcy C_OM_StRpTaxItemWithRefDoc TaxBaseAmountInTransCrcy Value-Added Tax
TaxAmount C_OM_StRpTaxItemWithRefDoc TaxAmount Tax Amt in Rptg Crcy
TaxBaseAmountInCountryCrcy C_OM_StRpTaxItemWithRefDoc TaxBaseAmountInCountryCrcy Base Amount
TaxAmountInCountryCrcy C_OM_StRpTaxItemWithRefDoc TaxAmountInCountryCrcy Tax Rept. Crcy
TaxBaseAmtInAdditionalCrcy1 C_OM_StRpTaxItemWithRefDoc TaxBaseAmtInAdditionalCrcy1 LC 2 Base
TaxBaseAmtInAdditionalCrcy2 C_OM_StRpTaxItemWithRefDoc TaxBaseAmtInAdditionalCrcy2 LC 3 Base
TaxAmountInAdditionalCurrency1 C_OM_StRpTaxItemWithRefDoc TaxAmountInAdditionalCurrency1 LC 2 Tax
TaxAmountInAdditionalCurrency2 C_OM_StRpTaxItemWithRefDoc TaxAmountInAdditionalCurrency2 LC 3 Tax
TaxCalculationProcedure C_OM_StRpTaxItemWithRefDoc TaxCalculationProcedure Tax Procedure
TargetTaxCode C_OM_StRpTaxItemWithRefDoc TargetTaxCode
EUTaxClassification C_OM_StRpTaxItemWithRefDoc EUTaxClassification
TaxNumber1 C_OM_StRpTaxItemWithRefDoc TaxNumber1 VAT Reg. No.
TaxNumber2 C_OM_StRpTaxItemWithRefDoc TaxNumber2 Tax Number 2
TaxNumber3 C_OM_StRpTaxItemWithRefDoc TaxNumber3
BusinessPartner C_OM_StRpTaxItemWithRefDoc BusinessPartner Issuing Authority
BusinessPartnerName C_OM_StRpTaxItemWithRefDoc BusinessPartnerName Extracted Customer Name
TaxIsNotDeductible C_OM_StRpTaxItemWithRefDoc TaxIsNotDeductible Non-Deductible
MiniOneStopShopTxRptgCntry C_OM_StRpTaxItemWithRefDoc MiniOneStopShopTxRptgCntry
RefAccountingDocument C_OM_StRpTaxItemWithRefDoc RefAccountingDocument Document Number
BillingDocument
ReferenceDocumentNumber
DebitCreditCodeIsChanged C_OM_StRpTaxItemWithRefDoc DebitCreditCodeIsChanged
TaxCountry C_OM_StRpTaxItemWithRefDoc TaxCountry Tax Ctry/Reg.
TaxRateValidityStartDate C_OM_StRpTaxItemWithRefDoc TaxRateValidityStartDate Tax Rate Validity Start Date
TaxBoxStrucValidityStartDate I_StRpTaxItemGrouping TaxBoxStrucValidityStartDate Vers.Valid From
TaxBoxStrucValidityEndDate I_StRpTaxItemGrouping TaxBoxStrucValidityEndDate Vers.Valid To
_ReportedItemsLog C_OM_StRpTaxItemWithRefDoc _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 C_OM_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: COMSRTAXITEMCUBE

CREATE VIEW C_OM_StRpTaxItemCube AS
SELECT
  item.CompanyCode AS CompanyCode,
  item.AccountingDocument AS AccountingDocument,
  item.FiscalYear AS FiscalYear,
  item.TaxItem AS TaxItem,
  item._ReportedItemsLog.StatryRptgEntity AS StatryRptgEntity,
  item._ReportedItemsLog.StatryRptCategory AS StatryRptCategory,
  item._ReportedItemsLog.StatryRptRunID AS StatryRptRunID,
  item.DebitCreditCode AS DebitCreditCode,
  I_StRpTaxItemGrouping.TaxBox AS TaxBox,
  item.TaxCode AS TaxCode,
  item.TransactionTypeDetermination AS TransactionTypeDetermination,
  I_StRpTaxItemGrouping.TaxDeclnAmountType AS TaxDeclnAmountType,
  I_StRpTaxItemGrouping.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  I_StRpTaxItemGrouping.SupplierAccountGroup AS SupplierAccountGroup,
  case when (DocType_config.TaxBox = '' or DocType_config.TaxBox is null) then 'X' when ( DocType_config.TaxBox = I_StRpTaxItemGrouping.TaxBox) then 'X' end as ItemIsReportingRelevant AS TaxBoxthenXendasItemIsReportingRelevant,
  item.TaxType AS TaxType,
  item.TaxRate AS TaxRate,
  item.GLAccount AS GLAccount,
  item.TaxItemGroup AS TaxItemGroup,
  item.BusinessPlace AS BusinessPlace,
  item.TaxJurisdiction AS TaxJurisdiction,
  item.AccountingDocumentType AS AccountingDocumentType,
  item.FinancialAccountType AS FinancialAccountType,
  item.ReferenceDocumentType AS ReferenceDocumentType,
  item.ReverseDocument AS ReverseDocument,
  item.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  item.DocumentReferenceID AS DocumentReferenceID,
  item.PostingDate AS PostingDate,
  item.DocumentDate AS DocumentDate,
  item.TaxReportingDate AS TaxReportingDate,
  item.FiscalPeriod AS FiscalPeriod,
  item.IsReversal AS IsReversal,
  item.IsReversed AS IsReversed,
  item.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  item.CompanyCodeCountry AS CompanyCodeCountry,
  item.ReportingCountry AS ReportingCountry,
  item.TaxReturnCountry AS TaxReturnCountry,
  item.ReportingDate AS ReportingDate,
  item.CompanyCodeCurrency AS CompanyCodeCurrency,
  item.CountryCurrency AS CountryCurrency,
  item.DocumentCurrency AS DocumentCurrency,
  item.ReportingCurrency AS ReportingCurrency,
  item.AdditionalCurrency1 AS AdditionalCurrency1,
  item.AdditionalCurrency2 AS AdditionalCurrency2,
  item.TaxBaseAmountInRptgCrcy AS TaxBaseAmountInRptgCrcy,
  item.TaxAmountInRptgCrcy AS TaxAmountInRptgCrcy,
  item.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  item.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  item.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  item.TaxAmount AS TaxAmount,
  item.TaxBaseAmountInCountryCrcy AS TaxBaseAmountInCountryCrcy,
  item.TaxAmountInCountryCrcy AS TaxAmountInCountryCrcy,
  item.TaxBaseAmtInAdditionalCrcy1 AS TaxBaseAmtInAdditionalCrcy1,
  item.TaxBaseAmtInAdditionalCrcy2 AS TaxBaseAmtInAdditionalCrcy2,
  item.TaxAmountInAdditionalCurrency1 AS TaxAmountInAdditionalCurrency1,
  item.TaxAmountInAdditionalCurrency2 AS TaxAmountInAdditionalCurrency2,
  item.TaxCalculationProcedure AS TaxCalculationProcedure,
  item.TargetTaxCode AS TargetTaxCode,
  item.EUTaxClassification AS EUTaxClassification,
  item.TaxNumber1 AS TaxNumber1,
  item.TaxNumber2 AS TaxNumber2,
  item.TaxNumber3 AS TaxNumber3,
  item.BusinessPartner AS BusinessPartner,
  item.BusinessPartnerName AS BusinessPartnerName,
  item.TaxIsNotDeductible AS TaxIsNotDeductible,
  item.MiniOneStopShopTxRptgCntry AS MiniOneStopShopTxRptgCntry,
  item.RefAccountingDocument AS RefAccountingDocument,
  cast( '0000000000' as abap.char( 10 ) ) AS BillingDocument,
  cast( '' as abap.char( 32 ) ) AS ReferenceDocumentNumber,
  item.DebitCreditCodeIsChanged AS DebitCreditCodeIsChanged,
  item.TaxCountry AS TaxCountry,
  item.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  I_StRpTaxItemGrouping.TaxBoxStrucValidityStartDate AS TaxBoxStrucValidityStartDate,
  I_StRpTaxItemGrouping.TaxBoxStrucValidityEndDate AS TaxBoxStrucValidityEndDate,
  case when I_StRpTaxItemGrouping.TaxBox = '16' or I_StRpTaxItemGrouping.TaxBox = '17' or I_StRpTaxItemGrouping.TaxBox = '18' or I_StRpTaxItemGrouping.TaxBox = '19' or I_StRpTaxItemGrouping.TaxBox = '22' or I_StRpTaxItemGrouping.TaxBox = '50' then '50' when I_StRpTaxItemGrouping.TaxBox = '10' or I_StRpTaxItemGrouping.TaxBox = '11' or I_StRpTaxItemGrouping.TaxBox = '12' or I_StRpTaxItemGrouping.TaxBox = '13' or I_StRpTaxItemGrouping.TaxBox = '14' or I_StRpTaxItemGrouping.TaxBox = '15' or I_StRpTaxItemGrouping.TaxBox = '20' or I_StRpTaxItemGrouping.TaxBox = '30' then '' when I_StRpTaxItemGrouping.TaxBox = '64' or I_StRpTaxItemGrouping.TaxBox = '67' or I_StRpTaxItemGrouping.TaxBox = '68' then '68' when I_StRpTaxItemGrouping.TaxBox = '60' or I_StRpTaxItemGrouping.TaxBox = '63' then '63' when I_StRpTaxItemGrouping.TaxBox = '1AT' or I_StRpTaxItemGrouping.TaxBox = '1DT' or I_StRpTaxItemGrouping.TaxBox = '1ET' or I_StRpTaxItemGrouping.TaxBox = '1FT' or I_StRpTaxItemGrouping.TaxBox = '2AT' or I_StRpTaxItemGrouping.TaxBox = '5BT' then '5BT' when I_StRpTaxItemGrouping.TaxBox = '1A' or I_StRpTaxItemGrouping.TaxBox = '1B' or I_StRpTaxItemGrouping.TaxBox = '1C' or I_StRpTaxItemGrouping.TaxBox = '1D' or I_StRpTaxItemGrouping.TaxBox = '1E' or I_StRpTaxItemGrouping.TaxBox = '1F' or I_StRpTaxItemGrouping.TaxBox = '2A' or I_StRpTaxItemGrouping.TaxBox = '3A' then '' when I_StRpTaxItemGrouping.TaxBox = '6AT' or I_StRpTaxItemGrouping.TaxBox = '6CT' or I_StRpTaxItemGrouping.TaxBox = '6DT' then '6DT' when I_StRpTaxItemGrouping.TaxBox = '6A' or I_StRpTaxItemGrouping.TaxBox = '6D' then '6D' else I_StRpTaxItemGrouping.TaxBox end as TaxBox AS TaxBoxendasTaxBox,
  item._ReportedItemsLog AS _ReportedItemsLog
FROM C_OM_StRpTaxItemWithRefDoc AS item
INNER JOIN I_StRpTaxItemGrouping ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): C_OM_StRpTaxItemWithRefDoc
;

Learn More