Inconsistencies data between ODS and RSA3 in SAP system (delta problem??)

[Former Member]

Hi everyone,

I have a problem in my SAP BW production system. There is inconsistencies data between ODS (using tcode LISTCUBE) and Datasource in SAP system (tcode RSA3).

I'm using Datasource: 0FI_GL_10 and ODS: 0FIGL_O10.

In SAP system (using RSA3):

-

---

GL Account: 1202012091

Comp Code : 5400

Bus Area: 5401

Fiscal Year :2008

Period: 07

Accum Balance : $0

Credit Total: $350

Debit Total: $350

Sales : $0

And in ODS (using ListCube):

-

---

GL Account: 1202012091

Comp Code : 5400

Bus Area: 5401

Fiscal Year :2008

Period: 07

0BALANCE : $350 (it should be $0,shouldn't it? )

0CREDIT: $0 (it should be $350,shouldn't it? )

0DEBIT: $350

0SALES: $350 (it should be $0,shouldn't it?)

I have tried these :

1. Check if there is a start routine / routine or not in transfer or update rules....and...i get nothing

2. Check the data using tcode FBL3N..but the data is ok

And then i tried to trace the process chain and find error on delta infopackage which pull these data

Date

07.30.2008 : 231141 records --> error (ODS activation) --> request has deleted forever

07.31.2008 : 2848 records --> error (ODS activation) --> request has deleted forever

08.01.2008 : 135679 records --> error (ODS activation) --> request has deleted forever

08.02.2008 : 135679 records --> successfull repeat delta action

From 30 July until 1 August there is an error on delta infopackage because

fail to activate ODS (No SID found for value 'RIM' of characteristic 0UNIT). On 2 August someone delete the red requests and repeat the delta and success. Is there any possibilities that this problem arise because of this? If this the cause, how to bring back 2848 and 231141 records which has deleted?

Thank you and Regards,

-Satria-

[Former Member]

Hi everyone,

I have solved my problem. I executed my infopackage again (selection condition using GL Account which have wrong amount) with update mode 'Full update' and choose Scheduler > Repair Full Request and tick the checkbox.Thank you.

Regards,

-Satria-

[Former Member]

Hi,

First thing, please check and make sure all your needed iobjects are mapped in transformation (0BALANCE, 0DEBIT, 0CREDIT). Then you will have the same data in ODS compare with datasource

If you want to recover all previous data, you should execute initial loading again.

Hope this helps

BR

TRUC

[Former Member]

Check the change log of the ODS

You will come to know how did the value arrive.

The Change log has complete history

if your valur is 10 and new value is 15 then the change log should have 3 entries

10

-10

15

Hope this helps

[Former Member]

Also check the transfer rule / update rule / transformation if you have maaped the right value to the right field

bcoz your output in ODS just feels as if it is wrongly mapped