topic Re: Automatic Update in SM30 in Application Development and Automation Discussions

Automatic Update in SM30

Former Member — Tue, 15 Oct 2013 09:10:07 GMT

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.

Re: Automatic Update in SM30

Former Member — Tue, 15 Oct 2013 09:11:44 GMT

Hi Deepak

Can u elaborate your question.

Thanks

Pavan.N

Re: Automatic Update in SM30

former_member188827 — Tue, 15 Oct 2013 09:15:45 GMT

This message was moderated.

Re: Automatic Update in SM30

former_member219162 — Tue, 15 Oct 2013 09:28:53 GMT

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.

Re: Automatic Update in SM30

Former Member — Tue, 15 Oct 2013 09:39:51 GMT

This message was moderated.

Re: Automatic Update in SM30

Former Member — Tue, 15 Oct 2013 11:14:07 GMT

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