Skip to Content
Former Member
Feb 14, 2011 at 03:05 PM

SQVI - removing duplicate/redundant lines


Dear Gurus,

in SQVI I have linked EKKO + EKPO + EKBE tables (in this order), but I receive redundant lines in the results.

Example: when I have 5 line items in the PO --> I see 5 lines for litem item 0010, also 5 lines for 0020, etc.

The link is establised via EBELN (Purch.Doc.Nr.) field. This is the only connection between the tables.

Could anyone kindly explain what is wrong? How can I fix this?

Many thanks,