topic Re: Module pool in Application Development and Automation Discussions

Module pool

Former Member — Thu, 07 Jun 2007 09:27:30 GMT

Hi everyone,

I have created a screen acepting employee name,deptno,salary.I have given 3 push buttons SAVE,UPDATE,EXIT.

1. How can i create an employee when i click on push button?

2. How can i update an employee when i click on update button ?

With Regards,

Srikanth.M

Re: Module pool

Former Member — Thu, 07 Jun 2007 09:31:05 GMT

First you should be clear with your requirement? what exactly you wants to do with the program?

You are designing the module pool program with screens, without knowing where that data has to be created and how?

Means to say that if it is related to HR the data has to be created in the related Infotype.

So first find the related db table where your records are to be updated and using the code you can update those tables.

IN PAI of the Screen flow logic you have to write code for all these buttons.

<b>Reward points for useful Answers</b>

Regards

Anji

Re: Module pool

Former Member — Thu, 07 Jun 2007 09:31:19 GMT

In PAI event

get the sy-ucomm of that button

If the button is clicked then

case sy-ucomm.

when 'CREATE'.

SELECT MAX( EMPNO ) from ZEMP

into l_emp.

L_emp = l_emp + 1.

and display this l_emp in athe text box.

t_txtbox = l_emp..

so this will show the emp no in that text box.

When 'SAVE'.

Modify zemp where empno = t_tetbox.

endcase.

Re: Module pool

alex_m — Thu, 07 Jun 2007 09:31:22 GMT

Where u want to update, do u have any Z table or u wnat to update in any std table.

Re: Module pool

Former Member — Thu, 07 Jun 2007 09:31:50 GMT

HI,

you will be assigning three different function codes to each button .

so in PAI event

case sy-ucomm

when 'save'

creat the employee.

when 'update'

update the table.

when exit.

leave to screen 0.

endcase.

reward points if helpful

regards,

venkatesh

Re: Module pool

Former Member — Thu, 07 Jun 2007 09:34:00 GMT

HI,

U should write the code in PAI module.

sample code.

Module PAI

Case: sy-sucom.

when 'save''.

write code for save

when 'exit.

............

when 'update'

,.........

Regards

Suresh.d

Message was edited by:

suresh dameruppula

Re: Module pool

Former Member — Thu, 07 Jun 2007 09:34:44 GMT

hi,

in pai write the coding logic.

case sy-ucomm.

when 'SAVE'.

write a bapi for creating an employee if Bapi exists or write ur own logic here.

when 'UPDATE'.

write a bapi for updating an employee if Bapi exists or write ur own logic here.

endcase.

by using BApi we can easily update or create an employee easily.

Re: Module pool

Former Member — Thu, 07 Jun 2007 09:37:53 GMT

to create in ztable

Re: Module pool

Former Member — Thu, 07 Jun 2007 09:41:41 GMT

Please sent that code when I click on save button and update button into a ztable

Re: Module pool

Former Member — Thu, 07 Jun 2007 09:50:51 GMT

Hi Srikanth,

I guess your question is more of how this can be done technically.

For each button, you can assign a funtion code (Double-click the button and you get the Properties window). Say your function codes are SAVE, UPD and EXIT.

At the PAI module, just handle the button clicks based on the SY-UCOMM value.

CASE SY-UCOMM.

WHEN 'SAVE'. <logic>.

WHEN 'UPD'. <logic>.

WHEN 'EXIT'. <logic>.

ENDCASE.

Hope this solves your query. If this isn't what you were looking for, get back to us.

Regards

Anil Madhavan

Re: Module pool

Former Member — Thu, 07 Jun 2007 09:53:07 GMT

In PAI event

get the sy-ucomm of that button

If the button is clicked then

case sy-ucomm.

when 'CREATE'.

SELECT MAX( EMPNO ) from ZEMP

into l_emp.

L_emp = l_emp + 1.

"and sure that text box will be in output mode.

tb_emp_no = l_emp.

"so this will be updated in data base in background.

"now add name and salary and press on create.

INSERT INTO zemp

(column-1, column-2, ... column-n)

VALUES

(value-1, value-2, ... value-n).

When 'SAVE'.

"here u change the name and salary and press on update button

update zemp where empno = t_tetbox.

when 'EXIT'.

Exit.

endcase.