2014 Nov 21 10:17 AM
Dear Experts,
I want to export structures of data dictionary to text or excel file. How can I do this. ?
I have searched help but no solution found. Please remember that I am talking about structure but not table structure.
I mean I want to export the all columns with data types and length into text file. or excel file.
Regards,
Aneel
2014 Nov 21 10:33 AM
2014 Nov 21 10:33 AM
2014 Nov 21 10:38 AM
Please use function module DD_NAMETAB_TO_DDFIELDS to get structure.
2014 Nov 21 10:39 AM
Hi Aneel,
Please follow below Steps.
1) Se11 -> Viewname -> Display -> Right Click on Fields -> Hierarchy Display
2) It will open 1 new Session -> Click on Print Dropdown and select Print Preview of View
3) Now Click on System -> List -. Save -> Local File -> Unconverted -> Select File with Extension .txt
-> Click on generate .
You will get your Work Done. Please let me know weather it is useful or not.
Regards,
Sagar
2014 Nov 21 10:48 AM
There is no print drop down option I am seeing . Please send the image if you can.?
2014 Nov 21 10:55 AM
2014 Nov 21 1:25 PM
Hi Aneel,
It will be good if you can close the thread ,so other peoples who will face the same difficulties can refer this thread and it will be more helpful for them.
Also if got the solution other than mentioned here, so please share with us. It might be helpful for all.
Regards,
Sagar
2014 Nov 26 4:19 AM
Dear Sagar,
There is no such option. Please see attached image. May be this is the version issue.
But many thanks for help.SRTT_GET_REMOTE_TABLE_DEF and DD_NAMETAB_TO_DDFIELDS solved my problem.
Regards,
Aneel
2014 Nov 21 12:10 PM
Hi Anil,
You can try using FM SRTT_GET_REMOTE_TABLE_DEF. Hope this will help.
Regards
Lakshman
2014 Nov 26 4:23 AM