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

49 columns | Print definition?ERP 6.0  | HOSTNAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/FHEADFile header data6HOSTNAMEFrontend Host Namenvarchar300
2/AIF/LFA_DATAFile data for Lean File Adapter5HOSTNAMEFrontend Host Namenvarchar300
3/IXOS/RSA_T_RENSTable: Rendition Server Overview3HOSTNAMELivelink archive rendition server Hostnamenvarchar2550
4/OPT/VIM_CFG_VERTable to store ICC Configuration data versions8HOSTNAMELogical Destination (Specified in Function Call)nvarchar320
5/OPT/VIM_FB_OBJTable to store ICC feedback status7HOSTNAMELogical Destination (Specified in Function Call)nvarchar320
6/OTX/RM_AUNITCFGServer-specific configuration for unit tests22HOSTNAMEHostnamenvarchar1320
7/OTX/RM_TELIBEnterprise Library Server Settings16HOSTNAMEHostnamenvarchar1320
8ACO000SAP_GP: Communication Data Set Bidder/Vendor/Portal6HOSTNAMEHost Name for URLnvarchar1000
9BBP_TMP_ACOTemporary: Request 'Bidder', Communication Data7HOSTNAMEHost Name for URLnvarchar1000
10DOCR_LOG_RECORDDBOSC-CR: Log Records4HOSTNAMEnvarchar600
11DOCR_TRC_RECORDDBOSC-CR: Trace Records8HOSTNAMEnvarchar600
12DYNABAPHDRHeader Table for Dynamic ABAP Coding2HOSTNAMEApplication Servernvarchar320
13MSSPPACKMSSQL : list of DB performance snapshots12HOSTNAMEMSSQL Multiconnect : SQL Server namenvarchar1280
14PATTPLOGPTRSTDOUT des letzten tp Aufrufs10HOSTNAMEServernamenvarchar220
15sap_dblocks9hostnamesysname1280
16TOACLSAP ArchiveLink: Frontend Customizing log1HOSTNAMEChar 20nvarchar200
17UCONVIRTHOSTHTTPVirtual hosts for HTTP2HOSTNAMEName of virt. hostsnvarchar300
TOPABAP Runtime Environment
18DBTABPRTTable of log records for table tupel changes6HOSTNAMEHost Namenvarchar200
19INSTVERSDocumentation for installation Status and History6HOSTNAMEApplication Servernvarchar320
TOPArchiveLink
20TOAC1SAP ArchiveLink: Frontend Customizing1HOSTNAMEChar 20nvarchar200
21TOACACache for frontend files1HOSTNAMEChar 20nvarchar200
22TSOFASAP ArchiveLink - incoming faxes - path conversion3HOSTNAMENetwork Addressnvarchar200
TOPAudit trail enhancements ILM
23AUT_D_DBTABLOGAudit Trail (ILM): Storage of Archived Table Logs6HOSTNAMEHost Namenvarchar200
24AUT_D_STXH_ARCHAudit Trail (ILM): Buffer/Rekeying Table Archiving12HOSTNAMEHost Namenvarchar200
25AUT_D_STXL_ARCHAudit Trail (ILM): Buffer/Rekeying Table Archiving12HOSTNAMEHost Namenvarchar200
TOPClient Copy
26CCPROCTABParallel Client Copy Processes7HOSTNAMEApplication Servernvarchar320
TOPClientServer Technology
27PATCHHISTHistory of Kernel Patch3HOSTNAMEServer namenvarchar220
TOPCommunication Services Mail, Fax, SMS, Telephony
28SPH_TERMNLSAPphone: Work center settings7HOSTNAMESAPphone: Host namenvarchar2550
TOPCross-Application Components
29/IXOS/DC_TCNTHLTable for nodetype hyperlinks8HOSTNAMEHyperlink hostnamenvarchar640
30/IXOS/RS_T_QUEUEQueue for asyncronous processing7HOSTNAMERendition Server Hostnamenvarchar200
31/IXOS/RS_T_RENDIRendition Servers4HOSTNAMERendition Server Hostnamenvarchar200
TOPDB-Independent Database Interface
32DBTABLOGLog Records of Table Changes6HOSTNAMEHost Namenvarchar200
TOPElectronic Data Records
33AUT_STXH_ARCHBuffer and Conversion Table for Archiving12HOSTNAMEHost Namenvarchar200
34AUT_STXL_ARCHBuffer and Conversion Table for Archiving12HOSTNAMEHost Namenvarchar200
TOPEnd User Technology
35RSFECBW Frontend Check2HOSTNAMEHost name for BW Frontend checknvarchar200
TOPInterestCharge Calculation
36BKKMINTVAREAHOSTInterval areas processed with priority by host3HOSTNAMEApplication Server Instancenvarchar400
TOPInternet Communication Framework
37ICF_SERV_STATInterim Storage of ICF Statistics Data3HOSTNAMEName of a Service in Internet Communication Frameworknvarchar150
TOPMicrosoft SQL Server
38MSQSNAPMS SQL Server: Database performance snapshot4HOSTNAMEHostname of the application server logged into SQL Servernvarchar300
39MSSDEADLCKDatabase Deadlock Information for MSSQL Server6HOSTNAMEName of the Host Servernvarchar320
40MSSDWDLLSHolds records on the dlls in the disp+work2HOSTNAMEnvarchar500
TOPPerformance Monitors TCC
41PAHIHistory of system, DB and SAP parameter2HOSTNAMEHost Namenvarchar320
TOPSAP NetWeaver Mobile - Use subcomponents
42MECONFIG_J2EEHost Name and Port of J2EE Engine for MI2HOSTNAMEHost Namenvarchar700
TOPSyntax, Compiler, Runtime
43D1GENImport Status for APG (Anticipatory Program Generation)3HOSTNAMEServer to delete data fornvarchar320
TOPTransport Organizer
44TRBAT3Communication Table for R3trans Parallelization13HOSTNAMEServer to delete data fornvarchar320
TOPWeb Service and SOAP - ABAP
45SRT_ALT_HOSTSTable for Defining Alternative Host Names3HOSTNAMEAlternative Host Name for publicationnvarchar1200
46SRT_MONILOG_DATASOAP Runtime Table for Monitoring and Log Data Records12HOSTNAMEApplication Servernvarchar320
47SRT_MONLOG_DATA2SOAP Runtime Table for Monitoring and Log Data Records12HOSTNAMEApplication Servernvarchar320
48SRT_TRC_ASSIGNKeep relation info between user sessions and local trace fil5HOSTNAMEApplication Servernvarchar320
TOPWithout Description
49CCMSBI_GUIDS_CPHGUIDs for Long MTE Names (Extended)14HOSTNAMESAP Workload NW Collector: Host Namenvarchar400