Client Name/IP in Approval Decision Report

[Former Member]

How to include Client name /IP in approval decision report?.I wrote this query but it output some duplicated values with all the  machine names in my domain.

SELECT USR5.ClientName,DocNum,CardCode,CardName,OWDD.OwnerID,USR5.ActionBy,WDD1.Status,OWDD.WtmCode,OWDD.Status,ODRF.DocDate,DocDueDate FROM ODRF

INNER JOIN OWDD ON ODRF.DocEntry = OWDD.DocEntry

INNER JOIN WDD1 ON OWDD.WddCode = WDD1.WddCode

INNER JOIN OUSR ON WDD1.UserID = OUSR.USERID

INNER JOIN USR5 ON OUSR.USER_CODE = USR5.UserCode

WHERE ODRF.DocDate = '20150101'

order by  DocDate

[kothandaraman_nagarajan · Accepted solution]

Hi,

Try:

SELECT distinct  USR5.ClientName,DocNum,CardCode,CardName,OWDD.OwnerID,USR5.ActionBy,WDD1.Status,OWDD.WtmCode,OWDD.Status,ODRF.DocDate,DocDueDate FROM ODRF
INNER JOIN OWDD ON ODRF.DocEntry = OWDD.DocEntry

INNER JOIN WDD1 ON OWDD.WddCode = WDD1.WddCode

INNER JOIN OUSR ON WDD1.UserID = OUSR.USERID

INNER JOIN USR5 ON OUSR.USER_CODE = USR5.UserCode and OUSR.USER_CODE = USR5.[ActionBy]

where OWDD.docdate = USR5.date and ODRF.DocDate = '20150101'
order by  DocDate

[Former Member · Accepted solution]

Nagarajan,

But Please check the output i getting.There is no way 'Ananthu-PC' & 'SAJI ' will do the approval.Think that something went wrong in this query. I'm getting the same issue while using USR5 on any queries.Also please include originator user name .

[kothandaraman_nagarajan · Accepted solution]

Is it possible to post your approval decision report here to check?

[Former Member · Accepted solution]

Nagarajan ,

Sure .Please see the Scrn. Shot.

[kothandaraman_nagarajan · Accepted solution]

Thanks for attachment. Again tested my query and getting required result.

Test above query in test DB  and let me know if any finding.

[kothandaraman_nagarajan · Accepted solution]

Any update?

[Former Member · Accepted solution]

Nagarajan ,

The  issue is still there.Many sap users are seems as logged in from different client machines like in the screen shot provided .

[former_member209066]

Hi,

Check This

SELECT  Distinct USR5.ClientName,USR5.ClientIP,DocNum,CardCode,CardName,OWDD.OwnerID,USR5.ActionBy,WDD1.Status,OWDD.WtmCode,OWDD.Status,ODRF.DocDate,DocDueDate FROM ODRF

INNER JOIN OWDD ON ODRF.DocEntry = OWDD.DocEntry

INNER JOIN WDD1 ON OWDD.WddCode = WDD1.WddCode

INNER JOIN OUSR ON WDD1.UserID = OUSR.USERID

INNER JOIN USR5 ON OUSR.USER_CODE = USR5.UserCode

WHERE ODRF.DocDate = '20150101'

order by  DocDate

Thanks,

Nithi

[Former Member]

Also tried the same .But its not working .Same issue

[former_member209066]

Hi,

Please post Screenshot.

Thanks,

Nithi

[Former Member]

Nithi ,

Please see the Scr.Shot