Tax breakdown table

[Former Member]

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!

[Former Member]

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!

[Former Member]

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

[Former Member]

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.

[Former Member]

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:

[Former Member]

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

[Former Member]

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.

[Former Member]

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