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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

159 columns | Print definition?ERP 6.0  | HOST

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GEOE/CONFIG_25Security tokens3HOSTApplication Servernvarchar320
2/MRSS/D_PPM_MEMMRS Memory Measurement4HOSTApplication Servernvarchar320
3/MRSS/D_PPM_RUNTMRS delay measurements7HOSTApplication Servernvarchar320
4/SAPSRM/CAT_FTPFTP Server Information for Contract-to-Catalog Upload2HOSTFTP Host Namenvarchar150
5CNVCMIS_A_1_FUNCFunc type Repository Analysis13HOSTFunction Module Hostnvarchar80
6IUUC_SCHEMA_CONDatabase connection per schema2HOSTApplication Servernvarchar320
7RFCTSTTABTable of RFC Test Destinations3HOSTHostname of one RFC test destinationnvarchar200
8RSMONREQDELREDUMonitoring of Reduce/Delete Runs for critical DTAs15HOSTName of the Host Servernvarchar320
9RSVEPRUNSPerformance-Messungen: Meßlauf-Informationen9HOSTApplikationsservernvarchar320
10SMOI_WS_RFCLOGONConnection details for RFC-Logon to and from remote systems2HOSTHost Name (or IP Address or FQDN)nvarchar2550
11SSF_PSE_HISTPSE History3HOSTApplication Servernvarchar320
12SSF_PSE_LConfiguration Table for PSE File Mode1HOSTApplication Servernvarchar320
13SWF_UNIT_MONWorkflow: Unit Monitoring10HOSTApplication Servernvarchar320
14SXMS_QERRORQueue Error6HOSTApplication Servernvarchar320
15SXMS_QERROR_SQueue Error Alert7HOSTApplication Servernvarchar320
16WBBGRFCTMPLog for Where Used Index Update in Backgound Tasks3HOSTApplication Servernvarchar320
17ZELFGLOBPARMOperational program parameters to control Elf bus case data2HOSTHost name for table TALIMnvarchar200
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
18CRMCHKENVEExtended Environment Information2HOSTApplication Servernvarchar320
19CRMCHKENVLExtended Environment Information on Test Machine (Not RefBD)2HOSTApplication Servernvarchar320
20CRMEXPVERSRefDB: Export Information for Delivery System4HOSTApplication Servernvarchar320
21CRM_TCKDBSYSTCK Checkman for Solutions: Database Systems3HOSTHostnvarchar320
22CRM_TCKHOSTSTCK Checkman for Solutions: Hosts2HOSTHostnvarchar320
23CRM_TCKINSTANCESTCK Checkman for Solutions: Instances4HOSTHostnvarchar320
24SATC_AC_ASPERR_BOBSOLETE10HOSTnvarchar320
25SATC_AC_ASPERR_SOBSOLETE12HOSTnvarchar320
26SATC_AC_PLNERR_BTransaction data: 'Failure Set' data > 510 bytes9HOSTHost where execution was carried outnvarchar320
27SATC_AC_PLNERR_STransaction data: 'Failure Set' data <= 510 bytes11HOSTHost where execution was carried outnvarchar320
28SATC_AC_RESULTPTransaction data: 'Display Load' plugin failures13HOSTHost where execution was carried outnvarchar320
29SATC_AC_RESULTVTTransaction data: 'Display Load' findings17HOSTHost where execution was carried outnvarchar320
30SATC_AC_RSLT_AEOBSOLETE: 'Display Load' aspect failure (plug-in error)12HOSTnvarchar320
31SATC_AC_RSLT_VTOBSOLETE: 'Display Load' aspect findings (verdicts)16HOSTnvarchar320
32SATC_AC_VERDCT_BTransaction data: 'Finding (Verdict) Set' data > 510 bytes17HOSTHost where execution was carried outnvarchar320
33SATC_AC_VERDCT_STransaction data: 'Finding (Verdict) Set' data <= 510 bytes21HOSTHost where execution was carried outnvarchar320
34SATC_AC_VRDCT_BOBSOLETE: 'Finding Set' data > 510 bytes; aspect format13HOSTnvarchar320
35SATC_AC_VRDCT_SOBSOLETE: 'Finding Set' data > 510 bytes; aspect format17HOSTnvarchar320
TOPABAP Unit
36TAUNIT_SRV_SETUPINTERNAL: Customizing of machine1HOSTApplication Servernvarchar320
TOPATC extensions for Technical Check
37SATCCHKENVEExtended Environment Information2HOSTApplication Servernvarchar320
38SATCEXPVERSRefDB: Export Information for Delivery System4HOSTApplication Servernvarchar320
39SATC_AC_RESULTVRMovement data: 'Display Load' module verdicts17HOSTHost where execution was carried outnvarchar320
40SATC_ENVEExtended Environment Information2HOSTApplication Servernvarchar320
41SATC_ENVLExtended Environment Information (local)2HOSTApplication Servernvarchar320
TOPBatch-Oriented Parallel Processing of Mass Data
42TBANK_PP_HOSTServer Used for Parallel Processing3HOSTServer namenvarchar200
TOPBRFplus - ABAP-Based Business Rules
43FDT_JOB_0000FDT: Job Header Table8HOSTApplication Servernvarchar320
TOPBusiness Planning and Simulation
44UPX_EXEC_GWHOSTValuate GWHost Default2HOSTchar120nvarchar1200
TOPBusiness Server Pages
45BSPHOSTMapping Table for Host Names and Ports in BSP4HOSTnvarchar1280
46TBSPJSDBGBusiness Server Pages (BSP) DB Table JavaScript Debugging2HOSTCHAR08 data element for SYSTnvarchar80
TOPCATT Computer Aided Test Tool
47CATKCATT: Log Process Data18HOSTApplication Servernvarchar320
TOPCCMS Database Monitors for Oracle
48SDBACDBA Action Table7HOSTName of the server where the DBA action is to be executednvarchar300
TOPChange Transport System
49TPALOGDB Buffer for ALOG File10HOSTApplication Servernvarchar320
50TPLOGLogging of tp Calls1HOSTApplication Servernvarchar320
51TRBAT2tp/R3trans Communication Table for Transport Control14HOSTSAPDBHOSTnvarchar320
TOPClientServer Technology
52HTTPURLLOCHTTP URL Location Exception Table6HOSTnvarchar2550
53HTTP_WHITELISTHTTP White List5HOSTnvarchar1280
54HTTP_WHITELIST_SHTTP White List5HOSTHost Name with Domain, e.g. *.myDomain.comnvarchar1280
TOPCollectionsDisbursements
55VVKKFSTControl Table for Posting Data Transfer Program4HOSTHost Namenvarchar200
TOPContent Management Service
56SCMSCACHECache Properties1HOSTHost Namenvarchar640
57SCMSCACHTKPRO CMS: Cache Descriptions2HOSTHost Namenvarchar640
58SCMSHOSTAttributes of Hosts1HOSTHost Namenvarchar640
59SCMSHOSTTKPRO CMS Descriptoin of Hosts2HOSTHost Namenvarchar640
60SCMS_SERCAMonitored Cache Servers1HOSTHost Namenvarchar640
61SCMS_SERCSMonitored Cache Servers1HOSTHost Namenvarchar640
62SCMS_SERPXMonitored Aliases1HOSTHost Name of Content Server Aliasnvarchar640
63SCMS_STACAStatus of Monitored Cache Servers1HOSTHost Namenvarchar640
64SCMS_STACSStatus of Monitored Content Servers1HOSTHost Namenvarchar640
65SCMS_STAPXStatus of Monitored Aliases1HOSTHost Name of Content Server Aliasnvarchar640
TOPContract Accounts Receivable and Payable
66DFKKEXCExternal Payment Information43HOSTApplication Servernvarchar320
67DFKKEXCJCash Journal: Data Store for Inbound Services35HOSTApplication Servernvarchar320
68DFKKEXC_SUMExternal Payment Information: Totals Records17HOSTApplication Servernvarchar320
69DFKKEXC_SUM_HISTCash Desk Closing History (DFKKEXC_SUM)18HOSTApplication Servernvarchar320
TOPCorporate Performance Monitor
70UMC_HTTP_PROXYHTTP Proxy Options for SEM-CPM2HOSTHTTP Proxy Hostnvarchar1000
TOPData Retention Tool
71TXW_DIRData file log (replaced by txw_dir2, use of guids)26HOSTApplication Servernvarchar320
72TXW_DIR2Data file log28HOSTApplication Servernvarchar320
73TXW_VWLOGView query log (replaced by txw_vwlog2: uuids)9HOSTApplication Servernvarchar320
74TXW_VWLOG2View query log10HOSTApplication Servernvarchar320
TOPData Staging
75RSBATCHCTRLBW Batch Management - Control Table7HOSTName of the Host Servernvarchar320
76RSBATCHCTRL_PARBW Batch Management - Control Table7HOSTName of the Host Servernvarchar320
77RSBATCHDEBUGWAITWaiting Processes for Batch Manager to Be Caught9HOSTName of the Host Servernvarchar320
78RSBATCHHEADERBW Batch Management - Header Table for the Start Process5HOSTName of the Host Servernvarchar320
79RSICSDELSTATCTRLControl Table for RSICSDELSTAT for Selective Deletion7HOSTName of the Host Servernvarchar320
80RSREQDPTIDNote TID for Request and Data Package8HOSTApplication Servernvarchar320
TOPDatabase Interface, Database Platforms
81SDBAC_DATADB13: DBA Action Table - Configuration Data Part5HOSTName of the server where the DBA action is to be executednvarchar300
TOPDirectory
82LDAPSERVERLDAP Server4HOSTHost name of LDAP servernvarchar2550
TOPeCATT Extended Computer Aided Test Tool
83TZRR_EVTCTestZone: Result Repository Event Test Case12HOSTHostnvarchar640
84TZRR_SUTTestZone Result Repository: System under Test Information4HOSTnvarchar320
TOPElectronic Data Interchange
85PRISBCPARAPRICAT: SBC Parameters for PRICAT Customers5HOSTPRICAT: Host SBC Servicenvarchar300
TOPFast Search Infrastructure
86SFSRFW_BATCH_RTReplication Framework - Background Processing Processes7HOSTApplication Servernvarchar320
87SFSRFW_BTC_RTReplication Framework - Batch Job Runtime8HOSTApplication Servernvarchar320
88SFSRFW_IDX_TASKSReplication Framework - Replication Tasks5HOSTApplication Servernvarchar320
TOPGeneral Ledger Accounting
89FAGL_BW_LOG_HEADFI-GL: Log for BW Extraction: Control Data9HOSTApplication Servernvarchar320
TOPGRC Access Control Plug-In
90/VIRSA/DBCONNECTHR Triggers - DB Connection7HOSTChar 20nvarchar200
TOPIntegration Engine
91SXMSBULKXML Message Broker: Bulk Statistics8HOSTApplication Servernvarchar320
92SXMSPMASTIntegration Engine: Message Queue (Master)45HOSTApplication Servernvarchar320
93SXMSPMAST2XML Message Broker: Message Queue (Master) (Switch Table)45HOSTApplication Servernvarchar320
94SXMSTRANS_MSGBody Table for Message Transfer6HOSTApplication Servernvarchar320
95SXMS_AS_STATUSStatus Table of Synchronous/Asynchronous Bridge10HOSTApplication Servernvarchar320
96SXMS_QMXML Message Broker: Queue Monitor3HOSTApplication Servernvarchar320
97SXMS_QM_SERVERXI: Server for Queue Monitoring3HOSTName of the Host Servernvarchar320
98SXMS_VIOL_LOGException Handling in EOIO Processing13HOSTApplication Servernvarchar320
TOPInterestCharge Calculation
99TBKKMHOSTServer Used for Parallel Processing3HOSTApplication Server Instancenvarchar400
TOPInternet Communication Framework
100PPROXY_CPlugin Proxy Configuration for HTTP/HTTPS Client (Host/Port)3HOSTProxy Hostnvarchar1200
TOPLegacy System Migration Workbench
101/SAPDMC/LSGUSDFILSMW Files Used2HOSTApplication Servernvarchar320
TOPliveCache Applications
102/SAPAPO/OM_HWHardware Description3HOSTHost Namenvarchar200
TOPLogistics Information System LIS
103MCEXLOGFile for saving logs8HOSTApplication Servernvarchar320
TOPManagement of Internal Controls
104FOPCWFNOTIFCFADetails for Notification System per Work Item5HOSTnvarchar2000
TOPMonitoring
105ALAVLPINGControl Table for CCMS RFC_PING - SALK_SYSTEM_AVAILABILITY12HOSTApplication Servernvarchar320
106ALAVLWORKCCMS: Dummy Table for Config. Table Controls6HOSTApplication Servernvarchar320
107CSMNIPINGCFGCCMS : Configuration Table for NI PING Availability2HOSTName of target host in IP or host notationnvarchar1000
108CSMSYSASCentral CCMS: List of SAP System Instances3HOSTApplication Servernvarchar320
109SCMLPSMOI_WS: Configuration of Logical Ports for SAPSTARTSRV8HOSTHost Name (or IP Address or FQDN)nvarchar2550
110SCSM_MONSYS_BUFBuffer Table ALSYSTEM8HOSTApplication Servernvarchar320
TOPOLAP Technology
111RSDDTZA_STATISTTREX Service Statistics2HOSTChar 20nvarchar200
112RSR_CACHEOLAP: Table Lock Arguments1HOSTApplication Servernvarchar320
113RSR_CACHE_DB_BLBW: Blob Table Cache2HOSTApplication Servernvarchar320
114RSR_CACHE_DB_IXBW: Cluster Table Cache3HOSTApplication Servernvarchar320
115RSR_CACHE_LOGOLAP Cache Table for Saving Log Entries5HOSTApplication Servernvarchar320
116RSR_CACHE_STATSOStatistics for Cache Entries for Shared Objects4HOSTApplication Servernvarchar320
117RSR_CACHE_ST_SHOStatistics for Cache Entries for Shared Objects4HOSTApplication Servernvarchar320
TOPPerformance Monitors TCC
118GST04SRVRSList of all R/3 instances with DB2HOSTHost Namenvarchar200
119GVD_SERVERLISTOracle Monitoring: Snapshot table for the R/3 serverlist3HOSTOracle Monitoring: ORA_MSHOST2nvarchar320
120SAPWLSERVSAP Workload: Table of active servers3HOSTHost Namenvarchar320
121TNETMONINFNetwork Monitor:Configuration data and work information1HOSTHost Namenvarchar200
122TUNE1Tune: Maximum Puffer Sizes/Directory Entries Reached2HOSTApplication Servernvarchar320
TOPPlanning
123RSPLS_LOCK_METHSActive Lock Methods2HOSTName of the Host Servernvarchar320
TOPProfile Maintenance
124TPFIDDescription of SAP instance2HOSTHost Namenvarchar400
TOPRepository Browser
125RSEUMODSettings for ABAP Workbench53HOSTApplication Servernvarchar320
TOPRuntime Analysis
126SATR_DIRECTORYDirectory of SAT Trace Containers24HOSTApplication Servernvarchar320
TOPRuntime for ABAP based automated TC
127STC_SESSIONTask List Runs16HOSTnvarchar1000
128STC_SESSION_EXIMTask List Runs for Refresh16HOSTnvarchar1000
TOPSAP Business Workflow
129SWRNOPROXYCustomizing: Proxy Exceptions2HOSTTemplate for a Host Name in a URLnvarchar500
TOPSecure Store and Forward
130SSF_PSE_HSSF: Personel Security Environment2HOSTApplication Servernvarchar320
TOPService Data Download
131/BDL/BADHOSTList of host that have not been transferred for certain dest6HOSTHost Namenvarchar200
132/BDL/BADHOSTSList of host that have not been transferred for certain dest5HOSTHost Namenvarchar200
133/BDL/CONTABContent description for following data transmission9HOSTCharacter field, length 32nvarchar320
134/BDL/NOHOSTSHosts which are NOT subject to service sessions1HOSTHost Namenvarchar200
135/BDL/SAPOSSinformation table for OSS-User13HOSTGateway host namenvarchar1000
136BDLBADHOSTList of host that have not been transferred for certain dest6HOSTHost Namenvarchar200
137BDLCONTABContent description for following data transmission9HOSTCharacter field, length 32nvarchar320
138BDLDATCOLData container for download data10HOSTCharacter field, length 32nvarchar320
139BDLDTOCRFC download -- Data cluster table of contents9HOSTCharacter field, length 32nvarchar320
140BDLNOHOSTSHosts which are NOT subject to service sessions1HOSTHost Namenvarchar200
TOPSupply Chain Management
141/SDF/EM_STEPException Management - Process Step Table13HOSTApplication Servernvarchar320
TOPSyntax, Compiler, Runtime
142TFDIRFunction Module8HOSTnvarchar80
143TPFSTStartup: List of programs to be started8HOSTSystemstart; Host, to which a program connects.nvarchar80
TOPSystem Landscape DirectoryComponent Repository
144LCRT_SERVADDRLandscape Directory Server Addresses1HOSTHost Name of Landscape Directory Servernvarchar640
TOPTools
145T52SPSHRPAY-Status Management: Process Status6HOSTApplication Servernvarchar320
TOPTransaction Manager
146TRGC_PARParallel Processing Control3HOSTServer used for parallel processingnvarchar200
TOPTranslation Tools
147LANG_MANDTObsolete table; do not use7HOSTHost Namenvarchar200
148LXE_PERF_LOGLXE Performance Tracing Table14HOSTApplication Servernvarchar320
149LXE_PERF_LOG_AGGAggregated Performance Log Data13HOSTApplication Servernvarchar320
150TRNL_LANGTranslation Environment: Target Languages and Attributes 15HOSTName of the Host Servernvarchar320
TOPTREX ABAP JAVA API
151TREX_INDEX_SERVIndex Server Location for Indexing3HOSTTREX host namenvarchar640
152TREX_SEARCH_SERVIndex Server Location for Search2HOSTTREX host namenvarchar640
TOPUpgrade - General
153EXP_VERSExport Information for Delivery Systems3HOSTApplication Servernvarchar320
TOPUse Subcomponents
154SODSPROFPresettings for access to LDAP service3HOSTHost name of LDAP servicenvarchar2550
TOPWeb Service and SOAP - ABAP
155SRT_CFG_CLI_ASGNAssignment of HTTP Destination to WS Client RT Configuration6HOSTntext10737418230
156SRT_DEST_WSDLSRT: Table for destinations for wsdl lookup3HOSTnvarchar750
157SRT_REG_ADRMAPSRT: Local System Table for Mapping Virtual Host and Address4HOSTSRT Registry Release Tool: Any URInvarchar1280
158WSRM_EHWSRM: Event Handler1HOSTApplication Servernvarchar320
TOPWorkbench Tools Editors, Painters, Modelers
159TDCTDialog Modules5HOSTnvarchar80