Data Base Table Values

[Former Member]

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

[Former Member]

use modify or update.

Regards,

Azad.

[former_member156446]

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..

[Former Member]

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.

[GauthamV]

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.

[Former Member]

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

[Former Member]

Hi Chhaya....

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

Reward with Points if info is helpful

Regards

Karan

[Former Member]

Hi,

Use UPDATE or MODIFY statement.

Thanks,

Sriram Ponna.

[Former Member]

Hi

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