Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Link Between EKKO and KONH or KONP

Former Member
0 Kudos
3,395

Hi gurus,

     I want tax conditions % for Purchase Order in my Z report. This conditions are stored in KONP table.

I couldn't find any linkage between EKKO and KONH or KONP.

Is there any link between this tables? Please help me out.

Regards,

Vijay

1 ACCEPTED SOLUTION

yogendra_bhaskar
Contributor
0 Kudos
1,323

Hi Vijay ,

For your requirement , I think FM " CALCULATE_TAX_ITEM " will be helpful ,

passing details of PO in i_taxcom and You will get the details of tax in table t_xkomv .

Regards ,

Yogendra Bhaskar

11 REPLIES 11

davis_raja
Active Participant
0 Kudos
1,323

Dear Vijay,

     There is no direction connection between EKKO and KONH or KONP.

     Instead you can also use KONV instead of KONH or KONP

     EKKO -> KONV  (Linking field KNUMV)

yogendra_bhaskar
Contributor
0 Kudos
1,324

Hi Vijay ,

For your requirement , I think FM " CALCULATE_TAX_ITEM " will be helpful ,

passing details of PO in i_taxcom and You will get the details of tax in table t_xkomv .

Regards ,

Yogendra Bhaskar

0 Kudos
1,323

Hi Yogendra,

Thanks for your help..I have used this FM. But when I have passed PO in i_taxcom, dump occured of type conflict. So, please give me example how to use this FM.

Regards,

Vijay Jadeja

0 Kudos
1,323

Hi Vijay ,

  Data : int_taxcom LIKE taxcom,

            ty_komv TYPE STANDARD TABLE OF  komv WITH HEADER LINE.

     CALL FUNCTION 'CALCULATE_TAX_ITEM'

         EXPORTING

           i_taxcom = int_taxcom

*            reset    = 'X'

         TABLES

           t_xkomv  = ty_komv.

Regards ,

Yogendra Bhaskar

0 Kudos
1,323

Hi Vijay ,

  Data : int_taxcom LIKE taxcom,

            ty_komv TYPE STANDARD TABLE OF  komv WITH HEADER LINE.

     CALL FUNCTION 'CALCULATE_TAX_ITEM'

         EXPORTING

           i_taxcom = int_taxcom

*            reset    = 'X'

         TABLES

           t_xkomv  = ty_komv.

Regards ,

Yogendra Bhaskar

0 Kudos
1,323

Hi Yogendra,

I have used this FM same way. But, int_taxcom requires lots of details to be filled. I have filled all information.

taxcom-ebeln = ekpo-ebeln.
taxcom-EBELP = ekpo-EBELP.
taxcom-MWSKZ = ekpo-MWSKZ.
taxcom-bukrs = ekpo-bukrs.
taxcom-budat = ekko-bedat.
taxcom-waers = ekko-waers.
taxcom-kposn = ekpo-ebelp.
taxcom-mwskz = ekpo-mwskz.
taxcom-txjcd = ekpo-txjcd.

......etc.....

Now, I get error "Tax code in procedure ZTAXIN is invalid".

0 Kudos
1,323

hi vijay ,

Plz. make sure that taxcom-MWSKZ is not initial .

regards,

Yogendra Bhaskar

venkateswaran_k
Active Contributor
0 Kudos
1,323

Dear Vijay

Why dont you use KONV table?  Is there any problem you are facing?

KONV table is the direct access based on KNIUMV key that will give all condition records.

Please post back with your comments

Regards,

Venkat

madhu_vadlamani
Active Contributor
0 Kudos
1,323

Hi Vijay,

Get the knumv number and get it.Check all the key fields to get good performance.

Regards,

Madhu.

Former Member
0 Kudos
1,323

Dear Venkates & Madhu,

I want to get conditions percentage of taxcode: For example, Tax Code : 20 has 4% of VAT and 1% of Addition VAT. Now, KONV doesn't store this data. Conditions of tax code are stored in KONP table.

So, I wanted link between PO tables and KONH, KONP tables. But later I found combination key of Unit, Vendor and material in KONH table. And that solved my problem.

Thanks guys for your comments & guidance.

Regards,

Vijay Jadeja

Feel
Discoverer
0 Kudos
1,022

Hi all, I see no VAKEY field in KONP and there are records flagged for deletion differently for different position number ( e.g 1 is null while 6 is X)  for the same KNUMH. And KONH has KNUMH and VAKEY. How do I link these two to identify condition items that are flagged for deletion. If I link them on KNUMH - I have multiple deletion indicator for same KNUMH. I am new to SAP tables, thanks for any insights and/or guidance on this. 

Also is A016 be better option to use to get purchase type contract items excluding the ones that are flagged for deletion?