SE16/SE11 Issue

[Former Member]

Dear Friends,

My user wishes to extract data for nearly 55000 material from MARA table at once in SE16/SE11.

Is it possible???

Regards,

Alok.

[Former Member]

Hi,

Yes you can extract, by using SE11 or SE16 Tcodes when you excuting in selecting screen you have to give maximum hits 55,000 once you get the data

you can export into a file like Excel or any file. or if it is time taking then

you have to write a small zprg. or ABAP query to fecth the data and export into a file the job can run in backgroub process also when you execute the prog.

in fornt end it won't disturb you, you can carry on with your work it will do in backgrond only.

Regards

Ganesh

[Former Member]

My dear friend it's not that easy. Had it been I'd have done it by now myself. Merely changing the max. no. of hits doesn't serve any purpose in this scenario. There should be some other way...

Thanks & Regards,

Alok.

[Former Member]

Hi,

Yes its possible, before selecting Execute in SE16 transaction for the table ask the user to change the maximum No of hits field from 200 to 55000 as the default will be 200

Regards,

Kasi S

[Former Member]

Dear All,

Thanks for responding. I agree it should be possible but at present it is resulting in an DBIF_RSQL_INVALID_RSQL :Er ror in the module RSQL accessing the database inter face.Runtime error.

What's the way out??

Alok.

[raymond_giuseppi]

It's possible, but your system will lag, as a very big temporary internal table will be created, Your PC/presentation server will lag too....

Be aware of possible dumps like SYSTEM_IMODE_TOO_LARGE or SYSTEM_NO_ROLL.

Regards

[Former Member]

Yes...

while giving selection-criteria...

"Maximum No. of Hits" field will be there...

In that you can specify the no. which you want.

If you want to get the data using SELECT's from report then use PAKAGE SIZE

SELECT. ... INTO|APPENDING [CORRESPONDING FIELDS OF] TABLE itab [PACKAGE SIZE n] you can give N as 5000, 10000 based on your requirement. Then it will get the data in multiples of "N"

[Former Member]

Hi,

yes it is possible , but again u have to check perfomance issues because as u r going to fetch 550000 records, so u have to take care of that.

Again it depends on which method u use to fetch data.

Reward points if useful..

Regards

Nilesh

[Former Member]

hi,

ya it is possible through program.

u have to write a simple qury for fetching material from mara into internal table.

then thru gui-download u download in the text file or as ur user want.

Rewards point if helpful.

Santosh.