Database view with duplicate records

[Former Member]

Hello guys, I am creating database view between three tables like condition

   Table 1 MANDT = Table 2 MANDT

   Table 1 Field1   = Table 2 Field1

   Table 2 MANDT = Table 3 MANDT

    Table 2 Field2   = Table 3 Field2

There are Five fields in View fields tab with Mandt included all are key fields.

How can there will be duplicates when all are Key Fields. Please help me out. Thanks.

[Former Member]

Hi

Infact, there is no 'Key field' in 'VIEW'. Just take the database view as result of a sql statement, 'join condition' and 'selection condition' refected the data of this view.

Say table1 have field1 field2 as key field. table2 have field2 field3 field4 as key field.

After inner join, the field1 will be duplicated in result,  even it`s key field in table1.

regards,

Archer

[Former Member]

Thanks,

So what's the solution for that prob. At last I am deleting multiple records.