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

question on data load

Hi All

can anyone please tell me what are the steps that are to be taken to load SD data from R/3 to BW for the first time(initial load).Everything is set up like the connection,Replication of the DS,IS,TR,UR,infoproviders and infopackage. I have to start the load which is about 30million records.

There is something about dividing this huge data into parts etc.

Any help is higly appreciated.



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 23, 2004 at 03:23 AM

    Hi Swetha,

    There may be different ways followed by different companies.

    If I were you i would have done the same things in the following way.

    1. I will delete the contents of Setup tables.

    2. I will create the varient for Initialisation.

    3. Block all the R/3 Users

    4. Delete the Delta Queue.

    5. Collect postings with the job and set the job parameters in LBWE

    6. Execute the Initializing variant

    7. Upload infosource to PSA (use a infopackage)

    8. Release all the R/3 users.

    9. Delete data of Info targets (if any)

    10.Load data from PSA to Info targets.

    11.Collapse the Cubes (Take care about market update option )

    These are the steps i would have followed but it may not suit your requirement.

    Take care.


    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.