Important Tables With Description
User Administration Related Tables
USR01 User master
USR02 Logon data
USR03 User address data
USR04 User master authorizations
USR05 Parametes assigned to users; These values you can see in parameters tab in su01
USRSTAMP Last modification time to user. Eg. profile assignment, password change etc.
USR11 User Master Texts for Profiles (USR10)
UST12 User master: Authorizations
USR12 User master authorization values
USR13 Short Texts for Authorizations
USR40 Prohibited passwords
TOBJ Objects
TOBC Authorization Object Classes
TPRPROF Profile Name for Activity Group
DEVACCESS Table for development user
UST04 User profiles (multiple rows per user)
USR10 Authorisation profiles (i.e. &_SAP_ALL)
UST10C Composite profiles (i.e. profile has sub profile)
USR11 Text for authorisation profiles
USR40 Table for illegal passwords
USGRP User groups
USGRPT Text table for USGRP
USH02 Change history for logon data
USER_ADDR Address Data for users
SAP Security
AGR1251 Authorization data for the activity group
AGR1252 Organizational elements for authorizations ( this table gives only organizational data)
AGR_DEFINE Role definition
AGR_USERS Rolese assigned to users
AGR_AGRS Roles in Composite Roles
TOBJ Authorization Objects
TDDAT Maintenance Areas for Tables
TSTC SAP Transaction Codes
TPGP ABAP/4 Authorization Groups
USOBT Relation transaction > authorization object
USOBX Check table for table USOBT
USOBT_C Relation Transaction > Auth. Object (Customer)
USOBX_C Check Table for Table USOBT_C
Transport Management System
E070 Give Request number, status, target client and Desrcription
E071 Request ID and Object Name
E070A Idenity TR based as per sap note
E070USE Use of Current requests by Users
E070DEP Dependencies of requests
E070CREATE Change & transport System & creation date
E070TC Client-Specific Imports
v_e071 Generated Table for View. Addresses
E070 Stores transport headers
E071 The names of the objects of a transport request is stored in table.
E070C stores information for client specific tarnsports
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
Change documents
CDHDR Change Document Header
CDPOS Change document positioned
JCDS Change Documents for System/User Statuses (Table JEST)
Reporting tree table
SERPTREE Reporting: tree structure LIS structure/control tables
TMC4 Global Control Elements: LIS Info Structure
Data dictionary tables
DD02L Tables in SAP
DD02T Tables description
DD03L Field names in SAP
DD03T Field description in SAP
Workbench
TADIR Directory of R/3 Repository Objects
TRDIR System table TRDIR
TFDIR Function Module
TLIBG Person responsible for function class
TLIBT Function Group Short Texts
TFTIT Function Module Short Text
TSTC Transaction codes in SAP
TSTCT Transaction Codes Texts
T100 Message text (vb e000)
VARID Variant data
D020T Screen texts
TDEVC Development class
TDEVCT Texts for development classes
Batch input queue
APQD Data Definition Queue
APQI Queue Info Definition
Job Processing
TBTCO Job status overview table
TBTCP Batch job step overview
A – Cancelled
F – Completed
P – Scheduled
R – Active
S – Released
Spool
TSP02 Spool: Print requests
Runtime errors
SNAP Runtime errors
Message control
TNAPR Processing Programs for Output
NAST Message status
NACH Printer determination
Change documents
CDHDR Change Document Header
CDPOS Change document positioned
JCDS Change Documents for System/User Statuses (Table JEST)
Reporting tree table
SERPTREE Reporting: tree structure
No comments:
Post a Comment