modify database table

[naveen_inuganti2]

hi!

say i have 150 fields............... 100 fields are modiafable..........

i want to change 10 fields among these 100.

what should i use : modify or update??

i dont want to enter remaining 90 fields.....they remain blank in the display screen.....

i only enter these 10 random modifying fields..........

what logic should i use??

thank u in advance.

regards.

[Former Member]

Hi Naveen,

The statement UPDATE only changes an existing DB entry otherwise sy-subrc 0.

The statement MODIFY updates an existing DB entry or, in no matching entry exists, inserts a new entry into the DB table.

So you can use UPDATE statement.

Thanks.

[Former Member]

Hai,

u can do this from UPDATE statement

first copy one record into one work area .

then change 10 fields of that work area with new values

then update the database table from the edited workarea

select single * from <table > into wa <condition>

wa-field1 = <value1>

wa-field2 = <value2>

..............................

.................................

update <dtab > from wa.

thanks & Regards

sarath p