Skip to Content
Author's profile photo Raman Korrapati

How to find data source was migrated or not.

Hi,

I thought to explain how to find data source was migrated to 7.x or not. we have two options.

1. Directly at RSA1–>Data source,symbol at Data source,

2. By using Tables.

At RSA1 –> Data source. Under respective application component

Here i am taking data source : 0FI_AA_12 .

One of my team member was replicated data source into bw side and asked me to continue to develop further data flow. i thought to create info package(because we are on 7.x). when i select data source–> right click, create info package, but i got message like below.

/wp-content/uploads/2013/08/1_264707.jpg

So my data source was in 3.x version. when our data source was at 3.x version, you will be see some symbol before the data source(as shown in red box). By seeing that symbol we can say data source was not migrated. Here DS: 0FI_AA_001 3.x version. DS: 0FI_AA_11(at 7.x)

/wp-content/uploads/2013/08/1_264707.jpg

From above screen my data source 0FI_AA_12 (3.X).

Now i am migrating using normal steps which already explained.

data source–> right click migrate or use Tx – RSDS, enter the data source, from menu bar data source –> Migrate 3.x data source to –> data source. click on it

/wp-content/uploads/2013/08/1_264707.jpg

we will get below screen, Here we will go With Export:

/wp-content/uploads/2013/08/1_264707.jpg

Once it completed the migration, we will get status bar message like below.

/wp-content/uploads/2013/08/1_264707.jpg

Now see the symbol for mentioned data source(0FI_AA_12) at RSA1–> Data source. Once data source was migrated there won’t be any symbol(red mark) before the data source description(0FI_AA_12).

/wp-content/uploads/2013/08/1_264707.jpg

At RSA1–> Data source, by seeing the symbol we can say data source was migrated or not.

3.X data source with symbol

7.X data source without symbol

Using tables:

3.x Data source are stored at table RSOLTPSOURCE.

Here i am taking 3.x data source 0FI_AA_001. If we have multiple source systems then better choose Logsys(source system ID) selection also.

/wp-content/uploads/2013/08/13_269418.jpg

For 7.x Data sources are storing at Table RSDS. So if i enter the 3.x data source name(0FI_AA_001) at  this table i need to get zero entries.

/wp-content/uploads/2013/08/44_269419.jpg

So using two tables also we can find whether data source 3.x or 7.x.

Please  refer below thread about with export or W/o Export usage and How to revert back 3.x


http://scn.sap.com/thread/1558590

Due to the existing 3.x data flow, we will use 3.x as well as 7.x flow. In that cases by seeing the same aymbol at transferrules we can cosnider that as its 3.x flow, it have transfer rules an update rules.

bleow screen shows my flow.

Data source–> DSO1—> DSO2—>info cube –> multi provider

Here upto dso2 my flow is 3.x and dso2 –> cube is 7.x.

See the same blue mark for transfer rules. By seeing that symbol we can consider its in 3.x and rest is 7.x(mean no blue mark)

/wp-content/uploads/2013/08/3_368752.jpg

Thank you

