topic Re: Data extraction using se16 in Application Development and Automation Discussions

Data extraction using se16

Former Member — Thu, 26 Jan 2006 10:34:42 GMT

Could anyone help please?

I am trying to extract data out of various SAP tables e.g VBAK, VBAP etc., using transaction se16. Unfortunately the maximum width of the list that's produced is 1023, which means that some fields that I need are not being displayed. Does any one have any ideas of how I can overcome this? Alternatively does anyone know of any free tools/other methods that allow me to get data out of SAP tables? i am a functional person and need to upload data into MS-Access to do some queries.

Thanks in advance.

Re: Data extraction using se16

manuel_bassani — Thu, 26 Jan 2006 10:45:34 GMT

Hi Elizabeth,

in se16 (when data is displayed) choose from menu User Parameters...

In the popup choose ALV List and click OK

With ALV list you can easily dwnload data in text or excel

Men u Edit->Download.

Regards, Manuel

Re: Data extraction using se16

Former Member — Thu, 26 Jan 2006 10:48:31 GMT

Hi Elizabeth,

why don´t you use transaction se16n and then the download functionality for export in excel.

Or if this doesn´t help, try using a quickview and thn display in excel.

Hope to help

Ute

Re: Data extraction using se16

Former Member — Thu, 26 Jan 2006 12:34:09 GMT

Thanks very much!