Skip to Content
avatar image
Former Member

Using datalinks in BFC to transfer data

Hi experts,

we plan to migrate our BO Objects Financial Consolidation from Oracle to SAP HANA. In addition we implement S/4HANA and a SAP BW on HANA system. We want to implement the following data flows

  1. Extracting balance sheet data from S/4HANA to BFC
  2. Extracting the consolidated balance sheet from BFC to SAP BW

For the data extraction between S/4HANA and BFC as well as between BFC and SAP BW we want to use a data link.

My questions:

  1. Is it possible to use BFC datalinks for loading from S/4HANA into BFC?
  2. Is it possible to use BFC datalinks to push data from BFC into a SAP BW on HANA system? Would that be possible using FIM instead?

Thanks for your help!

Regards,

Frank

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 23, 2017 at 11:08 PM

    Hi Frank

    1. No, this is not possible. DL cannot have HANA as a source.

    2. Extracting with DL would also be impossible.

    FIM can certainly use FC as a source system and BW and HANA can be targets. It really depends on your requirements. BW is really an OLAP engine, where FC natively runs on a relational DB. So, you may get issues with roll-ups etc. (e.g. FC will store data, even for a 'parent' accounts. If you extracted data on 'base' members, BW would aggregate based on a hierarchy, so it rolls up natively. You should then not extract data from FC on that parent, as you would see doubling). Obviously, all this can be handled in the design of the ETL job.

    There is another tool, called Cube Designer, which sole purpose is extracting data from FC and create OLAP cubes (it can deploy to MS Olap cubes, SAP BW and HANA views.)

    This may be something interesting for you, you can get more information here:

    https://help.sap.com/viewer/655c9dba6efb4e4ca3b2f0de156ec69a/10.1.5/en-US/808da012b8694f82aedac98c62d89b76.html

    Marc

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 06 at 04:35 PM

    Dear Franck,

    Since SP06, you have to possibility to use the S/4 Hana interoperability.

    To have more info, you can look at the what's new video

    https://help.sap.com/viewer/p/SAP_BUSINESSOBJECTS_FINANCIAL_CONSOLIDATION

    Best Regards,

    Pierre

    Add comment
    10|10000 characters needed characters exceeded