Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Mar 31, 2017 at 08:59 AM

    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!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 20, 2016 at 06:52 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 22, 2016 at 10:40 AM

    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

    Add comment
    10|10000 characters needed characters exceeded