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

60 columns | Print definition?ERP 6.0  | CHG_DATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVMBTPAT06PAT06-Control: Avoid ADDONS to be upgraded4CHG_DATEDate of Last Changenvarchar80
2SRAL_DAEMON_RUNControl parameters for RAL Daemon running options6CHG_DATESystem Datenvarchar80
TOPABAP Runtime Environment
3TNMAPAssignment of global to (instance)local table names6CHG_DATESystem Datenvarchar80
TOPCross-Application Components
4CCMSBI_MTEMAP_TConversion Rules for MTEs with Names That Are Converted8CHG_DATESystem Datenvarchar80
5FRE_DIF_NO_SITESBEF Occurrences for Number of Supplied Plants9CHG_DATEChanged onnvarchar80
TOPIncentive and Commission Management ICM
6YCRM01_B_VAR_CASVariants for Commission Case9CHG_DATEDate on Which Object was Creatednvarchar80
7YHITEC_B_VAR_CASVariants for Commission Case51CHG_DATEDate on Which Object was Creatednvarchar80
8YHITEC_CASCommission Case47CHG_DATEDate on Which Object was Creatednvarchar80
9YHITEC_DOCHDCommission Document Header45CHG_DATEDate on Which Object was Creatednvarchar80
10YSVMA_B_VAR_CASVariants for Commission Case9CHG_DATEDate on Which Object was Creatednvarchar80
11YSVMA_CASCommission Case9CHG_DATEDate on Which Object was Creatednvarchar80
12YSVMA_DOCHDCommission Document Header8CHG_DATEDate on Which Object was Creatednvarchar80
13YTEL01_B_VAR_CASVariants for Commission Case51CHG_DATEDate on Which Object was Creatednvarchar80
14YTEL01_CASCommission Case47CHG_DATEDate on Which Object was Creatednvarchar80
15YTEL01_DOCHDCommission Document Header45CHG_DATEDate on Which Object was Creatednvarchar80
16YTEL05_B_VAR_CASVariants for Commission Case9CHG_DATEDate on Which Object was Creatednvarchar80
17YTEL05_CASCommission Case9CHG_DATEDate on Which Object was Creatednvarchar80
18YTEL05_DOCHDCommission Document Header8CHG_DATEDate on Which Object was Creatednvarchar80
19ZICMAG_B_VAR_CASVariants for Commission Case51CHG_DATEDate on Which Object was Creatednvarchar80
20ZICMAG_CASCommission Case47CHG_DATEDate on Which Object was Creatednvarchar80
21ZICMAG_DOCHDCommission Document Header45CHG_DATEDate on Which Object was Creatednvarchar80
TOPLoans Management
22TDPR_ATTRFIELDAttribute: Field Description21CHG_DATESystem Datenvarchar80
23TDPR_ATTRIBUTEAttribute7CHG_DATESystem Datenvarchar80
24TDPR_ATTRIBUTETDescription Attribute5CHG_DATESystem Datenvarchar80
25TDPR_ATTRTREEAttribute Hierarchy8CHG_DATESystem Datenvarchar80
TOPMonitoring
26ALAVLAGENTCombine CCMSPING Agents into Groups4CHG_DATEAlert: Date of last changenvarchar80
27ALAVLGCNTLCCMS Avail. Mon.: Control Table for Reference System Group5CHG_DATEAlert: Date of last changenvarchar80
28ALCLASTOOLAlert: Assignment of tools to object class7CHG_DATEAlert: Date of last changenvarchar80
29ALCONSEGAlert: Context/segment assignment13CHG_DATEAlert: Date of last changenvarchar80
30ALCUSTSETAlert: Monitoring Properties Variants5CHG_DATEAlert: Date of last changenvarchar80
31ALGRPCUSGEAlert: General Customizing for MTE classes16CHG_DATEAlert: Date of last changenvarchar80
32ALGRPCUSMCAlert: Message container Customizing for Cust. groups15CHG_DATEAlert: Date of last changenvarchar80
33ALGRPCUSMGAlert: Group Customizing data single message class8CHG_DATEAlert: Date of last changenvarchar80
34ALGRPCUSPFAlert: Group Customizing data performance class16CHG_DATEAlert: Date of last changenvarchar80
35ALMTCUSGENAlert: MT-specific Customizing Class-independent24CHG_DATEAlert: Date of last changenvarchar80
36ALMTCUSMSCAlert: MTE-specific Customizing: message container23CHG_DATEAlert: Date of last changenvarchar80
37ALMTCUSPERAlert: MT-specific Customizing Performance-Class24CHG_DATEAlert: Date of last changenvarchar80
38ALMTCUSSMGAlert: MT-specific Customizing: Single Message Class16CHG_DATEAlert: Date of last changenvarchar80
39ALMTECLSETAlert: MTEClass setting of the Monitoring Architecture6CHG_DATEAlert: Date of last changenvarchar80
40ALSYSTEMSCCMS Central System Management: Remote Managed Systems11CHG_DATEAlert: Date of last changenvarchar80
41ALTIDTOOLAlert: Assignment of tools to Tid15CHG_DATEAlert: Date of last changenvarchar80
42ALTOOLEXECAlert: Tool definition (executable, dispatcher and so on)17CHG_DATEAlert: Date of last changenvarchar80
43CSMCONTXCCMS Central System Management: Remote Managed Contexts11CHG_DATEAlert: Date of last changenvarchar80
44CSMNSDICCCMS CSM: Central Name Server Directory10CHG_DATEAlert: Date of last changenvarchar80
45CSMSEGMCCMS Central System Management: Remote Managed Segments12CHG_DATEAlert: Date of last changenvarchar80
46CSMSEGMXCCMS: Cache for Administration of Monitored Segments12CHG_DATEAlert: Date of last changenvarchar80
TOPOnline Correction Support Support Package and Add-On Tools
47PAT06Component-Specific Patches5CHG_DATEDate of Last Changenvarchar80
TOPPosition Budgeting and Control
48T77HRFPM_CHGPERPeriod Allowed for Changes in the Past4CHG_DATEDatenvarchar80
TOPSAP Note Assistant
49SMODIUSERProcessor of Customer Modifications13CHG_DATECustomer Enhancement: Date of Last Status Changenvarchar80
TOPSyntax, Compiler, Runtime
50SHMA_ATTRIBUTESArea Attributes (ABAP Shared Objects)20CHG_DATEnvarchar80
51SHMA_ATTR_RTSArea Properties Changeable W/o Restrict. (ABAP Shared Obj,)4CHG_DATEnvarchar80
52SHMA_STARTList of Instance Names for Auto Build6CHG_DATEnvarchar80
53SHMA_START_RTSList of Instance Names for Auto Build (Runtime Setting)7CHG_DATEnvarchar80
TOPTraders and Schedulers Workbench
54OIJNOMSTNomination status (Header and Item)9CHG_DATEChanged Onnvarchar80
TOPTransaction Management
55VTB_ASGN_POSFTR Assignment Management: Assigned Position Changes6CHG_DATEFTR Assignment Management: Date of Profile Changenvarchar80
TOPTransaction Tax Engine
56TTEC_DT_DATADecision Tree Data9CHG_DATELast Change Datenvarchar80
TOPUser and Authorization Management
57SUIM_CHG_IDXChange Document Index for User Data4CHG_DATECreation date of the change documentnvarchar80
TOPWeb Service and SOAP - ABAP
58SRT_REG_BACKUPRSRT Registry: Backup Relation7CHG_DATEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
59TASK_VITA_RUNParameter Table for TW Runtime Environment9CHG_DATESystem Datenvarchar80
60WSRM_TXH_WATCHERParameter Table for Watcher of Transaction Handler5CHG_DATESystem Datenvarchar80