topic Re: doubt in updating database table in Application Development and Automation Discussions

doubt in updating database table

Former Member — Mon, 16 Oct 2006 13:43:00 GMT

hi all

i want to modify values ztable from a internal table ....

for eg : the ztable contains matnr and accept_qty

matnr qty

mat01

mat02

i need to modify qty of the table .. i am using where condition (ie modify where matnr = ) but where condition is not working for database tables .... how to proceed with this ..

thanks

lokesh

Re: doubt in updating database table

andreas_mann3 — Mon, 16 Oct 2006 13:45:09 GMT

hi,

try this command:

update ztab
  set f1 = 1
...
  where f2 = 'X'.

Message was edited by: Andreas Mann

Re: doubt in updating database table

Former Member — Mon, 16 Oct 2006 13:46:50 GMT

Hi Lokesh Chander,

Can you show your code?

It should be something like this:

data: begin of itab occurs 0.

include structure ztab.

data: end of itab.

itab-matnr = 'mat1'.

itab-accept_qty = 1.

append itab.

clear itab.

itab-matnr = 'mat2'.

itab-accept_qty = 1.

append itab.

clear itab.

modify ztab from table itab. "itab must be of the same type as ztab.

Re: doubt in updating database table

Former Member — Mon, 16 Oct 2006 13:49:07 GMT

Use conversion exit to convert the Material into SAP internal format before modify/update statement.

Normally this will fails when you are passing MATNR directly without conversion. Just have a look in debug.

Thanks

eswar

Re: doubt in updating database table

anversha_s — Mon, 16 Oct 2006 13:54:21 GMT

hi,

before that :- modify statemnt will modify a record if there is record having the same key like that of record in work area.

if there is no record in itab with key of work area record, it will insert a new record in itab.

look this sample code.

*modify internal table

loop at itab into wa.

wa-field1 = data1.

wa-field2 = data2.

wa-field 3= data3.

modify itab from wa transporting field1 field2 field3 where key_field = wa-keyfield. "there shuld not be any chang in key field.

endloop.

*now update database table

*work area and data base structure shuld be same type

if itab[] is not initial.

modify ztable from table itab.

endif.

rgds

anver

if hlped pls mark points