SAP Basis useful tables
|
Tables
|
Purpose
|
|
User Administration
|
|
|
USR01
|
User Master Table:Contains in formation we provide in SU01
|
|
USR02
|
Logon Data, Lock status, password in encrypted format
|
|
USR03
|
User Address data as we see is SU01
|
|
USR04
|
Profiles assigned to user
|
|
USR05
|
Parametes as signed to users;These values you can see in parameters tab in su01
|
|
USRSTAMP
|
Lastmodificationtimetouser.Eg.profileassignment,passwordchangeetc.
|
|
|
|
|
SAPSecurity
|
|
|
AGR1251
|
Authorizationdatafortheactivitygroup
|
|
AGR1252
|
Organizationalelementsforauthorizations(thistablegivesonlyorganizationaldata)
|
|
AGR_DEFINE
|
Roledefinition
|
|
AGR_USERS
|
Roleseassignedtousers
|
|
AGR_AGRS
|
RolesinCompositeRoles
|
|
TOBJ
|
AuthorizationObjects
|
|
TDDAT
|
MaintenanceAreasforTables
|
|
TSTC
|
SAPTransactionCodes
|
|
TPGP
|
ABAP/4AuthorizationGroups
|
|
USOBT
|
Relationtransaction>authorizationobject
|
|
USOBX
|
ChecktablefortableUSOBT
|
|
USOBT_C
|
RelationTransaction>Auth.Object(Customer)
|
|
USOBX_C
|
CheckTableforTableUSOBT_C
|
|
|
|
|
|
|
|
Transport Management
System
|
|
|
E070
|
Give Request number, status, target client and Desrcription
|
|
E071
|
Request ID and Object Name
|
|
|
|
|
|
|
|
Client Administration
|
|
|
T000
|
Logical System description. Gives details from TCode SCC4.
|
|
|
|
|
Spool Administration
|
|
|
TST01
|
TemSe: List of objects and parts
|
|
TST02
|
TemSe: Protection rules
|
|
TST03
|
TemSe data
|
|
|
|
|
System Component Version
|
|
|
UVERS
|
Deployed component version
|
|
CVERS
|
Detailed deployed component version
|
|
SVERS
|
Kernel Release Number
|
|
|
|
|
Other Useful Tables
|
|
|
SMEN_BUFFC
|
To know end users favorite list of transaction codes
|
|
EDID4
|
Idoc main data
|
|
EDIDC
|
Total Idoc number
|
|
EDIQI
|
Idoc related data
|
|
T001
|
TocheckCompanycode
|
|
T001W
|
Plant Codes
|
No comments:
Post a Comment