topic Re: Data Dictionary Tables and Fields in Application Development and Automation Discussions

Data Dictionary Tables and Fields

Former Member — Fri, 15 Feb 2008 17:46:56 GMT

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

Re: Data Dictionary Tables and Fields

former_member194669 — Fri, 15 Feb 2008 17:53:02 GMT

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

Re: Data Dictionary Tables and Fields

Former Member — Fri, 15 Feb 2008 18:11:34 GMT

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

Re: Data Dictionary Tables and Fields

Former Member — Fri, 15 Feb 2008 19:37:06 GMT

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

Re: Data Dictionary Tables and Fields

Former Member — Fri, 15 Feb 2008 20:20:08 GMT

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.

Re: Data Dictionary Tables and Fields

Former Member — Fri, 15 Feb 2008 21:50:12 GMT

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...

Re: Data Dictionary Tables and Fields

Former Member — Fri, 15 Feb 2008 22:01:11 GMT

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..

Re: Data Dictionary Tables and Fields

Former Member — Fri, 21 Nov 2008 09:06:36 GMT

Hi,

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

Re: Data Dictionary Tables and Fields

Former Member — Fri, 21 Nov 2008 09:39:06 GMT

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.

Re: Data Dictionary Tables and Fields

Former Member — Fri, 21 Nov 2008 10:10:35 GMT

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

Re: Data Dictionary Tables and Fields

Lakshmant1 — Fri, 21 Nov 2008 10:22:25 GMT

Hi Steven,

Check FM RPY_TABLE_READ. Also look at program RHDDIC00.

Thanks

Lakshman

Re: Data Dictionary Tables and Fields

vivekanandan_dharumalinga — Wed, 02 Dec 2015 09:25:33 GMT

Hi,

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