topic Re: SAP Query Modification in Application Development and Automation Discussions

SAP Query Modification

manichand_ale — Wed, 09 Aug 2023 16:25:53 GMT

We got a requirement from client to add one more field from the table to existing SAP Query.

Now the existing Infoset, Query and User group in DEv. are in Global Area.

Now before I add the field to existing query should I move them all to Standard area or I can change them in Global area.

How to transport them to Quality after, will there be any program or normal TR.

Re: SAP Query Modification

TammyPowlas — Wed, 09 Aug 2023 16:47:15 GMT

If the query is global, that means it is client independent and you will need to transport it.

See https://blogs.sap.com/2013/10/25/transporting-sap-query/

If you move it to local, it's client dependent, and you can upload and download it between DEV, Q and production, if you have access.

Re: SAP Query Modification

Sandra_Rossi — Wed, 09 Aug 2023 19:52:48 GMT

You do as you wish, standard or global, but why changing?

Maybe your question is to know the difference between Standard area and Global area?

Re: SAP Query Modification

manichand_ale — Thu, 10 Aug 2023 09:15:19 GMT

Thanks Tammy. In my case I made changes to Query (SQ01) only and it got captured in the Transport directly. Now if I move this TR to quality will it work now.

Re: SAP Query Modification

thkolz — Thu, 10 Aug 2023 09:33:20 GMT

My advice: Write a simple ALV report instead of using a query (did the same in my last big project).
Maintaining/transporting queries is a pain in the... 😉