Data Dictionary Tables and Fields

[Former Member]

Hi All,

I was wondering if there is a was to download table and field characteristics onto an excel spreadsheet using se11.

For example, KNA1 (customer master) I want to download the fields (data type, length, data element etc) to an excel spreadsheet just as it shows on the fields tab.

We re migrating data from legacy systems and we want to be able to compare the structures easily using spreadsheets.

Thanks for your help. <REMOVED BY MODERATOR>

Edited by: Alvaro Tejada Galindo on Feb 15, 2008 2:39 PM

[former_member194669]

Please check for table DD03L

and also please check for function module with

DDIF_*

and also check views

DD03K, DD03M, DD03N, DD03VT, DD03VV, DD05P, DD05Q

DD27M, DD35VV, DDVAL

a®s

Edited by: a®s on Feb 15, 2008 12:58 PM

[Former Member]

Hi,

check the table dd03l there one field is there with name TABNAME there just u give the table name for which u want to download the fields then u will get all the required fields and just down load them into excel sheet

for that u need to write one program first get all those fields into the internal table and by using the FM GUI_UPLOAD u can achieve task

i think i am clear to u....

Thanks

sunil kumar mutyala

[Former Member]

Thank you both. Will reward the points. Is there any way to get the field description (short text) with the rest of the information?

[Former Member]

Hi,

You get the field description in table DD03T, and short description of table in table DD02T

[Lakshmant1]

Hi Steven,

Check FM RPY_TABLE_READ. Also look at program RHDDIC00.

Thanks

Lakshman

[Former Member]

Hi,

Am not sure weather you will get all the Information together but you can assemble it by collecting different ways.

Here you can download Field ( Technical name and Description )

Go to Se17 give your Table Name

and press Enter

In output Select all the CheckBoxes and

In Sort Give 1(one) and Excute it

you will get one data scree here you click on Legend button

here you will get Description and field Technical names

Here you go Systems -> List -> Local File -> Spreadsheet -> Give your file name and save it.

Thanks,

Jak.

[Former Member]

go to se11> give table name> display.

extras--> hierarchy display

then expand all...

hierarchy--> print objects...

You will be able to print everything in that table...

[Former Member]

goto se11...

utilities--> table description generator

give the table name here and then execute..

print the list..

you will have all the fields and their description with their technical properties..

[Former Member]

Hi Steve,

My idea is to just develop one Z program, with the following details.

Use FM: REUSE_ALV_FIELDCATALOG_MERGE

Just pass table name from selection screen.

Create dynamic internal table on provided table on the selection screen

Pass below parameters in the FM.

I_STRUCTURE_NAME = <Table name from selection screen>

CT_FIELDCAT = < Dynamicall created internal table>

Display above fetched internal table, and download into excel , and keep required field data.

Hope this will take few min time to develop, but once for all in the project.

[Former Member]

Hi,

Check this

REPORT  z_struc_describe                        .

DATA  type_desc TYPE REF TO cl_abap_typedescr.

DATA : l_struc TYPE REF TO cl_abap_structdescr.

DATA : lt_comp TYPE abap_compdescr_tab,
       w_comp LIKE LINE OF lt_comp.

PARAMETERS : p_table TYPE tabname.

CALL METHOD cl_abap_complexdescr=>describe_by_name
  EXPORTING
    p_name         = p_table
  RECEIVING
    p_descr_ref    = type_desc
*  EXCEPTIONS
*    TYPE_NOT_FOUND = 1
*    others         = 2
        .
IF sy-subrc <> 0.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
*            WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.

l_struc ?= type_desc.

lt_comp = l_struc->components.
WRITE : 5 'Field',
        25 'Data type',
        40 'Length',
        50 'Decimals'.

LOOP AT lt_comp INTO w_comp.
  WRITE : /5 w_comp-name,
           30 w_comp-type_kind,
           35 w_comp-length RIGHT-JUSTIFIED ,
           45 w_comp-decimals RIGHT-JUSTIFIED .
  CLEAR w_comp.
ENDLOOP.

This program has a parameter for accepting a table name/ structure name that is present in the Data dictionary and outputs a list with the field name, data type, lenght and the decimals.

regards,

Advait

[vivekanandan_dharumalinga]

Hi,

Your solution has helped me in getting Table Details. Really Great thanks on your solution