How to create XS OData service using SAP HANA tables?

[Muthukumaran]

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.

[architectSAP]

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

[Muthukumaran]

Thanks for your input Frank!

Let me check the same and come back.

Regards,

Muthu

[Muthukumaran]

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

[architectSAP]

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

[Muthukumaran]

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.

[architectSAP]

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