cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Tax information CDS view

SivaNagiReddy
Participant
0 Likes
5,892

Hi,

Can someone help us with a standard CDS view, which gives us the Tax information and has the following fields:

Country, Tax Code, Tax Percentage.

We have been using the app - Display Tax Information per Country to get these details.

Just need to find the CDS is behind this app.

Accepted Solutions (1)

Accepted Solutions (1)

i310639
Product and Topic Expert
Product and Topic Expert
0 Likes

HI,

The view, based on backend table BSET fields, released in I_OperationalAccountingTaxItem.

You can also use I_TaxBaseBalancesGroup and I_TaxBalancesGrp.

sivasankarans
Participant
0 Likes

Hi there , I am looking for the Tax data CDS view as well, above Table/view I_TaxBalancesGrp doesn't exist, however, I_TaxBaseBalancesGroup is neither accessible, or, having no data in it. Any other alternate table, available?

I know in ECC or prior R3 Releases, we can use the following

T007S ---> Tax Code Names

T007A ---> Tax Keys

T007C ---> Groupings for tax codes

IDCFMBRSETX_HST ---> History table for taxation

Looking for corresponding table/CDS views in Public Cloud. 

Thanks for any expert's advice. Siva

Answers (1)

Answers (1)

sivasankarans
Participant
0 Likes

Hi there, 

I am facing a similar issue with fetching or identifying the correct CDS view for Tax details including tax code, tax procedure, tax access sequence, in line with tax condition record. 

I know how to fetch these from SD process based on Condition records from a Sales Order Line item. 

My issue is, when I raise an FI direct invoice or credit note, the tax table / CDS view 'I_OperationalAcctgDocTaxItem' does not show the Tax Rate as a percentage. 

From another forum, I find these CDS views might be of help, but it's not. 

I_TaxBalancesGrp - this is NOT accessible to me as a Key User or table view doesn't exist. 

I_TaxBaseBalancesGroup - this is accessible, but no data resides in this view. By any chance, has this been moved and replaced by another CDS view?

Any thoughts on this how to go about it, most welcome. 

Thanks, Siva