GL Validation

[Former Member]

hi,

I just would like to know the steps for validating GL Line Items in BW with the R/3 system.I have got all the GL line items into GL Line Item ODS and how do we validate with the GL Line items in R/3 tables(BKPF&BSEG).

Any Ideas.

Thanks in advance.

[Former Member]

Hi,

In R3 you can probably use some of the master report from the information system to run and display GL by company code. In most scenario, check with you FI colleague if there are availabe reports that runs GL by company code. I think one of the ways is via transaction f.10.

Then in BW (I assume the ODS is setup for reporting), create report or use existing report(s) to run the same thing, and check on total level, such as total creditor, debitor accounts or balance sheet. In case of discrepancies, you can always zoom in to view the difference. This is more of a top down approach for data reconciliation.

Hope this helps.

Cheers,

Gimmo

[Former Member]

Thanks for the information .

[Former Member]

Hi,

Are you trying to reconcile data?

Cheers,

Gimmo

[Former Member]

Yes, I am trying to reconcile data between R/3 system and BW systems. Please let me know your ideas.

Thanks in advance.

[Former Member]

I assume you would have used the 0FI_GL_4 datasource which brings line item data.

YOu can reconcile data by looking at different ways...

Say take up a company code in BKPF table. Check the number of entries in the table. Go to the active table of ur ODS and do the same.

Check if all the fields on the ODs are populated.

Also, go to RSA3. The number of records in 0FI_GL_4 extract run should match with the number of entries loaded on to the ODS. Also make sure no records in the ODS are overwritten...if transferred records is 1000, then added should be 1000 too, unless you have any routine/business rules built in the update/transfer rules!!

Rgds

Prakash

Assigning points is a way of saying thanks on SDN!!