Tuesday, 11 June 2013

Important Basis Tables

User Administration Related Tables

User Administration
USR01User master
USR02Logon data
USR03 User address data
USR04User master authorizations
USR11User Master Texts for Profiles (USR10)
UST12User master: Authorizations
USR12User master authorization values
USR13Short Texts for Authorizations
USR40Prohibited passwords
TOBJObjects
TOBCAuthorization Object Classes
TPRPROFProfile Name for Activity Group
DEVACCESSTable for development user
UST04User profiles (multiple rows per user)
USR10Authorisation profiles (i.e. &_SAP_ALL)
UST10CComposite profiles (i.e. profile has sub profile)
USR11Text for authorisation profiles
USR40Table for illegal passwords
USGRPUser groups
USGRPTText table for USGRP
USH02Change history for logon data
USER_ADDRAddress Data for users
USOBTRelation transaction to authorization object (SAP)
USOBT_CRelation Transaction to Auth. Object (Customer)
USOBXCheck table for table USOBT
USOBXFLAGSTemporary table for storing USOBX/T* change
USOBX_CCheck Table for Table USOBT_C
AGR_1016Name of the activity group profile
AGR_1016BName of the activity group profile
AGR_1250Authorization data for the activity group
AGR_1251Authorization data for the activity group
AGR_1252Organizational elements for authorizations
AGR_AGRSRoles in Composite Roles
AGR_DEFINERole definition
AGR_AGRSSingle roles that attach to a composite role
AGR_HIER2Menu structure information - Customer vers
AGR_HIERTRole menu texts
AGR_OBJAssignment of Menu Nodes to Role
AGR_PROFProfile name for role
AGR_TCDTXTAssignment of roles to Tcodes
AGR_TEXTSFile Structure for Hierarchical Menu - Cus
AGR_TIMETime Stamp for Role: Including profile
AGR_USERSAssignment of roles to users
Batch input queue
APQD Data Definition Queue
APQI Queue Info Definition
Job Processing
TBTCO Job status overview table
TBTCP Batch job step overview
Spool
TSP02 Spool: Print requests
Runtime errors
SNAP Runtime errors
Message control
TNAPR Processing Programs for Output
NAST Message status
NACH Printer determination
EDI
EDIDC Control Record
EDIDD Data record
EDID2 Data record 3.0 Version
EDIDS EDI status record
EDPAR Convert External < > Internal Partner Number
EDPVWEDI partner types
EDPI1 EDI partner profile inbound
EDPO1/2/3EDI partner profile outbound
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


Workbench Related Tables


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

No comments:

Post a comment