Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Client Name/IP in Approval Decision Report

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

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question