topic table names in Application Development and Automation Discussions

table names

Former Member — Tue, 15 May 2007 11:10:30 GMT

hai experts,

how to find all the table names present in sap?

kavitha.

Re: table names

amit_khare — Tue, 15 May 2007 11:11:59 GMT

Table DD02L

Re: table names

former_member225631 — Tue, 15 May 2007 11:12:57 GMT

Use the table DD02L. This contains all table names.

Re: table names

Former Member — Tue, 15 May 2007 11:13:30 GMT

Hi,

DD02L contains all SAP Tables.

Regards

Nilesh

Re: table names

Former Member — Tue, 15 May 2007 11:13:52 GMT

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.

Re: table names

Former Member — Tue, 15 May 2007 11:14:52 GMT

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

Re: table names

former_member2382 — Tue, 15 May 2007 11:14:55 GMT

Hi,

U can goto SE16 and enter the table name DD02L.

U can search anything like field or dataelement ...

regards,

parvez

Re: table names

Former Member — Tue, 15 May 2007 11:15:06 GMT

refer table DD02l in data dictionary.

regards,

Venkat

Re: table names

Former Member — Tue, 15 May 2007 11:15:31 GMT

Hi Kavitha,

Table containing all DB table names - DD02L

Regds,

<b>Younus</b>

Re: table names

Former Member — Tue, 15 May 2007 11:15:43 GMT

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

Re: table names

Former Member — Tue, 15 May 2007 11:16:14 GMT

Hi,

U can check them in DD02L.

Regards

Kannaiah

Re: table names

Former Member — Tue, 15 May 2007 11:49:11 GMT

Thanks a lot Haritha