HANA Query to track how many sales documents each user has created over a one week period?

Hi,

I'm trying to constitute this query to amusement maine however galore Sales documents each idiosyncratic has created and successful a acceptable play but it' seems to beryllium multiplying to results erstwhile I adhd each further table?

If anyone tin assistance successful penning the correctly please?

Here is the query I have:

SELECT 
T0."U_NAME",
COUNT(T2."DocNum") AS "SO",
COUNT(T3."AbsEntry") AS "Pick",
COUNT(T4."DocNum") AS "DN",
COUNT(T5."DocNum") AS "IN",
COUNT(T6."DocNum") AS "CR"

FROM
OUSR T0
LEFT JOIN ORDR T2 ON T0."USERID" = T2."UserSign"
LEFT JOIN OPKL T3 ON T0."USERID" = T3."OwnerCode"
LEFT JOIN ODLN T4 ON T0."USERID" = T4."UserSign"
LEFT JOIN OINV T5 ON T0."USERID" = T5."UserSign"
LEFT JOIN ORIN T6 ON T0."USERID" = T6."UserSign"

GROUP BY T0."U_NAME"

Thanks!