Skip to Content
avatar image
Former Member

Track change log with Host name /IP address ?

Is it possible to track  modification /Update details in SAP b1 8.82 PL 11 by combining  the document table  with USR5?What i need is to track the user name  and host name /Ip address who modifies a specific document like Business Prtner master data, Item master,all sales /Purchase /Inventory related documents .Is it possible without using any addons but  through a query report?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 23, 2014 at 06:37 AM

    Hi Nabil,

    Yes It is possible.

    I will tell you one example.

    If you want to find GRN data that enter user details and enter data client IP.

    then

    just find out GRN record.

    select * from OPDN where DocNum = 42867

    then use another Query for retrive User Details.

    select * from USR5 where ActionBy = 'STR1' and Date = '2014-06-19'

    I think you understand my concept.

    Regards,

    Nishit Makadia

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Nishit ,

      But  need to write two queries for that .I need something like the following query ,But the output contains duplicate values  so that i cant track the specific user/host name. I need to track  the change log of all the documents  like this query .

      SELECT T1.[CardCode], T1.[CardName],T1.[UpdateDate], T1.[CreateDate], T2.[UserCode], T2.[ClientIP], T2.[ClientName], T2.[Date], T2.[Time] FROM [dbo].[ACRD]  T1, USR5 T2 WHERE T1.[CardCode] = 'C-AP-HYD-1931'

  • Dec 23, 2014 at 07:33 AM

    Hi,

    Try to  link tables OITM, OUSR and USR5 to get updated details.

    Thanks & Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded