Versions Compared

Old Version 1

changes.mady.by.user Charles Evans (Unlicensed)

Saved on

compared with

New Version Current

changes.mady.by.user Charles Evans (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overview:

Often there is a need to provide ad-hoc reporting capabilities on instances of applications to power users.  As Fiori applications are based on OData, the option to use Microsoft Excel or any other OData compatible reporting tools is immediately supported.  The available OData service will bring back basic data about each instance of the application such as:

  • Submitted Timestamp
  • Change Timestamp
  • Submitted By
  • Instance ID
  • Form Status

Any configured Search Fields in your ABAP Implementation Class will also be brought back from this service.  This allows you to take important fields from your data model and have them available from your service.

OData Service End Points:

  • Form Header Information
    • (SAP Gateway Base URL)/sap/opu/odata/iqx/FAB_SRV/FormHeaderInstances?$filter=FabVersion eq '002' and Filter eq 'Administrator' and ZformName eq 'Form_ID'
  • Search Fields Information
    • (SAP Gateway Base URL)/sap/opu/odata/iqx/FAB_SRV/FormHeaderSearchTerms?$filter=ZformName eq 'Form_ID'


Info

Change Form_ID  to the name of the app your are wanting to interact with.

Instructions (For Excel):


  1. Open Excel and select the Data tab.  From within the Data tab, there will be an option to either Get External Data or Get Data.  (This will vary on your version of Microsoft Excel;).

    Image Added

  2. From the Data tab, find the option to Import Data from an OData Data Feed.

  3. You will then need to provide the OData Service End Point you wish to connect to

    Info
    • Form Header Information
      • (SAP Gateway Base URL)/sap/opu/odata/iqx/FAB_SRV/FormHeaderInstances?$filter=FabVersion eq '002' and Filter eq 'Administrator' and ZformName eq 'Form_ID'
    • Search Fields Information
      • (SAP Gateway Base URL)/sap/opu/odata/iqx/FAB_SRV/FormHeaderSearchTerms?$filter=ZformName eq 'Form_ID'


    Image Added


  4. Depending on your version of Excel, you may be prompted to confirm the tables you wish to import and provide a description.

    Image Added 
    Image Added


  5. You must then select where in the Excel workbook where you would like the data to be stored.

    Image Added


  6. The data will then be imported into Excel and can be refreshed using the options in the Data tab.

    Image Added