12 September, 2013

TABLES IN SAP BASIS

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
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
E070                             Transport request
E071                             Transport request/Object key
Administration
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
EDPVW                        EDI partner types
EDPI1                           EDI partner profile inbound
EDPO1/2/3                   EDI partner profile outbound
Change documents
CDHDR                                    Change document header
CDPOS                                    Change document positionen
JCDS                           Change Documents for System/User Statuses (Table JEST)
Reporting tree table
SERPTREE                   Reporting: tree structure
SREPOVARI                 Reporting: tree/program
LIS structure/control tables
TMC4                            Global Control Elements: LIS Info Structure

REPORTS IN SAP BAISIS

Reports in SAP
Reports in sap is a executable program which read data from database and provide output based on selection criteria of reports.
Run Reports in SAP
SE38 -- >Enter reports name in report/program field. -- > execute
It will execute in dialog mode if we want in background we can navigate to program -- > execute in background
Some standard reports
SUSR406    Regenerate SAP_ALL profile or su21
AGR_REGENERATE _SAP_ALL  it will generate SAP_ALL in all client if we going to run in 000 client
TH_POPUP    Message to particular user
RSSNAPDL    Delete ABAP Dumps
RSBPSTDE    Delete old job statistics
RSBTCDEL    Delete old background jobs
RSCOLL00    Performance Collector
RSTRFCER    Delete EXEC LUWs
RSPO1041    Delete old Spool Files
RSARFCDL    Cleans up log file for sm58 transfers
RSPO1041    Delete old Spool Files
RDDNEWPP   Schedule DDIC Jobs
RSBDCREO    Delete Old Batch input Files
RSBTCPRIDEL    Reorganization of Print Parameters for Background Jobs
RSPO1043    Spool Data-Consistency check in Background (SP12)
SAPconnect  Start Send Process Fax/Email
RSTBPDEL    Delete Entries in DBTABLOG
RSTRFCES    Deletes tRFC and qRFC entries
RSTS0024    Delete job log headers from TST01 that are older than jobs
SBAL_DELETE    Deletes application logs
RBDCPCLR    Deletes Obsolete change pointers
RSARFCEX    Retries entries in sm58 that may have failed due to temp conn errors
RSN3_STAT_COLLECTOR- Non R/3 Stat collector
RSAL_BATCH_TOOL_DISPATCHING - Job for monitoring
RSN3_AGGR_REORG    Program for Starting the Reorganization Function