Skip to Content
0
Former Member
Dec 02, 2008 at 09:52 AM

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

12 Views

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-