Assigned Tags

      43 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Piece of information and useful. Thank You.

      Author's profile photo Raman Korrapati
      Raman Korrapati
      Blog Post Author

      Thanks RB

      Author's profile photo Gurunath Kumar Dadamu
      Gurunath Kumar Dadamu

      Hi Ramanjaneyulu,

      Good blog.thanks for your efforts.

      Regards,

      Gurunath

      Author's profile photo Raman Korrapati
      Raman Korrapati
      Blog Post Author

      Thank You Gurunath.

      Author's profile photo Nitesh Kumar
      Nitesh Kumar

      Good observation. Nice information to learn.

      Regards,

      Nitesh

      Author's profile photo Raman Korrapati
      Raman Korrapati
      Blog Post Author

      Thank You

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K

      You are giving us small amounts of food. We are all hungry to have all food at a time. Just kidding..Very nice document.

      Author's profile photo Raman Korrapati
      Raman Korrapati
      Blog Post Author

      Yes, i felt the same. next time i  will come up with full meals.

      Thank You

      Raman

      Author's profile photo TANKA RAVICHANDRA
      TANKA RAVICHANDRA

      Hi korrapati,

      We need Family Pack..

      🙂

      Author's profile photo SRIKANTH GARBHAM
      SRIKANTH GARBHAM

      Nice document Ram 🙂 but one small addition - mention source system also while finding information from table. Only the data source entry is not sufficient to decide whether it is 3.x or 7x from tables if you have multiple sourcxe systems. Along with that logsys is also required if one has multiple source systems.

      Srikanth.

      Author's profile photo Raman Korrapati
      Raman Korrapati
      Blog Post Author

      Yes, Accept with you Srikanth. that would be useful when we have multiple source system.Thanks for additional information.i will add.

      Thanks

      Raman

      Author's profile photo Former Member
      Former Member

      Very useful information. Thank you

      Regards

      PR

      Author's profile photo Raman Korrapati
      Raman Korrapati
      Blog Post Author

      Thank You

      Author's profile photo Former Member
      Former Member

      Very useful tip. Thank you

      Author's profile photo Martin Grob
      Martin Grob

      good to know might come handy someday 🙂

      thanks

      Martin

      Author's profile photo Raman Korrapati
      Raman Korrapati
      Blog Post Author

      Hmm. Might be. Thank you

      Author's profile photo Former Member
      Former Member

      Again a good one ..M new on SDN n my target is to read ur blogs first ..very infromative ..:)

      Author's profile photo Former Member
      Former Member

      Useful one...Many Thanks for your efforts.

      Best Regards,

      Naresh K.

      Author's profile photo Kamal Mehta
      Kamal Mehta

      Hi RK ,

      Thanks.

      The other way could be to identify from the Object Type 4 digit code from Transport connection . Also think you can get this from ROOSOURCE as well .

      3.x has Object types as 'ISFS'.

      7.0 has Object type has 'RSDS'.

      Regards

      Kamal

      Author's profile photo Raman Korrapati
      Raman Korrapati
      Blog Post Author

      Hi Kamal,

      Thanks for your comments.

      Yes, thru transport might be possible. but once we in production we never think about transport to check its migrated or not. i checked the table ROOSOURCE, i didn't fine any related to this.  if possible pls check  and confirm the same from your end.

      Thanks

      Author's profile photo Kamal Mehta
      Kamal Mehta

      Hi RK,

      In Production we can check transport connection and can get the object type of the data source right. I checked ROOSOURCE it doesn't contain the information on this it does have field datasource type but that's just for Transaciton , Master etc.

      Thanks

      Author's profile photo Former Member
      Former Member

      Nice Document

      Author's profile photo Raman Korrapati
      Raman Korrapati
      Blog Post Author

      Thank you Venkat

      Author's profile photo Former Member
      Former Member

      Thanks so much for the useful info.you make it look easier to understand.Appreciate your effort . 🙂

      Author's profile photo Former Member
      Former Member

      Dear Ramanjaneyulu,

      Thanks for detailed and summarized explanation 🙂

      Regards

      Kiran N

      Author's profile photo Raman Korrapati
      Raman Korrapati
      Blog Post Author

      Thank you kiran for your appreciation.

      Thanks

      Raman

      Author's profile photo Former Member
      Former Member

      Nice information very useful...Raman.

      Amir-Toronto

      Author's profile photo Former Member
      Former Member

      Good info Raman..;)

      Author's profile photo Raman Korrapati
      Raman Korrapati
      Blog Post Author

      Thank You Naveen

      Author's profile photo Krishna Chaitanya
      Krishna Chaitanya

      Very useful info..  Thanks for sharing.

      Regards,

      Krishna Chaitanya.

      Author's profile photo Martin Grob
      Martin Grob

      nice trick 🙂 thanks for sharing Raman

      Martin

      Author's profile photo Raman Korrapati
      Raman Korrapati
      Blog Post Author

      Thank You Martin.

      Author's profile photo Former Member
      Former Member

      Hi Raman,

      Thanks for Descriptive explanation .,.,.

      Regards,

      J.Sakthikumar

      Author's profile photo Former Member
      Former Member

      Good one 🙂 🙂

      Author's profile photo Former Member
      Former Member

      Hi raman,

      Nice blog... thanks for sharing

      rgds,

      Verma

      Author's profile photo Former Member
      Former Member

      Hi Raman,

      Thanks a lot for sharing this piece of information. I was aware of replicating data source with RSDS Tcode and chcking through symbol but wasnt aware of this Table method. Thanks for increasing my knowledge.

      Regards,

      Priyanka

      Author's profile photo abilash n
      abilash n

      Nice one Raman. You are making nice and useful blogs....

      Author's profile photo Raman Korrapati
      Raman Korrapati
      Blog Post Author

      Thank You Abhilash.

      Author's profile photo Raman Korrapati
      Raman Korrapati
      Blog Post Author

      Added small info about how to know 3.x transfer rules in your data flow which have 3.x and 7.x.

      Thank You

      Author's profile photo Former Member
      Former Member

      Hi Ram,

      Simple but very valuable information.

      Keep posting more..

      Regards,

      J.Sakthikumar

      Author's profile photo Former Member
      Former Member

      Thanks for info Rama...Just now we have started migration proj and looking for some docs.

      Its very usefull info for me. Before seeing this doc I am little confusing with the symbols but verifying the same with the back end tables is the perfect confirmation.

      Thanks for the usefull point.

      Author's profile photo G.S Ramanjaneyulu
      G.S Ramanjaneyulu

      Hi ram,

      nicely you have explained, by looking it we can understand the things you have done

      Regards,

      G S Ramanjaneyulu

      Author's profile photo Former Member
      Former Member

      Hi Ram,

      Simple and elegant blog. Very useful minute information that I was overlooking so far. You made me a bit smart today, thank you.

      Regards

      K.