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

98 columns | Print definition?ERP 6.0  | CONTEXT_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IWFND/D_UM_SYSContext Based SAP System Alias Configuration2CONTEXT_IDUsed for Maintaining System Aliases for Contextsnvarchar160
2/MRSS/D_CH_DEMSignatures and Change Date/Time for Demands6CONTEXT_IDUnique ID to identify the mode within a sessionnvarchar400
3/SAPSRM/CHIP_CATChip categories5CONTEXT_IDContext Keynvarchar160
4/SAPSRM/CHIP_CFGMultiple POWL Feeder Types4CONTEXT_IDContext Keynvarchar160
5/SAPSRM/FP_CHP_GChip Grouping Categories3CONTEXT_IDnvarchar300
6/SAPSRM/SIDE_PANRegister for Side Panel6CONTEXT_IDContext Keynvarchar160
7/SDF/DRM_CONF_DEData Readyness Monitoring - Configuration Details2CONTEXT_IDCharacter String - 32 User-Defined Charactersnvarchar320
8/SDF/DRM_DC_RESData Readyness Monitoring - Data Collection Results2CONTEXT_IDCharacter String - 32 User-Defined Charactersnvarchar320
9/SDF/DRM_RES_DEData Readyness Monitoring - Results Details2CONTEXT_IDCharacter String - 32 User-Defined Charactersnvarchar320
10/SOMO/JOBMON01Job schedule template3CONTEXT_IDBPMon: GUID32nvarchar320
11/SOMO/JOBMON03Job data selection criteria cluster5CONTEXT_IDBPMon: GUID32nvarchar320
12/SOMO/JOBMON04Job Metric definition table3CONTEXT_IDBPMon: GUID32nvarchar320
13/SOMO/JOBMON06Active job rules in unified job monitoring4CONTEXT_IDBPMon: GUID32nvarchar320
14/SOMO/JOBMON07Monitoring configuration last monitoring activation object3CONTEXT_IDBPMon: GUID32nvarchar320
15/SOMO/JOBMON11Job schedule information3CONTEXT_IDBPMon: GUID32nvarchar320
16/SOMO/JOBMON12Job instance information3CONTEXT_IDBPMon: GUID32nvarchar320
17/SOMO/JOBMON14Job metric information3CONTEXT_IDBPMon: GUID32nvarchar320
18/SOMO/JOBMON16Unified job monitoring - joblog information cluster3CONTEXT_IDBPMon: GUID32nvarchar320
19/SOMO/JOBMON17Storage for data collector calls for monitoring object5CONTEXT_IDBPMon: GUID32nvarchar320
20/SOMO/JOBMON19Unified job monitoring - joblog information cluster new4CONTEXT_IDBPMon: GUID32nvarchar320
21/SOMO/MA_MAPPINGBPMon: MAI - BPMon Mapping3CONTEXT_IDBPMon: GUID32nvarchar320
22DBA_ALRT_METDBA: Alerting Metrics4CONTEXT_IDDBA: System GUID 32nvarchar320
23DBA_ALRT_MET_CDBA: Alerting Metric Components4CONTEXT_IDDBA: System GUID 32nvarchar320
24DBA_ALRT_MET_RDBA: Alerting Metrics Rules4CONTEXT_IDDBA: System GUID 32nvarchar320
25VBID_P13N_STOREVisual Business Personalization data storage3CONTEXT_IDConfiguration Identifiernvarchar500
TOPAuthentication and SSO
26SEC_CONTEXT_COPYServer-Specific Security Contexts (Due to Timeout Check)2CONTEXT_IDSecurity Context ID (Internal Representation of Session ID)varbinary320
TOPBackground RFC bgRFC
27BGRFC_EVENT_PARMInbound Scheduler/Destinations Customizing2CONTEXT_IDContext ID for Background RFC Event Handlingnvarchar400
28BGRFC_SRV_STATEServer Status of bgRFC Units8CONTEXT_IDContext ID for Background RFC Event Handlingnvarchar400
TOPBusiness Server Pages
29TBSPJSDBGBusiness Server Pages (BSP) DB Table JavaScript Debugging7CONTEXT_IDnvarchar400
TOPClinical System
30N2DI_CONTEXTRelationship Dictation - i.s.h.med Object2CONTEXT_IDContext IDnvarchar320
31N2DI_DICTATDictation - Administration Data3CONTEXT_IDContext IDnvarchar320
TOPCollaboration Folders
32CFX_ALIASAlias Names for Contexts2CONTEXT_IDUnique ID for Contextsvarbinary160
33CFX_CONTEXTSContexts for Alias Names3CONTEXT_IDUnique ID for Contextsvarbinary160
TOPDocument Management Framework
34SKWF_ISELKW Framework: Context Settings2CONTEXT_IDKW Framework: Context IDnvarchar320
TOPGraphic
35GFWCUAXGFW Customizing: Axis3CONTEXT_IDGFW: Context IDnvarchar10
36GFWCUAXUGFW Customizing: Axis (Customer Data)3CONTEXT_IDGFW: Context IDnvarchar10
37GFWCUDAGFW Customizing: Plot Area3CONTEXT_IDGFW: Context IDnvarchar10
38GFWCUDAUGFW Customizing: Plot Area (Customer Data)3CONTEXT_IDGFW: Context IDnvarchar10
39GFWCUDCGFW Customizing: Display Context3CONTEXT_IDGFW: Context IDnvarchar10
40GFWCUDCUGFW Customizing: Display Context (Customer Data)3CONTEXT_IDGFW: Context IDnvarchar10
41GFWCUDIGFW Customizing: Chart3CONTEXT_IDGFW: Context IDnvarchar10
42GFWCUDIUGFW Customizing: Chart (Customer Data)3CONTEXT_IDGFW: Context IDnvarchar10
43GFWCUDSGFW Customizing: Data sheet3CONTEXT_IDGFW: Context IDnvarchar10
44GFWCUDSUGFW Customizing: Data Table (Customer Data)3CONTEXT_IDGFW: Context IDnvarchar10
45GFWCUGRGFW Customizing: Grid3CONTEXT_IDGFW: Context IDnvarchar10
46GFWCUGRUGFW Customizing: Grid (Customer Data)3CONTEXT_IDGFW: Context IDnvarchar10
47GFWCUITGFW Customizing: Item3CONTEXT_IDGFW: Context IDnvarchar10
48GFWCUITUGFW Customizing: Item (Customer Data)3CONTEXT_IDGFW: Context IDnvarchar10
49GFWCUPOGFW Customizing: Point3CONTEXT_IDGFW: Context IDnvarchar10
50GFWCUPOUGFW Customizing: Point (Customer Data)3CONTEXT_IDGFW: Context IDnvarchar10
51GFWCUSCGFW Customizing: Scale3CONTEXT_IDGFW: Context IDnvarchar10
52GFWCUSCUGFW Customizing: Scale (Customer Data)3CONTEXT_IDGFW: Context IDnvarchar10
53GFWCUVAGFW Customizing: Value Series3CONTEXT_IDGFW: Context IDnvarchar10
54GFWCUVAUGFW Customizing: Value Series (Customer Data)3CONTEXT_IDGFW: Context IDnvarchar10
TOPHR Administrative Services
55T5ASRMSGCNTXTMessage Mapping: Contexts1CONTEXT_IDContext ID for Message Mappingnvarchar320
56T5ASRMSGCNTXTTMessage Mapping: Context Texts2CONTEXT_IDContext ID for Message Mappingnvarchar320
57T5ASRMSGMAP1CCustomer: Message Mapping Based on Message Type2CONTEXT_IDContext ID for Message Mappingnvarchar320
58T5ASRMSGMAP1SSAP: Message Mapping Based on Message Type1CONTEXT_IDContext ID for Message Mappingnvarchar320
59T5ASRMSGMAP2CCustomer: Message Mapping Based on Error Category2CONTEXT_IDContext ID for Message Mappingnvarchar320
60T5ASRMSGMAP2SSAP: Message Mapping Based on Error Category1CONTEXT_IDContext ID for Message Mappingnvarchar320
TOPKey Figure Monitor
61KFM_USR_VIEWUser, Context, and Role-Specific Views3CONTEXT_IDUnique Context ID in Portalnvarchar40
TOPKey Mapping Extension
62MDKMSD_CONTEXTContext Fields for an Object Type-Element Combination2CONTEXT_IDNumber of Context Fieldnvarchar30
TOPMDG Business Partner Central Part
63BST_CT_ACCORDINGAccording of Context IDs2CONTEXT_IDContext IDnvarchar100
64BST_CT_IDDefinitions of Context IDs1CONTEXT_IDContext IDnvarchar100
TOPMusing Tools
65WDKAPPNAVPARWDK: External navigation target parameters8CONTEXT_IDContext IDnvarchar20
TOPOffice Suite Program
66/OSP/T_CORRELATECorrelation Table3CONTEXT_IDContext of the Applicationnvarchar50
TOPRFC
67ARFCRCONTEXTAssignment of Context ID to TID6CONTEXT_IDContext ID for Background RFC Event Handlingnvarchar400
TOPStandardized Key Mapping
68UKMPI_MAPPINGMapping Settings for UKMS9CONTEXT_IDID of the Main Contextnvarchar320
TOPSyntax, Compiler, Runtime
69ABDBG_LISTENERWaiting Listener Processes for Breakpoint Notification5CONTEXT_IDnvarchar400
TOPTag Library
70WCF_CDS_TESTDATATest Data Entries for Central Data Source Test Application3CONTEXT_IDnvarchar200
TOPUI Configuration Design Layer
71BSPC_DL_FIELDUSEField Property table2CONTEXT_IDContext IDnvarchar400
72BSPC_DL_STXTELEMRepository for custom texts2CONTEXT_IDContext IDnvarchar400
73BSPC_DL_STXTREP2Repository for custom texts3CONTEXT_IDContext IDnvarchar400
74BSPC_DL_XMLSTORXStoragetable for XML layout descriptions2CONTEXT_IDContext IDnvarchar400
75BSPC_DL_XMLSTRX2Storagetable for XML layout descriptions2CONTEXT_IDContext IDnvarchar400
76BSP_DDLC_STEXTRPRepository for delivered custom texts2CONTEXT_IDContext IDnvarchar400
77BSP_DDLC_XMLSTORStoragetable for delivered XML layout descriptions1CONTEXT_IDContext IDnvarchar400
78BSP_DLC_CONTEXTContext definition for Dynamic Layout configuration tools4CONTEXT_IDContext IDnvarchar400
79BSP_DLC_STEXTREPRepository for custom texts3CONTEXT_IDContext IDnvarchar400
80BSP_DL_STXTELEMText Repository / Text Elements1CONTEXT_IDContext IDnvarchar400
81BSP_DL_STXTREP2Text Repository2CONTEXT_IDContext IDnvarchar400
82BSP_DL_XMLSTRX2Storagetable for delivered XML layout descriptions1CONTEXT_IDContext IDnvarchar400
83BSP_DL_XMLST_PRProcessed Standdard Configuration (switch related handling)2CONTEXT_IDContext IDnvarchar400
TOPVisual Business
84VBCD_CNTXTModel context9CONTEXT_IDContext IDnvarchar550
85VBCD_CONTEXTApplication Context5CONTEXT_IDContext IDnvarchar550
86VBCD_CONTEXT_ENCModel context7CONTEXT_IDContext IDnvarchar550
TOPWebClient UI
87WCFC_CDS_CONSTCentral Data Source Constant Attributes2CONTEXT_IDContext IDnvarchar200
88WCFC_CDS_CONST_TCentral Data Source Constant Attributes texts table2CONTEXT_IDContext IDnvarchar200
89WCFC_CDS_FUNCTCentral Data Source Custom Functions2CONTEXT_IDContext IDnvarchar200
90WCFC_CDS_FUNCT_TCentral Data Source Custom Functions texts2CONTEXT_IDContext IDnvarchar200
91WCFC_CDS_USERVCentral Data Source User Variable Attribute2CONTEXT_IDContext IDnvarchar200
92WCFC_CDS_USERV_TCentral Data Source Constant Attributes texts table2CONTEXT_IDContext IDnvarchar200
93WCF_CDS_CONSTCentral Data Source Constant Attributes1CONTEXT_IDContext IDnvarchar200
94WCF_CDS_CONST_TCentral Data Source Constant Attributes texts table1CONTEXT_IDContext IDnvarchar200
95WCF_CDS_FUNCTCentral Data Source Custom Functions1CONTEXT_IDContext IDnvarchar200
96WCF_CDS_FUNCT_TCentral Data Source Custom Functions texts1CONTEXT_IDContext IDnvarchar200
97WCF_CDS_USERVCentral Data Source User Variable Attribute1CONTEXT_IDContext IDnvarchar200
98WCF_CDS_USERV_TCentral Data Source Constant Attributes texts table1CONTEXT_IDContext IDnvarchar200