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

42 columns | Print definition?ERP 6.0  | CHANGED_TST

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1GHO_DM_CODEDeferment Code Check8CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
2GHO_DM_CODE_TDeferment Code Description8CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
3GHO_DM_EFFECTSDeferment Event Effects17CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
4GHO_DM_EVENTDeferment Event Data16CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
5GHO_DM_LINK_EVNTDeferment Event Relations (Linked Events)7CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
6GHO_DM_OTYP_CODOrder Type and Deferment Code Relation7CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
7GHO_DM_PLANSDeferment Plans Data7CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
8GHO_DM_RESULTSDeferment Results24CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
9GHO_FORM_MEAS_HAllocation Formula Measurements Header16CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
10GHO_MEAS_PRIO_HAllocation Rules Measurement Priority Header13CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
11GHO_WELL_PRIORCapture Measurement - Well Test Priority13CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPMeasurement System
12GHO_IMRG_STD_HHeader for Standardized QCI Volumes17CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPOwnership
13GHO_OWNRES_HOwnership results Header6CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPProduction Allocation
14GHO_ALLOCRES_HAllocation Results Header18CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
15GHO_ALLOC_OVROBSOLETE - GHO Allocation Theoratical Override17CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
16GHO_ALLOC_RES_HOBSOLETE - Table for storing allocation results (Header)17CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
17GHO_CHM_ANL_HChemical analysis header data15CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
18GHO_COM_WC_HCommingled Well Completion Header11CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
19GHO_NODERULE_HNode Allocation Rules Header14CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
20GHO_NODE_DS_SP_HNode Down Stream Split header table12CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
21GHO_NODE_RULE_HOBSOLETE - Node Allocation Rules Header14CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
22GHO_NWRULE_HNetwork Allocation Rules Header17CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
23GHO_NW_RULE_HOBSOLETE - Production Flow Network Allocation Rules Header15CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
24GHO_NW_UOM_RULEOBSOLETE - UoM Rule for Network12CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
25GHO_REP_MATReproduced Material details table12CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
26GHO_RULE_LOG_HAllocation Rule Log Header30CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
27GHO_SIMU_CAPSimulation: Modified network object capacities11CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
28GHO_SIMU_DOWNTIMSimulation: Predicted downtimes11CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
29GHO_SIMU_DS_SP_HSimulation: Node Down Stream Split rules header13CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
30GHO_SIMU_FLRT_HSimulation: Flow Rate Header10CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
31GHO_SIMU_HSimulation Header11CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
32GHO_SIMU_NDRHSimulation: Node Allocation Rules Header15CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
33GHO_SIMU_NWRHSimulation: Network Allocation Rules Header18CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
34GHO_SIMU_REP_MATSimulation: Reproduced Material details table13CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
35GHO_SIMU_TOR_HSimulation: Theoretical Override Header17CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
36GHO_SIMU_UOMRHSimulation: Network UoM Rule Header14CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
37GHO_SIMU_WCOM_HSimulation: Commingled Well Completion Header12CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
38GHO_SIMU_WC_OVRSimulation: Well Completion Override Details Table14CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
39GHO_THEO_OVR_HAllocation Theoretical Override Header16CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
40GHO_UOM_RULE_HNetwork UoM Rule Header13CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
41GHO_WC_OVRWell Completion Override Details Table13CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
42GHO_WC_RULE_LOGLog table for Well Completion Override, Reproduce material23CHANGED_TSTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150