SQVI - removing duplicate/redundant lines

[Former Member]

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,

Marton

[csaba_szommer · Accepted solution]

Link between EKPO and EKBE should be EBELN & EBELP (these are the key fields in EKPO).

Edited by: Csaba Szommer on Feb 14, 2011 4:11 PM

[Former Member · Accepted solution]

Issue closed.

Thank you Csaba for your valuable input