Creating tables on SQL studio and viewing the table in the SAP system

[Former Member]

i have just created a table using the SQL studio and wants to use it view it in the SAP system using the SAP logon. till now i have not found a way to create it therefore any help is much appreciated.

[Former Member]

so how is it am i going to go about to do it the correct way??? sorry i'm new to SAP.

[lbreddemann]

Hey, how about actually reading my replies?

I wrote, that the correct (or better the intended) way to create a new table for ABAP use is to create it in the ABAP dictionary, transaction SE11.

Might be a good idea to check the documentation, when you don't know how things work...

[Creating a Database Table and Data Elements|http://help.sap.com/saphelp_nw70/helpdata/EN/6c/f2934259a5c66ae10000000a155106/frameset.htm]

regards,

Lars

[lbreddemann]

Hmm... you want to see tables via SAPLogon ??

Ok, let's assume you really want to access tables via ABAP instead.

For that you've two options:

1. Create the table in the ABAP dictonary (SE11) exactly like you created it in the database and activate the table.

After that you can access the table via SE16 or any ABAP as you like.

2. You don't create the table in the ABAP dictonary and use native SQL to access the data.

Neither of these options is meant to be the way to do it.

The correct way would be to design the whole table in the ABAP dictionary and create the table on the database from that.

regards,

Lars