topic Re: writting SQL statement in Application Development and Automation Discussions

writting SQL statement

Former Member — Sun, 19 Apr 2009 04:02:28 GMT

dear all,

is it possible to write sql statement in ECC without abap? e.g. test a sql statement query with any abap required?

former_member194669 — Sun, 19 Apr 2009 04:13:55 GMT

check this

a®

former_member156446 — Sun, 19 Apr 2009 04:27:33 GMT

as said above can use SAP Queries

or a part of SQL can be used in ABAP using [NAtive SQL|http://help.sap.com/saphelp_nw70/helpdata/en/fc/eb3b8b358411d1829f0000e829fbfe/content.htm]

Former Member — Sun, 19 Apr 2009 05:35:49 GMT

Yes you can use ABAP queries.

You could have easily found this answer.

Regards,

Lalit Mohan Gupta.

Former Member — Sun, 19 Apr 2009 07:17:22 GMT

thanks... but it seems to be lots of drag and drop. any function that allows me to write proper sql statements with cursor option and such?

former_member156446 — Sun, 19 Apr 2009 15:17:10 GMT

native SQL is a good option, where ABAP will understand you core SQL commands and interprit that in SAP.

Former Member — Sun, 19 Apr 2009 20:25:31 GMT

Look at transaction ST05.

Rob

Former Member — Mon, 20 Apr 2009 04:34:14 GMT

Hi..

You can use SQVI transaction to create query. In this, transaction u can create query with table join.

Just, check in this transaction, I think it help u.