Import data from SAP Hana to SAP ERP

[Former Member]

Hello Experts,

Is it possible to import data from calculation view in SAP HANA to SAP ERP?

If yes, Please guide me the detail steps.

Thanks & Regards

Bhasin Naik

[Former Member]

Experts,

Please help me on this. I need to give solution to customer.

Thanks & Regards

Bhasin Naik

[Former Member]

Dear Bhasin,

-Create connection for secondary database in ERP side, That will create by basis team in DBCON table.

- Then Google , how to consume views in ABAP.

Please spend some time on scn post you will able  to do it.

[Former Member]

It has following ways.

1.If you have ABAP for eclipse you can create external views(dictionary view). It will available in se11.

2. If you wanted to access views in ECC, you need to create secondary database and use it in ABAP using SAP classes.

Amol.

[Former Member]

Hi Amol,

thanks for reply.

How is it gonna work with sidecar Approach?

Best Regards

Bhasin Naik

[henrique_pinto]

Yes, of course.

Search for "ABAP External Views", you'll find a lot of info.

Here is an excellent how-to guide:

One comment: you'll need to use ADT (ABAP for Eclipse) in order to be able to define External Views on your ABAP System. Also, it needs to be NW 7.40 on top of HANA.

Additional info: ABAP Keyword Documentation

[Former Member]

Hi Henrique,

Thanks for the reply.

The solution which you have given is for SAP ERP on HANA right? Correct me if i am wrong.

We have a side car approach here. In this case will it work?

Thanks & Regards

Bhasin Naik