GL Data Reconciliation in SAP BW 7.5 on HANA

[former_member428672]

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

[former_member308530]

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

[former_member428672]

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

[former_member308530]

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