Notes for Extraction Using the SAP
Query 
Client Dependency
Only the InfoSets that you have created globally, that is, independent of client, are available. You can set this global area in the initial screen of InfoSet maintenance, under Environment ® Work Areas.
Size Limits When Performing Extraction with SAP Query InfoSets
When extracting using an InfoSet, the system firstly collects all data in the main memory. Afterwards, this data is transferred to the BW system via the Service API interface. The size of the main memory is important with this type of extraction. It is suited to limited data volumes.
As of SAP Web Application Server 6.10, extraction of mass data is possible for certain InfoSets (tables or table joins).
See also: