Automatic Update in SM30

[Former Member]

Hi all,

i have one requirement in which,, when i will put the employee id of any user i want its email id will automatically will fetch through master data and update for the same.Please let me know how to do it.

Regards,

Deepak kansal.

[Former Member]

Hi Deepak

Can u elaborate your question.

Thanks

Pavan.N

[former_member188827]

This message was moderated.

[former_member219162]

Hi Deepak,

Following are the ways, by which you can do it;

1) You can use database event to update the the email ID column.

2) You can also use programming logic in the module. Suppose you created a Table Maintenance(SM30) named "ZHR_EMAIL", which has only two columns, PERNR & EMAIL.

i) You can go SE80

ii) Put function group = ZHR_EMAIL

iii) Choose the screen Number in SE80. this screen number is actuallythe screen that you have given in Table Maintenance generator.

iv) Double click on the screen

v) in "Process After Input",  you would get  Loop at extract..... Endloop, Within this loop, and just before Endloop, you can create a module "Module PERNR_EMAIL". In this module you can write the suitable logic.

Employee ID and Email ID is linked in IT0105 (PA0105) with suitable subtype. You can check it and put your logic.

[Former Member]

This message was moderated.

[Former Member]

thanks to all of you....it is working