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)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6OPCH386A/P Invoice
7INV1265A/R Invoice - Rows
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OINM101Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
1ERP EHP76.0EHPRCD_WL_E_RC_C232Entry - Regulatory Change Workist
SQL:  selectupdate insert create

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

SELECT MANDT, DB_KEY, PARENT_KEY, DATETIME_CR, USER_ID_CR, DATETIME_CH, USER_ID_CH, COD_REQ_REV_KEY, PRIORITY, PROP_ACT_CODE, STATUS_CODE, REG_CHG, REG_CHG_REAS, TECH_ISSUE_IND, LOG_MSG_ID, LOG_MSG_NO, LOG_MSG_V1, LOG_MSG_V2, LOG_MSG_V3, LOG_MSG_V4, LOG_MSG_COUNT, DECLARABLE_KEY, EEW_WL_RC_ETRY_D FROM EHPRCD_WL_E_RC_C
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2DB_KEYNodeIDvarbinary160
3PARENT_KEYNodeIDvarbinary160
4DATETIME_CRDate/Time of Item Creationdecimal150
5USER_ID_CRObject Created Bynvarchar120 Allow NULL? 
6DATETIME_CHDate/Time of Item Changedecimal150
7USER_ID_CHObject Changed Bynvarchar120 Allow NULL? 
8COD_REQ_REV_KEYCompliance Data Requirement Revision Keyvarbinary160
9PRIORITYPriority for a Regulatory List Revision Worklist Entrytinyint30
10PROP_ACT_CODEProposed Activitynvarchar100 Allow NULL? 
11STATUS_CODEWorklist Entry Statusnvarchar100 Allow NULL? 
12REG_CHGRegulatory Changenvarchar100 Allow NULL? 
13REG_CHG_REASReason for Regulatory Changenvarchar100 Allow NULL? 
14TECH_ISSUE_INDTechnical Issue Indicator with an Worklist Entrychar10 Allow NULL? 
15LOG_MSG_IDMessage Classnvarchar200 Allow NULL? 
16LOG_MSG_NOMessage Numbernvarchar30 Allow NULL? 
17LOG_MSG_V1Message Variablenvarchar500 Allow NULL? 
18LOG_MSG_V2Message Variablenvarchar500 Allow NULL? 
19LOG_MSG_V3Message Variablenvarchar500 Allow NULL? 
20LOG_MSG_V4Message Variablenvarchar500 Allow NULL? 
21LOG_MSG_COUNTApplication Log: Cumulated message countint100 Allow NULL? 
22DECLARABLE_KEYKey of a Declarable Substance Assigned to a Worklist Entryvarbinary160
23EEW_WL_RC_ETRY_DDummy function in length 1char10 Allow NULL? 
NamePrimaryUniqueTypeColumns
EHPRCD_WL_E_RC_CPANoNoNONCLUSTEREDPARENT_KEY, MANDT
EHPRCD_WL_E_RC_C~0YesYesCLUSTEREDDB_KEY, MANDT