Problem in Datasource based on View , a view based on tables T001 & ADRC

[Former Member]

Hi folks,

i have one issue i had created a view on the table T001 and ADRC Tables . Then while i am attempting to create the data source based on this view i am getting one error ,,,

Field CLIENT of the provider structure is missing in extract str. I dont know what exactly the problem is ,,

Can any one suggest be any thing on this.

?

[anindya_bose · Accepted solution]

Hi

In Join Condition put

T001-MANDT = ADRC-MANDT

and in view fields add MANDT field from any one table.

This should resolve your issue

[Former Member · Accepted solution]

Yeah , I have tried the same it is also included in the join conditions and also in the table fileds but the still problem exist.

[Former Member · Accepted solution]

Hi,

Add the Field MANDT to the extract structure of the created datasource and try activating the datasource. This will solve the issue.

Thanks,

Nagarjuna,

[Former Member · Accepted solution]

HI all,

The Problem is resolved by removing one of the filed ie is client filed from the Datasource fileds.

Now i can able to create the data source on top of the view..................

Edited by: GURU BI on Nov 2, 2011 12:34 PM

[Former Member]

The problem is solved by removing client filed from the data source fields

[Former Member]

Hi,

Include MANDT field in the join condition while creation of view.

Regards,

Durgesh.

[Former Member]

hi ,

I have included still the error is coming ...........

Field CLIENT of the provider structure is missing in extract struture

[Former Member]

Did you just add it as a join field or did you also add it to the list of fields the view returns?