topic Re: Database table names in Application Development and Automation Discussions

Database table names

Former Member — Wed, 28 Nov 2007 11:19:19 GMT

Hi Guys,

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

Regards,

Chandru

Re: Database table names

Former Member — Wed, 28 Nov 2007 11:20:35 GMT

hi,

in SE11

Re: Database table names

Former Member — Wed, 28 Nov 2007 11:20:42 GMT

DD02L-SAP Tables

Re: Database table names

Former Member — Wed, 28 Nov 2007 11:21:20 GMT

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.

Re: Database table names

Former Member — Wed, 28 Nov 2007 11:21:35 GMT

DD02L is table of all tables

check DD02T for all table texts

Re: Database table names

former_member404244 — Wed, 28 Nov 2007 11:21:58 GMT

Hi,

goto SE11,

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

Regards,

Nagaraj

Re: Database table names

Former Member — Wed, 28 Nov 2007 11:24:32 GMT

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.

Re: Database table names

former_member386202 — Wed, 28 Nov 2007 11:25:30 GMT

Hi,

CHeck Table DD02L SAP Tables.

Regards,

Prashant

Re: Database table names

Former Member — Wed, 28 Nov 2007 11:31:12 GMT

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.

Re: Database table names

Former Member — Wed, 28 Nov 2007 13:56:15 GMT

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