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

Extract data from SAP R/3 to SAP BI

Hi experts,

I am kind of new in SAP BI so I apologise if these questions might have been answered before.

I am planning to extract data from R/3 system to SAP BI. I know somehow the process of extracting and loading these data to BI from the R/3 source system but my questions are:

1. Can I extract data from R/3 system - (Ex.Material Management application component) and load it into Z-InfoObjects in SAP BI?

2. If I have loaded the required data from R/3 to BI system using Z-InfoObjects (BI-side) and then loading these Z-InfoObjects into a DSO, if later I would like to delete these Z-InfoObject or maybe delete the newly created DSO, does this mean that by deleting them I am also deleting the data in the R/3-side (source system) or somewhere else where these data is in Production in (R/3 side)? If I do any change (delete or update) in SAP BI side to the data that is extracted from R/3, will it affect the data and tables in R/3-side?

Thanks in advance for your time and effort.

Regards,

Regys

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Dec 08, 2015 at 12:49 PM

    Hi,

    1, Yes, you can load R/3 Data to Zinfo objects in bw side if you designed proper data flow design.

    2. BW data/objects deletion doesn't effect on ECC system. So you can delete what you want at bw side.

    To update changed data from ECC to BW, you can introduce delta pointer to your specific data source(if supports delta) and load delta data to bw targets(thru process chains frequently).

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 08, 2015 at 11:59 AM

    1. yes: you can load data into Z-object

    2. no: deleting data in BI has no effect on the data in R/3

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 08, 2015 at 12:24 PM

    yes you can load the data from r/3 into bi for any info object

    delete the data based on your requirement ... you can delete the previous data improve the system performance

    if there is any changes in bi side not reflectd in ecc side

    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.