How to build an OData Service with Gateway Service Builder (NO DDIC, BOR import)

[Former Member]

Hi Community,

I hope to get an answer here to finish my project. I´m a newbie to the sap gateway service builder. Please provide me a helping hand.

I have a problem I´m sure someone out there can help me.

I need to create an sap ui app, which is monitoring our database behaviour (->transaction st06) is there someone who knows how to build a OData Channel with sap gateway service builder without importing a BOR- Object, or a DDIC?

Or how to build an OData channel which exposes the database (monitoring) data from ST06?

I would really appreciate if someone could help me.

THANKS!

JOE

[arunchembra1 · Accepted solution]

Hi Joe,

1. In SAP ABAP you can create RFC which can expose exposes the database (monitoring) data from ST06.
2. Please reffer the below link to create Odata Service using RFC, there are lot of documents available in SCN.http://scn.sap.com/community/gateway/blog/2014/03/06/let-s-code-crudq-and-function-import-operations...

Thanks,

Arun

[Former Member · Accepted solution]

Hi,

thank you for your answer.

I am an absolute newbie to ODATA Gateway.

In this blog Chandrashekhar Mahajan is  importing table name ZUSERINFO. Is there an existing table for database. I guess not how do I creat an abab structure for the such an Database odata service to import it.

Sorry if this question sounds silly.

Thank you in advance.

Joe

[AshwinDutt]

Hello Joe,

If u do not want to import any Structure or BOR- Object, u can follow below steps :

1. Create ur data model by adding the properties manually in SAP GW service builder with correct Edm    types.Doing this would be pain in my opinion ( sometimes we are forced to do this but no other option    doing this way )

   Create associations & navigation needed. 

2. U can generate run-time objects.

3. Go to appropriate classes and implement methods with ur Business Logic.

4. Register ur service & consume.

U can also import RFC to create data model and create mapping as per required by implementing correct method as well.

once u do this generate objects and register service and consume it.

Check this out for ur info :

Regards,

Ashwin

[Former Member]

Hi Ashwin,

I understand... but i cannot figure out wich data source attribute i have to use for st06 (Database Performance) to proceed with the tutorial.

In general could you tell me how to find out the data source name of an RFC... ?

lets say when i only know the transaction code (ST06)

Please help.

Greetings,

Joe

[AshwinDutt]

Hello Joe,

We need to have knowledge on which part of the underlying code will be called.

Once u know that u can use that as our data source to create your GW service.

If u do not have an RFC then a custom RFC has to be build to accomplish your scenario.

I do not what is the underlying code / RFC called for ST06 t-code. I cannot help u here as i do not have knowledge on it. Sorry

U need to find our what code has to be used to accomplish your use case.

Regards,

Ashwin

[arunchembra1]

Hi Joe,

You can create Custom RFC with the help of any SAP abap developer to fetch data from tables used for ST06 and create GW service based on the RFC.

Tables for ST06:

http://scn.sap.com/thread/1080146

How to create RFC :

http://help.sap.com/saphelp_nw70/helpdata/EN/9f/db98fc35c111d1829f0000e829fbfe/content.htm

Thanks,

Arun