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  | UDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CIDEON/MEASTabelle4UDATEDatumnvarchar80
2CNVCMIS_A_1_BADIExit: Implementation side: Attributes13UDATEDatenvarchar80
3CNVC_SCWB_XTEVTrigger event table4UDATEDatenvarchar80
4TSCON_PROJ_LOGRecording of processed projects6UDATESystem Datenvarchar80
5ZAUTOTRObject lists for work lists16UDATEDate of Last Changenvarchar80
TOPALE Integration Technology
6BDLSHDRHeader Data for Conversion of Logical System Names14UDATEDate data element for SYSTnvarchar80
TOPAudit trail enhancements ILM
7AUT_D_ILM_CDHDRAudit Trail (ILM): Storage Change Document Headers (ILM)7UDATECreation date of the change documentnvarchar80
TOPBasic Functions
8ETXDCHExternal tax document: header info18UDATEAudit file update date (external interface)nvarchar80
9ETXDCLOGTemporay table for storing last error message of an update13UDATEDatenvarchar80
10TTXIExternal tax interface: index file7UDATEAudit file update date (external interface)nvarchar80
TOPBusiness Planning
11UPB_SY_BPSCONNLevel and Area for which Classes Were Generated5UDATEDatenvarchar80
TOPChange Documents
12CDHDRChange document header6UDATECreation date of the change documentnvarchar80
13CDSOLMIGSolution Manager Runs for Change Document Transfers6UDATECreation date of the change documentnvarchar80
14CDSOLMIG_DDChange Document Objects to be Migrated6UDATECreation date of the change documentnvarchar80
15PCDHDRChange document header6UDATECreation date of the change documentnvarchar80
TOPClient Copy
16VRSTABCClient Copy Exception Table5UDATEDate of Last Changenvarchar80
TOPCommand and Support Relationships
17/ISDFPS/ORXPRASWClient-Independent Final Confirmation for Table Conversion3UDATEDatenvarchar80
TOPContract Accounts Receivable and Payable
18DFKKCOLI_LOGCollection Agency Information File: Communication Log15UDATECreation date of the change documentnvarchar80
19DFKKCOLLP_IM_WBuffer: Coll. Agency Info File (Item Master Data Change)17UDATEChange Date (Batch Input)nvarchar80
20DFKKCOLL_CHCollection: Changes to Business Partner Master Data3UDATECreation date of the change documentnvarchar80
TOPCross-System Tools
21CMPWLECustomizing Comparison: Exception List (SAP)7UDATEDate of Last Changenvarchar80
22CMPWLECCustomizing Comparison: Exception List (Customer)7UDATEDate of Last Changenvarchar80
23CMP_EXCEPTComparison Tools Exception Table (will be deleted)5UDATEDate of Last Changenvarchar80
TOPCustomer Enhancements
24SXC_ATTRExit: Implementation side: Attributes9UDATEDatenvarchar80
25SXS_ATTRExit: Definition side: Attributes for an enhancement13UDATEDatenvarchar80
TOPCustomer Interaction Center
26CCMCLBSCall center callback - Whole20UDATECall center callback change datenvarchar80
TOPData Collection
27TKCOMSAP-EIS: Method table1UDATESystem Datenvarchar80
TOPDefault Risk and Limit System
28VTBLPLog for Single Transaction Check3UDATEDate of Last Changenvarchar80
TOPEnergy Data Management
29EPROFVALSTATHISTHistory of Profile Value Status10UDATECreation date of the change documentnvarchar80
TOPEnterprise Service Framework Layer
30SCOOLOBJECTSObject Pattern Model7UDATEChanged Onnvarchar80
TOPFlexible Real Estate Management
31VICALOGREFCNTInternal Performance Log7UDATESystem Datenvarchar80
TOPGeneral status management
32CRM_JCDOChange Documents for Status Object (Table JSTO)5UDATECreation date of the change documentnvarchar80
33CRM_JCDSChange Documents for System/User Statuses (Table JEST)6UDATECreation date of the change documentnvarchar80
34JCDOChange Documents for Status Object (Table JSTO)5UDATECreation date of the change documentnvarchar80
35JCDSChange Documents for System/User Statuses (Table JEST)6UDATECreation date of the change documentnvarchar80
TOPGRC Access Control Plug-In
36/VIRSA/ZANALOBJTAnalyzed authorization objects5UDATEDatenvarchar80
37/VIRSA/ZANALTRANAnalyzed transactions5UDATEDatenvarchar80
38/VIRSA/ZFFCDHDRFirefightId Change Document6UDATECreation date of the change documentnvarchar80
TOPJoint Venture und Production Sharing Accounting
39T8JDPJV EDI Inbound: Memo AFE Table11UDATEChanged onnvarchar80
TOPliveCache Applications
40MMRP_DATEVECSKey: Date Vector (Only in the liveCache)8UDATEChanged onnvarchar80
TOPNon Profit Organizations
41T7UN_T52CDSchema-Directory9UDATEDatum der letzten Änderungnvarchar80
TOPPayroll General Parts
42DSYS_XPRA_PROTLog table for converting RPDSYS to HRDSYS6UDATEChanged Onnvarchar80
43T514DForm Index11UDATEChanged Onnvarchar80
44T52CCDirectory of Customer Schemas10UDATEChanged Onnvarchar80
45T52CDSchema Directory10UDATEChanged Onnvarchar80
46T52CEDirectory of Personnel Calculation Rules7UDATEChanged onnvarchar80
47T52DZAssignment: Customizing - Model Wage Type6UDATESystem Datenvarchar80
TOPProduct Safety
48EST_CHANGE_DOCSEHS: Change Documents in the EH&S System11UDATECreation date of the change documentnvarchar80
TOPPublic Sector Contract Accounts Receivable and Payable
49DFMCAILOTPSCD: Approval List Installment Plans34UDATECreation date of the change documentnvarchar80
TOPRecords and Case Management
50RMPSP_DSPPhysical Disposal7UDATEPhysical Disposal Changed Ondecimal150
TOPRegulatory reporting for insurance companies
51TISSR_GP_CHANGEISSR: Tabelle zur Aufnahme der Informationen zur GP-Änderung18UDATEErstellungsdatum des Änderungsbelegsnvarchar80
TOPRepository Browser
52OBJTYPEGROUPSSemantic Group Affiliation of Object Types7UDATEChanged Onnvarchar80
53WVOBJECTTYPESRegistry Table for Object Types7UDATEChanged Onnvarchar80
TOPSales
54/CBAD/CHG_EFF_HCBAD: Changes to the future in extended contracts - Header7UDATECreation date of the change documentnvarchar80
55/CBAD/CHG_FUTURECBAD: Changes to the future in extended contracts - Header7UDATECreation date of the change documentnvarchar80
56ERP_SLS_LINKWorklist Subset Link12UDATEDatenvarchar80
TOPSAP Note Assistant
57SVRS_VCNT_HEADHeader table for TLogo test objects5UDATEDate of Last Changenvarchar80
TOPSets
58SETUSE_BERSet Use in Authorizations (Area of Responsibility)5UDATEDate of last changenvarchar80
TOPText Retrieval and Information Extraction
59SRETDOCSTable for user's document favorites2UDATEDate URL savednvarchar80
TOPTransaction Manager
60THMEXT_PLANNERE-HA: Hedge Plan11UDATEDatenvarchar80
TOPTranslation Tools
61LWRKOBJObject lists for worklists16UDATEDate of Last Changenvarchar80
62LWRKOTRObject lists for worklists16UDATEDate of Last Changenvarchar80
63LXE_AVTranslation Evaluations7UDATEDate of Last Changenvarchar80
64LXE_LOGSE63 - Recording of Processed Objects10UDATESystem Datenvarchar80
65LXE_LOG_TCSE63 - Recording of SP corrections8UDATESystem Datenvarchar80
66LXE_WRKOBObjects in Worklists20UDATEDate of Last Changenvarchar80
67LXE_WRKOB1Objects in Worklists20UDATEDate of Last Changenvarchar80
68LXE_WRKOBDObjects in Worklists20UDATEDate of Last Changenvarchar80
69LXE_WRKOBKObjects in Worklists20UDATEDate of Last Changenvarchar80
70LXE_WRKOBOObjects in Worklists20UDATEDate of Last Changenvarchar80
71LXE_WRKOBSObjects in Worklists20UDATEDate of Last Changenvarchar80
72LXE_WRKOBXObjects in Worklists20UDATEDate of Last Changenvarchar80
73LXE_WRKOBYObjects in Worklists20UDATEDate of Last Changenvarchar80
74LXE_WRKOBZObjects in Worklists20UDATEDate of Last Changenvarchar80
75TRNL_AVTranslation Evaluations6UDATEDate of Last Changenvarchar80
76TRNL_OLTranslation Object Lists7UDATEDate of Last Changenvarchar80
77TSLLTSLLT (translation accounting) settings11UDATEDate of Last Changenvarchar80
TOPTransport Organizer
78VERSOBJ_ALIASList of Active Alias Object Types13UDATEDate of Last Changenvarchar80
TOPUpgrade Add-On Components IS
79TSYSDEFInformation on Industry Switch3UDATEDate of Last Changenvarchar80
TOPUser and Authorization Management
80USARC_CDREDReloaded Archived Change Documents for User Data5UDATECreation date of the change documentnvarchar80
TOPWeb Services Tool
81CRMOST_GEN_TEMPLGeneration templates for Open Services Tool4UDATE(8-character) Date for SYSTnvarchar80