cancel
Showing results for 
Search instead for 
Did you mean: 

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

0 Kudos

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

Example:

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

Best regards,

Bhanu

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member192897
Active Contributor
0 Kudos

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.