ODATA BDC and Front End Services handling issue

[former_member594288]

Hi,

I am new to odata, could you please anyone clarify the below points.

1.We used to call cl_gui_frontend_services=>directory_browse to select a folder but how to achieve this functionality in odata. who is going to handle it front end developers or odata developers. If we can achieve this please mention how to achieve.

2.Can we write BDC code in odata service, will it work?

3. How to download excel file which is uploaded from front end in odata

[gregorw · Accepted solution]

1. Your Front End developers must look into the FileUploader control. For the backend look into the many posts regarding odata gateway file upload / media handling.
2. Yes, as long as the transactiondoesn't use any GUI controls
3. Check out abap2xlsx

[former_member594288 · Accepted solution]

2. Any GUI controls means?

3.we cant use abap2xlsx because from frontend they are sending excel file. we can't get data like GUI right that is the reason i am asking..

[gregorw · Accepted solution]

2. Active X controls

3. I don't get what you mean. When you implement 1. you can upload the Excel via the browser and process it with abap2xlsx. abap2xlsx can also read and not only create Excel.

[Andre_Fischer · Accepted solution]

And if you just want to download the content of your OData Service as Excel from your Fiori UI you can activate a flag so that an Excel Download Button becomes visible.

https://blogs.sap.com/2018/04/23/new-excel-export-functionality-available/

[viva_kd · Accepted solution]

Dear andre.fischer , i have been facing same issue, my BDC code inside Odata giving cotrol_error dump,

as soon as control comes CALL TRANSACTION 'KO02' mode 'N' UPDATE 'S',(trying to generate Cost Est Number) its giving dump.
i checked with basis its not GUI related issue,
any idea why BDC giving dump.

[Andre_Fischer · Accepted solution]

your question does not seem to be related to the original question.

Please post your own question and provide more details. (Code snippets, etc.)

[moshenaveh · Accepted solution]

Hello viva.kd ,

Please post a new question according to the guidance provided in the tutorial:

https://developers.sap.com/tutorials/community-qa.html

Thank you,

Moshe