Reverse postings - Accounts receivable data

[Former Member]

Hi All,

We have datasources 0FI_AR_4 and 0FI_GL_4. The R/3 team is going to make some changes to the 2011 AR entries like reverse postings, adding new data, deletion of some existing data. This will also be affecting some GL data. SO can you please let me know what should be done in BW to ensure all the data is loaded to BW with out any issues(no data is corrupted). There is no compression on my cubes. The data flow is psa-dso-cube.

Thank you!

[ravikanth_indurthi]

Hi,

Just pull the data to BW side, the reverse postings will make zero of existing values in the cube.

And new postings will add new records to the cube. But check the data load if you are doing a Delta load, because it will be based pulled only once per day based on CPU time stamp.

Hope this helps....

Rgs,

Ravikanth

[Former Member]

Can someone help me on this..

[Former Member]

Hi,

Depends on what kind of changes R/3 team is going to do.

If all changes to AR data in ECC will be introduced as new postings to existing entries via normal transactions you should expect that all changes will be caputred in BW via delta loads in 0FI_AR_4 and 0FI_GL_4,

I would propose to R3 team to execute one change and check if changed records are visible in delta queue.

If R3 team is going to make some direct updates on FI tables you should  reload data to your BW system. If transformation in BW is using only Overwrite update mode you do not need to delete all data but only execute a full load for specific period (e.g. year 2011, DSO will ensure correct delta upload to cube)

regards