ME23N + Relationships + Sales Mail IDs

[kiran_k8]

Hello Folks,

I am going into ME23n

Double clicking on Supplier

and then clicking on Relationships button

and navigating to the tab " Has Contact Person ".

Now I want to fetch the mail IDs that were maintained only for SALES.

Is there any function module to fetch this information ?

Or

What are the tables that we can refer to ?

Kindly throw some light on the above mentioned queries.

Thanks,

K.Kiran.

[kiran_k8]

BUT051 table has Vendor, Department and E-Mail Address.

Hence, no need of going to KNVK and ADR6 tables.

Get the LIFNR from EKKO table and pass it to BUT051.That will do.

[jagdeepsingh83]

if you are on S4 - try using BUPA_CENTRAL_READ_DETAIL  and use ES_DATA_PERSON but i you on ECC then you can use KNVK table, you should find the KNVK-LIFNR to find the contact persons--

You can also explore using WRB_RFC_VENDOR_GET_CONTACTDATA

[kiran_k8]

Hello Jagdeep,

Thanks for replying to my query.

I had passed the Vendor Number to the FM BUPA_CENTRAL_READ_DETAIL but it is not getting me the E Mail Ids based on the Sales Department. I need to fetch only the Sales Department Mail Ids. Moreover it is not fetching the data I require. ES_DATA_PERSON is blank and it is not having the field for Mail ID.

I had passed the Vendor Number to the FM WRB_RFC_VENDOR_GET_CONTACTDATA but it is resulting in dump. Fyi I am on S4 Hana System. Any Idea on this ?

Passed EBELN to EKKO and got LIFNR.

Passed LIFNR to KNVK and got the Address Number - ADRNP_2.

Passed ADRNP_2 to ADR6 and got the E mail Address.

Can you please let me know from which table I can get the Department (Sales). I need to fetch only the Sales Department E mail IDs.

Thanks,

K.Kiran.

[jagdeepsingh83]

You can notice field available in KNVK table and field name ABTNR--Department so when you passing LIFNR in KNVK also pass ABTNR='0003'--rest you have already figured out --I have not idea why you are getting dump other WRB program