Question:
why i go to edit menu and do download, sap unable to download completely? how to download all data?
for example bseg, very large file but i only can download limited records and limited columns. why?
another issue is about selection screen for table bseg. when i put company and fiscal year, immediately retrieve but when i put company, fiscal and vendor, it takes ages until timeout. why?
Answer:
you want to download BSEG?
Are you serious?
how many millions records you want to download? in what format, Excel?
_________________
SapFans Moderator
NetWeaver ‘04–SAP Web AS for ORACLE certified
Search: /forums/search.php
SAP Notes: http://service.sap.com/notes
SAP Help: http://help.sap.com
Basic Rules: /forums/viewtopic.php?t=222759
Answer:
i got the problem about selection screen for table bseg. when i put company and fiscal year, immediately retrieve but when i put company, fiscal and vendor, it takes ages until timeout. why so?
this has made me resorted to download. infact i just want to download about 8 columns. but when download, sap does not download the complete number of records. it only download about 200. why so?
Answer:
It only downloads 200 records because you tell it to download 200 records. Have a look at the screen and you will see a field titled "Maximum No Of Hits." Blank this field out and it will download all records.
As for the fields that you want, from the menu bar, Settings->List Format->Choose fields. Click Deselect all, and then check the fields you want in your output list (You can use Ctrl F to find fields if you need to).
However, as Snowy says Are you serious ?? Excel will not load your output file! Oh, and you'd better be prepared for a loooong wait!
_________________
Regards
R
Abap KC
SFMDR
Answer:
Oh, and you'd better be prepared for a loooong wait!
your session will most probably timeout before you get the whole table downloaded...
_________________
SapFans Moderator
NetWeaver ‘04–SAP Web AS for ORACLE certified
Search: /forums/search.php
SAP Notes: http://service.sap.com/notes
SAP Help: http://help.sap.com
Basic Rules: /forums/viewtopic.php?t=222759
Answer:
You're better off writing a small program to output the entire table (or specific selections) to a file on the SAP server. This way you could run it as a background job, which you will definitely need to do if you want the whole table!
The reason the select is so slow when entering certain selections is because it's probably not using the primary index of the table, which basically means that SAP has to trawl through EVERY record in the table to find the ones you want.
Check out the SAP documentation on database tables and cluster tables.