topic Re: Module Pool in Application Development and Automation Discussions

Module Pool

Former Member — Tue, 03 Oct 2006 12:59:04 GMT

I have created to text box ie empno & empname and also i have created a table zemp.

so when i click the save button it has to go & update in the zemp table .

on the click of save what is the code i have to write.

thanks

regards

Alfred

Re: Module Pool

Former Member — Tue, 03 Oct 2006 13:01:12 GMT

Just Assign the values to the Z Table field as ZTEMP-EMPNO = emp no from the screen

EMPNAME = from screen at the FORM INPUT UNDER THE OK_CODE for SAVE

MODIFY ZTEMP.

Message was edited by: Vara Prasad Kunathi

Re: Module Pool

Former Member — Tue, 03 Oct 2006 13:03:28 GMT

Hi on click on save button write the following code

When'SAVE'.

insert values of <itab> into zemp. "for insertingrecords

update zemp from itab "for update.

see the proper syntax and what fileds u want to update.

Regards

Manas Ranjan panda

Re: Module Pool

RichHeilman — Tue, 03 Oct 2006 13:03:39 GMT

I really depends on how your program is written and what the fields are that you are updating. Assuming that there is no relationship between your screen fields and the fields of your db, then I would suggest something like this.

data: wa_zemp type zemp.

wa_zemp-empno = empno.
wa_zemp-empname = empname.
insert zemp from wa_zemp.

Regards,

Rich Heilman

Re: Module Pool

Former Member — Tue, 03 Oct 2006 13:05:46 GMT

Hi Alfred,

Instead of text box, you can have normal input fields on your screens.

in your pai section.

module user_command.

case sy-ucomm.

zemp-empno = v_empno.

zemp-empname = V_emp_name.

modify zemp.

endcase.

endmodule.

Re: Module Pool

Former Member — Tue, 03 Oct 2006 13:15:30 GMT

Fill the data to <workarea> from the screen fields.

and then use the INSERT command to update the database table from the workarea.

Thanks

eswar

Re: Module Pool

Former Member — Tue, 03 Oct 2006 13:27:15 GMT

iit gives the error message as Field "V_EMPNO" is unknown. It is neither in one of the specified

tables nor defined by a "DATA" statement. "DATA" statement.

in the text box i have given the name as v_empno only

but still then it gives the error message , where would i have gone wrong.

thanks

alfred

Re: Module Pool

Former Member — Tue, 03 Oct 2006 13:32:36 GMT

Along with the text field on the screen, you also need to declare a variable in module pool program like

data : v_empno type zemp-empno.

Regards,

Richa