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

Extraction and Loading data into BW from SD Extractor

Hi Gurus,

Can you Please advice me Step by Step procedure of extracting, tranformation and loading of data into BI 7 datatarget (Cube) from R/3 SD Extractor (ex. 2LIS_13_VDITM) ??

I need to know each of the steps from LBWE (R/3) to DTP (execute).

Please help...

I will definitely assign good points...

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 28, 2007 at 09:22 AM

    HI Akash,

    LO Cockpit Step By Step

    LO EXTRACTION

    - Go to Transaction LBWE (LO Customizing Cockpit)

    1). Select Logistics Application

    SD Sales BW

    Extract Structures

    2). Select the desired Extract Structure inyour case 2LIS_13_VDITM and deactivate it first.

    3). Give the Transport Request number and continue

    4). Click on `Maintenance' to maintain such Extract Structure

    Select the fields of your choice and continue

    Maintain DataSource if needed

    5). Activate the extract structure

    6). Give the Transport Request number and continue

    - Next step is to Delete the setup tables

    7). Go to T-Code SBIW

    8). Select Business Information Warehouse

    i. Setting for Application-Specific Datasources

    ii. Logistics

    iii. Managing Extract Structures

    iv. Initialization

    v. Delete the content of Setup tables (T-Code LBWG)

    vi. Select the application (01 – Sales & Distribution) and Execute

    - Now, Fill the Setup tables

    9). Select Business Information Warehouse

    i. Setting for Application-Specific Datasources

    ii. Logistics

    iii. Managing Extract Structures

    iv. Initialization

    v. Filling the Setup tables

    vi. Application-Specific Setup of statistical data

    vii. SD Sales Orders – Perform Setup (T-Code OLI7BW)

    Specify a Run Name and time and Date (put future date)

    Execute

    - Check the data in Setup tables at RSA3

    - Replicate the DataSource

    Use of setup tables:

    You should fill the setup table in the R/3 system and extract the data to BW - the setup tables is in SBIW - after that you can do delta extractions by initialize the extractor.

    Full loads are always taken from the setup tables

    Hope this helps

    Ravi

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 28, 2007 at 09:12 AM

    Hi Akash,

    Follow the steps mentioned below.

    1. Lock all psotings for sales in R/3.

    2. Go to tcode OLI9BW in R/3. Give and name for the run and change the termination date to a date in future. Execute this in background using the Program menu.

    3. Monitor this job in SM37.

    4. Once this finishes do an init with data transfer to BI.

    5. Unlock R/3 postings.

    6. Schedule V3 job in LBWE.

    7. Schedule the delta.

    Hops this helps.

    Regards,

    Sumit

    Add a comment
    10|10000 characters needed characters exceeded

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

    Thanks all for your support !!!

    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.