Some useful Tables in sap for Basis

9 Basic data / administration

9.1 Workbench related tables

9.1.1 Data dictionary tables

DD02L Tables in SAP

DD02T Tables description

DD03L Field names in SAP

DD03T Field description in SAP

9.1.2 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

9.2 Administration

9.2.1 User administration

USR01 User master

USR02 Logon data

USR03 User address data

USR04 User master authorizations

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

9.2.2 Batch input queue

APQD DATA DEFINITION Queue

APQI Queue info definition

9.2.3 Job processing

TBTCO Job status overview table

TBTCP Batch job step overview

TABLES IN SAP

SAP_Tabs Page 14 of 17 18/06/2007

Collect & Edit:Shmulik Adar

SAP\Logistic Senior Consultant

9.2.4 Spool

TSP02 Spool: Print requests

9.2.5 Runtime errors

SNAP Runtime errors

9.2.6 Message control

TNAPR Processing programs for output

NAST Message status

NACH Printer determination

9.2.7 EDI

EDIDC Control record

EDIDD Data record

EDID2 Data record 3.0 Version

EDIDS EDI status record

EDPAR Convert External < > Internal Partner Number

EDPVW EDI partner types

EDPI1 EDI partner profile inbound

EDPO1/2/3 EDI partner profile outbound

9.2.8 Change documents

CDHDR Change document header

CDPOS Change document position

JCDS Change Documents for System/User Statuses (Table JEST)

9.2.9 Reporting tree table

SERPTREE Reporting: tree structure

9.2.10 LIS structure/control tables

TMC4 Global Control Elements: LIS Info Structure HR

9.3 Settings

T582A Infotypes: Customer-Specific Settings

9.4 Master data

T527X Organizational Units

T528T Position Texts

T554T Attendance and Absence Texts

T501 Employee group

T503 Employee group, subgroup

T503K Employee subgroup

T510N Pay Scales for Annual Salaries (NA)

T549A Payroll Accounting Areas

T750X Vacancy

9.5 Infotypes

PA0001 Org. Assignment

PA0002 Personal Data

PA0006 Addresses

PA0007 Planned Working Time

PA0016 Contract elements

PA0008 Basic pay

PA0105 Communications

PA1007 Vacancies

PA1035 Training