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

80 columns | Print definition?ERP 6.0  | ZEIT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CALLERTabelle der caller Einträge für Transaktion SVPQ2ZEITVerifikation : Time of Veri Runnvarchar60
2CNVC_SCNG_VERSVersions and Checksum Values9ZEITVersion management: Version creation timenvarchar60
3DFKK_ACCADJAdjustment Postings when Implementing Acct Assgmt Chars18ZEITTimenvarchar60
4DFKK_NEWACCADJObsolete: See DFKK_ACCADJ18ZEITTimenvarchar60
5FUNCTIONTabelle der Funktionseinträge für Transaktion SVPQ2ZEITVerifikation : Time of Veri Runnvarchar60
6KEYWORDKeyword Definitionen für PureQuantify3ZEITVerifikation : Time of Veri Runnvarchar60
7NRIV_DOCUNon-Assigned Internal Numbers in Parallel Buffering10ZEITSystem Timenvarchar60
8PQDATAPureQuantify Daten3ZEITVerifikation : Time of Veri Runnvarchar60
9PROGRAMSTabelle der program Einträge für Transaktion SVPQ2ZEITVerifikation : Time of Veri Runnvarchar60
10T258ETable for managing external data transfer7ZEITLast changed atnvarchar60
11VERFUNCVeris : PureCoverage Info auf Funktionenebene4ZEITVerifikation : Time of Veri Runnvarchar60
12VERIRUNSPQTabelle der Veri-Läufe für Transaktion SVPQ2ZEITVerifikation : Time of Veri Runnvarchar60
13VERMODVeris : PureCoverage Info auf Modulebene3ZEITVerifikation : Time of Veri Runnvarchar60
TOPAdvertising Management
14TJHVSW03IS-M/AM: Save VSW Interfaces Created3ZEITIS-M/AM: Entry Time for VSW Interfaces (HHMM)nvarchar40
TOPArchiveLink
15TOA_L03SAP ArchiveLink: Log table4ZEITSystem Timenvarchar60
TOPBusiness Application Support
16CNVWDMCNV watchdog: sent messages7ZEITSystem Timenvarchar60
TOPBW Service API
17RORQSTPRMSProtokolltable Request7ZEITSystem Timenvarchar60
TOPChange Transport System
18GTACLIENTSSystems Connected to GTADIR6ZEITTimenvarchar60
TOPClinical System
19N1AQLOGIS-H*MED: Log Table for Control Actions3ZEITTime in CHAR Formatnvarchar60
20N1LAPPservices without case or movement reference10ZEITIS-H: Time when Service Performance Starts (Actual)nvarchar60
TOPComplaints Processing
21CMP_VBFS_EXTStatus Messages from Mass Complaints Processing3ZEITTimenvarchar60
TOPContract Accounts Receivable and Payable
22DFKK_DUEGRIDOI - Reclassifications20ZEITTimenvarchar60
23DFKK_RECLASSOI - Reclassifications15ZEITTimenvarchar60
TOPCross-Application Components
24J_8A3LOGlogtable - Old Version, don't use4ZEITTime in CHAR format - Old version, don't usenvarchar60
25J_8A3T0002logtable4ZEITTime in CHAR formatnvarchar60
TOPCurrency Customizing and Handling for Euro
26EWCMPROTLog of Customizing currency settings for euro4ZEITTimenvarchar60
TOPData Modeler
27DM02LDM Entity Type9ZEITTime-dependency flagnvarchar10
28TDM04Entity Type9ZEITTime-dependency flagnvarchar10
TOPData Staging
29RSPCLOGCHAINCross-Table Log ID / Chain ID6ZEITSystem Timenvarchar60
30RSSDBATCHTable for batch run scheduler (new)8ZEITTimenvarchar60
31RSSDBATCHHISTTable for Background Run of Scheduler - Changes/History9ZEITTimenvarchar60
32RSSDBATCHSHTable for Batch Run Scheduler (New)7ZEITTimenvarchar60
TOPeCATT Extended Computer Aided Test Tool
33ECET_SECURETable for Security Aspects with External Tool5ZEITSystem Timenvarchar60
34ECWD_DATATable for the Data Section Transfer for Web Dynpro4ZEITSystem Timenvarchar60
35ECWD_RECORDTable for Recording Data Transfer to WebDynpro4ZEITSystem Timenvarchar60
36ECWD_RECORD2Table for Recording Data Transfer to WebDynpro4ZEITSystem Timenvarchar60
37ECWD_SSSTable for Transfer of Screen Snapshots for Web Dynpro ABAP4ZEITSystem Timenvarchar60
38ECWD_UITable for the UI Section Transfer for Web Dynpro4ZEITSystem Timenvarchar60
TOPF4 Help
39DDSHLPVERSCurrent Version of Search Help Activator3ZEITnvarchar60
TOPFunction Builder
40EUFUNCDevelopment Environment Objects10ZEITTimenvarchar60
TOPHelp Infrastructure for ABAP
41WEBSERVICE_TABTable for Web Service Access2ZEITnvarchar60
TOPLocal Currency Changeover
42EWUARCHIVCritical archiving objects12ZEITSystem Timenvarchar60
43EWUPGSTATConversion programs status13ZEITEMU conversion: Program net runtime for a restart in secondsint100
44EWUPGTABEMU conversion: Program/tables data9ZEITEstimated time for changeover in minutesint100
TOPMaxDB
45DBANBuffer for dban_state14ZEITSystem Timenvarchar60
TOPMenu Painter
46EUDBDevelopment Environment Objects8ZEITTimenvarchar60
TOPNumber Range Management
47NRIV_RESTEInternal numbers not assigned in conn. with NRIV split8ZEITSystem Timenvarchar60
TOPOLAP Technology
48RSCDS_LOADLOGTable for load manager2ZEITSystem Timenvarchar60
TOPPeriodical Sales and Distribution
49JDTVASYNCIS-M: Worklist for Issue Synchronization M/SD -> M/AM10ZEITTime of Last Changenvarchar60
TOPPrint and Output Management
50TSP0CSpool: Change Log8ZEITSpool: Time (internal)nvarchar60
51TSP0LSpool events1ZEITTime a spool request was creatednvarchar160
TOPRemaining Beverage - Obsolete Objects
52/BEV3/CHABRKZL_TCH Settlement Key Figure Statistics18ZEITTimenvarchar60
53/BEV3/CHCWSValue Date: CH Document Value Date11ZEITInsert/Update Timenvarchar60
54/BEV3/CHDVWD0001Basic Data for CHD17ZEITInsert/Update Timenvarchar60
55/BEV3/CHFSOBJRelease/Lock Object Transaction9ZEITTime of Last Changenvarchar60
56/BEV3/CHOPAObject Partnership14ZEITTimenvarchar60
57/BEV3/CHSORTKCH Assortments Header10ZEITTimenvarchar60
58/BEV3/CHTADIRObject Mapping Old --> New11ZEITTimenvarchar60
59/BEV3/CHTMPFSOBJRelease/Lock Object Transaction14ZEITTime of Last Changenvarchar60
60/BEV3/CHTMPVWSTAContract Handling Status Transaction12ZEITTime of Last Changenvarchar60
61/BEV3/CHTRMSTZ_SCH Date Statistics119ZEITTimenvarchar60
62/BEV3/CHVWSTATContract Handling Status Transaction7ZEITTime of Last Changenvarchar60
63/BEV3/CHWDContract Handling Document9ZEITTimenvarchar60
64/BEV3/CHWDAUFSTCHD-Increase in Loan9ZEITInsert/Update Timenvarchar60
65/BEV3/CHWDCMMNTInternal memos / comments on CHD6ZEITTimenvarchar60
66/BEV3/CHWDKLSSClassifications of CHD10ZEITInsert/Update Timenvarchar60
67/BEV3/CHWDKORRCorrepondence Data for CHD10ZEITInsert/Update Timenvarchar60
68/BEV3/CHWDLFZEITCHD Validity Periods5ZEITTimenvarchar60
69/BEV3/CHWDOBJObjects with Reference to CHD8ZEITInsert/Update Timenvarchar60
70/BEV3/CHWDPRTNRCHD Partner7ZEITInsert/Update Timenvarchar60
71/BEV3/CHWDSIGNVGContract for signing party7ZEITInsert/Update Timenvarchar60
72/BEV3/CHWDSIGNVNContract for signing party8ZEITInsert/Update Timenvarchar60
73/BEV3/CHWDVTRRBZContract Number References7ZEITInsert/Update Timenvarchar60
TOPRuntime WorkbenchMonitoring
74SXMSALERTLOGXI Alert Log3ZEITCreated Atnvarchar60
TOPTransport Organizer
75TESTFBParametersätze zu Tests von Funktionsbausteinen10ZEITUhrzeitnvarchar60
76VRSDVersion management: Directory table7ZEITVersion management: Version creation timenvarchar60
TOPTravel Expenses
77T706_CONSTPA parameters: Travel Management8ZEITTimenvarchar60
TOPWorkbench Tools Editors, Painters, Modelers
78EUDIALTest data for dialog module management10ZEITTimenvarchar60
TOPWorkbench Utilities
79DBDATAData Browser Procedure Data8ZEITTimenvarchar60
80TBPROGREFReference table - program4ZEITLast changed atnvarchar60