cancel
Showing results for 
Search instead for 
Did you mean: 

How i can add distinct in this query in sap business one hana version

Former Member
0 Kudos

(SELECT STRING_AGG(T7."WhsName", ',') FROM RCT2 T5 INNER JOIN OINV T8 ON T5."DocEntry"=T8."DocEntry" INNER JOIN INV1 T9 ON T9."DocEntry" = T8."DocEntry" INNER JOIN OWHS T7 ON T7."WhsCode" = T9."WhsCode" WHERE T5."DocNum" = T4."DocEntry" GROUP BY T5."DocNum", T7."WhsName") AS "Store",

Accepted Solutions (0)

Answers (2)

Answers (2)

inga_babco2
Explorer
0 Kudos

(SELECT STRING_AGG(A1."WhsName", ',')

FROM

(SELECT T7."WhsName"

FROM RCT2 T5

INNER JOIN OINV T8 ON T5."DocEntry"=T8."DocEntry"

INNER JOIN INV1 T9 ON T9."DocEntry" = T8."DocEntry"

INNER JOIN OWHS T7 ON T7."WhsCode" = T9."WhsCode"

WHERE T5."DocNum" =T4."DocEntry"

GROUP BY T7."WhsName")

AS A1) AS "Store"

brendanbell
Explorer
0 Kudos

Query doesnt work!

Where is the reference to T4.DocEntry

Regards