Reg Telephone and Fax Number updation in Purchase orders

[Former Member]

Hi Experts,

I need small information about Telephone Number and Fax numbers updation in Purchase Orders.

Actually my user requirement is they have been provided the Purchase Organizations XXXX,XXXX.

From this Two Purchase Orgs the users who are all created the POs the Telephone Number,Fax Number need to pick from the relvant User Master(user profile SU01).

For this how i can discuss with my Abaper.

If you have any idea on this please suggest me.

Brgds,

RK

[former_member187989 · Accepted solution]

Where exactly you want to update telephone or fax numbers in p.o ?

You can find user who created po using table EKKO,based on user id you can fetch telephone no & fax no.

[Former Member · Accepted solution]

Hi,

Thanks for your quick reply.

we had list of users in purchase departement,whenever the purchaser created the PO document this Telephone Number,Fax Number need to pick from user master.

I had seen one reply below to check with Abaper to hard code this in Purchase Org specific.

I have one option like we can maintain Purchase org and Purchase group combination at configration level.

Can you please suggest me how we can approach and discuss with our Abpaer.

Please guide me.

Brgds,

RK

[former_member187989 · Accepted solution]

I have one option like we can maintain Purchase org and Purchase group combination at configration level.

Yes,you are right with above combination you can fetch telephone & fax no.

Maintain telephone & fax no in respective purchasing group in SPRO settings.

[Former Member · Accepted solution]

Hi,

But right now my user requirement is for each user can create the Purchase order,that time this Telephone,Fax numbers need to pick from user master.

Presently in our KDS Purchase group is not maintianed for each user.

In each purchase group around 10 to 15 users,so that time we can not use the configuration setting.

I think we need to check with Abaper,please suggest me how we can approach with Abaper.

Brgds,

RK

[Former Member]

You can use exit EXIT_SAPMM06E_006 or EXIT_SAPMM06E_018.

Write a code to check sy-uname and sy-tcode= Me21n. it will return you user id. Pass this user id to table usr03. It will return telepone number and fax number the same can be used to either default . You need to check tcode also so that if it is subsequently changed by any other user it should not change telpone number or fax number.

Regards

Sangeeta

[Former Member]

Hi Sangeeta,

Its very helpful your suggstion.

If possible Can you pls elaborate in detail to understand in clearly.

than i can discuss with my Development team.

Brgds,

RK

[Former Member]

Hi RK

Where do you need to update this information in the PO or the PO output ( Print / Fax / email)

If you want to update these in the PO then you need to use the customer exit.

Enhancement MM06E005 - Customer fields in purchasing document

If you need to determine the details in the PO output then the smartform / script being used needs to be modified to determine the data of the user derived from table EKKO - ERNAM created by

The address number needs to determined from table USR21 using the user ID - PO created by( EKKO - ERNAM_ and using the address number derive the telephone number and fax number from table ADRC.

[Former Member]

Hi Kishore,

Can you please explain in detail,how i can develope this Enhancement.

I need this Telephone,Fax Number detials in PO output(print / Fax / Email).

Presently we need this requirement for Two Purchase Orgs XXXX,XXXX.

Once its done succesfully we will move into other Purchase Orgs also.

If we Implmented this Enhancement it will work for all Purchase docuemnts Like PO,RFQ,STO...etc.

Please elaborate in detail.

Brgds,

Ramakrishna

[Former Member]

Hi experts,

can any one please reply for my requirement.

Brgds,

RK

[JL23]

as it is an exit, you can enter coding that this only effects certain organisations. this can either be hardcoded in the coding, or you create an extra Z-table where you can add entries more flexible without needed to change the exit again.

[Former Member]

Hi,

I can agree with your suggestions.

But Presently we did changes with my Abaper in the PO output the smartform / script being used needs to be modified to determine the data of the user derived from table EKKO - ERNAM created by.

The address number needs to determined from table USR21 using the user ID - PO created by( EKKO - ERNAM_ and using the address number derive the telephone number and fax number from table ADRC.

My abaper done the changes but we can not see the Telephone Number,Fax Number in the PO documents.

Please help.

Brgds,

RK

[JL23]

if you want the telephone number and fax number from table ADRC from your user be visible as fields in the PO document, then you need to add customer fields.

SAP has an OSS note which outlines how to do this and which enhancements have to be used

[former_member533946]

Hi dear,

In PO printout form ask your ABAP er to hard code the Telephone no and fax no based on the purchasing organsation.

He can put the condition that if Purchasing Organisatoin in PO is XXXXX phone no & fax no should be 1111,22222,

Thus ur requirement could be met.