How to Access table in SAP

[Former Member]

Hi Gurus,

Actually I am new to SAP and was wondering if somebody could tell me how to access a table in SAP where the relavant data is being stored.

e.g. If I want to check table VBAK, what wouldbe the menupath/t-code?

Thank you.

Juhi Singhania

[ferry_lianto · Accepted solution]

Hi,

You can use transaction code SE16 or SE16N to browse the content of VBAK.

Also you can use transaction code SEARCH_SAP_MENU to find menu path for SE16 or SE16N.

Regards,

Ferry Lianto

Please reward points if helpful.

[Former Member · Accepted solution]

Hi Ferry,

Thanks for the reply. Is SE16 or SE16n is the tcode to view all the tables in SD. Suppose I want to view any other table than VBAK, then what should I do?

Thanks

juhi

[Former Member · Accepted solution]

Hi,

Yes SE16 is the t-code to view all tables in SAP (all modules). Inside SE16 you should know the table name to key in to retrieve the data.

If you are not sure of the table name, you can keep your cursor on the field name (in any screen) & just double click that field name.

Then you need to click on the "technical infor" to look for the table name & element.

This way you can use SE16.

Hope this helps !

Reward points if useful

[Former Member · Accepted solution]

Hi Juhi,

You can see the data related to ABAP tables using SE11/SE16. In SE16 you can see all the entries related which are available for a particular table. In SE11 you can see all the fields in a particular table with field length and type of field etc.

You can know what is the field name and table in which this field is available using F1 and technical Information as Pri Suggested.

You can also get to knnow in which tables a particular field exists using SE15.

Pl revert back for anu doubts

Regards

Srini

[staerk · Accepted solution]

In SE16, when I type VBAK and Enter, I get an error message saying "Table VBAK is not active in the dictionary". Same for tables T100 and SU01.

[Former Member]

Hi Juhi,

You can use

T.Code : SE11 --> To see Table fields and Data elements Ex:- VBAK - With Description / Text of the Table.

T.Code : SE16 --> Browsing any table data Ex:- VBAK -

SM30 : will be used for maintaining Ztbale Entries( if table maintainace view is maintained )

Hope this will be helpful to you.

Please reward points if helpful,

Warm Regards,

Sateesh.Kandula

[Former Member]

Hi Juhi,

Since you are new to SAP you might want to have this link handy.. it has several useful information including the tables list

http://www.erpgenie.com/abap/tables.htm

http://www.erpgenie.com/saptech/transactions.htm

http://www.sap-img.com/general/find-the-list-of-sap-transaction-codes.htm

http://www.sap-img.com/basis/useful-sap-system-administration-transactions.htm

Thanks

Janani

award points if helpful

[staerk]

the first two give me 404 errors

[Former Member]

HI,

You can access tables using SE11 - wherein you can find the data table type( just double click once the table is visible)

SE16 or SE16n is the databrowser where you can see the particular fields and structure of the tables entered.

You can also go to SM01 if you have problem relating to T Codes and their relative programs.

please reward if helpful

thanks

adi