Skip to Content
0

GL Data Reconciliation in SAP BW 7.5 on HANA

Feb 20 at 04:04 PM

80

avatar image

Hello All,

could any one provide me an solution for the Data reconciliation for GL between ECC and BW. Current FI transactional -figures model is straight forward no coding used straight from ecc, but there are many filters been used at the bex level for each report ,and so webi report is using 9 bex queries.

We've got SAP Suit on HANA , little confused Is it good to do a 1) model in BW on hana (using ODS view) for reconciliation or 2) join the ecc table like Faglflexa and bseg other tables in hana and make a calc view on top then make a report on it?

If it is 1 option - what we can use for datasource?

Thanks,
Teena

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Mar 04 at 09:43 AM
0

Are you asking the Datasource that can be used for your option 1 for reconcilation? Have you checked on 0FI_GL_RECON datasource?

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hello Sudhakar,

Thanks for your reply!

I've come across the 0FI_GL_RECON, but not sure we can use it for 0FI_GL_14.

Is 0FI_GL_RECON only for specific data sources?

Thanks,

Teena

0
Former Member
Teena Gattu

0FI_GL_RECON can be used to reconcile Balances but not line items(0FI_GL_14).

0