Steps of Activating Standard Data Sources

[Former Member]

I need to know the steps required to activate standard data sources

As I know that first I need to activate data source in ECC Dev then transfer to QA then Production

And what about LIS Data Sources that need steps like transfer data to set up table ( Do I need to perform this in ECC production or first in Dev then transfer to QA then Prod ?)

And After replicating data sources in BW Dev and perform the required data flow from ECC Production. what is the steps to transfer the object from BW Dev to BW Production? Do I need to repeat my work in BW Dev?

[Former Member · Accepted solution]

Go to ECC Dev : RSA5 - select and activate the required datasource and you will get it in RSA6.

It is does not ask for a trasport, collect this in a transport request -this should automatically activate the datasource in RSA6 in Quality & Prod..

You will generally not have access to activate datasource manually in Quality or Prod.

Transports will take care of getting the datasource activated in Quality and Prod.

Thanks.

[Former Member · Accepted solution]

What about set up table in ECC for LIS Data Source?

[Former Member · Accepted solution]

1) Go to transaction code RSA3 and see if any data is available related to your DataSource. If data is there in RSA3 then go to transaction code LBWG (Delete Setup data) and delete the data by entering the application name.

2) Go to transaction SBIW --> Settings for Application Specific Datasource --> Logistics --> Managing extract structures --> Initialization --> Filling the Setup table --> Application specific setup of statistical data --> perform setup (relevant application)

In OLI*** (for example OLI7BW for Statistical setup for old documents : Orders) give the name of the run and execute. Now all the available records from R/3 will be loaded to setup tables.

3) Go to transaction RSA3 and check the data.

4) Go to transaction LBWE and make sure the update mode for the corresponding DataSource is serialized V3 update.

5) Go to BW system and create infopackage and under the update tab select the initialize delta process. And schedule the package. Now all the data available in the setup tables are now loaded into the data target.

6) Now for the delta records go to LBWE in R/3 and change the update mode for the corresponding DataSource to Direct/Queue delta. By doing this record will bypass SM13 and directly go to RSA7. Go to transaction code RSA7 there you can see green light # Once the new records are added immediately you can see the record in RSA7.

7) Go to BW system and create a new infopackage for delta loads. Double click on new infopackage. Under update tab you can see the delta update radio button.

😎 Now you can go to your data target and see the delta record.

[Former Member · Accepted solution]

Dear AP_SAP

Thanks a lot for steps but I need to know where to apply this step

(on ERP Dev or ERP Prod directly?)

[Former Member · Accepted solution]

Hi,

Steps to activate the data sources you will do it in the Development System and transport to QA & Prod. Steps to load the data you will do it in the respective QA or Prod system.

REgards,

Vikram