cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Data Services: Problem with adding a view in Data Store based on SAP ERP as Source

0 Kudos

Hi everybody,

something strange is happening while using SAP Data Services. I'm connecting my Data Services to an ERP System where my source "tables" are located. With the "Search" dialog from the right button context menu I want to add my tables (or View). On the one hand I've got no problems - the dialog returns the table i was looking for:

Everything is fine. Now I want to add a view as source - this view exists in my source system, as you can see here:

When I now try to search for this view I did not get results:

I checked the properties of both objects (first and second) - I could not identify differences. First I thought that there is a difference between the view and the transparent table - but if I connect to our development system the search dialog returns both "tables".

Does anyone know if there are special requirements to use views as data sources in data stores in SAP Data Services? Maybe there is some system customizing anywhere?

Best regards

Thorsten

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hi Guys,

thank you for your answers. Unfortunately this is a bug in the search dialog. With the option "Import by name" and using the full name of the view I was able to import the view.

Thanks!

Answers (2)

Answers (2)

former_member198401
Active Contributor
0 Kudos

Check with the BASIS or security team about the view which you are trying to access in Data Services.

Compare the authorization between the two tables and you should see a difference.

Regards

Arun Sasi

former_member220897
Participant
0 Kudos

Might be an authorization issue. Is the user specified for the datastore the same user you use for SAP GUI?