table names

[Former Member]

hai experts,

how to find all the table names present in sap?

kavitha.

[amit_khare]

Table DD02L

[former_member225631]

Use the table DD02L. This contains all table names.

[Former Member]

Hi,

DD02L contains all SAP Tables.

Regards

Nilesh

[Former Member]

Hi

Go to se11 there in the database field click on F4 and then click the button SAP Applications, then all the database tables module wise will be displayed.

Regards

haritha.

[Former Member]

Thanks a lot Haritha

[Former Member]

Hi

It is not that easy to find every table name in SAP.

first press F1 help on any field , take the technical help which displays the field name and the table(not always) name.

People need some functional exposure to different SAP modules and if they know the process with Tcodes/ process flow, they will come to know the related process flow tables for each application in SAP.

There are certain defaults w.r.t to tables:

all customer master related starts with KN*

Material related with MA*

Sales related with V*

MM related E*

QM related with Q*

like that

there is no hard code rule to find the related table.

You may get the all table names from DD02L table, but which table belongs what functionality is not known correctly.

Reward points if useful

Regards

Anji

Message was edited by:

Anji Reddy Vangala

[former_member2382]

Hi,

U can goto SE16 and enter the table name DD02L.

U can search anything like field or dataelement ...

regards,

parvez

[Former Member]

hi

refer table DD02l in data dictionary.

regards,

Venkat

[Former Member]

Hi Kavitha,

Table containing all DB table names - DD02L

Regds,

<b>Younus</b>

[Former Member]

hi kavitha,

through this customized program u can get the names and details of perticular module table.

&----

---

*& Report ZVIJ_TABLE_DISPLAY *

*& *

&----

---

*& *

*& *

&----

---

REPORT ZVIJ_TABLE_DISPLAY.

data : begin of it_dd03l_one occurs 0,

tabname type dd03l-tabname,

end of it_dd03l_one.

data : begin of it_details occurs 0,

tabname type dd03l-tabname,

ddtext type dd02t-ddtext,

end of it_details.

DATA : BEGIN OF ITAB OCCURS 0,

TEXT(3) TYPE C,

END OF ITAB.

tables : dd03l, dd02l.

*REFRESH IT_DD03L_ONE.

SELECTION-SCREEN: BEGIN OF BLOCK BLK1 WITH FRAME TITLE TEXT-001.

PARAMETERS : TABTYPE(3) TYPE C.

SELECTION-SCREEN: END OF BLOCK BLK1.

*LEAVE TO LIST-PROCESSING AND RETURN TO SCREEN 0.

*module PROCESS input.

START-OF-SELECTION.

IF TABTYPE = 'MAT'.

select tabname

from dd03l

into table it_dd03l_one

where tabname LIKE 'M%'.

ENDIF.

IF TABTYPE = 'PUR'.

select tabname

from dd03l

into table it_dd03l_one

where tabname LIKE 'E%'.

ENDIF.

IF TABTYPE = 'SAL'.

select tabname

from dd03l

into table it_dd03l_one

where tabname LIKE 'V%'.

ENDIF.

IF TABTYPE = 'FIC'.

select tabname

from dd03l

into table it_dd03l_one

where tabname LIKE 'B%'.

ENDIF.

LOOP AT IT_DD03L_ONE.

SELECT SINGLE * FROM DD02L WHERE TABNAME = it_dd03l_one-tabname AND

TABCLASS <> 'INTTAB'.

if sy-subrc <> 0.

continue.

endif.

it_details-tabname = it_dd03l_one-tabname.

select single ddtext

from dd02t

into it_details-ddtext

where tabname = it_details-tabname

and ddlanguage = 'EN'.

append it_details.

clear it_details.

ENDLOOP.

END-OF-SELECTION.

LOOP AT IT_DETAILS.

write 😕 it_details-tabname color col_key hotspot on,

40 it_details-ddtext color col_normal.

DELETE ADJACENT DUPLICATES FROM IT_DETAILS COMPARING TABNAME.

hide it_Details-tabname.

ENDLOOP.

*endmodule.

TOP-OF-PAGE.

WRITE : / 'TABLE NAMES', 40 'DESCRIPTION OF TABLES'.

ULINE.

at line-selection.

set parameter id 'DTB' field it_details-tabname.

call transaction 'SE11' and skip FIRST screen.

&----

---

*& Module PROCESS INPUT

&----

---

• text

----

---

" PROCESS INPUT

[Former Member]

Hi,

U can check them in DD02L.

Regards

Kannaiah