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?