Kontakt

Ansicht
Dokumentation

02421 - SQ01, SQ02 & SQ03

02421 - SQ01, SQ02 & SQ03

RFUMSV00 - Advance Return for Tax on Sales/Purchases   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by SAP AG.
SAP E-Book

SQ01, SQ02 & SQ03

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]


 Durban Tours - Südafrika Safari

CPI1466 during Backup   ABAP Short Reference  
This documentation is copyright by SAP AG.

Length: 5116 Date: 20240520 Time: 191134     sap01-206 ( 3 ms )