Automate

 View Only
  • 1.  Evolve Report based on a Query

    Posted 06-09-2025 06:19
    Edited by Renette Nienaber 06-10-2025 10:41

    Hi - is it possible to change the field names to be that of the field description with Evolve Report based on a Query?

    Evolve reports

    Evolve reports



    ------------------------------
    Renette Nienaber
    Data Management specialist
    VIVO ENERGY SOUTH AFRICA (PTY) LTD

    10-06-2025

    Thank you Ronald. When creating a Report with referencing to your own Query, I don't see the options to edit the SQL, only Runtime values.

    report

    report


    ------------------------------



  • 2.  RE: Evolve Report based on a Query

    Posted 06-10-2025 01:15

    Hi Renette,

    It should be possisble to change the field names as the query is SQL. The field name is generated at the "select" command as in below example. 
    You can change the field name 'Status' in any name.

     



    ------------------------------
    Ronald Vlasveld
    Master data specialist
    Industrie- en Handelsonderneming Vreugdenhil B.V.
    ------------------------------



  • 3.  RE: Evolve Report based on a Query

    Employee
    Posted 06-12-2025 06:38
    Edited by Divya Verma 06-12-2025 06:40

    Hi Renette,

    In Evolve, you cannot provide an alias for a field when creating a report based on a Query Script. The alias option or SQL query window is only available when using the SQL (Manual) option. You can raise an idea Aha! item to suggest this as a potential improvement.



    ------------------------------
    Divya Verma
    *Precisely Software Inc.
    ------------------------------



  • 4.  RE: Evolve Report based on a Query

    Posted 06-12-2025 07:21

    Thank you Divya, I will log a suggestion.

    For the interim, I will provide the end user with a SAP field Glossary. Best I can do for now.

    report


    ------------------------------
    Renette Nienaber
    Data Management specialist
    VIVO ENERGY SOUTH AFRICA (PTY) LTD
    ------------------------------