Ansicht
Dokumentation
02422 - SQ01, SQ02 & SQ03
ROGBILLS - Synchronize billing plans ABAP Short ReferenceThis documentation is copyright by SAP AG.
SQ01, SQ02 & SQ03
Keep in mind that an ABAP query that's just listing or totaling a table probablywon't perform too bad, either. It's the 2- or 3- or 4-way table joins that
cause the performance problems.
Jim Doll, Perrigo
>>> aacsuggZnmhg.com 06/21 1:42 PM >>>
I will have to keep your idea close by!
Chris
-----Original Message-----
From: Mike Martin, IS, Sousa [mailto:MMartinZsola.com]
Sent: Thursday, June 21, 2001 1:50 PM
To: 'Sugg, Chris'
Cc: SAP - AS/400 List (E-mail)
Subject: RE: SQ01, SQ02 & SQ03
Hi Chris,
I constantly have to remind the users that an ABAP program that simply lists
table contents can be written faster than an associated ABAP query.
Additionally, when the developers tell me they are too busy, I usually offer
to do the development myself. I challenge that it will only take a couple
of hours to write a simple ABAP report like that. It's amazing that as soon
as a developer feels that they're losing some of their responsibilities,
they immediately have time to do the report! 🙂
Good luck!
Mike D. Martin<?xml:namespace prefix = o ns =
"urn:schemas-microsoft-com:office:office" />
SAP Basis Administrator
SOLA Optical, USA
707-763-9911 x6106
mmartinZsola.com
-----Original Message-----
From: Sugg, Chris [mailto:aacsuggZNMHG.com]
Sent: Thursday, June 21, 2001 10:18 AM
To: 'Mike Martin, IS, Sousa'; SAPLIST (E-mail)
Subject: RE: SQ01, SQ02 & SQ03
Hey Mike.
Thanks for the information. I am trying to keep from having to grant access
to the tools but its an uphill battle.
Thanks again
-----Original Message-----
From: Mike Martin, IS, Sousa [mailto:MMartinZsola.com]
Sent: Thursday, June 21, 2001 12:51 PM
To: 'Sugg, Chris'; SAPLIST (E-mail)
Subject: RE: SQ01, SQ02 & SQ03
Hi Chris,
Unfortunately, SOLA started using ABAP Query (or 'Killme') before I started
working here. We have many queries that I am constantly trying to convert
to ABAP so that performance and selection limitations can be enforced on
selection criteria.
We have two activity groups that we assign for this access:
General Users (who run queries):
S_TCODE = SQ00 and SQ01
S_QUERY = Change
Key Users (who maintain user groups, etc.):
S_TCODE = SQ00, SQ01, SQ02
S_QUERY = Change, Maintain
...and for some reason...
S_DEVELOP =
Activity 03
Development Class for Change $*, T*, Y*, Z*
Object name *
Object type FUGR, PROG
Authorization group ABAP/4 pro *
Regards,
Mike D. Martin
SAP Basis Administrator
SOLA Optical, USA
707-763-9911 x6106
mmartinZsola.com
-----Original Message-----
From: Sugg, Chris [ mailto:aacsuggZnmhg.com <mailto:aacsuggZnmhg.com> ]
Sent: Thursday, June 21, 2001 8:42 AM
To: SAPLIST (E-mail)
Subject: RE: SQ01, SQ02 & SQ03
I have a request for granting transactions SQ01, SQ02 & SQ03 to a user.
Looking at these, it looks like they are used for creating queries in SAP.
I have numerous issues with allowing an enduser access to these codes.
Resource usage with large tables.
Security issues with tables.
Adding/removing users from query user groups.
Being able to monitor user usage of queries ran/created/deleted from
an enduser.
I strongly feel that no user except for BASIS should have access to these
tcodes. Does anyone allow these codes to be used on your system today? If
so, could you expalin/diagram your security set up with each transaction?
Any help would be great.
Thanks in advance,
Chris Sugg
SAP Basis Administrator
NACCO Materials Handling Group
1400 Sullivan Drive
Greenville, NC 27834-2011
AACSUGGZNMHG.COM
Phone: (252) 695-1912
Fax #: (252) 931-0934
[Non-text portions of this message have been removed]
To unsubscribe from this group, send an email to:
SAP on System i-unsubscribeZegroups.com
Your use of consolut is subject to http://www.consolut.net
Durban Tours - Südafrika Safari
BAL Application Log Documentation PERFORM Short Reference
This documentation is copyright by SAP AG.
Length: 5887 Date: 20240602 Time: 014819 sap01-206 ( 3 ms )