on 05-08-2008 1:18 PM
Hi ALL
one have a listing of all tables and fields (with characteristic, data type, length etc) for Sales and Distribution. I know that you can view in ECC using t-code SE11 and using vbap, Vbfa, Vbkd,Vbap kna1, knb1, etc, but how can I extract this information or put into MS excel.
If anyone has this already in spreadsheet format please reply...
Thanks in advance for your help. Points given..
Hi
Once you execute a table, go to system>list>save>Local file and select spread sheet to save the list in excel.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear rashmi arora
Go to OIDV, give some dummy file name in PC Database, select the client from which you would like to download in the field "RFC Destination", and table name say KNA1 and select either "Download" or "Log" and execute.
You will get the desired result. Like this, for all tables, you can convert into excel.
thanks
G. Lakshmipathi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi
you can do this through go to the transaction se11 and give whatever the tables you require after that . press control + Y and select all with mouse. Then copy control +c then past in your excel sheet. you will get it.
If you feel this answer is valuable please reward with points. You will get more answers for further queris
Thanks & Regards
rack29
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.