on 10-01-2009 3:42 PM
One of the table in Production system contains 450K entries. I want to download the entire table records. Is there a way of doing it other than exporting to a local file. Since there is too many entries I dont think it is a good idea to display all the entries and save it as a local file. Can any one please advice on this.
A side note --> something which I noticed from the same OP around the same time:
I guess the ABAP route is being explored ...
Cheers,
Julius
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
we had once the request to download an amount of data from a table (wich may exceed the memory limits
if done over SE16).
What we did on the Oracle system was using a dedicated Oracle user with SELECT privileges to the table in question.
We used him in an ODBC datasource wich pointed to the Oracle Instance of the SAP system and used the ODBC to extract into XLS , Access , you name it....
We have the policy to make it possible to invite other clients to the SAP-Oracle Instance for these tasks
(check out INVITED_NODES Parameter in PROTOCOL.ORA, SQLNET.ORA)
bye
yk
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Eric,
99% of the time we need only one or few tables to extract from. It's a kind of Reporting snapshot because we don't use the ODBC sources (or similar) in applications.
Another technique are database links wich gives you another extract option .
Sometimes the good , old SQL comes to the rescue when the board wants to have these figures and you have no ABAP development resources at hand to program that stupid little extract program (and according to Murphy' s law breaks down because developer thinks memory is cheap and an unlimited resource)
I agree:
Normally you would extract the table's data in a file per SAP procedure and FTP it to your target system (i.e. ORACLE).
where you could use i.e. the extended table feature to load the data into the DB.
bye
yk
I'd go for a small ABAP doing a select and writing the output directly to a file.
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I hope you are not planning to put them in Excel?
depending on your needs, solutions exist.
so, what do you plan to do with 450K records?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
450K rows is not so much, even I also don't see a reason to put them into excel. If the average row length is 100 bytes, then you have 45mb data, if the row has 1kb then it would be 450mb, at this point the SAP system might run into memory issues, but your pc also will.
You can try to load a part of the table and check how much memory is beeing used. It will be significantly more, than the net data amount. You can use transaction SM04 , SM50 and ST02 to monitor the memory usage. The memory will be freed, after you exit the transaction.
Regards, Michael
SAP works best, when put into excel!
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.