Duplicate(double) values in Database view
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.
Can you add MANDT(Client) as well in Table join condition on 1st row and then MATNR(2nd row) and recheck it?