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.
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)
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
we will get below screen, Here we will go With Export:
Once it completed the migration, we will get status bar message like below.
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).
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.
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.
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)
Thank you
Piece of information and useful. Thank You.
Thanks RB
Hi Ramanjaneyulu,
Good blog.thanks for your efforts.
Regards,
Gurunath
Thank You Gurunath.
Good observation. Nice information to learn.
Regards,
Nitesh
Thank You
You are giving us small amounts of food. We are all hungry to have all food at a time. Just kidding..Very nice document.
Yes, i felt the same. next time i will come up with full meals.
Thank You
Raman
Hi korrapati,
We need Family Pack..
🙂
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.
Yes, Accept with you Srikanth. that would be useful when we have multiple source system.Thanks for additional information.i will add.
Thanks
Raman
Very useful information. Thank you
Regards
PR
Thank You
Very useful tip. Thank you
good to know might come handy someday 🙂
thanks
Martin
Hmm. Might be. Thank you
Again a good one ..M new on SDN n my target is to read ur blogs first ..very infromative ..:)
Useful one...Many Thanks for your efforts.
Best Regards,
Naresh K.
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
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
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
Nice Document
Thank you Venkat
Thanks so much for the useful info.you make it look easier to understand.Appreciate your effort . 🙂
Dear Ramanjaneyulu,
Thanks for detailed and summarized explanation 🙂
Regards
Kiran N
Thank you kiran for your appreciation.
Thanks
Raman
Nice information very useful...Raman.
Amir-Toronto
Good info Raman..;)
Thank You Naveen
Very useful info.. Thanks for sharing.
Regards,
Krishna Chaitanya.
nice trick 🙂 thanks for sharing Raman
Martin
Thank You Martin.
Hi Raman,
Thanks for Descriptive explanation .,.,.
Regards,
J.Sakthikumar
Good one 🙂 🙂
Hi raman,
Nice blog... thanks for sharing
rgds,
Verma
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
Nice one Raman. You are making nice and useful blogs....
Thank You Abhilash.
Added small info about how to know 3.x transfer rules in your data flow which have 3.x and 7.x.
Thank You
Hi Ram,
Simple but very valuable information.
Keep posting more..
Regards,
J.Sakthikumar
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.
Hi ram,
nicely you have explained, by looking it we can understand the things you have done
Regards,
G S Ramanjaneyulu
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.