Skip to Content

Tax breakdown table

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!

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 06, 2011 at 03:11 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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.

  • Posted on Dec 06, 2011 at 01:51 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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:

      How to read tax data from BSET....

  • Posted on Dec 11, 2011 at 06:04 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.