Change Log

[former_member218051]

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

[former_member184718]

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

[former_member218051]

Hi Kamba Dasan & Harikumar

I've given all these things.

Only thing I wanted to know is when do adoc and ado1 tables are updated ?

Thanking You

Malhaar

[Former Member]

Hi

These table will get updated,when you make any changes to that document.

for ex:

you create new Sales order and you cannot find data for that sale order in ADOC and ADO1 table while running query.

It will show blank,but after changing any value in that sale order and running the same query will gfet you result

[former_member184718]

Hi,

The tables, ADOC & its child tables ADO1...ADO16 are huge tables which includes the history of all marketing documents means all the object types are covered here.

These tables will not get exposed through DI API. History tables can be used as reference for any support arises.

Thanks.

Hari

[former_member218051]

Hi Kambadasan,

If this is the case, how come the rows whose shipdate is somewhere in august and linestatus is closed is shown in the log where updatedate is 25-sep-2012 ?

Thanking You

Malhaar

[former_member184718]

Hi,

Check the object type of those rows whose shipdate is somewhere in august and linestatus is closed.

The tables, ADOC & its child tables ADO1...ADO16 are huge tables which includes the history of all marketing documents means all the object types are covered here.

Thanks.

Hari

[Former Member]

Hi

You have linked only the docentry.

so it wont compare the other detail with ADOC and ADO1 table.

[former_member218051]

hi Harikumar,

Is there a way to know which fields were changed ?

Thanking You

Malhaar

[Former Member]

Hi Malhaar,

It is easy to tell by trying through a query:

SELECT * from adoc t0 inner join ado1 t1 on t0.docentry=t1.docentry

WHERE t0.objtype='17' and t0.DocNum = [%0]

Browsing through every fields and lines to know what had been changed.

Thanks,

Gordon

[former_member218051]

Hello Gordon,

I tried this by giving additional criteria as adoc.updatedate = '09/25/2012' in order to know the changes made to the sale order on that day. Because log shhots every day.

But my management asked me why the log is showing rows whose shipdate is in august and on top of it they are closed.

I have no answer.

Thanking You

Malhaar

[Former Member]

Even though the document is closed, some fields or UDF can still be updated.

[Former Member]

Hello Gordon,

thank you for the explanations. I try to find out the date, when a Sales Order change the Status to "close" before SBO 882 PL 13 it was a entry in the ADOC. After migrate to PL 13 the change to status "close"  is no more a new entry in the ADOC.

For example

SO in 882 before PL 13 created on 01.02.2013

AR Invoice for the SO on 01.03.2013 (all items) --> SO change to status close.

this status change reflect in a entry in ADOC.

SO in 882 after PL 13 created on 01.12.2013

AR Invoice for the SO on 15.12.2013 -->  SO change the Status to close

--->> NO ENTRY IN ADOC <<---

Is there a reason for that handling , how can i find out the date when the status fom the SO is changed?

[kothandaraman_nagarajan]

Hi,

Please post your issue as new discussion. This is standard forum rule. Link this thread in your new discussion.

Thanks & Regards,

Nagarajan

[Former Member]

Hello Nagarajan,

thank you for that hint.

Now it is

http://scn.sap.com/thread/3531378

best regards

Gerhard

[kothandaraman_nagarajan]

Hi,

Thanks for understanding.

Regards,

Nagarajan

[Former Member]

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

[KennedyT21]

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

[former_member218051]

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