Change log table updates!

[Former Member]

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. *

[Former Member]

Hi,

As you know we have different recordmodes in SAP BI

N -- New Image

A -- After Image

X - Before Image

R - Reverse Image

D - Deletion image

Now lets take a record 1111(sales order) 30(Qty) is loaded to the DSO.

while activating the DSO, as this record is new one(this record is not present in active table of DSO) it will move to active table of DSO and change log table of DSO. in change log table we will have the below record

1111 30 N(new)

Now, today this order quantity has been changed to 40. So will get record 1111 40 into BI system. When activation takes place, system compares the records with active table. As this records already exist in active table, it will get overwrite. We will get the below records in chagne log table.

1111 -30 X(Before image)

1111 40 A(After Image)

When we load this data to info cube, this two records and existing record will get summed up(property of Info Cube).

1111 30(existing record)

1111 -30

1111 40

so we will get correct result as 1111 40, which is required.

You can check my article

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/a080ea68-fba2-2e10-8cb7-d42d5bfba09c

Regards,

Venkatesh.

[Former Member]

Hi Venky,

Thanks for your response...

First small correction, After image will be blank " ", not as 'A'.

2. Next, So every transaction changes, there is a before image and after image, right?

3. So now I have a billing doc, which is cleared by Accounting side,

when they cleared the document

Firstly, when they clear the document, they cleared using Posting key for the A & B billing doc. with new FI clearing no and so my status for A & B billing doc closed.

• Secondly, it is wrong, so they reverse with reversal posting key for the A & B billing doc.*

*so now what happened is when the reversal happened, A billing doc is re-opened and so my doc status is "Open" *

and so the transaction is appearing as NEW image with Open status.

but actually the billing is cleared but my report says the status still open.

Any idea or suggestions what I can do? wAITIN FOR YOUR RESPONSE

I thought of doing a Full Repair to test, but I still cannot as I dont have selections for doc.no in

info package

Could it be due to Key field?? as we have a Fiscal Year Change from Calendar Year K4 to V3 (Apr-Mar) and so this 2012 Jan-Mar is considered as 2011 as 15months with new variant Z1.

I have sent the docs data to your email id.

so the reversal happened in K4 and so it is open K4 and closed in Z1 variant..If I remove it, will it clear my open issue..

Thanks. Expecting your possible soln.

[Former Member]

Hi,

Next, So every transaction changes, there is a before image and after image, right?

Yes, for every transaction change before image and after image is created.

**so now what happened is when the reversal happened, A billing doc is re-opened and so my doc status is "Open" **

and so the transaction is appearing as NEW image with Open status.

Your current document status is open and after clearing it should become closed, what is the change in opening same document again?

Regards,

Durgesh.

[Former Member]

Durgesh-- Your current document status is open and after clearing it should become closed, what is the change in opening same document again?

What do you mean by that? I didnt understand.

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 now as it will create two billing doc with diff variant ,right?correct me if I am wrong.

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.