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	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

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	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

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	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: SAP Utilities :: Device Management
1	ERP EHP7	6.0	ETYP	66	5	Dev. Cat.: IS-U Additional Material Data	Device Management

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	MATNR	Material Number	nvarchar	18	0	CHAR	(N' ')	No	MARA	MATNR	Allow NULL?
3	KOMBINAT	Combination of a device category	nvarchar	8	0	CHAR	(N' ')	Yes		KOMBINAT	Allow NULL?
4	FUNKLAS	Function class	nvarchar	8	0	CHAR	(N' ')	Yes	TE055	FUNKLAS	Allow NULL?
5	BAUKLAS	Construction class	nvarchar	8	0	CHAR	(N' ')	Yes	TE237	BAUKLAS	Allow NULL?
6	BAUFORM	Device category description	nvarchar	30	0	CHAR	(N' ')	Yes		BAUFORM	Allow NULL?
7	BAUTXT	Text for description	nvarchar	30	0	CHAR	(N' ')	Yes		BAUTXT	Allow NULL?
8	PREISKLA	Price Class	nvarchar	10	0	CHAR	(N' ')	Yes	TE431	PREISKLA	Allow NULL?
9	PTBNUM	PTI number	nvarchar	15	0	CHAR	(N' ')	Yes		PTBNUM	Allow NULL?
10	DVGWNUM	GGWA number	nvarchar	15	0	CHAR	(N' ')	Yes		DVGWNUM	Allow NULL?
11	BGLKZ	Type of certification requirement	char	1	0	CHAR	(N' ')	Yes		BGLKZ	Allow NULL?
12	VLZEITT	Calibration validity (yrs) for ext. devs subject to certif.	decimal	2	0	DEC	((0))	Yes		VLZEIT
13	VLZEITTI	Internal certification period (years)	decimal	2	0	DEC	((0))	Yes		VLZEITI
14	VLZEITN	Old cal. validity/int. cert. period (yrs) until prod. year	decimal	2	0	DEC	((0))	Yes		VLZEITN
15	VLKZBAU	Prod. yr until which old calib. valid./int.insp.per.is valid	nvarchar	4	0	NUMC	(N'0000')	Yes		BISBAUJR	Allow NULL?
16	ZWGRUPPE	Register Group	nvarchar	8	0	CHAR	(N' ')	Yes	EZWG	E_ZWGRUPPE	Allow NULL?
17	EAGRUPPE	Input/output group	nvarchar	8	0	CHAR	(N' ')	Yes	EEAG	EAGRUPPE	Allow NULL?
18	MESSART	Type of measurement	char	1	0	CHAR	(N' ')	Yes		MESSART	Allow NULL?
19	UEBERVER	Transformation ratio	decimal	10	3	DEC	((0))	Yes		UEBERVER
20	BGLNETZ	Certify installed devices	char	1	0	CHAR	(N' ')	Yes		BGLNETZ	Allow NULL?
21	WGRUPPE	Winding group	nvarchar	8	0	CHAR	(N' ')	Yes	EWIK	WGRUPPE	Allow NULL?
22	PRIMWNR1	Winding number of active primary winding	nvarchar	2	0	NUMC	(N'00')	Yes		PRIMWNR	Allow NULL?
23	SEKWNR1	Winding number of active secondary winding	nvarchar	2	0	NUMC	(N'00')	Yes		SEKWNR	Allow NULL?
24	PRIMWNR2	Winding number of active primary winding	nvarchar	2	0	NUMC	(N'00')	Yes		PRIMWNR	Allow NULL?
25	SEKWNR2	Winding number of active secondary winding	nvarchar	2	0	NUMC	(N'00')	Yes		SEKWNR	Allow NULL?
26	AENAM	Name of Person Who Changed Object	nvarchar	12	0	CHAR	(N' ')	Yes		AENAM	Allow NULL?
27	AEDAT	Changed On	nvarchar	8	0	DATS	(N'00000000')	Yes		AEDAT	Allow NULL?
28	ZSPANNS	Register factor: secondary transformer voltage	decimal	4	1	DEC	((0))	Yes		E_ZSPANNS
29	ZSTROMS	Register factor: secondary transformer current	decimal	5	2	DEC	((0))	Yes		E_ZSTROMS
30	ZSPANNP	Register factor: primary transformer voltage	decimal	6	0	DEC	((0))	Yes		E_ZSPANNP
31	ZSTROMP	Register factor: primary transformer current	decimal	5	1	DEC	((0))	Yes		E_ZSTROMP
32	GRPMATNR	Number for group material for IS-U serialization	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	GRPMATNR	Allow NULL?
33	ORDER_CODE	Special Order Code for Dev./Dev. Category in Replacement	nvarchar	4	0	CHAR	(N' ')	Yes	TEWOCODES	ORDERCODE2	Allow NULL?
34	SPARTE	Division	nvarchar	2	0	CHAR	(N' ')	Yes	TSPA	SPARTE	Allow NULL?
35	NENNBEL	Nominal load	decimal	10	4	DEC	((0))	Yes		NENNBEL
36	KENNZTYP	Vehicle category	nvarchar	2	0	CHAR	(N' ')	Yes		KENNZ_TYP	Allow NULL?
37	KENNZTYP_TXT	Short Description of Repository Objects	nvarchar	60	0	CHAR	(N' ')	Yes		AS4TEXT	Allow NULL?
38	STELLPLATZ	Number of container spaces	nvarchar	2	0	NUMC	(N'00')	Yes		ANZ_PLATZ	Allow NULL?
39	HOEHEBEH	Height of container category	decimal	7	2	DEC	((0))	Yes		HOEHEBEH
40	BREITEBEH	Width of container category	decimal	7	2	DEC	((0))	Yes		BREITEBEH
41	TIEFEBEH	Depth of container category	decimal	7	2	DEC	((0))	Yes		TIEFEBEH
42	ABMEIH	Unit for the dimensions of the container category	nvarchar	3	0	UNIT	(N' ')	Yes	T006	ABMEIH	Allow NULL?
43	LADEZEIT	Pull-up time of container category	decimal	7	2	DEC	((0))	Yes		LADEZEIT
44	LADZ_EIH	Unit of pull-up time	nvarchar	3	0	UNIT	(N' ')	Yes	T006	LADZ_EIH	Allow NULL?
45	LADEVOL	Load volume	decimal	7	2	DEC	((0))	Yes		LADEVOL
46	LADV_EIH	Unit of load volume	nvarchar	3	0	UNIT	(N' ')	Yes	T006	LADV_EIH	Allow NULL?
47	GEW_ZUL	Maximum permissible load for container category	decimal	7	2	DEC	((0))	Yes		GEW_ZUL
48	GEWEIH	Unit of Weight	nvarchar	3	0	UNIT	(N' ')	Yes	T006	GEWEIH	Allow NULL?
49	EIGENTUM	Owner	nvarchar	2	0	CHAR	(N' ')	Yes		EIGENTUM	Allow NULL?
50	EIGENTUM_TXT	Short Description of Repository Objects	nvarchar	60	0	CHAR	(N' ')	Yes		AS4TEXT	Allow NULL?
51	LADV_TXT	Dimension Text	nvarchar	60	0	CHAR	(N' ')	Yes		DIMTEXT	Allow NULL?
52	LADZ_TXT	Dimension Text	nvarchar	60	0	CHAR	(N' ')	Yes		DIMTEXT	Allow NULL?
53	GEW_TXT	Dimension Text	nvarchar	60	0	CHAR	(N' ')	Yes		DIMTEXT	Allow NULL?
54	ABM_TXT	Dimension Text	nvarchar	60	0	CHAR	(N' ')	Yes		DIMTEXT	Allow NULL?
55	PRODUCT_AREA	Service Area	nvarchar	2	0	CHAR	(N' ')	Yes	TPRDCTAREA	PRODUCT_AREA	Allow NULL?
56	NOTIF_CODE	Notification code	nvarchar	4	0	CHAR	(N' ')	Yes	TENOCODES	NOTIF_CODE	Allow NULL?
57	G_INFOSATZ	Type of Device to be Created	char	1	0	CHAR	(N' ')	No		G_INFOSATZ	Allow NULL?
58	PPM_METER	Prepayment Meter	nvarchar	2	0	NUMC	(N'00')	Yes	TEPPM	PPM_METER	Allow NULL?
59	LOSSDTGROUP	Loss Determination Group	nvarchar	8	0	CHAR	(N' ')	Yes	TE1001	E_LOSSDTGROUP	Allow NULL?
60	RATING	Power Transformer: Rating	nvarchar	11	0	CHAR	(N' ')	Yes	TE1002	E_RATING	Allow NULL?
61	P_VOLTAGE	Power Transformer: Primary Voltage	nvarchar	8	0	CHAR	(N' ')	Yes	TE1002	E_P_VOLTAGE	Allow NULL?
62	S_VOLTAGE	Power Transformer: Secondary Voltage	nvarchar	8	0	CHAR	(N' ')	Yes	TE1002	E_S_VOLTAGE	Allow NULL?
63	AMS_DGRP	AMS Determination Group	nvarchar	10	0	CHAR	(N' ')	Yes	TEAMI_AMSDGRP	E_AMI_AMS_DGRP	Allow NULL?
64	AMCG_DGRP	AMCG Determination Group	nvarchar	10	0	CHAR	(N' ')	Yes	TEAMI_AMCGDGRP	E_AMI_AMCG_DGRP	Allow NULL?
65	SMART_METER	Advanced Meter	char	1	0	CHAR	(N' ')	Yes		E_AMI_SMART_METER	Allow NULL?
66	MSG_DGRP_ID	Message Attribute Determination Group	nvarchar	4	0	NUMC	(N'0000')	Yes	TEAMI_MSG_DGRP	E_AMI_MSG_DGRP_ID	Allow NULL?

Name	Primary	Unique	Type	Columns
ETYP~0	Yes	Yes	CLUSTERED	MATNR, MANDT
ETYP~EAG	No	No	NONCLUSTERED	EAGRUPPE, MANDT
ETYP~GMN	No	No	NONCLUSTERED	GRPMATNR, MANDT
ETYP~TZG	No	No	NONCLUSTERED	ZWGRUPPE, MANDT
ETYP~WGR	No	No	NONCLUSTERED	WGRUPPE, 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

66 COLUMNS | 5 INDEXES | ERP 6.0 | ETYP TABLE

TOP ERP 6.0 | ETYP COLUMNS

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

66 COLUMNS | 5 INDEXES | ERP 6.0 | ETYP TABLE

TOPERP 6.0 | ETYP COLUMNS

TOPERP 6.0 | ETYP INDEXES

TOP ERP 6.0 | ETYP COLUMNS

TOP ERP 6.0 | ETYP INDEXES