B1UP - how to put a UF in "General Functions"?

Marcus Dörndorfer

Hello, unfortunately I don't know the English names of B1UP, so I'll add the German terms here. 


Surely a very simple question...: I want to put a query from the query manager into the B1UP window “General Functions” (Allgemeine Funktionen). I think that I have to define a UF for this. 


At this point I fail...: Can someone please give me a tip on how to do this? So how can I access a query in the UF configuration window ("UF Konfiguration") or am I wrong there?)?

Thank you very much,
Marcus Dörndorfer.

Comentarios

1 comentario

Fecha Votos
  • Comment author
    Alessandro Lopez Santinelli
    • Editado

    Hi Marcus, I hope I understood correctly; you need to access the queries saved in SAP (Query Manager). If so, you need to know the IntrnalKey of your query. You can run this query:

    SELECT T0.IntrnalKey, T0.QName, T1.CatName FROM OUQR T0 JOIN OQCN T1 ON T0.QCategory = T1.CategoryId WHERE T0.QCategory != -2 ORDER BY T1.CatName, T0.QName

    Once you have it, create a macro and use the statement: UserQuery(queryId);

    You can also create an SQL Report with the query you need, which I believe is a better option. I hope this is what you were looking for.

    regards.

    Alessandro.

     

     

    0

Iniciar sesión para dejar un comentario.