SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

126 columns | Print definition?ERP 6.0  | SERVER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GEOE/CONFIG_17Picture Marker Path5SERVERGeoServiceServernvarchar400
2/XFT/APPLLAYHTTPApplication layer: HTTP destination5SERVERServernvarchar2550
3ABDBG_TRACEDebugger Tracing7SERVERApplication Server Instancenvarchar400
4BANK_WL_SRVRELWAAssignment of Servers to Areas of Work Packages3SERVERApplication Server Namenvarchar400
5CNVCMISBACKUP_EXBackup Functionality - Runtime Information7SERVERServer namenvarchar200
6CNVMBTDESTSPECSpecial settings for a execution target Destination5SERVERName of target hostnvarchar1000
7CNVMBTDESTVERSMBT: RFC destination versions and settings10SERVERName of target hostnvarchar1000
8CNVMBTJOBSCMBT PCL: Batch-related information6SERVERTarget System to Run Background Jobnvarchar320
9CNVMBTJOBSCTMBT PCL: Batch-related technical control7SERVERTarget System to Run Background Jobnvarchar320
10CNVMBTVERS_CTRLMBT: RFC destination versions and settings10SERVERName of target hostnvarchar1000
11RSMONREQDELREDUMonitoring of Reduce/Delete Runs for critical DTAs14SERVERApplication Server Instancenvarchar400
12SITSTRACEMETAGeneral Memory Trace Information5SERVERApplication Servernvarchar320
13SITSTRACERUNITS: Memory Trace3SERVERApplication Servernvarchar320
14T164CSAPcomm: Destination server assignment1SERVERSAPcomm: Server namenvarchar120
15TASK_DAEMON_LOGLogging data for RAL Daemon4SERVERApplication Server Instancenvarchar400
16TATRADT_SQLTRACESQL Trace/ABAP Trace1SERVERApplication Server Instancenvarchar400
17TATRAPI_FILES2Trace Files1SERVERApplication Server Instancenvarchar400
18TCPCHECKTesttabelle Konvertierungen8SERVERApplication-Server-Instanznvarchar400
19ZKWHLPAssignment of User-Id to Enh.Contexts for R/3 Links Demos4SERVERSIWR: Server Online-Hilfenvarchar1000
20ZTDCLOGON_INFOTable for logon text2SERVERApplication Servernvarchar320
21ZZCOPYTESTInfo Systemkopie2SERVERApplikationsservernvarchar320
TOPABAP XML Processing
22TIXBCHTSEiXML BC Registration Table for HTTP Servers6SERVERHandler class name for iXML BC http server registrationnvarchar320
TOPArchive Development Kit
23ARCH_SERVData Archiving Server Selection (Obsolete from Release 6.10)2SERVERApplication Server Instancenvarchar400
TOPAssortment List
24WBB_SAVE4Packet Number for Cancelled Packets (Assortment List)4SERVERLogical Destination (Specified in Function Call)nvarchar320
TOPAuthentication and SSO
25USR41User master: Additional data4SERVERServernvarchar400
TOPBatch-Oriented Parallel Processing of Mass Data
26BANK_PACK_SRVRELAssignment of Servers to Areas of Work Packages3SERVERServer namenvarchar200
27BANK_WL_SRVRELAssignment of Servers to Areas of Work Packages3SERVERApplication Server Namenvarchar400
28BANK_WORKL_CNTNumber of Objects in Parallel Processing3SERVERApplication Server Namenvarchar400
TOPBusiness Application Support
29CNVPERFANALYSEResults of performance analysis3SERVERServer namenvarchar200
30CNVSTATEConversion: Status of programs12SERVERServer namenvarchar200
TOPBusiness Navigator
31DF63SBusiness Browser Web Server1SERVERServer namenvarchar640
TOPClient Copy
32CCCFLOWClient Copy Control Flow34SERVERLogon/Server Group Namenvarchar200
TOPCommunication Services Mail, Fax, SMS, Telephony
33SPH_EXTNSNSAPphone: Extensions per Work Center4SERVERName of SAPconnect Node or Telephony Servernvarchar60
34SPH_PCTONOSAPphone: Work center settings4SERVERName of SAPconnect Node or Telephony Servernvarchar60
35SPH_SERVERSAPphone: Telephony server settings2SERVERName of SAPconnect Node or Telephony Servernvarchar60
36SPH_SERVTSAPphone: Telephony server - Text table for SPH_SERVER3SERVERName of SAPconnect Node or Telephony Servernvarchar60
37SPH_STESRVSAPphone: Server in Sites3SERVERName of SAPconnect Node or Telephony Servernvarchar60
38SPH_TERMNLSAPphone: Work center settings4SERVERName of SAPconnect Node or Telephony Servernvarchar60
39SRSERVERSAP Rule-Based Routing Servers2SERVERSAP Rule-Based Routing Server IDnvarchar320
40SRSRVAPPBCOM Routing: Server for each Application3SERVERSAP Rule-Based Routing Server IDnvarchar320
41SRSRVCHNLRouting Server: Channels (Phone Calls, E-Mails, Fax, ...)2SERVERSAP Rule-Based Routing Server IDnvarchar320
TOPCross-Application Components
42SWKHANDTURI of Workflow Launch Handler for external HTTP Services5SERVERServernvarchar2550
TOPData Staging
43RSBATCHCTRLBW Batch Management - Control Table6SERVERApplication Server Instancenvarchar400
44RSBATCHCTRL_PARBW Batch Management - Control Table6SERVERApplication Server Instancenvarchar400
45RSBATCHDEBUGWAITWaiting Processes for Batch Manager to Be Caught8SERVERApplication Server Instancenvarchar400
46RSBATCHHEADERBW Batch Management - Header Table for the Start Process4SERVERApplication Server Instancenvarchar400
47RSICSDELSTATCTRLControl Table for RSICSDELSTAT for Selective Deletion6SERVERApplication Server Instancenvarchar400
48RSPCCHAINATTRAttributes for a Process Chain10SERVERApplication Server Instancenvarchar400
49RSREQDPTIDNote TID for Request and Data Package12SERVERApplication Server Instancenvarchar400
50RSSEARCHLOGSLock Table for Parallel Dev Trace Searching3SERVERApplication Server Instancenvarchar400
TOPDatabase Interface, Database Platforms
51DBA_DBH_SRV_DBSLDBA-DBH: Application Servers and installed DBSL1SERVERDBA Cockpit: Server Namenvarchar2550
TOPDocument Management Services
52SDOKSTRESDOK: Physical storage locations (Storage Repository)11SERVERFile servernvarchar1000
TOPeCATT Extended Computer Aided Test Tool
53ECLOG_CALLHierarchical Caller Information for Log8SERVERCaller Hostnvarchar640
TOPEmployee Self-Service
54T7XSSSERRESResource Object Definition3SERVERServer Keynvarchar400
55T7XSSSERRESCXSS: Resource object definition customer3SERVERServer Keynvarchar400
56T7XSSSERSDBXSS: Server definition2SERVERServer Keynvarchar400
TOPeXternal Management Interface Framework
57BAPIXMLOGRBAPI XMI: Logon information on actions of external mgt tools11SERVERXMI logging: Name of server, on which XMI action was exectdnvarchar200
58TXMILOGLog Information on Actions of External Management Tools13SERVERXMI logging: Name of server, on which XMI action was exectdnvarchar200
59TXMILOGRAWLog Information on Actions of External Management Tools11SERVERXMI logging: Name of server, on which XMI action was exectdnvarchar200
TOPF1 Help
60IWR_31_PRMIWR: System Parameters (Only for Cust. Solution for 3.1)2SERVERName of target hostnvarchar1000
61SHLPADM1Administration: Display of the SAP Library5SERVERSIWR: Server Online Helpnvarchar1000
62SHLPADM2TText Table for Administration Online Help5SERVERSIWR: Server Online Helpnvarchar1000
63SHLPUSRVALUser Settings for SAP Library (Display)5SERVERSIWR: Server Online Helpnvarchar1000
TOPI18N Unicode
64UMGXMLFILESSUMG: R3load log names7SERVERApplication Servernvarchar320
TOPInterestCharge Calculation
65BKKMWORKLCNTNumber of Objects in Parallel Processing3SERVERApplication Server Instancenvarchar400
TOPInternet Communication Framework
66ICFATTRIBDescription of ICF Attributes (Trace/Debugging)5SERVERLogical Destination (Specified in Function Call)nvarchar320
TOPKnowledge Warehouse
67IWEXDESTKEn: Html Export Destinations2SERVERHTML Export Servernvarchar640
TOPLocal Currency Changeover
68EWUARREMU Tables: Conversion Sequence and Server Assignment5SERVERHost Namenvarchar200
TOPMigration
69TEMFIRMAIS-U mig.: company5SERVERRemote server of migration path dialognvarchar400
70TEMJOBIS-U Migration: Definition of Import Job13SERVERServer namenvarchar200
71TEMRUNDISTMass import: Data for distributing the run3SERVERApplication Server Instancenvarchar400
72TEMSCHEDIS-U Migration: Import Runs9SERVERRemote server of migration pathnvarchar400
73TEMUSIS-U Mig.: Managmnt11SERVERRemote server of migration path dialognvarchar400
TOPOperating System Monitors
74OSMONOperating system monitoring data1SERVERServer namenvarchar80
TOPPackage Tools
75AKB_DLVUNITSObsolete: Generated Table for AKB_PRODUCTS5SERVERObsolete: Software Product IDnvarchar200
76AKB_LOGBOOKObsolete: BCB Logbook5SERVERObsolete: Software Product IDnvarchar200
77AKB_PRODUCTSProduct Catalog1SERVERObsolete: Software Product IDnvarchar200
78AKB_PRODUCT_CHKObsolete: Assignment Check Projects to Products1SERVERObsolete: Software Product IDnvarchar200
79AKB_PRODUCT_INTFObsolete: Product Catalog1SERVERObsolete: Software Product IDnvarchar200
80AKB_RUNLISTObsolete: Information for Decoupling Administration3SERVERObsolete: Software Product IDnvarchar200
81AKB_SYSLISTObsolete: BCB System List for Replication3SERVERObsolete: Software Product IDnvarchar200
TOPPerformance Monitors TCC
82GVD_SESSIONOracle monitoring: Snapshot table for GV$SESSION15SERVEROracle monitoring: SERVER: Server typenvarchar90
83TRS35Control Table RSSTAT35 Collector Run1SERVERServer namenvarchar80
TOPPrint and Output Management
84TSPSVSpool: Server table1SERVERServer Namenvarchar200
85TSPSVISpool: Server Information (Updated by Spool Work Processes)1SERVERServer Namenvarchar200
TOPRuntime Analysis
86SATR_DIRECTORYDirectory of SAT Trace Containers31SERVERApplication Server Instancenvarchar400
TOPSAP Business Workflow
87SWFWSHANDTHandler Customizing for Web Service Execution in Workflow4SERVERHandler Servernvarchar2550
88SWLWPHANDTURLs for Workflow Launch and Callback Handler (Ext. Service)6SERVERServer Namesnvarchar2550
89SWLWPSWorkflow: External Services4SERVERServer Namesnvarchar2550
TOPSAP System Log
90TSLE4Instances operating systems1SERVERSysLog: Instance name (System & Computer & Number)nvarchar200
TOPService Data Download
91/BDL/SAPOSSinformation table for OSS-User12SERVERName of target hostnvarchar1000
92/SDF/INDXINDX table5SERVERApplication Server Instancenvarchar400
93/SDF/MON_HEADERMonitoring Data4SERVERApplication Server Instancenvarchar400
94TCUSHISTData transfer history4SERVERApplication Servernvarchar320
TOPSyntax, Compiler, Runtime
95AAB_ID_ACTActivatable IDs for Breakpoints and Assertions: Activation4SERVERApplication Server Instancenvarchar400
96ABDBG_LISTENERWaiting Listener Processes for Breakpoint Notification4SERVERApplication Server Instancenvarchar400
97RTMTESTSTable of RTM Tests on the Different Servers1SERVERApplication Server Instancenvarchar400
98SHMM_TRC_GLOBALShared Memory Monitor Trace: Global Control1SERVERApplication Server Instancenvarchar400
99SRTM_ACTTable of RTM Tests on the Different Servers1SERVERApplication Server Instancenvarchar400
100TPDAPI_TESTTest von Listener / Attach4SERVERApplikationsservernvarchar320
TOPSystem Landscape DirectoryComponent Repository
101LCRT_STATUSAI-LCR: Status Table of Change Actions6SERVERApplication Server Instancenvarchar400
TOPTelephone Connection
102SPH_PDGUIDSAPphone: Planned Call GUID and Server for Get Dialer3SERVERName of SAPconnect Node or Telephony Servernvarchar60
TOPTransaction Tax Engine
103TTED_OUTDOC_COMOutput Document12SERVERIPC-Servernvarchar320
104TTEPD3_DOCUMENT3.0 TTE Persistency Document19SERVERIPC-Servernvarchar320
105TTEPDT_DOCUMENTTTE Persistency Document19SERVERIPC-Servernvarchar320
106TTESDT_DOCUMENTTTE Simulaton Document17SERVERIPC-Servernvarchar320
TOPTranslation Tools
107LXE_LANGTranslation Environment: Target Languages and Attributes 15SERVERApplication Server Instancenvarchar400
108TRNL_LANGTranslation Environment: Target Languages and Attributes 16SERVERServer Namenvarchar200
TOPTransport Management System
109LISCOMDESLIS: Destination Table17SERVERName of target hostnvarchar1000
110TMSSRVTMS SRV: Description of General Server Systems1SERVERTMS: System Namenvarchar100
111TMSSRVTTMS SRV: Texts for TMSSRV1SERVERTMS: System Namenvarchar100
TOPTransport Organizer
112WBOSYSCUSTTransport Organizer: Central Settings5SERVERServer namenvarchar200
TOPUse Subcomponents
113EMSERVERAssignment of External Mail Server to User3SERVERChar255nvarchar2550
114SOFRSAPoffice: Distribution List Table for Incoming Faxes3SERVERSAPoffice: Server IDnvarchar100
TOPUser and Authorization Management
115TUCNTRAWCounters for Application Objects for each Work Process5SERVERApplication Server in Format rdisp/mynamenvarchar640
TOPWeb Survey
116TUWS_LDAPKEYAssignment LDAP Server <-> Technical Key and Variant3SERVERSymbolic name of LDAP servernvarchar160
TOPWithout Description
117RSENQSM21PROTLog Table for Enqueue Traces18SERVERApplication Servernvarchar320
TOPWorkbench Tools Editors, Painters, Modelers
118COVDATCOLLast Data Collection: Control Table1SERVERApplication Server Instancenvarchar400
119COVDATVOLCoverage Analyzer: Data Volume Monitor3SERVERApplication Server Instancenvarchar400
120COVMODStatus of Coverage Analyzer1SERVERApplication Server Instancenvarchar400
121COVRES0Temporary Storage for Coverage Results2SERVERApplication Server Instancenvarchar400
122COVRES0_SYNCSynchronization Records for Merging of COVRES0 to COVRES3SERVERApplication Servernvarchar320
123COVRES0_SYNCHSynchronization Records for Merging of COVRES0 to COVRES4SERVERApplication Servernvarchar320
124COVRFCERRNumber of RFC Errors While Accessing Server1SERVERApplication Server Instancenvarchar400
125COV_SHM_FLUSHShared Memory Flush: Coverage Logs by Server1SERVERApplication Server Instancenvarchar400
126SCOVSRVERRSCOV: Server for which init. of registration failed1SERVERApplication Server Instancenvarchar400