Enabling ​Copying and Pasting of Table Entries into List Report Page

[gregorw]

Hello SAP Fiori Elements Experts,

the documentation at Copying and Pasting from Microsoft Excel to Editable Tables and Enabling Inline Creation of Table Entries on Object Page describes nicely how to setup an Object Page to allow the inline creation of Table Entries. That then allows also the copy & paste from Excel (or other tab separated sources). But I would like to know if it is possible to enable the List Report Page with such a functionality. That way Business Users could do also mass data imports.

Best regards
Gregor

[patrick_winkler]

Hello,

how to develop transactional apps with multi inline edit capabilities:
Developing Transactional Apps with Multi-Inline-Edit Capabilities

This way you can use the excel upload in the list report of your main entity.

Regards,

Patrick

[gregorw]

Hi Patrick,

thank you for pointing me to this documentation. Can you confirm that animated GIF shows the actual behaviour for the user? It shows just one entry when doing the search, the user has to select this one entry and then on the detail page has a list with all entries. Can the page with the one entry be avoided to be shown?

Best regards
Gregor

[patrick_winkler]

Hello Gregor,

The GIF shows the ADT preview function of the service binding. However if you develop a Fiori Elements app with the illustrated OData service as the data source, you can skip the list report with the dummy entry so the user does not see it.

1. Typically your FE app has a List Report and Object page for your entity (e.g. Carrier) with navigation in between. With the singleton root entity model, your FE app does not need a list report but has two Object pages with navigation in between: one for the singleton entity (which has the table showing all carriers), and one for the Carrier. Doing so the List report with the dummy entry is not accessible.

2. Create a FLP mapping to navigate directly to the singleton object page. https://help.sap.com/viewer/a7b390faab1140c087b8926571e942b7/1709.001/en-US/33daedef95454af68903ef12...

In this example the FLP mapping would set CarrierSingletonID ( the semantic key of the singleton entity ) to 1.

Once the next SAP BTP version is released to customer, I will check if there is a suitable tutorial available.

Regards,

Patrick

[gregorw]

Hi Patrick,

is the next SAP BTP version released? Could you check if there is a tutorial available?

Best Regards
Gregor

[patrick_winkler]

Hi Gregor,

https://developers.sap.com/group.abap-env-factory.html

shows how to create a factory calendar with multi edit capabilities w/o showing the dummy entry.

However it uses the Maintain Business Configurations app, i.e. you will not implement the FE app but only the required backend objects.

Regards,

Patrick

[rb]

Hi, is there any new tutorial for this? Especially the direkt to object page navigation for direct inline editing? SM30 Style

[patrick_winkler]

Hello richard.brnning2 ,

Read this blog: https://blogs.sap.com/2023/03/31/how-to-create-a-fiori-elements-app-for-a-rap-bo-with-transport-sele.../

It is not only about the transport selection, but also the handling of a singleton node for inline editing.