How to adjust the data package size?

[Former Member]

If anyone can let us know how to adjust the data package size for data loading, we will be very appreciated!

[Former Member · Accepted solution]

Hi Kevin

Open the infopack then goto scheduler from menu then select DataS. Default data transfer.

Then enter the data package size.

Hope it helps..

Chandu.

[former_member214773]

This message was moderated.

[former_member21257]

Hi Kevin,

The data extraction parameters can be set in two ways:

- one directly on the source system with table ROIDOCPRMS

- or within the BW system itself through SBIW -> Maintain Control Parameters for Data Transfer

Some extra info on source sys tbl ROIDOCPRMS:

It contains the control parameters for data transfer from the source system to BW:

maxsize - maximum size of an IDoc packet in KB;

statfrqu - the number of packets that are transferred before statistical info is sent

maxlines - maximum number of records sent in one IDoc packet;

maxprocs - maximum number of dialog work processes per upload request used to send the data to the BW system

If table ROIDOCPRMS is empty, the systems use default values during runtime.

You should not allow these default values to be used.

See also

Note 417307 Extractor package size: Collective note for applications

Rgds,

Colum

[amol_jaiswal]

hi,

You can also maintain entry in table ROIDOCPRMS on R/3 side for your source system to adjust data package size. Please refer to the sap note 401847 for more details on this. Other thing you can do is at Infopackage level, you can maintain the datapackage size.

Hope this helps.

Amol

[mansi_dandavate]

Hi,

Open your InfoPackage.. In the Menu you will find the option, package size.. You can change it from there...

[Former Member]

mansi,

We open an InfoPackage in BI7.0 environment and go through all the Menu/Menu Items, can not find a place to change the data package size. Could you illustrate on this?

Thanks!

[Former Member]

Well Kevin...in general the infopackage size is a calculated value....the process is in SAP BI (somewhere in SPRO customizing.... i dont remember) theres a system parameter that have the memory space assigned to an infopackage by example 20000 KB the system calculates the number of records than the nfopackage can bring in 2000KB; depending of the size of the record (a record with many fields needs more space than another one with few fields), if you want to bring more records you must change the memory size......

But this is a general configuration...theres a way to set up a specifical configuration for every datasource, in Infopackage menu> sheduler>DataS. Default data Transfer..... here you can change the packet size in KBytes and the number of records per idoc....

I hope this helps you..

Regards

[former_member208595]

HI,

While loading data use selection condition based on date/key field, so that package size will be less.