Skip to Content
0

How to create XS OData service using SAP HANA tables?

May 16, 2017 at 02:32 PM

398

avatar image
Former Member

Hi All,

I am new to XS OData service and trying to access SAP HANA tables in XS OData service. As far as I explored in SAP blogs and help documents, we can create MDC tenant database in hcp and create and process the schema table(Create, update, get, read, delete) with xsOdata service.

But, I want to access the SAP HANA system database tables(eg. MARA) in XSEditor and generate OData service.

Kindly let me know the steps for the same.

Based on my understanding, Generating data through XSOdata service is much faster than ABAP NetWeaver gateway service(Kindly let me know If am wrong).

Regards,

Muthukumaran P.

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

1 Answer

Frank Schuler
May 16, 2017 at 04:30 PM
0

Hello Muthu,

One easy way to expose a standard SAP ERP table like MARA from SAP HANA is to create a Calculation View on top of it and expose this Calculation View. This way you can also specify the columns you would like to expose and whether they should be Dimensions or Measures.

Best regards

Frank

Show 5 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks for your input Frank!

Let me check the same and come back.

Regards,

Muthu

0
Former Member

Hi Frank.

Is it possible without abap layer, I mean directly calling on-premise system tables by registering the system in SAP HANA workbench?

Thanks,

Muthu

0

Hello Muthu,

Technically, this is possible, but depending on your HANA license, you might have to go though the ABAP layer and create a CDS view instead.

Best regards

Fank

0
Former Member

Hi Frank,

I have HANA license, But I am unable to find the approach to connect my HANA database(on premise) to the xsHANA workbench(MDC tenant database in my cloud account).

Kindly provide some hints/ blogs on the same.

Sorry for the delayed reply!!

Thanks,

Muthu.

0

Hello Muthu,

If you like, please have a look at this blog of mine. It should give you an idea how to expose a HANA table via an OData service:

Measure your Raspberry Pi sensor data on the go with the Smart Business Service

Best regards

Frank

0