Wrong Balances

[Former Member]

Dear All

I am facing a problem, the cumulative balances which are being pulled to my ODS - 0FIGL_O10 are coming wrong.

I am using new GL. I checked the table FAGLFLEXT and i find that the cumulative balance is being overwritten by any new transaction balance.

For eg

Account no Op Bal Debit Credit Closing Bal

11101050 1000 0 0 1000

11101060 5000 500 0 500

In the above case the balance of account 11101060 should be 5500.

So where there are no transaction during the period the system picks up the correct closing balance. However when there is a transaction during the period the system instead of adding it overwrites the balance with the transaction data.

A quick help shall be highly appreciated.

Cheers

Shivkumar

[Former Member]

We have found the solution to the problem.

[Former Member]

Dear Team basis,

I am facing the same issue. could you please post the solution you used to sort this out?

thanks and regards

dilanke

[dennis_scoville4]

Is the data correct for balance in the PSA of 0FI_GL_10? If so, then it's being somehow calculated in the Transformation going to 0FIGL_O10, assuming that you have the 0BALANCE Key Figure Characteristic Rule set to Overwrite.

[Former Member]

Hi,

FI_GL_10 gives aggregated values and it provides after image values hence what you have chosen as ODS with overwrite mode is correct . Refer the link below

http://help.sap.com/saphelp_nw04/helpdata/en/a8/e26840b151181ce10000000a1550b0/content.htm

which will explain you clearly the fields to be kept as keyfields and updation process. if you design the ODS as per the above link the values will be perfect.

Hope this helps for you.

Thanks,

Arun.

[Former Member]

Dear Arun

This is the SAP documentation i was referring in my earlier reply. My settings are correct as per this.

But on ECC side the value in the table seems to be wrong.

Thanks for your help

Cheers

Shivkumar

[Former Member]

Hi,

Check in the update rule or transformation if for that key figure the Update type is set as addition. Only in that case the key figure will be added without being overwritten. If it is set to overwrite, change it to addition and load.

If it is cube the key figures will be accumulated by default. But DSO will be having a property to overwrite.

Hope this helps.

[Former Member]

Hi Akhan

Thanks for your prompt reply, it is much appreciated.

When i check the FAGLFLEXT table in ECC, which is the source table for the data source 0FI_GL_10; the values are wrong in this table for cumulative balances.

I checked SAP documentation for the data source 0FI_GL_10 and as per that on the BW side all my settings are fine.

Cheers

Shivkumar