Skip to Content

Table for VAT/CST/BED at item level in MIRO

Hi all,

I want to create Tax report at line Item level Using BSET
table where I need separate Line item for all taxes.

But when I Execute BSET table I found sum of Excise conditon( JMOP) , VAT(JVRD) etc.not found on item Level


Line 10  JMOP :12

Line 20 JOMP:14

Line 30 JMOP:16

BSET table Output:12+14+16=42 when we pass MIRO document and Year

As per tax report requirement we need to value of individual
line item .

Please suggest how we can calculate tax value at line item

Best regards,


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 27, 2015 at 05:18 AM

    You only have two options.

    1) Check if you can fetch the Excise duty details line item wise in BSET table.

    2) Get the MIRO Line item wise Tax code and pass it in the respective table say if you are using key combination (Tax classification) you can get the details in 003 Table. You have to prefix A to the table i.e. A003. From A003 you get the condition record and later you pass it on KONP table for the rate.

    Ensure you are reading the Tax rate for the MIRO Posting date.

    Add comment
    10|10000 characters needed characters exceeded