Get the filednames and characters from Data dictionary

[Former Member]

Hi All,

I want to download the list of fields field type,data element ,length and decimal to a xls sheet .

How can i do this one?

[Former Member]

Hello,

One way ....

From an ABAP program you can use FM DD_NAMETAB_TO_DDFIELDS.

Then you can download the internal table which is output from the FM.

Open the text file with Excel.

Regards

Greg Kern

[Former Member]

Table DD03L will give you list of Fields,Data Elements,Length,Decimals.

Just use select Query on the table DD03L and get the data into an internal table.

Use Gui_Download or SAP_CONVERT_TO_XLS_FORMAT to download the internal table

to a local Excel file.

Regards,

Gurpreet

[Former Member]

hi,

pls use table DD03L and extract all the required data with the help of Select query....

ie

code:
select TABNAME FIELDNAME ROLLNAME DOMNAME from dd03l INTO <INTERNAL_TABLE>.

" use FM SAP_CONVERT_TO_XLS_FORMAT 

ie CALL FUNCTION SAP_CONVERT_TO_XLS_FORMAT 

and download the table to an xls file on your system....

thanks