Linking MSEG to GLPCA in SQVI

I'm trying to link MSEG to GLPCA in order to map storage location to line items against a specific G/L account.

The quickview is duplicating each entry based on the number of lines in the material document - so a 5 line material document si creating 25 entries when only 5 are unique.

Anyway to stop the duplicates as the volume of date means exporting and sorting is not possible.