Extend Custom Business Object UI - Enable Export

[janmrs]

Hi SAP Community,

Is there a way to enable Excel spreadsheet export for tables on auto-generated UIs for custom business objects? The UI uses the SmartTable SAPUI5 control, which should have a property for enabling this feature.

In fact, with the UI5 Inspector extension for Chrome installed, I can set this property to 'true' and have the export feature enabled, but I don't think it's a good idea to tell our users to do this.

It seems overkill to create a custom Fiori application just for having an export feature. I don't think I can extend these custom business object UIs either, but I might be wrong.

Best Regards,

Andre

[former_member1214360 · Accepted solution]

Hi Andre,

Instead of Extending the Standard Application which is generated after publishing the Custom Business Object then create the Analytical Query with reference of the CDS view.Once the Query created successfully then we have option to publish the same as a APP in the launchpad.

After the Custom app published successfully then we can download the data in Excel.

Please check and let me know if any quiries.

[janmrs · Accepted solution]

Hi Sairam,

This is more or less the same approach I took, I guess it's impossible to activate such a simple feature that easily.

I hope SAP adds an option to enable this via UI adaptation, as this seems like a good feature to have.

[Enda]

Hello Andre,

Have you checked the information in the KBA https://launchpad.support.sap.com/#/notes/2434491 for the issue you describe with the Export to Excel?

What tool / App are you using to create the Business Object?

Thank you

Enda

[janmrs]

Hi Enda,

The custom business objects are created manually using the Custom Business Objects Fiori app. I also had the UI Generation feature enabled during creation of the custom business object.

As for the KBA you shared, I tried performing UI adaptation, but there doesn't seem to be an option to include additional buttons, despite already having the necessary role assigned to me for the Extensibility (SAP_CORE_BC_EXT) catalog.

Andre

[janmrs]

Hi Enda,

Reading further into possible options for extending the custom business object UI, I have found out that the way to do it is to create a new Adaptation project from Web IDE, and use the generated custom business object UI as my source.

Since I am trying to extend an app in S/4HANA Cloud, I had a communication arrangement set up for getting the list of apps from the S/4HANA Cloud system. I was able to see the app that I was trying to extend/adapt, but after selecting said app, the table just loads indefinitely, and I was not able to proceed with the project creation.

Looking at my browser's developer tools, there's 1 network error for "logger" which returned HTTP 403 error.

Then there seems to be an error with the Javascript code, which I was not able to make sense of at all, as the code is minified.

Best Regards,

Andre