topic Re: Save data in module pool in Application Development and Automation Discussions

Save data in module pool

Former Member — Mon, 05 Jan 2009 09:48:38 GMT

Hi All,

I have made a screen in module pool. Whenever I enter data on my screen fields and click save button, the data should get saved . I do not have to update any DB table.

Please suggest what more code should be written in PAI:

case sy-ucomm.

when 'SAVE'

....

...

Every useful aswer will be rewarded.

Abhimanyu

Re: Save data in module pool

I355602 — Mon, 05 Jan 2009 09:53:16 GMT

Hi Abhimanyu,

Take the names of the input/output fields as work_area-field_name.

Use code, its working:-

In PAI,


PROCESS AFTER INPUT.
  MODULE USER_COMMAND_8003.

  LOOP WITH CONTROL PO_TB. "po_tb is name of table control
    MODULE INSERT_DATA. "to insert data from table control into internal table
  ENDLOOP.


*&---------------------------------------------------------------------*
*&      Module  INSERT_DATA  INPUT
*&---------------------------------------------------------------------*
MODULE INSERT_DATA INPUT.
  APPEND WA_ZEKPO TO IT_ZEKPO.
  "append data from work area fields into internal table on user command
ENDMODULE.                 " INSERT_DATA  INPUT

Hope this solves your problem.

Thanks & Regards,

Tarun Gambhir

Re: Save data in module pool

GauthamV — Mon, 05 Jan 2009 09:54:57 GMT


module USER_COMMAND_0100 input.


case sy-ucomm.

when 'DISP'.

select name city salary role from ztable into table it_data
where name = wa_data-name.

read table it_data into wa_data with key name = wa_data-name.

when 'INS'.

WA_DATA-NAME = ztable-NAME.
WA_DATA-city = ztable-city .
WA_DATA-salary = ztable-salary.
WA_DATA-role = ztable-role.

append wa_data to it_data.
clear wa_data.

insert ztable from table it_data.

IF sy-subrc = 0.

  MESSAGE 'records created succesfully' TYPE 'S'.

ENDIF.

when 'SAVE'.
modify ztable from ztable.

if sy-subrc = 0.

message 'record updated succesfully' type 'S'.

endif.

Endcase.
endmodule.                 " USER_COMMAND_0100  INPUT

Re: Save data in module pool

Former Member — Mon, 05 Jan 2009 09:59:26 GMT

Hi abhimanyu...

Your screen fields will refer a dictionary structure...and you need to have a work area were ,you can transport the statemnt from screen to work area using FIELD statements .

e,g FIELD (SCREENFIELD NAME)

Re: Save data in module pool

Former Member — Mon, 05 Jan 2009 10:02:33 GMT

Hi,

Just pass the values of corresponding screen fields to the table fields in the loop.

Hope it helps!!

let me know if you still not clear!!

Regards,

Pavan

Re: Save data in module pool

Former Member — Mon, 05 Jan 2009 12:40:46 GMT

Hi,

When save just insert the internal table row into db table after the validation using INSERT stmt.

Do the insertion into the loop stmt.

I hope this will help u.

Thanks.

Re: Save data in module pool

Former Member — Mon, 05 Jan 2009 14:17:59 GMT

HI....

I do not have to update table....

Data should remain on the screen when the screen is opened again.

Re: Save data in module pool

Former Member — Mon, 05 Jan 2009 14:26:36 GMT


> HI....
> 
> I do not have to update table....
> 
> Data should remain on the screen when the screen is opened again.

Make the screen fields global and pass the data into it.

Re: Save data in module pool

Former Member — Tue, 24 Aug 2010 17:40:42 GMT

done