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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

72 columns | Print definition?ERP 6.0  | NETID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1GHO_ALC_SRC_CHEMChemical Analysis Source data for alloc results invalidation6NETIDNetwork Object IDnvarchar300
2GHO_ALC_SRC_FORMFormula Source data for Allocation results invalidation3NETIDNetwork Object IDnvarchar300
3GHO_ALC_SRC_NDRLSource Table for Node Rule4NETIDNetwork Object IDnvarchar300
4GHO_ALC_SRC_NRULSource Table for Network Rule4NETIDNetwork Object IDnvarchar300
5GHO_ALC_SRC_THEOObsolete:Theoretical Src data for Alloc reslts invalidation4NETIDNetwork Object IDnvarchar300
6GHO_ALC_SRC_TRTheoretical Source data for Allocation results invalidation3NETIDNetwork Object IDnvarchar300
7GHO_ALC_SRC_UOMRSource Table for UOM Rule4NETIDNetwork Object IDnvarchar300
8GHO_ALC_SRC_WCObsolete:Allocation Source Data from Well completion6NETIDNetwork Object IDnvarchar300
9GHO_ALC_SRC_WCTAllocation Source Data from Well completion8NETIDNetwork Object IDnvarchar300
10GHO_ALC_SRC_ZNLZonal Source data for Allocation Results Invalidation4NETIDNetwork Object IDnvarchar300
11GHO_ALLOC_PREPAllocation Results Header4NETIDNetwork Object IDnvarchar300
12GHO_ALLOC_RUN_JBAllocation Results Header4NETIDNetwork Object IDnvarchar300
13GHO_DM_ALLOC_RESAllocation Results2NETIDNetwork Object IDnvarchar300
14GHO_DM_RESULTSDeferment Results2NETIDNetwork Object IDnvarchar300
15GHO_FORM_MEAS_HAllocation Formula Measurements Header3NETIDNetwork Object IDnvarchar300
16GHO_PPA_DATAPPA request details5NETIDNetwork Object IDnvarchar300
17GHO_WELL_PRIORCapture Measurement - Well Test Priority2NETIDNetwork Object IDnvarchar300
18GHO_WELL_STD_HTable for storing the well test standard header values2NETIDNetwork Object IDnvarchar300
TOPMeasurement System
19GHO_IMRG_STD_HHeader for Standardized QCI Volumes2NETIDProduction Flow Network IDnvarchar300
TOPNetwork Modeler
20GHO_NETWORKProduction Network2NETIDProduction Network Identificationnvarchar80
21GHO_NETWORK_TProduction Network Language Dependent Texts2NETIDProduction Network Identificationnvarchar80
22GHO_OBJ_ATTRNetwork Object Attributes2NETIDProduction Network Identificationnvarchar80
23GHO_OBJ_ATTR_LNetwork Object Attributes Link Level2NETIDProduction Network Identificationnvarchar80
24GHO_OBJ_GR_ATTRNetwork Object Graphical Attributes2NETIDProduction Network Identificationnvarchar80
25GHO_SIM_INETObject Links for Network Simulation3NETIDProduction Network Identificationnvarchar80
TOPNetwork Objects
26GHO_IFLOT_EXTFunction location extension table109NETIDNetwork identificationnvarchar80
TOPNetwork Operations
27GHO_NETVER_HHeader Data of a Production Network Version2NETIDProduction Network Identificationnvarchar80
28GHO_NETVER_ITMItems of a Production Network Version2NETIDProduction Network Identificationnvarchar80
29GHO_NETVER_OBJLObject Links assigned to a Production Network Version2NETIDProduction Network Identificationnvarchar80
30GHO_NETVER_TXTemplate Set: Language Dependent Descriptions2NETIDProduction Network Identificationnvarchar80
31GHO_OTSGHO Order Template Structures3NETIDProduction Network Identificationnvarchar80
32GHO_PP_PTABLE_HDHeader Table for Results of GHO Planning Table3NETIDNetwork Object IDnvarchar300
33GHO_PP_PT_FILTABFilter Settings Table for Planning Table3NETIDNetwork Object IDnvarchar300
34GHO_PP_PT_UDATAUser specific Data for the Planning Table4NETIDNetwork Object IDnvarchar300
TOPObject Networking
35INETObject networking4NETIDNetwork identificationnvarchar80
36T372INetwork identification2NETIDNetwork identificationnvarchar80
37T372I_TLanguage-dependent texts for network ID2NETIDNetwork identificationnvarchar80
TOPProduct Configurator
38COMM_CFGCNTDEPDependency Nets that are attached to Tasks/Events4NETIDInternal identifier of a model elementint100
39COMM_CFGDEPBasic Data for Dependencies (including Nets)8NETIDInternal identifier of a model elementint100
40COMM_CFGDEPCOMCompiled Code for Dependency Nets3NETIDInternal identifier of a model elementint100
41COMM_CFGDEPDNNDiscrimination Nodes3NETIDInternal identifier of a model elementint100
42COMM_CFGDEPPATPattern3NETIDInternal identifier of a model elementint100
43COMM_CFGDEPSPNSimple Pattern Nodes3NETIDInternal identifier of a model elementint100
44COMM_CFGDEPVARPattern3NETIDInternal identifier of a model elementint100
45COMM_CFGNETBLOBBLOBed Dependency Nets3NETIDInternal identifier of a model elementint100
46COMM_CFGNETOBJPosition Numbers of the Characteristics of Classes3NETIDInternal identifier of a model elementint100
TOPProduction Allocation
47GHO_ALLOCRES_HAllocation Results Header3NETIDNetwork Object IDnvarchar300
48GHO_ALLOC_OVROBSOLETE - GHO Allocation Theoratical Override2NETIDNetwork Object IDnvarchar300
49GHO_ALLOC_RES_HOBSOLETE - Table for storing allocation results (Header)3NETIDNetwork Object IDnvarchar300
50GHO_COM_WC_HCommingled Well Completion Header3NETIDNetwork Object IDnvarchar300
51GHO_INET_LOGChange log table for INET - productive networks2NETIDNetwork identificationnvarchar80
52GHO_RULE_LOG_HAllocation Rule Log Header25NETIDNetwork Object IDnvarchar300
53GHO_SIMU_CAPSimulation: Modified network object capacities2NETIDNetwork Object IDnvarchar300
54GHO_SIMU_DOWNTIMSimulation: Predicted downtimes2NETIDNetwork Object IDnvarchar300
55GHO_SIMU_FLRT_HSimulation: Flow Rate Header3NETIDNetwork Object IDnvarchar300
56GHO_SIMU_HSimulation Header2NETIDNetwork Object IDnvarchar300
57GHO_SIMU_H_TSimulation Header Language Dependent Texts2NETIDNetwork Object IDnvarchar300
58GHO_SIMU_INETLOGLog table for simulation changes in production network2NETIDNetwork identificationnvarchar80
59GHO_SIMU_INETXLanguage-dependent texts for Links in Simulated Networks3NETIDNetwork identificationnvarchar80
60GHO_SIMU_TOR_HSimulation: Theoretical Override Header3NETIDNetwork Object IDnvarchar300
61GHO_SIMU_WCOM_HSimulation: Commingled Well Completion Header4NETIDNetwork Object IDnvarchar300
62GHO_THEO_OVR_HAllocation Theoretical Override Header3NETIDNetwork Object IDnvarchar300
TOPProduction Campaign
63PCMO4Production campaign pegged reqmt resource network9NETIDObject ID of the resourcenvarchar80
TOPRouting
64PLKOTask list - header54NETIDObject ID of the resourcenvarchar80
TOPSales and Distribution
65SCECNTDEPAssignment of Dependencies to Control Knowledge4NETIDInternal counter for objects in an SCE knowledge basenvarchar60
66SCEDEPDependencies (Basic Data)6NETIDInternal counter for objects in an SCE knowledge basenvarchar60
67SCEDEPCOMCompilation of Dependency Nets3NETIDInternal counter for objects in an SCE knowledge basenvarchar60
68SCEDEPDNNDNNs of Dependency3NETIDInternal counter for objects in an SCE knowledge basenvarchar60
69SCEDEPPATPattern of Dependency3NETIDInternal counter for objects in an SCE knowledge basenvarchar60
70SCEDEPSPNSPNs of Dependency3NETIDInternal counter for objects in an SCE knowledge basenvarchar60
71SCEDEPVARVariables of Dependencies3NETIDInternal counter for objects in an SCE knowledge basenvarchar60
TOPTechnical Objects
72EAML_D_EVTEAML: Events DB Table17NETIDNetwork identificationnvarchar80