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

81 columns | Print definition?ERP 6.0  | SYSTEM_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IWPGW/C_SYALCustomizing table "System Alias" - PGW Local Configuration6SYSTEM_IDProcess Provider System IDnvarchar300
2/PERSONAS/C_IMPCDefinition of import clients1SYSTEM_IDImport system idnvarchar80
3/SLOAP/ANALYSISSLOAP analysis data7SYSTEM_IDSLOAS system idnvarchar30
4/SLOAP/RESULTSLOAP analysis results4SYSTEM_IDSLOAS system idnvarchar30
5ARBFND_C_PLCLNTDefine Settings for Polling Agent4SYSTEM_IDLogical systemnvarchar100
6ARBFND_D_PLCLNTPolling client4SYSTEM_IDLogical systemnvarchar100
7BTP_PCI_RFCDESBTP RFC Destinations2SYSTEM_IDSystem IDnvarchar80
8CNVMBTDELREFDeletion references for the coordinated reorganization12SYSTEM_IDSystem IDnvarchar80
9CNVMBTDESTCHANGEChanged system settings relevant for RFC1SYSTEM_IDSystem IDnvarchar80
10CNVMBTDESTSPECSpecial settings for a execution target Destination8SYSTEM_IDSystem IDnvarchar80
11CNVMBTDESTVERSMBT: RFC destination versions and settings7SYSTEM_IDSystem IDnvarchar80
12CNVMBTVERS_CTRLMBT: RFC destination versions and settings7SYSTEM_IDSystem IDnvarchar80
13CNV_10940_RUN_IDSearch Run IDs created in Sol Man for RVS5SYSTEM_IDCommunication Identification/Numbernvarchar300
14DBA_LOG_HEADERDBA: Audit/Trace Log for DBA Cockpit4SYSTEM_IDName of SAP Systemnvarchar80
15DBA_XCHG_DATADBA Cockpit: Exchange Data for Action Controllers3SYSTEM_IDName of SAP Systemnvarchar80
16STERM_COMP_WEBCustomer-Defined Components for Terminology Maintenance4SYSTEM_IDName of SAP Systemnvarchar80
17SWLT_TABLE_MDSWLT: Metadata for tables1SYSTEM_IDName of SAP Systemnvarchar80
18ZIDES_USER_LOGONAlternative Logon Users1SYSTEM_IDName of SAP Systemnvarchar80
19ZIDES_USER_PROCControl for User Handling in Component System1SYSTEM_IDName of SAP Systemnvarchar80
20ZIDES_USER_PROCCControl for User Handling in Component System1SYSTEM_IDName of SAP Systemnvarchar80
TOPABAP Unit
21SAUNIT_CM_IMPORTImport Log Table2SYSTEM_IDName of SAP Systemnvarchar80
22SAUNIT_TASK_00OBSOLETE4SYSTEM_IDName of SAP Systemnvarchar80
TOPBusiness Context Viewer
23/BCV/C_SESYSSearch System3SYSTEM_IDLogical Systemnvarchar100
24/BCV/C_SESYSRSearch System (Reference System)3SYSTEM_IDLogical Systemnvarchar100
TOPClinical System
25N2DI_RECORDAdministration Data of Speech Recording4SYSTEM_IDDictation System IDnvarchar300
26TN2COM_SYSTIDMaintain Sender Settings3SYSTEM_IDSender System ID of Institutionnvarchar100
27TN2DI_SYSTEMDictation System1SYSTEM_IDDictation System IDnvarchar300
28TN2DI_SYSTEMTRMNDictation System - Terminal Assignment2SYSTEM_IDDictation System IDnvarchar300
TOPContract Accounts Receivable and Payable
29DFKK_CUST_EXTRFI-CA Partner - Extracts5SYSTEM_IDLogical Systemnvarchar100
30DFKK_DOC_EXTRFI-CA Documents - Extracts7SYSTEM_IDLogical Systemnvarchar100
31DFKK_GP_EXTRFI-CA Partner - Extracts6SYSTEM_IDLogical Systemnvarchar100
TOPContract Billing
32ERCH_DOC_EXTRBilling Document Extract -Selection Requirements -4SYSTEM_IDLogical Systemnvarchar100
TOPDatabase Interface, Database Platforms
33DB6PMPROTDB6: Protocol Table for DBA Actions1SYSTEM_IDName of SAP Systemnvarchar80
TOPDB2 Universal Database for UNIX NT
34DB6GSDTBSDB6: Cumulated Table-Specific Snapshot Data1SYSTEM_IDName of SAP Systemnvarchar80
35DB6HISTBSDB6: Cumulated Table-Specific Snapshot Data1SYSTEM_IDName of SAP Systemnvarchar80
36DB6MONDB6: Datacluster for monitor reset data2SYSTEM_IDName of SAP Systemnvarchar80
37DB6_RESET_DATADB6: Datacluster for monitor reset data2SYSTEM_IDName of SAP Systemnvarchar80
TOPDocuments
38N1IM_STUDYMeta Data of Image Study13SYSTEM_IDSystem ID of Image Processing Systemnvarchar100
TOPeCATT Extended Computer Aided Test Tool
39ECAT_CVERSeCATT Table of Version Information for System Under Test1SYSTEM_IDName of SAP Systemnvarchar80
TOPFast Search Infrastructure
40SFSG_FREQTechnical Settings (Customizing)12SYSTEM_IDReplication Framework - System ID (abbreviation)nvarchar30
41SFSRFW_JDX_DReplication Framework - Join Index Rules11SYSTEM_IDReplication Framework - System ID (abbreviation)nvarchar30
TOPFinancial Services
42PSJ_C_LANDSCAPESystem Landscape for Evaluations in the Global Journal2SYSTEM_IDSystem IDnvarchar600
43PSJ_D_STEPPSJ: Journal Entries12SYSTEM_IDSystem IDnvarchar600
TOPGRC Risk Management
44GRRMTKRIBUPRKRI Business Process2SYSTEM_IDSystem IDnvarchar100
45GRRMTKRIBUPRCOMPRelationship between Business Process and Component2SYSTEM_IDSystem IDnvarchar100
46GRRMTKRIBUPRTKRI Business Process Texts3SYSTEM_IDSystem IDnvarchar100
47GRRMTKRICOMPKRI Component2SYSTEM_IDSystem IDnvarchar100
48GRRMTKRICOMPTKRI Component Texts3SYSTEM_IDSystem IDnvarchar100
49GRRMTKRISYSKRI System2SYSTEM_IDSystem IDnvarchar100
50GRRMTKRISYSTKRI System Texts3SYSTEM_IDSystem IDnvarchar100
51HRP1844DB Table for Infotype 184418SYSTEM_IDSystem IDnvarchar100
TOPIntercompany Data Exchange
52TINV_EXTR_HDRExtract of Bill Receipt Document: Admin. Data (Eval. System)6SYSTEM_IDLogical Systemnvarchar100
TOPInternet Communication Framework
53ICFRECORDERStore ICF Documents (Related to Recorder Layer)6SYSTEM_IDName of SAP Systemnvarchar80
TOPInvoicing
54ERD_DOC_EXTRPrint Document Extract - Selection Conditions -4SYSTEM_IDLogical Systemnvarchar100
TOPKnowledge Management and Collaboration
55SUWLNOTIFCFGTBLConfiguration table for UWL java-side notifications3SYSTEM_IDLogical systemnvarchar100
56SUWLNOTIFREGTBLRegistration table for java side server instances2SYSTEM_IDLogical systemnvarchar100
TOPLaunchpad
57APB_LPD_CHNGELOGLogs changes made to launchpad for updating user version7SYSTEM_IDName of SAP Systemnvarchar80
58APB_LPD_TRANSLOGTransports change logs to lpd for updating user version7SYSTEM_IDName of SAP Systemnvarchar80
TOPNetWeaver Enterprise Search
59ESH_ADM_GEN_CONNESH: Generic Connections7SYSTEM_IDIdentifier for an External Systemnvarchar60
60ESH_ADM_MDM_CONNESH: Connections to MDM Servers9SYSTEM_IDIdentifier for an External Systemnvarchar60
61ESH_ADM_RFCDESTESH: RFC Destinations and Assignment of LOGSYS3SYSTEM_IDName of SAP Systemnvarchar80
62ESH_ADM_RFC_CON1ESH: RFC Connections to ABAP Backend Systems3SYSTEM_IDSystem IDnvarchar80
63ESH_ADM_RFC_CONNESH: RFC Connections to ABAP Backend Systems3SYSTEM_IDSystem IDnvarchar80
TOPNetwork Objects
64GHO_IFLOT_EXTFunction location extension table6SYSTEM_IDSystem IDnvarchar600
TOPOLAP Technology
65RSECLOPDLOGHLOPD Logs: Control Data5SYSTEM_IDName of SAP Systemnvarchar80
TOPOnline Text Repository
66SOTR_HEADHeader Table for OTR Texts11SYSTEM_IDName of SAP Systemnvarchar80
67SOTR_HEADUHeader Table for Strings in the OTR11SYSTEM_IDName of SAP Systemnvarchar80
TOPProduction Optimization Interface POI
68TCBP_SYSList of active systems2SYSTEM_IDType of optimization systemnvarchar10
TOPRetention Warehouse
69IWP_GEN_CONFIGConfiguration of BI extraction6SYSTEM_IDSystem IDnvarchar20
TOPSearch Integration
70/PLMPCV/D_SESYSSearch System3SYSTEM_IDLogical systemnvarchar100
71/PLMPCV/D_SESYSRSearch System (Reference System)3SYSTEM_IDLogical systemnvarchar100
TOPTerminologyGlossary
72STERM_ADDCCustomer-Defined Components for Terminology Maintenance4SYSTEM_IDName of SAP Systemnvarchar80
73STERM_ADDTCustomer Components for Terminology Maintenance - Text Table5SYSTEM_IDName of SAP Systemnvarchar80
74STERM_SYSDistributed Terminology Maintenance:1SYSTEM_IDName of SAP Systemnvarchar80
75STERM_SYSTEMIDSystems for Input Help1SYSTEM_IDName of SAP Systemnvarchar80
76STERM_SYSTEMID_TText Table for Systems for Input Help1SYSTEM_IDName of SAP Systemnvarchar80
77STERM_USERUser-Specific Settings in SAPterm2SYSTEM_IDName of SAP Systemnvarchar80
78STERM_XTNDEnhancement Information: Add-On and Customer7SYSTEM_IDName of SAP Systemnvarchar80
TOPURL Generation
79TWPSRVLOGSRuntime for Release Status of Logical System (Workplace Srv)8SYSTEM_IDName of SAP Systemnvarchar80
TOPWeb Service and SOAP - ABAP
80SRT_DOMAIN_SYSSRT Central Configuration: Domain Systems3SYSTEM_IDSRT Central Configuration: Domain System IDnvarchar2550
81SRT_MED_SYSSRT Central Configuration: Managed Systems3SYSTEM_IDSRT Central Configuration: Managed System IDnvarchar2550