2011 Sep 30 7:43 PM
Hello
I have created a customer master hierarchical data source in R/3. When I extract data data is R/3 it is extracting correct number of records. But when creating info object in BW is is giving error Data Source does not exist in source system
Any help would be appericiated
Thanks
Aarti
Hello
I have created a customer master hierarchical data source in R/3. When I extract data data is R/3 it is extracting correct number of records. But when creating info object in BW is is giving error Data Source does not exist in source system
Any help would be appericiated
Thanks
Aarti
2011 Oct 01 6:21 AM
hi Aarthi,
try this,
1. Create an infoobject
2. Create a hierarchy for this infoobject.
3. Assign source sysyem to this infoobject.
4. When you assign datasource, sysyem will prompt you
three selection, master, hierarchy and text.
5. Once you have selected hierarchy, choose transfer
method IDoc, at the below there is a tab named 'hier.
structure', click on it and create a hierarchy that
you have created previously.
6. Automatically, system generates a structure
hierarchy format for you to upload.
7. create infopackage.
8. go to the master table for the infoobject, at tab
'hierarchy', double click on the hierarchy table,
download it into txt file, then modify from the text
file, delete those unnecessary column according to you
hierarchy format, save it as .csv
9. upload it as normal flat file.
2011 Oct 04 7:06 PM
Hello,
Thank you for the response. However I have not created the DS through RSO2. I have written a program to create data source(populating all ROO tables) it has wrapper FM.
Data source is fine. I can extract data in ECC. We are having issue while creating info package it is giving following error
"There are no hierarchies for this Infosource in the source system"
Please let me know if you need more information.
Appreciate your response!!
Thanks
Aarti