Deploy SAPUI5 application to ABAP repository database connection

[Former Member]

Hi Gurus,

I have one question which i searched in SDN but not able to figure out.

When we deploy SAP UI5 application to ABAP Server, what is the code required to connect to oracle database and where we need to write it. Next, how to fetch data from backend ECC to UI5 application.

I found some blogs where we are deploying to BSP application but i won't be able to find where we are writing code for connecting to database and how backend ECC data is getting fetched.

Please provide an example if possible where the code snippet would be illustrating the above queries and would be really appreciated.

Thanks for your support and time in advance.

Regards,
Ajay

[Former Member]

Hi Gurus,

I found out how to develop UI5 application in eclipse without using gateway services, so i am closing this thread.

Thanks for your help.

Regards,
Ajay

[junwu]

if you don't have gateway, you'd better forget about UI5

one more thing to check if you are able to deploy ui5 to your abap server.

[Former Member]

Hi Jun,

Yes we can deploy UI5 to ABAP server. Can you please give some steps how to connect UI5 to backend in such cases.

Like, where we need to write the logic to call the RFC and display the data in the frontend.

Any help will be really appreciated.

Regards,
Ajay

[ashwin_narayan]

Hi Ajaya,

You can expose the ECC tables through odata service through Netweaver Gateway Services.You can refer to below blog or video for a basic overview.

• Blog on Odataservcie
• Video on Odataservice

Thanks,

Ashwin

[Former Member]

Hi Ashwin,

Thanks for your response.

As i already mentioned in my previous post we don't have Odata server in our system.

What are the other ways of using the RFC to pass data to the front end?

Regards,
Ajay

[Sharadha1]

You have to create the FM to access data and expose it via oData. This oData service can then by consumed in Ui5 application.

-Sharadha

[Former Member]

Hi Sharadha,

Thanks for your quick response.

Can you please give an example where the above steps are described in details which would be really helpful.

Regards,
Ajay

[Sharadha1]

There are loads of blogs which can help you out with this.. one of them is

https://blogs.sap.com/2016/02/09/way-to-create-odata-from-rfc-and-consume-into-sap-ui5-application-p...

- Sharadha

[Former Member]

Hi Sharadha,

Thanks for your response.

We have sap on netweaver 7.31 as shown below where we can't create sap odata services using SEGW. How can we fetch backend data using RFC to SAP UI5.

sap-version.png

Regards,
Ajay

[saurabh_vakil]

Your system does not have the required gateway components. Refer to this page SAP Gateway Installation Prerequisites and setup your system by installing the mentioned components, only after this you will be able to create oData services using SEGW.

[Former Member]

Hi saurabh,

Our company don't have any such plan to upgrade the required component.

Therefore i want to deploy SAP UI5 to ABAP server as BSP application. Please let me know how to use RFC and pass data to SAP UI5 in detailed steps.

Regards,
Ajay