Now I need to insert 60 sap-tables into A table not in sap DB ,according to a formula.so i need to use dynamic native sql, but i find it can not work.
a test example as follow: just as native sql in sap server.
DATA: l_matnr LIKE mara-matnr.
CONCATENATE 'SELECT matnr FROM MARA INTO :L_MATNR WHERE MATNR ='
SEPARATED BY space.
system return :
SQL error "-104" occurred when executing EXEC SQL.
I wonder the right use of dynamic native sql .
Message was edited by: