SQL in ABAP

[Former Member]

Hi!

Someone can explain me the process to read database tables with sql in abap, and where can i see this tables.

Thanks. Bty.

[venkata_ramisetti]

Hi,

If you want to see the table definition in SAP, go to transaction SE11 and give your table name and click Display.

If you want to see the data in the table, go to transction SE16 and give your table name and click Table contents and execute.

You can use select statement in ABAP to fect data from database tables.

Click the below link to know more in the SAP Help Documentation.

http://help.sap.com/saphelp_47x200/helpdata/en/fc/eb3969358411d1829f0000e829fbfe/frameset.htm

Thanks,

Ramakrishna

[RichHeilman]

You can see these tables via SE11 and SE16(data browser). In ABAP, we use Open SQL, which is an abstraction of the native SQL.

http://help.sap.com/saphelp_nw2004s/helpdata/en/c9/5472f9787f11d194c90000e8353423/frameset.htm

Regards,

Rich Heilman

[Former Member]

Ok!!!

Thanks everybody.