Change log table updates!

[#1]

Hi All

Can anyone tell how the Record update mode for Change log works..

I see new image and then comes the before image and comes the after image..

how to make sure which came in first...?any idea...as some transaction in AR, after reversal, there is a duplicate transaction created which still cause the AR report for the customer as OUTSTANDING

[former_member188080]

Hi,

Change log table is meant for this kind of analysis.

just see when this change has occured in the source system side for this document.

Post that you can see in BW which are those REQU*,ODSO * request in change log..

when you will filter data on that particular document you can see that how record has changed..say if KF value 100 and it is reversed one more record with -100 if value changed then say 100 to 120 ...either -100 will be created or just 20 record will be created based on which image is getting used...

I hope this will help you analysing the issue...

Thanks and regards

Kiran

[Former Member]

Hi Kiran

Thanks for your response..That I understood...but basically I just wanted to know how do I need to update my changes log based on the current issue...what is causing this issue? that is my concern..if you could help me suggest some ideas wuld be appreciable.*

*Hi actually we tried cancelling and redo the reversal, but still I see the same status. Actually the accounting was cleared with wrong billing doc and they did the reversal again and so the cleared wrong billing doc is opened which is different FY Variant K4 and

so now they re-cleared the same billing doc with correct accounting docs. now it is cleared with the FY variant Z1 as we have the FY changes this year from CALYEAR(K4) to APR-MAR (V3). so this 2012 JAn-Mar still considered as 15months period of Year 2011.

the FY and FYVariant are Keyfields now..do they have to be Key fields or not as it will create two billing doc with diff variant ,right?correct me if I am wrong. this is what is my current analysis which might clear the issue.

so because of this, my billingdoc reversed one with FY Variant K4 is still OPEN where as the Billing doc is cleared.

*Thanks! expecting your response. *