topic Re: Database view with duplicate records in Application Development and Automation Discussions

Database view with duplicate records

Former Member — Tue, 09 Sep 2014 05:44:53 GMT

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.

Re: Database view with duplicate records

Former Member — Tue, 09 Sep 2014 07:39:49 GMT

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

Re: Database view with duplicate records

Former Member — Tue, 09 Sep 2014 07:45:11 GMT

Thanks,

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