Table that holds Table and column data

[#1]

Hi,

I am looking for a table that contains a list of table and column description for example, MARA and its columns.

I would appreciate if anyone can tell me.

Sunny

[carlos_verabaca · Accepted solution]

Use table DD03L.

Regards,

Carlos.

[Former Member · Accepted solution]

Hello Carlos,

Thank you for your help.

I am sorry I should have been more clear on my question. I know that I can get the list of columns for a table from DD03L. What I am looking for is the textual description for table and its columns. For example, where is the description for table MARA? I also looked in DD02T and DD03T but I don't find this information.

Appreciate your help.

Sunny

[Former Member · Accepted solution]

Hello,

I am not aware of such a table but I would love to know if there is any.

Try this function module. I hadnt tried this so far so I am not aware of the output. Hope this will solve your purpose.

DDIF_FIELDINFO_GET - FM to display all the fields of a table

Regards,

[Former Member · Accepted solution]

Hi

Table description can be extracted from DD02T

( Or using FM TXW_GET_TEXT_FROM_DDIC )

<b>TABLES : DD02T.

PARAMETERS PTABLE LIKE DD02T-TABNAME.

SELECT SINGLE * FROM DD02T WHERE DDLANGUAGE = SY-LANGU

AND TABNAME = PTABLE .

WRITE 😕 DD02T-TABNAME , DD02T-DDTEXT.</b>

Field descrition you can get from DD03T if the fields are direct type entry and have no dataelement . For fields having dataelemnt the text can be retrived from DD04T.

Cheers

[Former Member · Accepted solution]

either you have not asked well or i am unable to understand

but i think if you display MARA in SE11 .

you can see its desc as well as desc of all its column

what are you exactly looking for .

do you want to use these somewhere in a program

please explain more

regards

[Former Member · Accepted solution]

Sanjay,

Thank you for your reply. However, I looked into DD02T but it contains only table info. I am looking for columns' textual description. I also Looked into DD04T but I could not find. For example, I want to find MARA and the text description of the columns in it.

Sunny

[Former Member · Accepted solution]

Surpreet,

Transaction code SE11 will not help me because I am looking for the table that contains table and text description of the columns. I will incorporate this in ABAP code.

Sunny

[RichHeilman · Accepted solution]

Use table DD03L to get the data element, hit this table with your tablename, for each field, there should be a data element assigned to it, you need to link to DD04L and DD04T to get the text of the data element. If there is not data element for that field, then you need to go to DD03T to get the text. In this table this is the text that is assigned to the field when a data element is not used.

Regards,

Rich Heilman

Message was edited by: Rich Heilman

[RichHeilman · Accepted solution]

Here is a sample program. Of course, this could be cleaned up a bit, but you get the idea.

report zrich_0002
       no standard page heading.


parameters: p_table(30) type c.

data: begin of itab occurs 0,
      tabname type dd03l-tabname,
      fieldname type dd03l-fieldname,
      rollname type dd03l-rollname,
      ddtext(50) type c,
      end of itab.

data: xdd04l type dd04l.
data: xdd04t type dd04t.
data: xdd03t type dd03t.

select * into corresponding fields of table itab
            from dd03l
                   where tabname = p_table.

loop at itab.

  select single * from dd04l into xdd04l
               where rollname = itab-rollname.

  select single * from dd04t into xdd04t
               where rollname = itab-rollname
                and ddlanguage = sy-langu.
  if sy-subrc  = 0.
    itab-ddtext = xdd04t-ddtext.
    modify itab.
    continue.
  endif.


  select single * from dd03t into xdd03t
                  where tabname = itab-tabname
                    and fieldname = itab-fieldname
                    and ddlanguage = sy-langu..
  if sy-subrc  = 0.
    itab-ddtext = xdd03t-ddtext.
    modify itab.
    continue.
  endif.



endloop.


loop at itab.
write:/ itab-tabname, itab-fieldname, itab-rollname, itab-ddtext.


endloop.

Regards,

Rich Heilman

[Former Member · Accepted solution]

Use DDIF_FIELDINFO_GET. This will give all the information about the fields of the table including data elements, domains, check table, and the descriptions.

Now if that is not what you are looking for, please let us know exactly what you need with the example of MARA as you mentioned.

Srinivas

[andreas_mann3]

Hi Sunny,

better use view DD03<b>M</b>

regards Andreas