topic Re: Tax breakdown table in Application Development and Automation Discussions

Tax breakdown table

Former Member — Mon, 05 Dec 2011 22:22:51 GMT

Hi experts,

Is there a table that can give me the tax amount by each line of a FI document? I know there is the BSET but that one has the total amount of taxes, the report we are building needs the tax amount of each line and we are trying to avoid the calculation and fetch the data from the database.

Any help will be appreciated.

Thanks!

Re: Tax breakdown table

Former Member — Tue, 06 Dec 2011 01:51:36 GMT

BSET stores tax amounts at line item level as evidenced by the table key, that consists of document item number BSET-BUZEI. So you can get what you want from BSET itself

BSET Primary key

BUKRS
BELNR
GJAHR
BUZEI

Re: Tax breakdown table

Former Member — Tue, 06 Dec 2011 02:58:17 GMT

Thanks Vishnu, but that is not true, BSET has buzei field but it does not exactly match with the lines of the FI document, I have plenty of examples for that. It has one line per each tax code, so if you have a FI document with 10 lines but just one tax code, BSET will have only 1 line.

Re: Tax breakdown table

Former Member — Tue, 06 Dec 2011 03:11:06 GMT

doubtful one , let me know if u find one ....

few year ago..i was trying to find out table/FM which can give itemwise breakups..but finally i came up with my own logic.

regards

Prabhu

Re: Tax breakdown table

Former Member — Tue, 06 Dec 2011 03:13:16 GMT

Yeph.

I found a FM that will give me the tax amount and the tax base amount, it will work, but customer is trying to avoid calculations so I am looking for options. Nothing so far, I don't even know if there is a standard transaction code that can show me such information.

Re: Tax breakdown table

Former Member — Tue, 06 Dec 2011 03:15:05 GMT

Yeah, you are right BSET sums up the taxes at tax code level and it really doesn't store taxes at document item level. I recollect transactions like FB60 / FB50 automatically sum up taxes at tax code level.

I think, the only way to get tax amounts for individual document items is to use CALCULATE_TAX_FROM_NET_AMOUNT on BSEG GL relevant line items, from net amount posted in the GL accounts that are relevant to taxes.

Refer this thread:

Re: Tax breakdown table

Former Member — Sun, 11 Dec 2011 18:04:38 GMT

There is no logic, hence the program has to do the math. There are some function modules that help