topic Re: How to update database table !!! in Application Development and Automation Discussions

How to update database table !!!

Former Member — Mon, 24 Mar 2014 05:07:03 GMT

hi all,

Please advice how to update database table with certain cndition needs to be checked.

Please consider below scenario.

have used enqueu and dequeue function to lock entries and also i have used BAPI so considering that return parameter . i want to update table

/tdk/st0027.

1. I want to update database table

2. there are certain condition needs to be checked like ,

loop at it_final into wa_final.

th_return-type = 'S'.

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

if th_final-vbeln = /tdk/st0027-vbeln and

th_final-posnr = /tdk/st0027-posnr and

th_final-etenr = /tdk/st0027-sdslno.

above condition which i need to check .and need to append below system fields need to be appended in table.

th_final-prstsind = '20'.

th_final-chgdate = g_date.

th_final-chgtime = g_uzeit.

th_final-chgprog = g_cprog.

th_final-chguser = g_uname.

append th_final to td_final.

update /tdk/st0027 FROM th_final.

endif.

endloop.

but i am getting error saying that "The type od database table and work area (TH_FINAL) are not unicode convertible"?

I am not able to understandwhat would be the solution for this ?

Thanks and regards,

Prasad K. NAralkar

Re: How to update database table !!!

Former Member — Mon, 24 Mar 2014 05:12:55 GMT

Hi,

The work area is not type compatible with the DB.

Check how you have declared the work area TH_FINAL.

It should be DATA: work area TYPE database table.

Regards

Sree

Re: How to update database table !!!

Former Member — Mon, 24 Mar 2014 05:54:25 GMT

yes have declared the same .but still its not allowing me to write modify or update query ?

Re: How to update database table !!!

nabheetscn — Mon, 24 Mar 2014 06:03:52 GMT

Prasad

Can you please paste declaration of TH_FINAL and TD_FINAL

Re: How to update database table !!!

Former Member — Mon, 24 Mar 2014 06:30:24 GMT

hi,

plz check the data type of your inter table th_final.

your table type must be same .

Re: How to update database table !!!

Former Member — Mon, 24 Mar 2014 06:53:24 GMT

please find above details as i am restrict to copy paste the perticular code .

Re: How to update database table !!!

Former Member — Mon, 24 Mar 2014 06:54:51 GMT

Re: How to update database table !!!

nabheetscn — Mon, 24 Mar 2014 06:56:40 GMT

Prasad

Please compare structure of typ_final with database table /tdk/st00027. These both are different. Please create a local internal table of same type as database table. append data into that table and update

Nabheet

Re: How to update database table !!!

Former Member — Mon, 24 Mar 2014 07:09:43 GMT

i think the structure of both table is not same. first declare a local internal table as same as structure of that db table. then move corresponding value of th_final to that local internal table. then, update it.

Re: How to update database table !!!

mayur_priyan — Mon, 24 Mar 2014 07:54:03 GMT

The error occurs in the UPDATE statement included in the code. In this statement it is seen that there is a mismatch of structure defined for the DDIC table /tdk/st0027 and that of your work area th_final.

try to create a structure w.r.t the DDIC table.

Eg: DATA: wa_temp TYPE /tdk/st0027.

MOVE-CORRESPONDING th_final TO wa_temp.

Then try to UPDATE using the temporary work area i.e wa_temp which has structure similar to that of the database table.

Re: How to update database table !!!

Former Member — Mon, 24 Mar 2014 09:28:31 GMT

Hi but i want to update only some of fields of them .. have declared another structure with same fields still i am getting same error. ??

Re: How to update database table !!!

RaymondGiuseppi — Mon, 24 Mar 2014 12:58:21 GMT

Either use a structure identical to database (and initially filled with current values of every field from database, else many fields will get initial value) or use a LOOP and a SELECT SET field = value WHERE statement.

Regards,

Raymond