Skip to Content
author's profile photo Former Member
Former Member

DATA packet size

hi

when i take load from r/3 the size of data packet is 6000 i increase the size in info package that i set to 20000 kb and also do the setiing in sbiw in r/3

still its remain same.

please help us data loading is very very slow.

regars

mangra

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 20, 2007 at 10:59 AM

    Hi,

    check whether you have followed the same procedure to set the DP size in source sytem

    Please use the below mentioned formula to caclculate DP size

    The packet size can be calculated as

    packet size = (Maximum size of the OLTP/BW system *1000)/ Transfer structure size.

    If the maximum line size in OLTP system is less than the result of formula,the maximum line size as in OLTP system is transferred to BW, else the size as obtained from the above formula is transferred to BW.

    For further information refer OSS note 409641:Examples of packet size dependency on ROIDOCPRMS.

    to check MAXLINES defined

    . Log on to R/3

    2. Go for SBIW

    3. Expand Data transfer to SAP Business Information

    warehouse

    4 .Expand General settings

    5. Execute Maintain control parameters for data

    transfer

    please let me know if you need any help!!!!!!!!!!!!!

    Regards,

    Swapna.G

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 20, 2007 at 11:02 AM

    Hi..

    MAXSIZE = Maximum size of an individual data packet in KB.

    The individual records are sent in packages of varying sizes in the data transfer to the Business In-formation Warehouse. Using these parameters you determine the maximum size of such a package and therefore how much of the main memory may be used for the creation of the data package. SAP recommends a data package size between 10 and 50 MB.

    MAXLINES = Upper-limit for the number of records per data packet

    The default setting is 'Max. lines' = 100000

    The maximum main memory space requirement per data packet is around

    memory requirement = 2 * 'Max. lines' * 1000 Byte,

    meaning 200 MByte with the default setting

    3 THE FORMULA FOR CALCULATING NUMBER OF RECORDS

    The formula for calculating the number of records in a Data Packet is:

    packet size = MAXSIZE * 1000 / transfer structure size (ABAP Length)

    but not more than MAXLINES.

    eg. if MAXLINES < than the result of the formula, then MAXLINES size is transferred into BW.

    The size of the Data Packet is the lowest of MAXSIZE * 1000 / transfer structure size (ABAP Length) or MAXLINES.

    https://www.sdn.sap.com/irj/sdn/directforumsearch?threadid=&q=cube+size&objid=c4&daterange=all#results=15

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.