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

Marcus Dörndorfer

• 16 de septiembre de 2024 07:30

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.

Vote

0

• 

  Alessandro Lopez Santinelli

  • 17 de septiembre de 2024 16:29
  • 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.

   

   

Iniciar sesión para dejar un comentario.