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

56 columns | Print definition?ERP 6.0  | CHG_TIME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1SRAL_DAEMON_RUNControl parameters for RAL Daemon running options7CHG_TIMESystem Timenvarchar60
TOPABAP Runtime Environment
2TNMAPAssignment of global to (instance)local table names7CHG_TIMESystem Timenvarchar60
TOPBackground Processing
3TBTC_EXT_SDLExtSdl: Registration Table: External Schedulers12CHG_TIMEBackground Processing: Time Stamp (UTC)decimal150
TOPCross-Application Components
4FRE_DIF_NO_SITESBEF Occurrences for Number of Supplied Plants10CHG_TIMEChanged Atnvarchar60
TOPDocument Management Framework
5SKWS_CACHECache Table for CM Status Management5CHG_TIMETime of change (UTC)nvarchar140
TOPIncentive and Commission Management ICM
6YCRM01_B_VAR_CASVariants for Commission Case10CHG_TIMETime at Which Object was Creatednvarchar60
7YHITEC_B_VAR_CASVariants for Commission Case52CHG_TIMETime at Which Object was Creatednvarchar60
8YHITEC_CASCommission Case48CHG_TIMETime at Which Object was Creatednvarchar60
9YHITEC_DOCHDCommission Document Header46CHG_TIMETime at Which Object was Creatednvarchar60
10YSVMA_B_VAR_CASVariants for Commission Case10CHG_TIMETime at Which Object was Creatednvarchar60
11YSVMA_CASCommission Case10CHG_TIMETime at Which Object was Creatednvarchar60
12YSVMA_DOCHDCommission Document Header9CHG_TIMETime at Which Object was Creatednvarchar60
13YTEL01_B_VAR_CASVariants for Commission Case52CHG_TIMETime at Which Object was Creatednvarchar60
14YTEL01_CASCommission Case48CHG_TIMETime at Which Object was Creatednvarchar60
15YTEL01_DOCHDCommission Document Header46CHG_TIMETime at Which Object was Creatednvarchar60
16YTEL05_B_VAR_CASVariants for Commission Case10CHG_TIMETime at Which Object was Creatednvarchar60
17YTEL05_CASCommission Case10CHG_TIMETime at Which Object was Creatednvarchar60
18YTEL05_DOCHDCommission Document Header9CHG_TIMETime at Which Object was Creatednvarchar60
19ZICMAG_B_VAR_CASVariants for Commission Case52CHG_TIMETime at Which Object was Creatednvarchar60
20ZICMAG_CASCommission Case48CHG_TIMETime at Which Object was Creatednvarchar60
21ZICMAG_DOCHDCommission Document Header46CHG_TIMETime at Which Object was Creatednvarchar60
TOPLoans Management
22TDPR_ATTRFIELDAttribute: Field Description22CHG_TIMETIME Data Element for SYSTnvarchar60
23TDPR_ATTRIBUTEAttribute8CHG_TIMETIME Data Element for SYSTnvarchar60
24TDPR_ATTRIBUTETDescription Attribute6CHG_TIMETIME Data Element for SYSTnvarchar60
25TDPR_ATTRTREEAttribute Hierarchy9CHG_TIMETIME Data Element for SYSTnvarchar60
TOPMonitoring
26ALAVLAGENTCombine CCMSPING Agents into Groups5CHG_TIMEAlert: Time of last changenvarchar60
27ALAVLGCNTLCCMS Avail. Mon.: Control Table for Reference System Group6CHG_TIMEAlert: Time of last changenvarchar60
28ALCLASTOOLAlert: Assignment of tools to object class8CHG_TIMEAlert: Time of last changenvarchar60
29ALCONSEGAlert: Context/segment assignment14CHG_TIMEAlert: Time of last changenvarchar60
30ALCUSTSETAlert: Monitoring Properties Variants6CHG_TIMEAlert: Time of last changenvarchar60
31ALGRPCUSGEAlert: General Customizing for MTE classes17CHG_TIMEAlert: Time of last changenvarchar60
32ALGRPCUSMCAlert: Message container Customizing for Cust. groups16CHG_TIMEAlert: Time of last changenvarchar60
33ALGRPCUSMGAlert: Group Customizing data single message class9CHG_TIMEAlert: Time of last changenvarchar60
34ALGRPCUSPFAlert: Group Customizing data performance class17CHG_TIMEAlert: Time of last changenvarchar60
35ALMTCUSGENAlert: MT-specific Customizing Class-independent25CHG_TIMEAlert: Time of last changenvarchar60
36ALMTCUSMSCAlert: MTE-specific Customizing: message container24CHG_TIMEAlert: Time of last changenvarchar60
37ALMTCUSPERAlert: MT-specific Customizing Performance-Class25CHG_TIMEAlert: Time of last changenvarchar60
38ALMTCUSSMGAlert: MT-specific Customizing: Single Message Class17CHG_TIMEAlert: Time of last changenvarchar60
39ALMTECLSETAlert: MTEClass setting of the Monitoring Architecture7CHG_TIMEAlert: Time of last changenvarchar60
40ALSYSTEMSCCMS Central System Management: Remote Managed Systems12CHG_TIMEAlert: Time of last changenvarchar60
41ALTIDTOOLAlert: Assignment of tools to Tid16CHG_TIMEAlert: Time of last changenvarchar60
42ALTOOLEXECAlert: Tool definition (executable, dispatcher and so on)18CHG_TIMEAlert: Time of last changenvarchar60
43CSMCONTXCCMS Central System Management: Remote Managed Contexts12CHG_TIMEAlert: Time of last changenvarchar60
44CSMNSDICCCMS CSM: Central Name Server Directory11CHG_TIMEAlert: Time of last changenvarchar60
45CSMSEGMCCMS Central System Management: Remote Managed Segments13CHG_TIMEAlert: Time of last changenvarchar60
46CSMSEGMXCCMS: Cache for Administration of Monitored Segments13CHG_TIMEAlert: Time of last changenvarchar60
47SCMLPSMOI_WS: Configuration of Logical Ports for SAPSTARTSRV17CHG_TIMESMOI_WS: UTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPSAP Note Assistant
48SMODIUSERProcessor of Customer Modifications14CHG_TIMECustomer Enhancement: Time of Last Status Changenvarchar60
TOPSyntax, Compiler, Runtime
49SHMA_ATTRIBUTESArea Attributes (ABAP Shared Objects)21CHG_TIMEnvarchar60
50SHMA_ATTR_RTSArea Properties Changeable W/o Restrict. (ABAP Shared Obj,)5CHG_TIMEnvarchar60
51SHMA_STARTList of Instance Names for Auto Build7CHG_TIMEnvarchar60
52SHMA_START_RTSList of Instance Names for Auto Build (Runtime Setting)8CHG_TIMEnvarchar60
TOPTraders and Schedulers Workbench
53OIJNOMSTNomination status (Header and Item)10CHG_TIMETime of day the record was changednvarchar60
TOPTransaction Tax Engine
54TTEC_DT_DATADecision Tree Data10CHG_TIMELast Change Timenvarchar60
TOPWeb Service and SOAP - ABAP
55TASK_VITA_RUNParameter Table for TW Runtime Environment10CHG_TIMESystem Timenvarchar60
56WSRM_TXH_WATCHERParameter Table for Watcher of Transaction Handler6CHG_TIMESystem Timenvarchar60