Tax code wise balances in different G/L accounts

[prabhakar_vemuri]

Dear All

My customer requires a report where he can see tax code wise balances that can exist in different G/L accounts. In the input screen if we enter tax code then in the output screen the respective G/L accounts with the amount credited should appear. We are planning to develop a BI report for the same. Can anybody suggest the related tables and the logic to be used to develop the said report. Your inputs and suggestions will be appreciated.

Thanks in advacne.

[Former Member · Accepted solution]

Hi,

Use the table BSET - Tax Data Document Segment, for this requirement of yours.

[Former Member]

hii,

about standard t-code, i cant say more. but plz check this threads.......

else,

the taxation report - S_ALR_87012357 for all input tax codes for a given period of time

hope it will help u.

[prabhakar_vemuri]

Thank you for your inputs.

The suggested reports S_ALR_87012357 does not give output G/L code wise and i think there is no standard report that suffices my requirement. BSET table can do the needful if i am goin for a Z report. But as we are preparing a BI report i need some Equivalent data in BI and the approach to be followed for making a BI report for the said requirement.

[Former Member]

Hi,

For tax codes the tables are KONP, KONH, KONV. DO The G/L account assignment also . I hope this will help you. Thanking you.