topic Re: modifying the field and inserting into the database in Application Development and Automation Discussions

modifying the field and inserting into the database

Former Member — Mon, 04 May 2009 04:50:39 GMT

i am working on modulepool programming...here i have to display material related data i.e. material number,material name,quantity,price and others...

here the data must be displayed in changeable format and when i change the quantity and press save button the new quantity must be written in the database.

kindly let me know how can i resolve this..thanks in advance

Re: modifying the field and inserting into the database

Former Member — Mon, 04 May 2009 04:56:41 GMT

Hi,

As per my understanding, you have to call the API's or Function Modules to save the data once the SAVE Button is pressed.

The general flow of the program will as follows : SAVE --> PAI --> Check the Ok Code and then based on that you need to call the Code to make a save to the Database.

Process Before Output.

Module GUI_LOAD.

Process After Input.

Module process_function_code.

Also, make sure you make the proper validation before you call the final Database call.

Hope this helps.

Thanks,

Samantak.

Re: modifying the field and inserting into the database

Former Member — Mon, 04 May 2009 04:59:58 GMT

thanks for the reply...

can u please let me know how can i display the particular quantity column in editable format...

Re: modifying the field and inserting into the database

Former Member — Mon, 04 May 2009 05:07:47 GMT

Hi,

In the PBO Event of the Screen you can put the code in one of the module which will enable/disable the quantity column.

The pseudo code is as follows:

LOOP AT SCREEN.

IF Screen- name = 'Column Name'.

screenname-input = 1.

modify screen.

ENDIF.

ENDLOOP.

Have a look at the ABAPDOCU Transaction Code for example code.

Hope this will help.

Thanks,

Samantak.

Re: modifying the field and inserting into the database

Former Member — Mon, 04 May 2009 05:10:26 GMT

thanks alot