Skip to Content
avatar image
Former Member

Change Log

Hello Experts,

How sale order change log tables are updated.

for example, I've an order number 1002.

I'm supposed to produce a change log statement to management every day.

but when i queried ado1 and adoc tables to know the changes made to the order for 25 - sep - 2012 then I got 495 rows.

I'm joining adoc and ado1 tables on docentry and objtype.

In where condition I've passed adoc.updatedate = '09/25/2012'

Can anyone please tell me how SAP maintains log ?

I'm confused.

thanking You

Malhaar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Sep 26, 2012 at 09:20 AM

    Hi Prandnya Samant,

    Check in

     Administration  System Initialization  General Settings  Services  tab.

    History / Log

    Sets the number of records to be saved in the log file.

    The log file saves the history of changes made in master records (items, business partners, and G/L accounts), documents, and other windows in SAP Business One. This setting is updated per company, for all users.

    If you change the Log number and update it will delete according to the log history..

    Check when the last history count has been changed

    Hope Helpful.😊

    Regards

    Kennedy

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Kennedy,

      99 is set over there.

      That setting is untouched because i was not aware of this.

      If it is like this, then this table holds more than 500 records as change log for this particular sales order.

      Kindly help.

      Thanking You

      Malhaar

  • avatar image
    Former Member
    Sep 26, 2012 at 09:22 AM

    Hi

    Try this:

    select * from adoc t0 inner join ado1 t1 on t0.docentry=t1.docentry where t0.objtype='17' 

    and t0.UpdateDate = '2012-04-23 00:00:00.000'

    You can replace '*' by necessary fields

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 26, 2012 at 09:38 AM

    Hi,

    Filter it by the objtype value of ADOC table.

    Try this:

    select * from ADO1 t0

    inner join adoc t1 on t1.DocEntry = t0.DocEntry

    where t0.docdate = '20120925' and t1.DocNum = '1002' and t1.ObjType = '17'

    Thanks.

    Hari

    Add comment
    10|10000 characters needed characters exceeded