Native SQL

[Former Member]

I have one internal table which was processed and there is some change in one filed. Now I want to place these changes back into the database table.

Now as I told u previously to establish link between SAP table and legacy system connection between the table and dictionary has been dropped so I need to write Native SQL there. Such as

 

Loop at t_table into fs_table.

 

Exec sql.

   Update database_table_name

         Set changed_field_name = fs_table-changed_field_name

     Where filed = fs_table-field

Endexec.

 

If I give like this it is going to dump.

If I give values then it is working such as

Exec sql.

 

   Update database_table_name

         Set changed_field_name = u201812345u2019

     Where filed = u2018XYZu2019

 

Endexec.

But if I give variables it is not working, let me know what I can do

[Former Member]

HI,

What is the data type of fs_table-changed_field_name & fs_table-field.?

Have you ascertained that the variables are correctly filled during execution?

[Former Member]

hi,

in open sql you will check the type of repository structure

in similier .. check the datatype of the base database as

wen you use opensql it directly likes to the database so give the type of bothe variables fs_table-changed_field_name & fs_table-field as same

shiva

[Former Member]

copy_pasted_from

http://help.sap.com/saphelp_nw70/helpdata/en/fc/eb3b8b358411d1829f0000e829fbfe/content.htm

Edited by: Vijay Babu Dudla on Jan 19, 2009 5:25 AM

[Former Member]

Hi Thanks a lot,

My problem got solved....

[Former Member]

Can you please tell me what is the solution ..

I am facing the same problem

Regards,

Amit Teja V