RE: [sap-dev] SAP Query reports - reverse generation
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by zvudarcik (Dipl. ING.) on May 22 at 4:35 PM |  Mark as helpful |
Thank you for advice, Horacio. I it try when user will ask it again. Primary I must check tens user's programs by ECC6 upgrade. Now the poblem seems to be out of scope.
BR.
Zdeno
From: sap-dev@Groups.ITtoolbox.com
To: zvudarcik@hotmail.com
Date: Fri, 21 May 2010 10:29:34 -0300
Subject: RE: [sap-dev] SAP Query reports - reverse generation
Posted by horacio zapettini
on May 21 at 9:28 AM Mark as helpful
You could ? but it would be a real pain?
You have to do this:
For SQ02
determine the tables used (or the logical database)
determine joins
determine computed fields
determine any additional coding
for SQ01:
determine the format, sumary info, and any other agregation you need.
determine any parameters and calculated fields specific to the infoset query
Once you have this: you could recreate the infoset, then the infoset query. I don't think this is worth. (but if they want to pay ? J it's up to them )
De: zvudarcik via sap-dev [mailto:sap-dev@Groups.ITtoolbox.com]
Enviado el: Viernes, 21 de Mayo de 2010 10:19 a.m.
Para: Horacio Zapettini
Asunto: RE: [sap-dev] SAP Query reports - reverse generation
Posted by zvudarcik (Dipl. ING.)
on May 21 at 9:15 AM Mark as helpful
Hi Horacio,
hanks for your answer. The first thing I did was debuging report name from Display Report Name functionality:
* Namenskonventionen
* AQwwbbbbbbbbbbbbqqqqqqqqqqqqqq:
* ww - 00..99 Mandant 000 bis 099 im Standardbereich
* A0..YZ Mandant 100 bis 999 im Standardbereich
* ZZ im globalen Standardbereich
* bbbbbbbbbbbb - Benutzergruppe
* qqqqqqqqqqqqqq - Query
* in den ersten 30 Stellen werden Leerzeichen durch = ersetzt
The problem is, that the Mandant was deleted, therefore the query is unknown and the key user running the Z-transaction (= the generated report) would edit the original query. By now I've brought him about impossibility of his wishing.
BR.
Zdeno
From: sap-dev@Groups.ITtoolbox.com
To: zvudarcik@hotmail.com
Date: Thu, 20 May 2010 14:39:19 -0300
Subject: RE: [sap-dev] SAP Query reports - reverse generation
Posted by horacio zapettini
on May 20 at 1:39 PM Mark as helpful
Zdeno, if you're lucky, in the name of the report (in the code) it is hidden the functional area name and the infoset query name.
Why if you're lucky? because some programmers (like me) do not change the original report name in the code (so I can have a reference to the original code just in case I need it in the future).
If the report is a copy, then a minor change could solve the problem: there has been a change in the call to a form AUTHORITY
This is how it looked before:
PERFORM AUTHORITY(RSAQEXCE) USING 'LFA1'.
And this is how it should look now:
perform authority_begin(rsaqexce) using 'CL_QUERY_TAB_ACCESS_AUTHORITY'. "NEW in ECC6.
perform authority(rsaqexce) using 'LFA1' 'CL_QUERY_TAB_ACCESS_AUTHORITY'. "the second parameter is new in ECC 6
perform authority_end(rsaqexce) using 'CL_QUERY_TAB_ACCESS_AUTHORITY'. "NEW in ECC6
HTH
Horacio
PS. There is no way to go back from the program to the infoset query used to generate the report (unless you have the original name?)
De: zvudarcik via sap-dev [mailto:sap-dev@Groups.ITtoolbox.com]
Enviado el: Jueves, 20 de Mayo de 2010 10:49 a.m.
Para: Horacio Zapettini
Asunto: [sap-dev] SAP Query reports - reverse generation
Posted by zvudarcik (Dipl. ING.)
on May 20 at 10:21 AM
Hi experts,
in fresh upgrade SAP ECC6 there are user transactions which use programs generated by SAP Queries. I've generated them from existing query. But some of the used programs were generated by unknown Queries even in source system.
Is it possible to reverse report generation for creation Query from a program?
Or is it possible to transport such a program? The programs exist in source system, but they've no records in object catalog.
Thanks in advance
__.____._ BR.
Zdeno
From: sap-dev@Groups.ITtoolbox.com
To: zvudarcik@hotmail.com
Date: Fri, 21 May 2010 10:29:34 -0300
Subject: RE: [sap-dev] SAP Query reports - reverse generation
Posted by horacio zapettini
on May 21 at 9:28 AM Mark as helpful
You could ? but it would be a real pain?
You have to do this:
For SQ02
determine the tables used (or the logical database)
determine joins
determine computed fields
determine any additional coding
for SQ01:
determine the format, sumary info, and any other agregation you need.
determine any parameters and calculated fields specific to the infoset query
Once you have this: you could recreate the infoset, then the infoset query. I don't think this is worth. (but if they want to pay ? J it's up to them )
De: zvudarcik via sap-dev [mailto:sap-dev@Groups.ITtoolbox.com]
Enviado el: Viernes, 21 de Mayo de 2010 10:19 a.m.
Para: Horacio Zapettini
Asunto: RE: [sap-dev] SAP Query reports - reverse generation
Posted by zvudarcik (Dipl. ING.)
on May 21 at 9:15 AM Mark as helpful
Hi Horacio,
hanks for your answer. The first thing I did was debuging report name from Display Report Name functionality:
* Namenskonventionen
* AQwwbbbbbbbbbbbbqqqqqqqqqqqqqq:
* ww - 00..99 Mandant 000 bis 099 im Standardbereich
* A0..YZ Mandant 100 bis 999 im Standardbereich
* ZZ im globalen Standardbereich
* bbbbbbbbbbbb - Benutzergruppe
* qqqqqqqqqqqqqq - Query
* in den ersten 30 Stellen werden Leerzeichen durch = ersetzt
The problem is, that the Mandant was deleted, therefore the query is unknown and the key user running the Z-transaction (= the generated report) would edit the original query. By now I've brought him about impossibility of his wishing.
BR.
Zdeno
From: sap-dev@Groups.ITtoolbox.com
To: zvudarcik@hotmail.com
Date: Thu, 20 May 2010 14:39:19 -0300
Subject: RE: [sap-dev] SAP Query reports - reverse generation
Posted by horacio zapettini
on May 20 at 1:39 PM Mark as helpful
Zdeno, if you're lucky, in the name of the report (in the code) it is hidden the functional area name and the infoset query name.
Why if you're lucky? because some programmers (like me) do not change the original report name in the code (so I can have a reference to the original code just in case I need it in the future).
If the report is a copy, then a minor change could solve the problem: there has been a change in the call to a form AUTHORITY
This is how it looked before:
PERFORM AUTHORITY(RSAQEXCE) USING 'LFA1'.
And this is how it should look now:
perform authority_begin(rsaqexce) using 'CL_QUERY_TAB_ACCESS_AUTHORITY'. "NEW in ECC6.
perform authority(rsaqexce) using 'LFA1' 'CL_QUERY_TAB_ACCESS_AUTHORITY'. "the second parameter is new in ECC 6
perform authority_end(rsaqexce) using 'CL_QUERY_TAB_ACCESS_AUTHORITY'. "NEW in ECC6
HTH
Horacio
PS. There is no way to go back from the program to the infoset query used to generate the report (unless you have the original name?)
De: zvudarcik via sap-dev [mailto:sap-dev@Groups.ITtoolbox.com]
Enviado el: Jueves, 20 de Mayo de 2010 10:49 a.m.
Para: Horacio Zapettini
Asunto: [sap-dev] SAP Query reports - reverse generation
Posted by zvudarcik (Dipl. ING.)
on May 20 at 10:21 AM
Hi experts,
in fresh upgrade SAP ECC6 there are user transactions which use programs generated by SAP Queries. I've generated them from existing query. But some of the used programs were generated by unknown Queries even in source system.
Is it possible to reverse report generation for creation Query from a program?
Or is it possible to transport such a program? The programs exist in source system, but they've no records in object catalog.
Thanks in advance
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Related Content
In the Spotlight
White Papers
In the Spotlight
Your SAP Security is at Risk...Learn How to Stay Protected. Read the free white paper from SenSage
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
_.____.__ 
