Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Duplicate(double) values in Database view

Dear Experts,

I have created Database view with two tables like MARA and MAKT. Key field-MATNR. Based on MATNR i collected MARA and MAKTX values. I got double(one duplicate) values in this view. How to approach single values.

I attached screen shots. Kindly give me suggestions for removing duplicate value.

Regards,

Abbas.

Former Member
Former Member replied

Hi Syed,

Can you add MANDT(Client) as well in Table join condition on 1st row and then MATNR(2nd row) and recheck it?

Regards,

Sudeesh Soni

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question