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

43 columns | Print definition?ERP 6.0  | CREATED_TST

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1GHO_DM_CODEDeferment Code Check6CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
2GHO_DM_CODE_TDeferment Code Description6CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
3GHO_DM_EFFECTSDeferment Event Effects15CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
4GHO_DM_EVENTDeferment Event Data14CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
5GHO_DM_LINK_EVNTDeferment Event Relations (Linked Events)5CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
6GHO_DM_OTYP_CODOrder Type and Deferment Code Relation5CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
7GHO_DM_PLANSDeferment Plans Data5CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
8GHO_DM_RESULTSDeferment Results22CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
9GHO_FORM_MEAS_HAllocation Formula Measurements Header14CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
10GHO_MEAS_PRIO_HAllocation Rules Measurement Priority Header11CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
11GHO_PPA_DATAPPA request details15CREATED_TSTPPA Request Created Timenvarchar60
12GHO_WELL_PRIORCapture Measurement - Well Test Priority11CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPMeasurement System
13GHO_IMRG_STD_HHeader for Standardized QCI Volumes15CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPOwnership
14GHO_OWNRES_HOwnership results Header4CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPProduction Allocation
15GHO_ALLOCRES_HAllocation Results Header16CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
16GHO_ALLOC_OVROBSOLETE - GHO Allocation Theoratical Override15CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
17GHO_ALLOC_RES_HOBSOLETE - Table for storing allocation results (Header)15CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
18GHO_CHM_ANL_HChemical analysis header data13CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
19GHO_COM_WC_HCommingled Well Completion Header9CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
20GHO_NODERULE_HNode Allocation Rules Header12CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
21GHO_NODE_DS_SP_HNode Down Stream Split header table10CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
22GHO_NODE_RULE_HOBSOLETE - Node Allocation Rules Header12CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
23GHO_NWRULE_HNetwork Allocation Rules Header15CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
24GHO_NW_RULE_HOBSOLETE - Production Flow Network Allocation Rules Header13CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
25GHO_NW_UOM_RULEOBSOLETE - UoM Rule for Network10CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
26GHO_REP_MATReproduced Material details table10CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
27GHO_RULE_LOG_HAllocation Rule Log Header28CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
28GHO_SIMU_CAPSimulation: Modified network object capacities9CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
29GHO_SIMU_DOWNTIMSimulation: Predicted downtimes9CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
30GHO_SIMU_DS_SP_HSimulation: Node Down Stream Split rules header11CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
31GHO_SIMU_FLRT_HSimulation: Flow Rate Header8CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
32GHO_SIMU_HSimulation Header9CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
33GHO_SIMU_NDRHSimulation: Node Allocation Rules Header13CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
34GHO_SIMU_NWRHSimulation: Network Allocation Rules Header16CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
35GHO_SIMU_REP_MATSimulation: Reproduced Material details table11CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
36GHO_SIMU_TOR_HSimulation: Theoretical Override Header15CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
37GHO_SIMU_UOMRHSimulation: Network UoM Rule Header12CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
38GHO_SIMU_WCOM_HSimulation: Commingled Well Completion Header10CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
39GHO_SIMU_WC_OVRSimulation: Well Completion Override Details Table12CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
40GHO_THEO_OVR_HAllocation Theoretical Override Header14CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
41GHO_UOM_RULE_HNetwork UoM Rule Header11CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
42GHO_WC_OVRWell Completion Override Details Table11CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
43GHO_WC_RULE_LOGLog table for Well Completion Override, Reproduce material21CREATED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150