topic Re: View in Application Development and Automation Discussions

View

Former Member — Sun, 24 May 2009 04:01:34 GMT

Please use a meaningful subject in future

hi,

I've 2 tables X and Y .

Z is the Database View of X and Y tables.

So, on activating this view........Displaying error message "Field name MANDT not unique."

Edited by: Matt on May 29, 2009 5:39 PM

Re: View

Former Member — Sun, 24 May 2009 05:35:07 GMT

Are you adding MANDT in your Join condition? I think you need to.

Also see if both are transperent tables as we can define joins only on transperent table.

Re: View

Former Member — Sun, 24 May 2009 06:47:21 GMT

Hi,

Are your X and Y Tables are Client Dependent or Client Independent? Have you included MANDT fields in both the tables? And are both the tables Transparent one?

A Database View can be created on Transparent Tables and can be used for tables maintenance if created on a Single Transparent Table.

As for your Error, Check that whether you have included the Mandt field in the Table or Join Condition? Hope that will resolve your error. Have a look at the link below for a complete overview of the Database Join.

http://help.sap.com/saphelp_webas620/helpdata/en/cf/21ea31446011d189700000e8322d00/frameset.htm

Thanks,

Samantak.

Re: View

Former Member — Sun, 24 May 2009 12:50:51 GMT

hi,

Yes ,i've included MANDT fields in both the tables and both are trasparent one.

Re: View

Former Member — Mon, 25 May 2009 04:33:23 GMT

check whether u have included the MANDT field in both the tables and check

whether the UNIQUE field checkbox is selected for MANDT field in both the tables

and also while joining both the table check whether u have joined the tables based on Client

field MANDT.

Regards

Re: View

Former Member — Thu, 28 May 2009 12:13:40 GMT

Hi,

Go and check the standard view T333_V.

Naveen M.

Re: View

Former Member — Fri, 29 May 2009 10:39:25 GMT

Hi,

In T333_V Database table, i've the following feilds

MANDT, LGNUM, BWLVS, LBWAT, XDREL.

Would u plz, Tell me What should i check in this view table.

Edited by: SSK on May 29, 2009 5:28 PM

Re: View

Former Member — Fri, 29 May 2009 14:48:48 GMT

Hi,

Have you added MANDT twice in the view fields like for each table ?? Sounds crazy but have a check

Regards,

Yogesh

Re: View

matt — Fri, 29 May 2009 15:40:15 GMT

Please use a meaningful subject in future

Re: View

Former Member — Mon, 01 Jun 2009 22:03:56 GMT

HI ,

For X and Y field one should be unique field , the only you can create view of that both table, first check that .

Regards

Sathish

Re: View

Former Member — Tue, 02 Jun 2009 11:51:30 GMT

I Solved the problem by myself......

and i created a view.

No more answers plz.

Re: View

Former Member — Tue, 02 Jun 2009 11:54:49 GMT

Experts ,

Give answers ...straight to the point.

dont "beat around the bush".