Skip to Content

Invalid Extract Structure error while creating "Generic DataSource" on a view...

Dear All,

I have created a view on following tables MARA, AFKO and MSEG. The Table/Join condition is as follow:

AFKO--AUFNR = MSEG--AUFNR

AFKO--PLNBEZ = MARA--MATNR

I have included all the fields from MSEG and other all fields from MARA and AFKO. The view is created successfully and contents/records are also being fetched/displayed from this view.

See screen shot as well:

But when I go to RSO2 to create a "Generic DataSource" on this view. I get a series of warning messages and then error message "Invalid Extract Structure" and therefore I'm unable to create my DataSource on this view. See below screen shots of warning and error messages.

Other warning messages are as follow:

Field GAMNG with reference field MEINS: Reference table MARA is replaced by ZOXPRD0150

Field PLSVB with reference field PLNME: Reference table PLKO is replaced by ZOXPRD0150

Field PLSVN with reference field PLNME: Reference table PLKO is replaced by ZOXPRD0150

Field LODIV with reference field MEINS: Reference table MARA is replaced by ZOXPRD0150

Following is the screen shot of error message:

1. How can I get rid of this error message and be able to create my "Generic DataSource" on top of this "View"?

2. What should I do to resolve the above warning and error messages?

I will appreciate your reply.

Many thanks!

Tariq Ashraf

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on May 12, 2015 at 11:37 AM

    fields with units/currencies have a reference table/field in a table or view. when you create your datasource, you need to include the references in your datasource else you have the issue as described. other option is to delete the amounts/quantities from the datasource.

    regards,

    M.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.