Link Between EKKO and KONH or KONP

[Former Member]

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

[davis_raja]

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]

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

[Former Member]

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

[yogendra_bhaskar]

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

[yogendra_bhaskar]

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

[Former Member]

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

[yogendra_bhaskar]

hi vijay ,

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

regards,

Yogendra Bhaskar

[venkateswaran_k]

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]

Hi Vijay,

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

Regards,

Madhu.

[Former Member]

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]

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?