native sql query in sap

[former_member190312]

Hi all,

my open SQL query is like

select matnr matkl from mara into corresponding fields of table i_mara for all entries in i_marc

where matnr = marc-matnr.

can u plz tell me the native sql for the same query?

Thanks.

pabi

[Former Member]

hi,

EXEC SQL PERFORMING form.

Native SQL Anweisung

ENDEXEC.

EXEC SQL

select matnr matkl from mara into corresponding fields of table i_mara for all entries in i_marc

where matnr = marc-matnr.

ENDEXEC.

For further ref pls refer to link...

[Former Member]

hi,

demo prg ADBC_DEMO provided by SAP ,,,,use CL_SQL_STATEMENT to start

http://help.sap.com/saphelp_nw04/helpdata/EN/fc/eb3b8b358411d1829f0000e829fbfe/content.htm

u can try

EXEC SQL.

SELECT connid, cityfrom, cityto

INTO :itab_mytable

FROM spfli

ENDEXEC.

thanks

[former_member222860]

Hi,

Use this :

data: begin of i_mara occurs 0,
          matnr like mara-matnr,
          matkl like mara-matkl,
       end of i_mara.

exec sql.
select matnr, matkl from mara where matnr in (select matnr from marc) into :i_mara
endexec.


loop at i_mara.
write:/ i_mara-matnr, i_mara-matkl.
endloop.

thanks\

Mahesh

[former_member190312]

ans