Getting Vendor Number and Price...

[Former Member]

hi everyone,

i have done the following:

CALL FUNCTION 'CHANGEDOCUMENT_READ_HEADERS'

EXPORTING

DATE_OF_CHANGE = p_b_date

OBJECTCLASS = 'MATERIAL'

TIME_OF_CHANGE = p_b_time

DATE_UNTIL = p_e_date

TIME_UNTIL = p_e_time

TABLES

I_CDHDR = i_pt_cdhdr

EXCEPTIONS

NO_POSITION_FOUND = 1

WRONG_ACCESS_TO_ARCHIVE = 2

TIME_ZONE_CONVERSION_ERROR = 3

OTHERS = 4.

SORT i_pt_cdhdr BY objectid.

DELETE ADJACENT DUPLICATES FROM i_pt_cdhdr COMPARING objectid.

LOOP AT i_pt_cdhdr.

MOVE i_pt_cdhdr-objectid TO i_updtd_materials-matnr.

APPEND i_updtd_materials.

CLEAR i_updtd_materials.

ENDLOOP.

select mara_{matnr mara}bstme <b>mara_{vpreh</b> mara}matkl mara_{meins mara}mfrnr mara~mfrpn

makt_{maktx marc}plifz

from mara

join marc on marc_{matnr = mara}matnr

join makt on makt_{matnr = mara}matnr

into table i_matl_details

FOR ALL ENTRIES IN i_updtd_materials

where mara~matnr = i_updtd_materials-matnr

and mara~mtart in s_matl

and makt~spras = sy-langu.

I am reading the changes for material and selecting data based on those changes. The requirement changed a bit, I have to select 'price' based on contracts, so i am no longer going to choose VPREH. I have to get EKPO-NETPR. This I can do by putting the statement: join ekpo on ekpo_{netpr = mara}matnr.

I also need to pull the vendor from the same contract. How do I do that. How can I link it up in my select statement?

Thanks in advance.

Regards,

Fred.

[former_member181962 · Accepted solution]

Hi Fred you can get vendor from EKKO-ELIFN.

Get EKPO-EBELN and pass it to EKKO to get ELIFN.

Regards,

Ravi

[Former Member · Accepted solution]

Thats true I can get vendor from EKKO-LIFNR, but is there a way I can somehow link in my join statements. Because I want all data to be put in one internal table and then load all that in CSV format to the App. Server. I can link EKPO-NETPR in my select statement based on material number and put it in the same internal table. But what about the vendor number?

Thanks.

[Former Member · Accepted solution]

link ekko-vbeln to ekpo-vbeln and get ekko-lifnr.

Message was edited by: Srinivas Adavi

My mistake.... it should be EBELN not VBELN

[former_member181966 · Accepted solution]

As you have material number , check out the table <b>ELBM ( Vendor Evaluation: Material-Related Item)</b>

Hope this’ll give you idea!!

<b>P.S award the points.</b>

Good luck

Thanks

Saquib Khan

"Some are wise and some are otherwise"

[former_member181962]

select mara_{matnr mara}bstme mara_{vpreh mara}matkl mara_{meins mara}mfrnr mara~mfrpn

makt_{maktx marc}plifz

<i><b>ekpo~ebeln

ekpo~netpr

ekko~ebeln

ekko~elifn</b></i>from mara

join marc on marc_{matnr = mara}matnr

join makt on makt_{matnr = mara}matnr

<b>join ekpo on ekpo_{matnr = mara}matnr

join ekko on ekko_{ebeln = ekpo}ebeln</b>into table i_matl_details

FOR ALL ENTRIES IN i_updtd_materials

where mara~matnr = i_updtd_materials-matnr

and mara~mtart in s_matl

and makt~spras = sy-langu.

Try the above code.

Regards,

Ravi