Important Basis Tables

No comments

User Administration Related Tables 


User Administration
USR01User master
USR02Logon data
USR03User 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
APQDData Definition Queue
APQIQueue Info Definition
Job Processing
TBTCOJob status overview table
TBTCPBatch job step overview
Spool
TSP02Spool: Print requests
Runtime errors
SNAPRuntime errors
Message control
TNAPRProcessing Programs for Output
NASTMessage status
NACHPrinter determination
EDI
EDIDCControl Record
EDIDDData record
EDID2Data record 3.0 Version
EDIDSEDI status record
EDPARConvert External < > Internal Partner Number
EDPVWEDI partner types
EDPI1EDI partner profile inbound
EDPO1/2/3EDI partner profile outbound
Change documents
CDHDRChange Document Header
CDPOSChange document positioned
JCDSChange Documents for System/User Statuses (Table JEST)
Reporting tree table
SERPTREEReporting: tree structure
LIS structure/control tables
TMC4Global Control Elements: LIS Info Structure


Workbench Related Tables 

Data dictionary tables
DD02LTables in SAP
DD02TTables description
DD03LField names in SAP
DD03TField description in SAP
Workbench
TADIRDirectory of R/3 Repository Objects
TRDIRSystem table TRDIR
TFDIRFunction Module
TLIBGPerson responsible for function class
TLIBTFunction Group Short Texts
TFTITFunction Module Short Text
TSTCTransaction codes in SAP
TSTCTTransaction Codes Texts
T100Message text (vb e000)
VARIDVariant data
D020TScreen texts
TDEVCDevelopment class
TDEVCTTexts for development classes


No comments :

Post a Comment