database tables

[Former Member]

how to modify data of a database table through screens

[Former Member]

hi

once u modufy ur screen... say the user clicks on a check box... then this will be stored in the screen work area... modify the corresponding entry in the internal table... and then finally update ur database table... use lock table concept while doing this

<b>

please reward points if useful</b>

regards,

raksha

[Former Member]

can u plz send me any data abut lock table concept..

[Former Member]

the below link can provide you thr concept of locking table

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eef3446011d189700000e8322d00/frameset.htm

[Former Member]

thanx 4 sending d link

[former_member196299]

hi ,

Use a table maintenance generator :

Check these threads:

For further help look into these links

http://help.sap.com/saphelp_46c/helpdata/EN/cf/21eb6e446011d189700000e8322d00/frameset.htm

http://help.sap.com/saphelp_bw30b/helpdata/en/69/c2516e4ba111d189750000e8322d00/content.htm

regards,

Ranjita

[varma_narayana]

Hi ..

To modify DB table you have to code the SQL statements in the module pool.

INSERT <DBTABLE> FROM <WA>.

UPDATE <DBTABLE> SET field = <wa-field>

where <condition>.

here the WA is the work area of the Screen fields.

Hope this helps u.

<b>Reward if so.</b>

[Former Member]

Refer this link

http://publib.boulder.ibm.com/infocenter/wbihelp/v6rxmx/index.jsp?topic=/com.ibm.wbia_adapters.doc/d...

Regards,

Pavan

This document might help you...

www.bwexpertonline.com/downloads/BW%20EXP%20HetherColeman%20download%20v3.doc

Message was edited by:

Pavan Pachimatla

[jayanthi_jayaraman]

Hi,

If table maintenace is allowed, use SM30 for that.Otherwise in SE16, select the particular record in output.Double click it and then put /h for debugging.In debugging mode press F7 until it reaches code value = SHOW.Then in debugging change code = EDIT.Then F8, you can change the values.

Hope it helps you and it is not for standard tables.

Kindly reward points by clicking the star on the left of reply,if it helps.

[Former Member]

Hi Karthik,

Use Table Maintainance generator.

Go to se11 and display the table .

From the menu --> Utilities --> Table maintainance generator

Regards

Arun

[former_member188827]

hi

collect data from screen into a work area and den use

modify<table> from wa.

[Former Member]

Hi Karthik,

Once you develop Screens using PARAMETERS or SELECT-OPTIONS or through customized SCREENS, you get the data entered by the user and store them in your dta objects.

After that create Internal Tables or a Work Area according to the Row Type of the Database Table and pass the data provided by the user on the screen.

You can use OPEN SQL statements, to update the database.