How to link to the KONP table from EINE or from EKKO/EKPO

[former_member637182]

Hi All,

Here, I didn't get how to link to the KONP table from EINE or from EKKO/EKPO, do they have a common field? please let me know ASAP.

Thanks & Regards

sureh.

[Former Member · Accepted solution]

what you want to find out? Probably conditon type values?

Then you will not get it through EKKO /EKPO..

Try info record tables A016 or A017 depending on your need. Get the field KNUMH.

input KNUMH in KONP. you will get the value.

Regards

Seema

[former_member637182 · Accepted solution]

Hi Seema,

Thanks for reply,Here my Quation is how to link KONP to EINE or from EKKO/EKPO.In this i need a common feild, not using from another tables(A016 or A017).This is using for Data Migration.

Thanks & Regards

Suresh.

Hi Suresh, I am not sure how to link to the KONP table from EINE or from EKKO/EKPO, do they have a common field? I have looked and I am not sure, thanks, Sharon

[hubaibnedu]

T-code SQVI

Table Join - EINE- PIR : Purchase Org. data

A017- Material Info record plant specific

KONP- conditions (Item)

Hope this helped

[ndoukkara]

Hello, How could you join a pool table A017 in SQVI ? I tried to add A018 and i had thi message AQ501: "Table <tablename> cannot be used in a join". Thanks in advance

[Former Member]

You can use field

LIFNR ( Vendor ) from KONP table to join with EKKO

Then u can Join EKKO with EKPO through EBELN i.e Purchasing Document

Hope this will help

Reward Points if useful

[Former Member]

Hi

You have link KONP with EINE through the table A017:Material Info Record (Plant-Specific) or Condition table or A018: Material Info Record.

Link the table EINE and A017 with Vendor,Material,Pur.Org.Plant combination.For these values get the Condition record number KNUMH in A017.From this condition record number you can get the value in KONP.

I think this can solve your problem

Regards

Ramakrishna.

[former_member637182]

Hi Ramakrishna,

Thanks! for your reply,may be! i can get the solution.

Thanks & Regards

Suresh

[Former Member]

Hi suresh,

using query select data from ekpo

SELECT SINGLE * FROM ekpo

INTO i_ekpo

WHERE ebeln = l_ebeln

AND ebelp = l_ebelp.

>>>>

assign data to Function Module's internal table

i_taxcom-bukrs = i_ekpo-bukrs.

i_taxcom-budat = i_ekko-aedat.

i_taxcom-bldat = i_ekko-bedat.

i_taxcom-waers = i_ekko-waers.

i_taxcom-kposn = i_ekpo-ebelp.

i_taxcom-mwskz = i_ekpo-mwskz.

IF i_ekko-bstyp = 'L'. "Outline Agreement.

i_taxcom-wrbtr = i_ekpo-zwert.

ELSE.

i_taxcom-wrbtr = i_ekpo-netwr.

ENDIF.

i_taxcom-xmwst = 'X'.

i_taxcom-txjcd = i_ekpo-txjcd.

i_taxcom-lifnr = i_ekko-lifnr.

i_taxcom-ekorg = i_ekko-ekorg.

i_taxcom-matnr = i_ekpo-matnr.

i_taxcom-werks = i_ekpo-werks.

i_taxcom-matkl = i_ekpo-matkl.

i_taxcom-meins = i_ekpo-meins.

i_taxcom-mglme = i_ekpo-menge.

i_taxcom-mtart = i_ekpo-mtart.

i_taxcom-land1 = i_ekko-lands.

i_taxcom-ebeln = i_ekko-ebeln.

i_taxcom-ebelp = i_ekpo-ebelp.

>>>>

Call Function Module

*function module to calculate taxes

CALL FUNCTION 'CALCULATE_TAX_ITEM'

EXPORTING

dialog = 'DIAKZ'

display_only = 'X'

i_taxcom = i_taxcom

TABLES

t_xkomv = i_xkomv

EXCEPTIONS

mwskz_not_defined = 1

mwskz_not_found = 2

mwskz_not_valid = 3

steuerbetrag_falsch = 4

country_not_found = 5

OTHERS = 6.

IF sy-subrc <> 0.

MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno

WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

ENDIF.

Rewards.....

Regards

Sanjay L