ERP 6.0: Top 10 requests

	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	OJDT	100	Journal Entry
6	INV1	265	A/R Invoice - Rows
7	OPCH	386	A/P Invoice
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

B1 8.8: Top 10 requests

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: Industry Solution Oil :: Downstream :: Hydrocarbon Product Management
1	ERP EHP7	6.0	MSEGO1	90	2	Quantity Conversion Parameters for Material Documents	Hydrocarbon Product Management

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	MBLNR	Number of Material Document	nvarchar	10	0	Allow NULL?
3	MJAHR	Material Document Year	nvarchar	4	0	Allow NULL?
4	ZEILE	Item in Material Document	nvarchar	4	0	Allow NULL?
5	LINE_ID	Unique identification of document line	nvarchar	6	0	Allow NULL?
6	PARENT_ID	Identifier of immediately superior line	nvarchar	6	0	Allow NULL?
7	LINE_DEPTH	Hierarchy level of line in document	nvarchar	2	0	Allow NULL?
8	MAA_URZEI	Original Line for Account Assignment Item in Material Doc.	nvarchar	4	0	Allow NULL?
9	UMRSL	Conversion Group (Oil, Natural Gas,..)	nvarchar	4	0	Allow NULL?
10	CMODE	Conversion Mode	char	1	0	Allow NULL?
11	FDICHEH	Unit for densities at standard/base conditions	nvarchar	3	0	Allow NULL?
12	FDICH	Fixed Density	float	15	16
13	COEFF	Quantity Conversion Coefficient	float	15	16
14	BDICHEH	Unit for densities at standard/base conditions	nvarchar	3	0	Allow NULL?
15	BDICH	Oil/gas density at standard/base conditions	float	15	16
16	BHVALEH	Heating value unit at standard/base conditions (natural gas)	nvarchar	3	0	Allow NULL?
17	BHVAL	Heating value at standard/base conditions (natural gas)	float	15	16
18	TSTMP	Oil/Gas Test Temperature: Observed Density	float	15	16
19	TSTEH	Test Temperature Unit (Density): Measurement	nvarchar	3	0	Allow NULL?
20	MTTMP	Oil/Gas Material Temperature: Observed Quantity	float	15	16
21	MTTEH	Oil/Gas Material Temperature Unit: Observed Quantity	nvarchar	3	0	Allow NULL?
22	THVAL	Heating value at test conditions (natural gas): observed	float	15	16
23	TDICHEH	Unit for densities of petroleum products and natural gas	nvarchar	3	0	Allow NULL?
24	TDICH	Oil/Gas Test Density	float	15	16
25	MTPRES	Oil/gas material pressure: observed quantity	float	15	16
26	MTPRESEH	Oil/gas material pressure unit: observed quantity	nvarchar	3	0	Allow NULL?
27	TPRED	Oil/gas test pressure: metering (obs. density)	float	15	16
28	TPREDEH	Oil/Gas test press. unit: metering (density)	nvarchar	3	0	Allow NULL?
29	TPRHV	Natural gas test pressure: combustion (obs. heating value )	float	15	16
30	TPRHVEH	Natural gas test pressure unit: combustion ( heating value )	nvarchar	3	0	Allow NULL?
31	TTMPHV	Natural gas test temperature: combustion (obs. heat. value )	float	15	16
32	TTMPHVEH	Natural gas test temp. unit: combustion (heating value)	nvarchar	3	0	Allow NULL?
33	ATPRES	Atmospheric pressure of the air surrounding a product	float	15	16
34	ATPRESEH	Atmospheric pressure unit	nvarchar	3	0	Allow NULL?
35	VAPRES	Vapor pressure of liquid petroleum gases (LPG)	float	15	16
36	VAPRESEH	Vapor pressure unit (LPG)	nvarchar	3	0	Allow NULL?
37	THVALEH	Heating value unit	nvarchar	3	0	Allow NULL?
38	MTCOMBTMP	Natural gas material combustion temp.: observed quantity	float	15	16
39	MTCOMBTEH	Natural gas material combustion temp. unit: obs. quantity	nvarchar	3	0	Allow NULL?
40	MTCOMBPRES	Natural gas material combustion pressure: observed quantity	float	15	16
41	MTCOMBPRESEH	Natural gas material combustion pres. unit: oberved quantity	nvarchar	3	0	Allow NULL?
42	TSTMPCAL	Natural gas: Calorimeter test temperature (density)	float	15	16
43	TSTMPCALEH	Natural gas: unit for calorimeter test temperature (density)	nvarchar	3	0	Allow NULL?
44	TPREDCAL	Natural gas: Calorimeter test pressure (density)	float	15	16
45	TPREDCALEH	Natural gas: Unit for calorimeter test pressure (density)	nvarchar	3	0	Allow NULL?
46	HYDRO	Hydrometer Correction Indicator	char	1	0	Allow NULL?
47	ABIND	Air Bouyancy Indicator	char	1	0	Allow NULL?
48	ABFAC	Air Bouyancy Factor	decimal	3	1
49	MCF	Meter correction factor	float	15	16
50	BSWCN	BSW %	float	15	16
51	BSWCNEH	BSW % unit (volume %, mol %, mass % or proportion )	nvarchar	3	0	Allow NULL?
52	HVCLS	Heating value class (calorific value class)	nvarchar	2	0	Allow NULL?
53	HVCLS_TO	Heating value class (calorific value class)	nvarchar	2	0	Allow NULL?
54	DEFAULT_GUID	GUID in 'CHAR' Format in Uppercase	nvarchar	32	0	Allow NULL?
55	CH4RATIO	Natural gas CH4 content (ratio)	float	15	16
56	N2RATIO	Natural gas N2 (nitrogen) content (ratio)	float	15	16
57	CO2RATIO	Natural gas CO2 content (ratio)	float	15	16
58	C2H6RATIO	Natural gas C2H6 (ethane) content (ratio)	float	15	16
59	C3H8RATIO	Natural gas C3H8 (propane) content (ratio)	float	15	16
60	H2ORATIO	Natural gas H2O content (ratio)	float	15	16
61	H2SRATIO	Natural gas H2S content (ratio)	float	15	16
62	H2RATIO	Natural gas H2 (Hydrogen) content (ratio)	float	15	16
63	CORATIO	Natural gas CO content (ratio)	float	15	16
64	O2RATIO	Natural gas oxygen (O2) content (ratio)	float	15	16
65	ISOC4H10RATIO	Natural gas ISO-C4H10 (iso-butane ) content (ratio)	float	15	16
66	NC4H10RATIO	Natural gas n-C4H10 (n-butane ) content (ratio)	float	15	16
67	ISOC5H12RATIO	Natural gas ISO-C5H12 (ISO-pentane ) content (ratio)	float	15	16
68	NC5H12RATIO	Natural gas n-C5H12 (n-pentane ) content (ratio)	float	15	16
69	C6H14RATIO	Natural gas C6H14 (n-hexane ) content (ratio)	float	15	16
70	C7H16RATIO	Natural gas C7H16 (n-heptane ) content (ratio)	float	15	16
71	C8H18RATIO	Natural gas C8H18 (n-octane ) content (ratio)	float	15	16
72	C9H20RATIO	Natural gas C9H20 (n-Nonane ) content (ratio)	float	15	16
73	C10H22RATIO	Natural gas C10H22 (n-Decane ) content (ratio)	float	15	16
74	HERATIO	Natural gas He (Helium) content (ratio)	float	15	16
75	ARRATIO	Natural gas Argon content (ratio)	float	15	16
76	GASCOMPRATEH	Unit (vol. %, mol % or mass % ) of natural gas composition	nvarchar	3	0	Allow NULL?
77	MOLDEN	Natural gas molar density (mol/volume) at standard condition	float	15	16
78	MOLDENEH	Unit for molar density at base conditions ( nat.gas)	nvarchar	3	0	Allow NULL?
79	MOLWEIGHT	Molecular weight of natural gas:return value from AGA c-code	float	15	16
80	HYDROCARBMOLFRAC	Hydrocarbon mole fraction calculated from AGA c-code	float	15	16
81	MOLWEIGHTEH	Unit for molar mass	nvarchar	3	0	Allow NULL?
82	CUSTPARCHAR1	Customer parameter character field 1	nvarchar	3	0	Allow NULL?
83	CUSTPARFLOAT1	Customer parameter float 1	float	15	16
84	CUSTEH1	Customer parameter 1 unit	nvarchar	3	0	Allow NULL?
85	CUSTPARCHAR2	Customer parameter character field 2	nvarchar	3	0	Allow NULL?
86	CUSTPARFLOAT2	Customer parameter float 2	float	15	16
87	CUSTEH2	Customer parameter 2 unit	nvarchar	3	0	Allow NULL?
88	CUSTPARCHAR3	Customer parameter character field 3	nvarchar	3	0	Allow NULL?
89	CUSTPARFLOAT3	Customer parameter float 3	float	15	16
90	CUSTEH3	Customer parameter 3 unit	nvarchar	3	0	Allow NULL?

Name	Primary	Unique	Type	Columns
MSEGO1~0	Yes	Yes	CLUSTERED	ZEILE, MJAHR, MBLNR, MANDT
MSEGO1~OIB	No	No	NONCLUSTERED	DEFAULT_GUID, MANDT

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

90 COLUMNS | 2 INDEXES | ERP 6.0 | MSEGO1 TABLE

TOP ERP 6.0 | MSEGO1 COLUMNS

TOP ERP 6.0 | MSEGO1 INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

90 COLUMNS | 2 INDEXES | ERP 6.0 | MSEGO1 TABLE

TOPERP 6.0 | MSEGO1 COLUMNS

TOPERP 6.0 | MSEGO1 INDEXES

TOP ERP 6.0 | MSEGO1 COLUMNS

TOP ERP 6.0 | MSEGO1 INDEXES