topic Re: database tables in Application Development and Automation Discussions

database tables

Former Member — Fri, 20 Jul 2007 07:01:58 GMT

how to modify data of a database table through screens

Re: database tables

Former Member — Fri, 20 Jul 2007 07:04:07 GMT

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

Re: database tables

former_member196299 — Fri, 20 Jul 2007 07:05:05 GMT

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

Re: database tables

varma_narayana — Fri, 20 Jul 2007 07:05:10 GMT

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>

Re: database tables

Former Member — Fri, 20 Jul 2007 07:05:11 GMT

Refer this link

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

Regards,

Pavan

This document might help you...

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

Message was edited by:

Pavan Pachimatla

Re: database tables

jayanthi_jayaraman — Fri, 20 Jul 2007 07:05:53 GMT

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.

Re: database tables

Former Member — Fri, 20 Jul 2007 07:07:46 GMT

Hi Karthik,

Use Table Maintainance generator.

Go to se11 and display the table .

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

Regards

Arun

Re: database tables

former_member188827 — Fri, 20 Jul 2007 07:08:45 GMT

collect data from screen into a work area and den use

modify<table> from wa.

Re: database tables

Former Member — Fri, 20 Jul 2007 07:11:10 GMT

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.

Re: database tables

Former Member — Fri, 20 Jul 2007 18:14:39 GMT

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

Re: database tables

Former Member — Sat, 21 Jul 2007 01:20:08 GMT

the below link can provide you thr concept of locking table

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

Re: database tables

Former Member — Sat, 21 Jul 2007 18:16:06 GMT

thanx 4 sending d link