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
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
Environment, Health and Safety :: SAP EHS Management :: Risk Assessment
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0EHHSSD_RAC_ROOT586Risk Assesment ActionsRisk Assessment
SQL:  selectupdate insert create

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

SELECT MANDT, DB_KEY, DATETIME_CR, USER_ID_CR, DATETIME_CH, USER_ID_CH, BO_KEY_REF, ROOT_KEY_REF, NODE_KEY_REF, KEY_REF, PC_BO_KEY_REF, PC_ROOT_KEY_REF, DEF_ROOT_KEY_REF, ID, EHSM_COMPONENT, PURPOSE, VARIANT, STATUS, TITLE, SUBJECT, CATEGORY, TYPE, PRIORITY, PROT_GOAL, EFFECTIV, EA_ST_TIMESTAMP, EA_ST_TI_ZO, DUE_TIMESTAMP, DUE_TI_ZO, DUE_N_TH, DUE_TYPE, RESP_ID, IMPLEM_ID, APPR_ID, IMPL_TIMESTAMP, IMPL_TI_ZO, APPR_TIMESTAMP, APPR_TI_ZO, PLANT_ID, FUNC_LOC_ID, EQU_ID, EQU_TYPE, WF_EXIST_IND, EXT_NOTIF_ID, EXT_NOTIF_TYPE, EXT_NOTIF_PRIO, MAT_ID, PROC_SETUP_KEY, DESC_KEY_REF, ACT_NATURE_TS, MIGRATION_SRC, CH_REQ_TYPE, CH_REQ_IMPACT, CH_REQ_EMERGENCY, CH_REQ_LIFETIME, CH_REQ_ID, CH_REQ_REP_ID, EEW_ACT_ROOT_D FROM EHHSSD_RAC_ROOT
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2DB_KEYNodeIDvarbinary160
3DATETIME_CRDate/Time of Item Creationdecimal150
4USER_ID_CRObject Created Bynvarchar120 Allow NULL? 
5DATETIME_CHDate/Time of Item Changedecimal150
6USER_ID_CHObject Changed Bynvarchar120 Allow NULL? 
7BO_KEY_REFBO Reference - Definition Key of the Business Objectvarbinary160
8ROOT_KEY_REFBO Reference - Instance Key of the ROOT Nodevarbinary160
9NODE_KEY_REFBO Reference - Definition Key of the Subnodevarbinary160
10KEY_REFBO Reference - Instance Key of the Subnodevarbinary160
11PC_BO_KEY_REFPCBO Reference - Definition Key of the Process Control BOvarbinary160
12PC_ROOT_KEY_REFPCBO Reference - Instance Key of the ROOT Nodevarbinary160
13DEF_ROOT_KEY_REFNodeIDvarbinary160
14IDIDnvarchar200 Allow NULL? 
15EHSM_COMPONENTComponent of EHS Managementnvarchar50 Allow NULL? 
16PURPOSEProcess Purposenvarchar230 Allow NULL? 
17VARIANTName of Process Variantnvarchar300 Allow NULL? 
18STATUSStatusnvarchar20 Allow NULL? 
19TITLETitlenvarchar600 Allow NULL? 
20SUBJECTSubtypenvarchar210 Allow NULL? 
21CATEGORYCategorynvarchar30 Allow NULL? 
22TYPETypenvarchar210 Allow NULL? 
23PRIORITYPrioritychar10 Allow NULL? 
24PROT_GOALProtection Goalnvarchar210 Allow NULL? 
25EFFECTIVEffectivenessnvarchar210 Allow NULL? 
26EA_ST_TIMESTAMPStart date (UTC)decimal150
27EA_ST_TI_ZOTime Zone of Earliest Start Datenvarchar60 Allow NULL? 
28DUE_TIMESTAMPDue date (UTC)decimal150
29DUE_TI_ZOTime Zone for Due Datenvarchar60 Allow NULL? 
30DUE_N_THDue Date Rangeint100 Allow NULL? 
31DUE_TYPEDue Typenvarchar30 Allow NULL? 
32RESP_IDResponsiblenvarchar130 Allow NULL? 
33IMPLEM_IDImplementornvarchar130 Allow NULL? 
34APPR_IDApprovernvarchar130 Allow NULL? 
35IMPL_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
36IMPL_TI_ZOTime Zone of Implementationnvarchar60 Allow NULL? 
37APPR_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
38APPR_TI_ZOTime Zone of Approvalnvarchar60 Allow NULL? 
39PLANT_IDPlant IDnvarchar40 Allow NULL? 
40FUNC_LOC_IDFunctional Location IDnvarchar300 Allow NULL? 
41EQU_IDEquipmentnvarchar180 Allow NULL? 
42EQU_TYPEEquipment Typenvarchar100 Allow NULL? 
43WF_EXIST_INDProcess (Workflow) Existschar10 Allow NULL? 
44EXT_NOTIF_IDNotification IDnvarchar120 Allow NULL? 
45EXT_NOTIF_TYPENotification Typenvarchar20 Allow NULL? 
46EXT_NOTIF_PRIONotification Prioritychar10 Allow NULL? 
47MAT_IDMaterialnvarchar180 Allow NULL? 
48PROC_SETUP_KEYNodeIDvarbinary160
49DESC_KEY_REFNodeIDvarbinary160
50ACT_NATURE_TSAction Nature Ternarychar10 Allow NULL? 
51MIGRATION_SRCMigration Sourcenvarchar600 Allow NULL? 
52CH_REQ_TYPEChange Request Typenvarchar30 Allow NULL? 
53CH_REQ_IMPACTChange Request Impactnvarchar20 Allow NULL? 
54CH_REQ_EMERGENCYChange Request Emergencychar10 Allow NULL? 
55CH_REQ_LIFETIMEChange Request Lifetimenvarchar30 Allow NULL? 
56CH_REQ_IDChange Request IDnvarchar200 Allow NULL? 
57CH_REQ_REP_IDChange Request Reporternvarchar100 Allow NULL? 
58EEW_ACT_ROOT_DDummy function in length 1char10 Allow NULL? 
NamePrimaryUniqueTypeColumns
EHHSSD_RAC_ROOT~0YesYesCLUSTEREDDB_KEY, MANDT
EHHSSD_RAC_ROOT~ADNoNoNONCLUSTEREDDESC_KEY_REF, MANDT
EHHSSD_RAC_ROOT~AINoNoNONCLUSTEREDID, MANDT
EHHSSD_RAC_ROOT~AKNoNoNONCLUSTEREDKEY_REF, MANDT
EHHSSD_RAC_ROOT~ARNoNoNONCLUSTEREDROOT_KEY_REF, MANDT
EHHSSD_RAC_ROOT~DENoNoNONCLUSTEREDDEF_ROOT_KEY_REF, MANDT