View

[Former Member]

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

[Former Member]

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.

[Former Member]

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.

[Former Member]

hi,

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

[Former Member]

hi

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

[Former Member]

Hi,

Go and check the standard view T333_V.

Naveen M.

[Former Member]

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

[Former Member]

Hi,

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

Regards,

Yogesh

[matt]

Please use a meaningful subject in future

[Former Member]

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

[Former Member]

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

and i created a view.

No more answers plz.

[Former Member]

Experts ,

Give answers ...straight to the point.

dont "beat around the bush".