Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Database table names

Former Member
0 Likes
4,139

Hi Guys,

Where can i find the names of all the database tables..

Regards,

Chandru

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
2,539

DD02L Table contains the SAP Tables.

DD02T Table contains the SAP Table Texts.

DD01L Table contains the Domains

DD01T Table contains the Domain Texts.

DD03L Table contains the Table Fields.

DD03T Table contains the Table Field Texts. (Language Dependent)

DD04L Table contains the Data Elements.

DD04T Table contains the Data Element Texts.

DD05s Table contains the Foreign Key Fields

Rewards if useful.

9 REPLIES 9
Read only

Former Member
0 Likes
2,539

hi,

in SE11

Read only

Former Member
0 Likes
2,539

DD02L-SAP Tables

Read only

Former Member
0 Likes
2,539

Hi,

Check the table name <b>DD02L</b> to view all the table names stored in R/3 and check the table <b>DD02T</b> to see the their table name descriptions.

Regards,

Omkar.

Read only

Former Member
0 Likes
2,539

DD02L is table of all tables

check DD02T for all table texts

Read only

former_member404244
Active Contributor
0 Likes
2,539

Hi,

goto SE11,

specify there DD* and press F4 and u can see lot of tables related to this

Regards,

Nagaraj

Read only

Former Member
0 Likes
2,539

Hi

DD02L Table..Here u will get all database Tables

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

1. Database tables are stored in table DD02L . Check it in SE11.

2. To process the fields with a Delimiter '#'. use the Split statement.

Eg:

DATA: V_RECORD(20) TYPE C VALUE 'ABC#123#USA'.

SPLIT V_RECORD AT '#' INTO V_NAME V_ID V_COUNTRY.

Reward if Helpful.

Read only

former_member386202
Active Contributor
0 Likes
2,539

Hi,

CHeck Table DD02L SAP Tables.

Regards,

Prashant

Read only

Former Member
0 Likes
2,540

DD02L Table contains the SAP Tables.

DD02T Table contains the SAP Table Texts.

DD01L Table contains the Domains

DD01T Table contains the Domain Texts.

DD03L Table contains the Table Fields.

DD03T Table contains the Table Field Texts. (Language Dependent)

DD04L Table contains the Data Elements.

DD04T Table contains the Data Element Texts.

DD05s Table contains the Foreign Key Fields

Rewards if useful.

Read only

Former Member
0 Likes
2,539

hi,

last words with L and T only. L->Database Fetch T-> Text

DD03L -


>Table Fields.

DD03T -


> Table Field Texts.

DD04L -


> Data Elements.

DD04T -


> Data Element Texts.

Regards,

s.suresh

Message was edited by:

suresh selvarajan