writting SQL statement

[Former Member]

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]

check this

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/40bec8da-4cd8-2910-27a9-81f5ce10...

a®

[Former Member]

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]

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

[former_member156446]

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]

Yes you can use ABAP queries.

You could have easily found this answer.

Regards,

Lalit Mohan Gupta.

[Former Member]

Look at transaction ST05.

Rob

[Former Member]

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.