Skip to Content
avatar image
Former Member

Data extraction from R/3 to BW

The transaction data is being extracted from R/3 to BW. The IDOCs with respect to the data extracted can be seen in the IDOCs lists in R/3 server but in the BW server the table of data is not being displayed. In the R/3 server the data is generated and 12 records are being read. Please help in getting the data displayed in the BW server which has been extracted from R/3. Points will be rewarded.

Edited by: Poonam Shukla on Sep 2, 2008 11:23 AM

Edited by: Poonam Shukla on Sep 2, 2008 2:25 PM

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

7 Answers

  • avatar image
    Former Member
    Sep 02, 2008 at 12:35 PM

    have you tried to do test extraction in RSA3?

    If it is successful, then you should be able to see data at the PSA level in BW when you extract.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 02, 2008 at 12:47 PM

    Hello Raj,

    Thank you for your help. The extraction has been already done in R/3 server. The datasource is displaying 12 records read and extracted but its not being displayed in the BW server in the schedule part for that particular datasource. Please guide.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 03, 2008 at 01:52 AM

    Hi,

    Check in SM58 and BD87 for pending tRFCs and IDOCS in R/3 and process them manually.

    Hope this helps.

    Thanks,

    JituK

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2008 at 05:03 AM

    Hello Ravi n Krishna,

    Thank you for your help.

    Ravi,

    I have already executed the infopackage in BW server and the data has been successfully requested. No data is coming to the cube but its coming to the PSA.

    Krishna,

    In R/3 server the IDOC is not being displayed using the tcode- BD87.

    Please guide.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2008 at 05:27 AM

    Hello Krishna,

    I need to map R/3 and BW in a table for the data display, please let me know the table name.

    Thanks.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2008 at 06:31 AM

    Hello,

    The main reason behind the inconsistency was, routines were written in tranferrules level or updaterule level.By writing routine in the transformations level records will get filtered.

    So u r unable to view the data in the BW side.

    By doing debugging in the tranfer rule level u can find the those records where they were filtered exactly.

    Hope it will helpful for you.

    Bye,

    Chandu.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 24, 2008 at 01:12 PM

    Hello Everyone,

    Please help. We are still not able to view data in the Cube.

    Regards,

    Poonam

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Are you getting n of n records or 0 of n records at BW?

      If ur getting n of n records then follow these steps.

      Make the request red.

      Goto details tab and do manual update.

      This will make records available in BW.

      Now change the request to u2018back to request statusu2019

      END