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	TVPODO1	85	2	Proof of delivery - Oil conversion parameters	Hydrocarbon Product Management

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

Name	Primary	Unique	Type	Columns
TVPODO1~0	Yes	Yes	CLUSTERED	MANDT, HANDLE_LIPS, GRUND
TVPODO1~OIB	No	No	NONCLUSTERED	MANDT, DEFAULT_GUID

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

85 COLUMNS | 2 INDEXES | ERP 6.0 | TVPODO1 TABLE

TOP ERP 6.0 | TVPODO1 COLUMNS

TOP ERP 6.0 | TVPODO1 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

85 COLUMNS | 2 INDEXES | ERP 6.0 | TVPODO1 TABLE

TOPERP 6.0 | TVPODO1 COLUMNS

TOPERP 6.0 | TVPODO1 INDEXES

TOP ERP 6.0 | TVPODO1 COLUMNS

TOP ERP 6.0 | TVPODO1 INDEXES