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
1ERP EHP76.0GRFNMWCNGLBSET181MSMP Global Settings per Process
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, PROCESS_ID, ESCALATION_ENBLE, ESCALATION_DATE, ESCALATION_ADMIN, NOTVAR_RULE_TYPE, NOTVAR_RULE_ID, SUB_TEMPLATE_ID, SUB_RECIPIENT_ID, EOR_TEMPLATE_ID, EOR_RECIPIENT_ID, ERR_TEMPLATE_ID, ERR_RECIPIENT_ID, CONSOLIDATE_NOTI, FLEXIBLE_NOTIF, MAX_LI_SUBMITTED, MAX_APPRS_PER_LI, MAX_STAGE_VISITS FROM GRFNMWCNGLBSET
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2PROCESS_IDProcess IDnvarchar300 Allow NULL? 
3ESCALATION_ENBLEEscalation Enabledchar10 Allow NULL? 
4ESCALATION_DATEMSMP Escalation Datenvarchar80 Allow NULL? 
5ESCALATION_ADMINMSMP Escalation Administrator Agentnvarchar400 Allow NULL? 
6NOTVAR_RULE_TYPENotification Variables Rule Typechar10 Allow NULL? 
7NOTVAR_RULE_IDNotification Variables Rule IDnvarchar320 Allow NULL? 
8SUB_TEMPLATE_IDNotification - Template ID Submissionnvarchar600 Allow NULL? 
9SUB_RECIPIENT_IDNotification - Submission Recipient IDnvarchar400 Allow NULL? 
10EOR_TEMPLATE_IDNotification - Template ID Closingnvarchar600 Allow NULL? 
11EOR_RECIPIENT_IDNotification - Closing Recipient IDnvarchar400 Allow NULL? 
12ERR_TEMPLATE_IDNotification - Template ID when Errornvarchar600 Allow NULL? 
13ERR_RECIPIENT_IDNotification - Error Recipient IDnvarchar400 Allow NULL? 
14CONSOLIDATE_NOTIConsoliadtion of Notifications Across Whole Requestchar10 Allow NULL? 
15FLEXIBLE_NOTIFUse Flexible Notifications (from DB table GRFNMWCNGLBNOT)char10 Allow NULL? 
16MAX_LI_SUBMITTEDMax. Line-Items per Submitted Requestnvarchar50 Allow NULL? 
17MAX_APPRS_PER_LIMax. Determined Approvers per Line-Itemnvarchar50 Allow NULL? 
18MAX_STAGE_VISITSMax. Visits of one Stage During Runtime (cycles-detection)nvarchar50 Allow NULL? 
NamePrimaryUniqueTypeColumns
GRFNMWCNGLBSET~0YesYesCLUSTEREDPROCESS_ID, MANDT