topic Re: native sql query in sap in Application Development and Automation Discussions

native sql query in sap

former_member190312 — Fri, 09 Jan 2009 02:53:28 GMT

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

Re: native sql query in sap

Former Member — Fri, 09 Jan 2009 03:00:06 GMT

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...

Re: native sql query in sap

Former Member — Fri, 09 Jan 2009 03:05:52 GMT

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

Re: native sql query in sap

former_member222860 — Fri, 09 Jan 2009 04:44:11 GMT

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

Re: native sql query in sap

former_member190312 — Sun, 01 Mar 2009 06:41:18 GMT

ans