Datasource Extraction?how mnay records process from BW datasource to r3

[Former Member]

I have a data source in BW. How can I find out that if, how many records does it process at once when it tries to retrieve data from R/3? How can I change the setting? What is standard?

The issue is I got 46000 records in a table and when I try to use my extractor in u201CRSA3u201D when given more records to pull instead of 100, at once it takes forever? So how does BW data source pulls data, does it also pulls 100 records at once or more?

[Former Member · Accepted solution]

Hi Amer,

When you extract the data directly in BI it sends the data based on data package size you have defined not based on RSA3 setting.

RSA3 transaction is given so that you can check particular data on source system side if you have some issue or for test. It is kind of test run and for that they have given you additional option for selecting data.

Regards,

Kams

[Former Member · Accepted solution]

and where can i define this " data package size " is this in the infopackage or SPRO.

[Former Member · Accepted solution]

Hi,

Go to info package> Scheduler>DataS. Default Data Transfer and you can define the package size.

About data package , the general formula is:

Package size = MAXSIZE * 1000 / size of the transfer structure, but not more than MAXLINES.

You can look up the transfer structure (extract structure) in Table ROOSOURCE in the active version of the DataSource and determine its size via SE11 (DDIC) -> Utilities -> Runtime object -> Table length.

Please refer to note 417307 " Extractor package size: Collective note for applications" for general information on the package size.

Regards,

Kams

[Former Member]

You can pull more than 100 records, "data records/call" is maximum number of records you need for each call and "display extraction calls" is number of call you need.

Please wait for some time to get the records if data is not coming you can go to debug mode to check where ectractor is stuck.

Regards,

Kams

[Former Member]

so does this means every time i set a job in my infopackage and when it goes to r/3 to pull data out, it runs extracts the first 100 records then the next 100 then the next 100 instead of all 40000 at once?