To view orders with specific Tax Code

[Former Member]

Dear All,

Require your urgent help.

My Query is:

There is a tax code S1 in Production System with 10% Tax. I wish to see how many orders are processed with this S1 Tax Code.

I want to know the Sales Order Numbers.

'

I tried looking at KNVI and branching it using KNOV/KNOP but its a lengthy process. Can anyone help me out with a better solution if you have?

Thanks a lot in advance.

Regards,

Santosh

[prasanna_kumar4]

HI

Check the Transaction Code: J1I2

Based on the Tax code and Condition Type system will show the list of Sale orders and its corresponding Details

[Lakshmipathi]

If you want to correlate tax value with sale order, you can go with Siva's suggestion.  On the other hand, if you want to mingle tax code with sale order, then you need to develop a query as tax code is being stored in KOMV structure.

G. Lakshmipathi

[vidyasagar24]

Dear Mr. Santhosh,

Tax codes are used for condition types, the condition types are used in sales order. As it is the finance integrated, you can't find any standard report. So, you need to develop SAP query report or Z report.

Best Regards

Vidya Sagar.

[siva_vasireddy2]

Hi,

you can develope a report by yourself in SQVI by taking the logical Database - VAV which connects sales order tables with condtion tables-KONV in which you have Tax code Field-MWSK1

with the above report you will get all the orders for a specific Tax code