Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to set records per data packect

HI All,

I would like to know :

How to set records per data packect? (R/3 or BW)

for example: 2.3 laks records

It loads per packet 50000.

packet1 : 50000

packet2 : 50000

packet3 : 50000

packet4 : 50000

packet5 : 3000

How can I do it. Please explain step by step.

Thanks & Regards,

sri.

replied

Hi,

sbiw>general settings>maintain control parameters for data transfer

This you can do both in r/3 and bw.

Maintain Control Parameters for Data Transfer

Activities

1. Source System

Enter the logical system of your source client and assign the control parameters you selected to it.

You can find further information on the source client in the source system by choosing the path Tools -> Administration -> Management -> Client Maintenance.

2. Maximum Size of the Data Package

When you transfer data into BW, the individual data records are sent in packages of variable size. You can use these parameters to control how large a typical data packet like this is.

If no entry was maintained then the data is transferred with a default setting of 10,000 kBytes per data packet. The memory requirement not only depends on the settings of the data package, but also on the size of the transfer structure and the memory requirement of the relevant extractor.

3. Maximum Number of Rows in a Data Package

With large data packages, the memory requirement mainly depends on the number of data recrods that are transferred with this package. Using this parameter you control the maximum number of data records that the data package should contain.

By default a maximum of 100,000 records are transferred per data package.

The maximum main memory requiremen per data package is approximately 2'Max. Rows'1000 Byte.

4. Frequency

The specified frequency determines the number of IDocs that an Info IDoc is to be sent to, or how many data IDocs an Info Idoc describes.

Frequency 1 is set by default.. This means that an Info Idoc follows every data Idoc. In general, you should select a frequency between 5 and 10 but no higher than 20.

The bigger the data IDoc packet, the lower the frequency setting should be. In this way, when you upload you can obtain information on the respective data loading in relatively short spans of time .

With the help of every Info IDoc, you can check the BW monitor to see if there are any errors in the loading process. If there are none, then the traffic light in the monitor will be green. The Info IDocs contain information such as whether the respective data IDocs were uploaded correctly.

5. Maximum number of parallel processes for the data transfer

An entry in this field is only relevant from release 3.1I onwards.

Enter a number larger than 0. The maximum number of parallel processes is set by default at 2. The ideal parameter selection depends on the configuration of the application server, which you use for transferring data.

6. Background job target system

Enter the name of the application server on which the extraction job is to be processed.

To determine the name of the application server, choose Tools -> Administration -> Monitor -> System monitoring -> Server. The name of the application server is displayed in the column Computer.

7. Maximum Number of Data Packages in a Delta Request

With this parameter, you can restrict the number of data packages in a delta request or in the repetition of a delta request.

Only use this restriction when you expect delta requests with a very high data volume, so that, despite sufficiently large data package sizes, more than 1000 data packages can result in a request.

With an initial value or when the value is 0, there is no restriction. Only a value larger than 0 leads to a restriction in the number of data packages. For reasons of consistency, this number is not generally exactly adhered to. The actual restriction can, depending on how much the data is compressed in the qRFC queue , deviate from the given limit by up to 100.

shylaja.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question