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

Use of RSA3

Posted on Mar 31, 2009 at 04:01 AM 1.4k Views

Hello, I am little bit confused in using RSA 3 transaction.

1. As i understand - Datasource never stores data actually. It only use to extract the data and saves the data in PSA by running infopackage. - Plz correct me.

2. In LO extraction - Datasource could extract the data either from Set up table or from Delta Queue.

If you want to delete the data the Best practise is to delete the data from setup tables by LBWG and from delta queue by RSA7

3. What is the exact use of RSA3 transaction. Plz explain.

Thanks

BW Content and Extractors
Add comment
10|10000 characters needed characters exceeded

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Mar 31, 2009 at 04:10 AM

    Ashwin,

    1. As i understand - Datasource never stores data actually. It only use to extract the data and saves the data in PSA by running infopackage. - Plz correct me.

    --> yes, BI side data initially stores at PSA.

    2. In LO extraction - Datasource could extract the data either from Set up table or from Delta Queue.

    If you want to delete the data the Best practise is to delete the data from setup tables by LBWG and from delta queue by RSA7

    --> For FULL loads and Initialization with data transfer data pulled from Setup tables.

    --> For Delta Loads data pulled from delta queue.

    3. What is the exact use of RSA3 transaction. Plz explain.

    --> To check data, for example after enhancing datasource with newfiels we can and debugg thourgh RSA3.

    Srini

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Mar 31, 2009 at 07:08 AM

      Hello, Sorry i could not get your point.

      So i run RSA3 in R/3 Side.

      i will get four columns -

      1. To enter the name of data source. - I entered the data source name.

      2. Setting- i left it as it is.

      3. Execution mode - Debug mode , Auth trace - I haven't check any one

      4. Selection - I haven't enter any selection.

      5. I clicked on extraction button ..

      -- A new pop up apperar saying - 190 data records selected -

      My question - from where and when it select those data records ? from where they came ?

      -

      Now i get the button for Display List -when i click on it Its shows me --

      2 data packets one with 100 records and another with 90 records.

      If i click on any data packet it shows me all the records belong to that data packet.

      My Question - Why there is data packets in the data source, From where they come.

      -

  • author's profile photo Surendra Kumar Reddy Koduru
    Surendra Kumar Reddy Koduru
    Posted on Mar 31, 2009 at 04:14 AM

    Hi,

    1. As i understand - Datasource never stores data actually. It only use to extract the data and saves the data in PSA by running infopackage. - Plz correct me.

    Yes DataSource is a Structure and it won't store data, it will pick the data from base tables/Delta Queue

    2. In LO extraction - Datasource could extract the data either from Set up table or from Delta Queue.

    If you want to delete the data the Best practise is to delete the data from setup tables by LBWG and from delta queue by RSA7

    First Time you need to fill setup tables and then load Init in BW using setup tables. After that set V3 job an dthen load deltas in BW, it will pick the data from RSA7 (Delta Queue). If you want to delete an dload data again, then delete setup tables, delete Queues in SMQ1/LBWQ and then RSA7.

    3. What is the exact use of RSA3 transaction. Plz explain.

    This is the place to test your DataSource, whethere the data is extacting correctly or not?.

    Thanks

    Reddy

    Add comment
    10|10000 characters needed characters exceeded