topic Data Base Table Values in Application Development and Automation Discussions

Data Base Table Values

Former Member — Fri, 13 Jun 2008 05:42:01 GMT

HI ,

i created data for a Z table ,

but now i have to change that data ,

is there any possiblility for that changing data with out delete and adding that record .

THX

Re: Data Base Table Values

Former Member — Fri, 13 Jun 2008 05:45:01 GMT

use modify or update.

Regards,

Azad.

Re: Data Base Table Values

former_member156446 — Fri, 13 Jun 2008 05:45:22 GMT

after the data is displayed in se16.. you can debug the code.. by entering the /h....and in the bebug mode change the code to EDIT and can make the changes.. without transport or access or sm30..

Re: Data Base Table Values

GauthamV — Fri, 13 Jun 2008 05:46:33 GMT

hi,

u can use update and modify statements to change data in database tables.

check these syntax .thy will help u.

reward points if hlpful.

MODIFY

Changing a database table

- MODIFY dbtab FROM wa.

- MODIFY (dbtabname) FROM wa.

- MODIFY dbtab FROM TABLE itab.

- MODIFY (dbtabname) FROM TABLE itab.

- MODIFY dbtab.

- MODIFY *dbtab.

- MODIFY dbtab VERSION vers.

- MODIFY *dbtab VERSION vers.

Changing an internal table

- MODIFY itab [FROM wa] [INDEX idx] [ASSIGNING <fs>|REFERENCE INTO dref] [TRANSPORTING f1 ... fn].

- MODIFY TABLE itab [FROM wa] [ASSIGNING <fs>|REFERENCE INTO dref] [TRANSPORTING f1 ... fn].

- MODIFY itab [FROM wa] TRANSPORTING f1 ... fn WHERE cond.

Changing a list line

- MODIFY LINE n.

- MODIFY LINE n OF CURRENT PAGE.

- MODIFY LINE n OF PAGE m.

- MODIFY CURRENT LINE.

Changing the properties of a screen field

- MODIFY SCREEN.

*******************************************************************************************************

UPDATE

Variants:

1. UPDATE dbtab SET f1 ... fn. or

UPDATE (dbtabname) SET f1 ... fn.

2. UPDATE dbtab FROM wa. or

UPDATE (dbtabname) FROM wa.

3. UPDATE dbtab FROM TABLE itab. or

UPDATE (dbtabname) FROM TABLE itab.

4. UPDATE dbtab. or

UPDATE *dbtab.

Re: Data Base Table Values

Former Member — Fri, 13 Jun 2008 05:46:56 GMT

Hi,

go to transaction se16n,

give table name

and type &sap_edit in command prompt and press ENTER

then u can create new entries

if u wanna to change existing entires prss F8 , all the entries will be displayed in edit mode.

Please reward points if helpful

Regards,

Sriram

Edited by: Srirama Murthy Maddirala on Jun 13, 2008 7:47 AM

Re: Data Base Table Values

Former Member — Fri, 13 Jun 2008 05:47:40 GMT

Hi Chhaya....

Go to transaction SM30, change the particular record u want to.

Reward with Points if info is helpful

Regards

Karan

Re: Data Base Table Values

Former Member — Fri, 13 Jun 2008 05:56:18 GMT

For mass maintenance you can use tran. se16n.

Steps:

Goto transaction SE16N

Give the table name

In command box write u2018&sap_editu2019 then press u2018Enteru2019

Press execute button

Regards,

Joy.

Re: Data Base Table Values

Former Member — Fri, 13 Jun 2008 06:11:39 GMT

Hi,

Use UPDATE or MODIFY statement.

Thanks,

Sriram Ponna.

Re: Data Base Table Values

Former Member — Fri, 13 Jun 2008 06:21:54 GMT

1. Go to se16

2. select the data what ever u want to edit.

3. enter /h

4. press display

5.press F7

6. In debug mode change the code value from Show to EDIT

7. Press F8

8. Then u can change the table entries

Regards

Anbu