Query for PO Pricing TAX Conditions

[former_member490410]

Dear Gurus,

Can any help me to create a query report for a purchase order tax entered using tables of TAX data ( JMOP,JEX1, JVRD etc.).

Note we are using FV11 ( TAXINN) for tax calculations. Which tables needs to joined to get report like below

Po no     Po item no   Tax Code Tax condition     Tax %

1XXX          10                V6          JMOP            12%

1XXX          10                V6          JMX1           100%

1XXX          10                V6          JEC1           2%

Thanks in advance.

Baalu

[former_member187965 · Accepted solution]

Hi,

You need below three tables for this requirement,

EKPO, Condition table and KONP.

Condition table - To find the condition table, go to OBYZ, double click on 'Access Sequences'. select 'JTAX', double click on 'Accesses'. Here you will find the condition table for the access sequence which you are using in FV11 for maintaining tax condition records. Go to SE16N, here just put 'A' at the starting of the condition table and then you can find the data in the table. For ex. If the condition table no. is '901' then the table no. will be 'A901'.

Now, pass the PO no to the EKPO table and you will get the PO line item number and tax code for that line item. So, you will get first three fields (PO no, PO line item no and tax code) of your report from EKPO table.

Pass the tax code to the condition table and you will get condition record number (KNUMH). You can also check the 'Valid from' date for the condition record. Here in condition table you will get the fourth field (Tax condition) of your report.

Pass KNUMH to KONP table and you will get the percentage maintained (KBETR) for the condition type. In KONP, you will get the last field (Tax %) of your report.

I hope above logic will resolve your query.

I think, instead of query you should go for ABAP report for this requirement.

[Former Member · Accepted solution]

use Tables EKKI, EKPO, EKKO and KONP.

But may be you need abaper Help since you need to have the Condition record Number which you will get from EKKI Table.

Thanks,

Shiva

[former_member490410 · Accepted solution]

Pass means it table join?

[former_member187965 · Accepted solution]

Hi,

No. Pass means it is the unique key between the tables with which you can pull the data from other table.

Join three tables, EKPO - condition table - KONP,

Link between EKPO and condition table is the 'Tax Code' 'MWSKZ'. Link between condition table and KONP is 'condition record no' 'KNUMH'.

[former_member182873]

Dear Balu,

You can write a query through SQVI by using the Logical database ERM and selecting EKKO_EBELN EKKO_KNUMV and KONV-KNUMV. You can get desired result.

[BijayKumarBarik]

Hi,

Get the Purchase Order MM Calculation Schema( Pricing Procedure) value by passing the value EKKO-KNUMV in the field KONV-KNUMV and  get purchase order tax values(Excise Value & Sales Tax Value) by using the function module:CALCULATE_TAX_ITEM

Regards,

Biju K

[Former Member]

Hi,

You need to fetch PO item data from EKPO and then conditions from KONP. Detailed logic is wel explained by SK. However it is always incorrect if you prepare report for taxes based on excise as always condition values are edited every now and then. The correct approach is pull values based on scenarios such as GR/Reversals etc.