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

165 columns | Print definition?ERP 6.0  | DATA

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/FLINEText lines4DATALine Datavarbinary1270
2/AIF/PERS_XMLAIF XML Persistency: Message Header7DATAXML Persistence: Dataimage21474836470
3/AIF/T_ERR_VARSVariant enhancement /AIF/ERR7DATAimage21474836470
4/GEOE/USER_DATAUser data4DATARaw 32kbimage21474836470
5/SAPPSSRM/SYNOPSynopsis Data12DATAimage21474836470
6/UI2/CACHE_STATSUI2 cache statistics7DATAData in asXML format (URL params, list of invalidated BLOBS)ntext10737418230
7/UI2/TINY_DATATiny Data: Raw Data and Its Alias7DATAntext10737418230
8/XFT/STLCERTxft StorageLink: Zertifikatsverwaltung3DATAimage21474836470
9BGRFC_CCMS_DATAData for CCMS Monitor4DATAimage21474836470
10BGRFC_NOTI_ERRTemporary Storage of Error Messages3DATAimage21474836470
11CNV_TDMS_BPL_CONBPL Conflicting records during data transfer7DATAChar255nvarchar2550
12CNV_TDMS_BP_SECBPL Conflicting records during data transfer7DATAChar255nvarchar2550
13DOCM_STG_DATADBOSC-CM: Staging Data7DATAimage21474836470
14ESH_SE_PROCESSESH Search Runtime Data Buffer Processes8DATAntext10737418230
15EST_PROPTREE_CSVAblage der CSV-Dateien für Eigenschaftsbaum-Abgleich6DATAimage21474836470
16GRPCCLMIDMAPTable to Save CLM PC Job Id mapping3DATABuffer Valueimage21474836470
17HRSFI_D_ONB_IMPSuccessFactors: Staging Area for Onboarding Applicants11DATAFilter Stringntext10737418230
18HRSFI_D_RCT_LOGSuccessFactors: Staging Area for Recruiting Import14DATAFilter Stringntext10737418230
19LTMC_DISP_TEMPGeneric store for extracts16DATAExtract informationnvarchar600
20REC_DATADefinition Table for Recording Objects5DATAnvarchar2550
21REC_DATUSRDefinition Table for Recording Objects6DATAnvarchar2550
22sap_mon_text5DATAntext10737418230
23SRAL_BGRFC_CACHECache for bgRFC log data3DATARead Access Logging: Rule Dataimage21474836470
24SRAL_LOGRead Access Logging: Log19DATARead Access Logging: Data Field Valueimage21474836470
25SRAL_LOG_PERFRead Access Logging: Log (modified version for performance)17DATAimage21474836470
26T5BSDOG0SDoG: Historical and External Data10DATASDoG: Declaration Code Valuedecimal152
27WDR_TEST_RECORDRepository for WD ABAP Test Cases5DATAData for WD ABAP Test Casesntext10737418230
28WDYADT_VE_DEFSWeb Dynpro UI element data2DATAimage21474836470
29ZQBUTESTImport table for Time Zones2DATAcharacter 60 lower casenvarchar600
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
30SATC_AC_USERCustomizing: Personalization of online check6DATASerialized Data (Export or Call Transformation)image21474836470
TOPABAP Unit
31SAUNIT_TASK_00OBSOLETE24DATAPacked dataimage21474836470
32SAUNIT_TASK_01OBSOLETE11DATAPacked dataimage21474836470
TOPAlert Framework
33SALRTCCNTAlerts: Container Table (Customizing)5DATAContainer: Line of Binary Table for XMLvarbinary10240
34SALRTCNTAlerts: Container Table (Runtime)5DATAContainer: Line of Binary Table for XMLvarbinary10240
TOPBalanced Scorecard
35UMB_EBB_STRUCBriefing Book Structure3DATAimage21474836470
TOPBasic Market Data
36/BA1/F4_MD_BUFMarket Data Buffer: Data4DATABinary Data Field (Any Length)image21474836470
TOPBasis Services Communication Interfaces
37SIXMLCEXML Conformance Tests Entities4DATAXStringimage21474836470
TOPBatch-Oriented Parallel Processing of Mass Data
38PPF_TST_HISTORYHistory Data for Mass Runs13DATAHistory Event Detailsntext10737418230
TOPBelgium
39T5BSB0HR-BE: Social Balance Historical and External Data9DATADeclaration Code Valuedecimal152
TOPBusiness Configuration Sets
40SCPRTEMPBC Sets: Save temporary table data in DB4DATABC Sets: X Stringimage21474836470
TOPBusiness Configuration Tools Runtime
41SC2REP_CONFDATA(Preliminary) Configuration Repository for C2 Repository5DATAntext10737418230
42SC2_PG_QUERYCC2 Server: Generated Proxy Method Compiled Range Table5DATAntext10737418230
TOPBusiness Objects, Common Components
43EHFNDD_BO_ASAVEBOBF BO auto save8DATAStringntext10737418230
TOPBusiness Planning and Simulation
44UPWB_DATAData in XML Format of BSP Applications4DATALine with Data in XML Formatvarbinary2500
TOPBusiness Process Engine
45BRR_CONTContainer of a Business Rule4DATAContainer: Line of Binary Table for XMLvarbinary10240
46BRR_CONT_CContainer of a Client-Specific Rule5DATAContainer: Line of Binary Table for XMLvarbinary10240
47SWFDXMPCNTXML Message Proxy: Container Definition (XML Persistence)4DATAContainer: Line of Binary Table for XMLvarbinary10240
48SWFRXICNTXI Adapter: XML Container for a Message Object6DATAContainer: Line of Binary Table for XMLvarbinary10240
49SWFRXIPCNTXI Adapter: XML-Parameter Container5DATAContainer: Line of Binary Table for XMLvarbinary10240
50SWFRXMPICNTXML Message Proxy: Instance Container5DATAContainer: Line of Binary Table for XMLvarbinary10240
TOPCATT Computer Aided Test Tool
51CAT_DP_TABSave CATT DataProvider data7DATAvarbinary10240
TOPClientServer Technology
52DYNPLOADScreen Loads4DATAimage21474836470
53DYNPTXTLDContains Screen Text Loads5DATAimage21474836470
54REPOSRCReport Source Code34DATAimage21474836470
55REPOTEXTReport Texts8DATAimage21474836470
TOPContent Management Service
56CREP_CERTCertificates for HTTP Access to R3 Database4DATAvarbinary2550
TOPContract Accounts Receivable and Payable
57DFKKMDUGPMaster Data Lot: Items of the Groups of a Lot12DATAData of Application Objectsntext10737418230
TOPCross-Application Components
58/IXOS/DC_TBCROverflow table for duplicate COLD records9DATALRAW 8320ntext10737418230
59/IXOS/DC_TBRBRecycle bin11DATALRAW 8320ntext10737418230
60CKLTEXGeneric store for extracts17DATAInformation on MiniALV Extractnvarchar600
61CMLTEXGeneric store for extracts17DATAInformation on MiniALV Extractnvarchar600
62QDATTable For Storing Received Queue Data3DATAnvarchar140
63TWPPSVLSVWorkplace PI: Allocation of Physical to Logical Services5DATAWorkplace Plug-In: Physical Service Datanvarchar2550
64TWPPSVLSVCWorkplace PI: Phys. Allocation to Log. Services - Customer5DATAWorkplace Plug-In: Physical Service Datanvarchar2550
65TWPSRVTABWorkplace Plug-In: Physical and Logical Services5DATAWorkplace Plug-In: Physical Service Datanvarchar2550
TOPCustomer Enhancements
66ENH4DELTABTable for Cleanup After Import Object Deletion7DATAimage21474836470
67ENHHEADEREnhancement Header Table10DATAimage21474836470
68ENHSPOTHEADEREnhancement Spot Header Data11DATAimage21474836470
TOPData Basis
69RSCNVTSTDATARemodeling test data5DATAntext10737418230
70RSDUPARTTCTest Data for Automatic Tests5DATAntext10737418230
TOPData Staging
71RSAR_BUFFERGeneric Buffer for Error Stack Records5DATAimage21474836470
72RSDS_QUEUE_DATADataSource Queue: Data (Binary)4DATADataSource Queue: Raw Stringimage21474836470
73RSMIMETable with mime data (pictures)3DATAData row in Mime formatvarbinary2550
TOPDatabase Interface, Database Platforms
74DB6AUDITDTDB6: Audit log for maintenance actions6DATAnvarchar2550
TOPDevice Management
75EDEVCHECK_BACKUPIS-U Device Checker: Test Data Backup4DATAIS-U Device Checker: Backup of Test Data: Work Areanvarchar2190
TOPE-Recruiting
76T77RCF_ATTACH_PLTemporary Database for Attachments3DATAAttachment Contentsimage21474836470
TOPeCATT Extended Computer Aided Test Tool
77ECEVT_DATOBSOLETE - Table for Transfer of GUI Event Data3DATAChar255nvarchar2550
78ECSCR_TTABeCATT - TCD Data Provider Data DP_TAB9DATAvarbinary10240
TOPEnd User Technology
79RSFRONTENDINITData for the BW Front-End Initialization2DATAData for the Initialization Data Recordnvarchar300
80RSWR_DATARuntime Data4DATARuntime Data as Stringntext10737418230
81RSZWBTMPDATABW Web Template Data5DATABinary Data (Normally UTF8 Unless BOM Marked)image21474836470
82RSZWITEMDATABW Web Item Data (7.0)+5DATABinary Data (Normally UTF8 Unless BOM Marked)image21474836470
83RSZWMDITEMDATABW Web Metadata: Binary and Textual Data7DATABW Web Reporting: Stringntext10737418230
84RSZWMDITEMDOCUBW Web Metadata: Binary and Textual Data8DATABW Web Reporting: Stringntext10737418230
85RSZWTEMPLATEDATABW Web Template 3.x Data5DATABinary Data (Normally UTF8 Unless BOM Marked)image21474836470
TOPEnterprise Search Integration
86CRMD_ES_TMPLHDRTemplates for ES7DATAXML Data for ESntext10737418230
TOPGeneric Statistical Data
87/DSD/GS_GENDAT_IDSD: Generic Data Container7DATAGeneric structure for transferring datanvarchar2500
TOPGovernance, Risk and Compliance
88GRFNSCRWSWeb Service Scripts3DATAScript Datanvarchar2550
TOPHelp Infrastructure for ABAP
89WEBSERVICE_TABTable for Web Service Access4DATAText, 40 Characters Longnvarchar400
TOPIncentive and Commission Management ICM
90CACS_DET_VARDATAData for Determination Variants4DATAntext10737418230
TOPInformation System
91GRW_HISTORYReport Writer Changes history9DATAReport Writer Change History Datanvarchar2550
TOPInternationalization I18N
92TCPT1Code pages: Table 1 for tests and messages3DATAText Field of Length 60nvarchar600
TOPItaly
93T5ITPCCAF table13DATAForm data archiving datenvarchar80
TOPMobile Applications
94/ISDFPS/MSG_BODYData for Error/Conflict Messages12DATAGeneral String Fieldntext10737418230
TOPNetWeaver Enterprise Search
95ESH_OM_TRANSPORTTable for transport of template and models7DATAimage21474836470
TOPObject Links
96DPR_OBL_OBTYPProperties of Object Link to Object Type8DATARead Linked Object Datanvarchar10
TOPOLAP Technology
97RSCDSTCContains Test Scenarios for Program RSDR_ARCH_CHECK5DATAntext10737418230
98RSDRDTCTest Scenario for Archiving Check5DATAntext10737418230
TOPOperational Data Provisioning ODP
99RODPSLOADDATAODP Activation (Data)3DATAimage21474836470
100RODPSODPEDATAODP Activation (Data)3DATAimage21474836470
TOPOracle Database Monitors
101ORA_ISQ_HISTORYIndex Storage Quality - Objectshistory Data16DATADatadecimal222
TOPOrganizational Management
102HRSCONTContainer Data for Workflow Container (Definition)5DATAContainer: Line of Binary Table for XMLvarbinary10240
TOPPayment Transactions
103OFX_VERSION_FIEBAttributes for a DTD Version of OFX3DATAType of Data Content for OFXnvarchar300
TOPPerformance Assessment Workbench
104SLS_LOGLPAW - logging error8DATAPAW - Long characterntext10737418230
TOPPortal Content
105ISTNLMXMLGANTTXML Data for Gantt Display6DATAXML Data in an Orderntext10737418230
TOPPortfolio Management
106RPM_OBL_OBTYPProject Object Link Type8DATAHierarchical Processingnvarchar10
TOPProcess Management
107CMX_XSE_DB_PERSXSEditor: Personalization Data3DATAXSEditor: Data in XML Formatimage21474836470
TOPProduct Cost Planning
108CKQS_MAP_IDMapping of Costing Run ID + Data Basis to Variant10DATACommentnvarchar500
TOPRelationships Between Objects with GUID Identification
109COMC_IL_STRUCStructures and Table Types of Relationship Types4DATAName of Structure with Relship-Type-Dependent Attributesnvarchar300
TOPReuse Services for Country Development
110T596MData Personnel Area Reporting16DATAVariable Data Field with Maximuml Length for Screensnvarchar1320
TOPSales
111TERRFErroneous Data for First Data Transfer5DATASERPLISTS datanvarchar17000
TOPSAP Business Partner
112TB050_SScreen Configuration (Shadow Table) (Obsolete)10DATAText field length 200nvarchar2000
113TBZ6SBDT: VCT Usages (Shadow Table)10DATACharacter 100nvarchar1000
TOPSAP Business Workflow
114SWBSAPDFLTSAP Default Values for Prog./Trans./FMs (Applic.-Specific)5DATAData component for default valuesnvarchar2550
115SWBUSRDFLTDefault Values of SAP User for Prog./Trans./FMs6DATAData component for default valuesnvarchar2550
116SWDSCONTWF Definition: Container (from 610)9DATAContainer: Line of Binary Table for XMLvarbinary10240
117SWD_CONTWF Definition: Container (from 610)10DATAContainer: Line of Binary Table for XMLvarbinary10240
118SWFDCRLHCNCorrelation: Parameter (XML Container)4DATAContainer: Line of Binary Table for XMLvarbinary10240
119SWFPFRUNTIMEData for Runtime Collector7DATANon-Interpreted Performance Datanvarchar640
120SWFRCNTXMLContainer: XML Runtime Data5DATAContainer: Line of Binary Table for XMLvarbinary10240
121SWFRCNTXMLSContainer: XML Runtime Data as XSTRING3DATAimage21474836470
122SWFREVTCNTContainer: XML Runtime Data5DATAContainer: Line of Binary Table for XMLvarbinary10240
123SWFSLSCNTDeadline Service: Data Container5DATAContainer: Line of Binary Table for XMLvarbinary10240
124SWJPCNTContainer Definition/Values for Parameter Conditions (XML)5DATAContainer: Line of Binary Table for XMLvarbinary10240
125SWJ_CONTContainer Instance (Separate) for PPF (XML)5DATAContainer: Line of Binary Table for XMLvarbinary10240
126SWPCMPCONTComponent Container of WFM4DATAimage21474836470
127SWR_BPMLWorkflow: BPML Document5DATAimage21474836470
128SWTRQTRACEWorkflow: Trace Table for Requests11DATAimage21474836470
129SWWCNTP0Workflow Container: XML Database (P0)5DATAContainer: Line of Binary Table for XMLvarbinary10240
130SWWCNTPADDWorkflow Runtime: Persistence for Additional Container (XML)5DATAimage21474836470
TOPSAP Healthcare - Industry-Specific Components for Hospitals
131NWCHPATRECIS-H CH: PATREC - erstellte Statistiksätze8DATAIS-H CH: PATREC - stringa datinvarchar2500
132NWCH_BOA_RESPAntwortsdaten von der Massendeckungsabfrage7DATAIS-HCM Inhalt der HCM-Nachrichtnvarchar10240
TOPSAP List Viewer
133LTCXGeneric store for extracts16DATAExtract informationnvarchar600
134LTEXGeneric store for extracts16DATAExtract informationnvarchar600
TOPSAP NetWeaver Mobile - Use subcomponents
135MEREP_210Variant for SyncBO Emulator7DATALong Characternvarchar20480
136MEREP_504Inbox/Outbox Data7DATALong Characternvarchar20480
137MEREP_504IInbox5DATAHolds Data of Variable Length from MEREP_207ntext10737418230
138MEREP_504OOutbox5DATAHolds Data of Variable Length from MEREP_207ntext10737418230
TOPSCM Basis
139CIF_IMAXMaximum Vectors for Target System and Publishing Type6DATAData Vector for Integration Model APO Interfaceimage21474836470
140CIF_IMODBasis Table of Integration Model for APO Interface14DATAData Vector for Integration Model APO Interfaceimage21474836470
141CIF_IMOD_TEMPTemporary Data Storage for CIF Integration Models14DATAData Vector for Integration Model APO Interfaceimage21474836470
TOPSecurity
142RSECTABSecure Storage: Memory for Encrypted Data6DATAvarbinary1840
143SEC_TEST_MAPTable with Test Data5DATAimage21474836470
144WSS_PROFILEWS Security Profiles7DATAWeb Services Security Profile Datantext10737418230
145WSS_TEMPLATEWS Security Templates5DATAWeb Services Security Profile Datantext10737418230
TOPSyntax, Compiler, Runtime
146VER_TIDY_HTMLTIDY VERIFICATION DATA8DATAXstringimage21474836470
TOPSystem Landscape DirectoryComponent Repository
147SLDAGDIDSLD Agent: Data with ID3DATASLD Agent: Data of an IDnvarchar2550
TOPTransaction Variant and Table Control Settings
148SHDIRSCRDResource raw data5DATASAP Query: Raw data 132varbinary1320
TOPTREX ABAP JAVA API
149TREX_TRACE_DEntries for the TREX trace3DATAimage21474836470
TOPUser Administration
150SPERS_EXTExternal table integration example2DATAChar 20nvarchar200
151SPERS_GMAGeneric Personalization for MiniApps6DATAPersonalization data fieldnvarchar2550
152SPERS_GMASGeneric Personalization for MiniApps for Access by ITS6DATAPersonalization data fieldnvarchar2550
TOPWD ABAP Page Builder
153CHIP_NAMESPACETest Namespace4DATA30 Charactersnvarchar300
TOPWeb Dynpro
154WRC_DATADefinition Table for Recording Objects5DATAnvarchar2550
155WRC_DATUSRDefinition Table for Recording Objects6DATAnvarchar2550
TOPWeb Dynpro ABAP
156WDG_GEN_LOGWeb Dynpro Generation Log10DATAntext10737418230
TOPWeb Dynpro ABAP Rendering
157WDR_ADP_CHNGLOGChange Log of Web Dynpro Adapter Data3DATAimage21474836470
TOPWeb Dynpro ABAP Runtime
158WDR_RR_LOADWeb Dynpro: Runtime Table for Component Metadata2DATAimage21474836470
TOPWeb Service and SOAP - ABAP
159SIDL_TEST_DATASIDL WSDL Test Samples3DATAimage21474836470
160SRTFT_SA_APPLSRT Runtime Framework: SOAP Applications9DATAimage21474836470
161SRT_NAME_CACHESRT Name Cache5DATAntext10737418230
162SRT_SA_APPLSOAP Runtime Framework: SOAP Applications9DATAimage21474836470
163SRT_SA_PRFSOAP Runtime Framework: DT Profiles6DATAimage21474836470
164SRT_SEQ_CPS_PSRVcompensate preserve info4DATAChar 80nvarchar800
165SRT_TEST_OBJECTSDatenobjekte für die Testausführung5DATAimage21474836470