Skip to Content
avatar image
Former Member

Newbie: Creating a DataSource

I'm trying to create a basic DataSource and am encountering a strange error.

1) Right-click application component -> Create DataSource

2) Give name, pick source system, pick type of "Master Data Attributes", hit OK.

3) "Change DataSource" screen comes up

4) Enter descriptions on "General Info." tab

5) Switch to Extraction tab

6) Enter table name.

Then I hit the problems:

A) If I click the popup button next to the table name and click execute I get the error:

"Some table name(s)like: product are invalid

Removed from selection ->Long Text"

What does that mean?

B) Can the system auto-populate the input-fields? I can't get this to happen.

C) If I try to manually enter field definitions, I get a variety of strange errors (not worth posting)

What else can I do at this point to move forward? I want to import the attributes data from my external database into SAP.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 16, 2007 at 08:06 PM

    Hi,

    I'll move this to the BI area where you can get more attention on this problem.

    Also, are you trying to pull from a table that is not in the same SAP system as where you are creating the datasource?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      The problem was that my table name was lowercase. The table name MUST be uppercase. My database is case-insensitive, but the uppercase requirement still holds.

      If I create an uppercase view into the table, and reference that view, this error goes away.