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 :: SAP Media :: Master Data
1	ERP EHP7	6.0	JGTEUWV	102	1	IS-M: Retailer	Master Data

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	EWKUN	IS-M: Retailer	nvarchar	10	Allow NULL?
3	ERFUSER	Created By	nvarchar	12	Allow NULL?
4	ERFDATE	Created On	nvarchar	8	Allow NULL?
5	ERFTIME	Time Created	nvarchar	6	Allow NULL?
6	AENUSER	Last Changed By	nvarchar	12	Allow NULL?
7	AENDATE	Date of Last Change	nvarchar	8	Allow NULL?
8	AENTIME	Time of Last Change	nvarchar	6	Allow NULL?
9	XEUWLOE	IS-M: Deletion Indicator (Role-Specific)	char	1	Allow NULL?
10	ANZMIT	IS-M: Number of Retail Employees	nvarchar	5	Allow NULL?
11	EVKSTART	IS-M: Point of Sale Category	nvarchar	2	Allow NULL?
12	EVKSTBEZ	POS Type	nvarchar	4	Allow NULL?
13	SEASON	Season Indicator	nvarchar	2	Allow NULL?
14	CHAINCODE	Retail Chain to Which POS Belongs	nvarchar	10	Allow NULL?
15	CHAINCHANNEL	Distribution Channel of Retail Chain to Which POS Belongs	nvarchar	10	Allow NULL?
16	CHAINID	ID of POS in Retail Chain	nvarchar	10	Allow NULL?
17	SHOPINSHOP	IS-M: Shop in Shop Indicator	char	1	Allow NULL?
18	SHOPINSHOP_AREA	POS Shelf Space - Shop-in-Shop	nvarchar	2	Allow NULL?
19	SHOP_CATEGORY	Category of Main Business (Shop-in-Shop)	nvarchar	4	Allow NULL?
20	EVKFLAECHE	IS-M: POS Area Key	nvarchar	2	Allow NULL?
21	ISMGEOKATEGORIE	Geography Category (Geographical Location) for Point of Sale	nvarchar	2	Allow NULL?
22	NO_OF_POS	Number of POS with Same Address	smallint	5
23	NO_OF_SUPPLIERS	Number of Press Vendors for a Point of Sale	smallint	5
24	PRESS_SALESCAT	Type of Press Products	nvarchar	5	Allow NULL?
25	PRESS_SALESVOL	Weekly Press Sales	nvarchar	5	Allow NULL?
26	IUMSEINFL	Internal (Primary) Influencing Factor for POS Sales	nvarchar	2	Allow NULL?
27	IUMSEINFL2	Internal (Secondary) Influencing Factor for POS Sales	nvarchar	2	Allow NULL?
28	IUMSEINFL3	Internal (Tertiary) Influencing Factor for POS Sales	nvarchar	2	Allow NULL?
29	EUMSEINFL	External Sales Influence at POS (Primary)	nvarchar	2	Allow NULL?
30	EUMSEINFL2	External (Secondary) Influencing Factor for POS Sales	nvarchar	2	Allow NULL?
31	EUMSEINFL3	External (Tertiary) Influencing Factor for POS Sales	nvarchar	2	Allow NULL?
32	EFREQUENZ	IS-M: POS Customer Frequency per Week	char	1	Allow NULL?
33	EFREQUENCE_ORIG	POS: Origin of Customer Frequency	nvarchar	2	Allow NULL?
34	CASH_SCANNER	Scanner Cash Desk at Point of Sale	char	1	Allow NULL?
35	SALES_COUNTER	Sales Counter at Point of Sale	char	1	Allow NULL?
36	EBEDIENART	Service Type at Point of Sale	char	1	Allow NULL?
37	ISMNUMBERPOSTERS	Number of Advertising Spaces at Point of Sale	smallint	5
38	ISMPLANCALENDER	Planning Calendar for Point of Sale	nvarchar	2	Allow NULL?
39	BUSINESSHOURS_ID	Business Hours ID (Default Number)	nvarchar	3	Allow NULL?
40	OPEN_MOR_MO	Business Hours: Monday Mornings From	nvarchar	6	Allow NULL?
41	CLOSE_MOR_MO	Business Hours: Monday Mornings To	nvarchar	6	Allow NULL?
42	OPEN_AFT_MO	Business Hours: Monday Afternoons From	nvarchar	6	Allow NULL?
43	CLOSE_AFT_MO	Business Hours: Monday Afternoons To	nvarchar	6	Allow NULL?
44	OPEN_MOR_TU	Business Hours: Tuesday Mornings From	nvarchar	6	Allow NULL?
45	CLOSE_MOR_TU	Business Hours: Tuesday Mornings To	nvarchar	6	Allow NULL?
46	OPEN_AFT_TU	Business Hours: Tuesday Afternoons From	nvarchar	6	Allow NULL?
47	CLOSE_AFT_TU	Business Hours: Tuesday Afternoons To	nvarchar	6	Allow NULL?
48	OPEN_MOR_WE	Business Hours: Wednesday Mornings From	nvarchar	6	Allow NULL?
49	CLOSE_MOR_WE	Business Hours: Wednesday Mornings To	nvarchar	6	Allow NULL?
50	OPEN_AFT_WE	Business Hours: Wednesday Afternoons From	nvarchar	6	Allow NULL?
51	CLOSE_AFT_WE	Business Hours: Wednesday Afternoons To	nvarchar	6	Allow NULL?
52	OPEN_MOR_TH	Business Hours: Thursday Mornings From	nvarchar	6	Allow NULL?
53	CLOSE_MOR_TH	Business Hours: Thursday Mornings To	nvarchar	6	Allow NULL?
54	OPEN_AFT_TH	Business Hours: Thursday Afternoons From	nvarchar	6	Allow NULL?
55	CLOSE_AFT_TH	Business Hours: Thursday Afternoons To	nvarchar	6	Allow NULL?
56	OPEN_MOR_FR	Business Hours: Friday Mornings From	nvarchar	6	Allow NULL?
57	CLOSE_MOR_FR	Business Hours: Friday Mornings To	nvarchar	6	Allow NULL?
58	OPEN_AFT_FR	Business Hours: Friday Afternoons From	nvarchar	6	Allow NULL?
59	CLOSE_AFT_FR	Business Hours: Friday Afternoons To	nvarchar	6	Allow NULL?
60	OPEN_MOR_SA	Business Hours: Saturday Mornings From	nvarchar	6	Allow NULL?
61	CLOSE_MOR_SA	Business Hours: Saturday Mornings To	nvarchar	6	Allow NULL?
62	OPEN_AFT_SA	Business Hours: Saturday Afternoons From	nvarchar	6	Allow NULL?
63	CLOSE_AFT_SA	Business Hours: Saturday Afternoons To	nvarchar	6	Allow NULL?
64	OPEN_MOR_SU	Business Hours: Sunday Mornings From	nvarchar	6	Allow NULL?
65	CLOSE_MOR_SU	Business Hours: Sunday Mornings To	nvarchar	6	Allow NULL?
66	OPEN_AFT_SU	Business Hours: Sunday Afternoons From	nvarchar	6	Allow NULL?
67	CLOSE_AFT_SU	Business Hours: Sunday Afternoons To	nvarchar	6	Allow NULL?
68	OEFFZT	IS-M: Point of Sale Opening Time	char	1	Allow NULL?
69	SCHLZT	IS-M: POS Closing Time	char	1	Allow NULL?
70	OEFFMO	IS-M: Opening Type Monday	char	1	Allow NULL?
71	OEFFDI	IS-M: Opening Type Tuesday	char	1	Allow NULL?
72	OEFFMI	IS-M: Opening Type Wednesday	char	1	Allow NULL?
73	OEFFDO	IS-M: Opening Type Thursday	char	1	Allow NULL?
74	OEFFFR	IS-M: Opening Type Friday	char	1	Allow NULL?
75	OEFFSA	IS-M: Opening Type Saturday	char	1	Allow NULL?
76	OEFFSO	IS-M: Opening Type Sunday	char	1	Allow NULL?
77	XLOTTO	IS-M: Lottery Agent Indicator	char	1	Allow NULL?
78	MBRSYS	IS-M: Automatic Payment System	nvarchar	2	Allow NULL?
79	BAGNR	IS-M: BAG Transaction Number	nvarchar	5	Allow NULL?
80	ISPCNR	IS-M: ISPC Number	nvarchar	10	Allow NULL?
81	XISPCTEILN	IS-M: Indicator: Business Partner Is EDI Participant	char	1	Allow NULL?
82	ISPCTEILN	IS-M: EDI Participant Number	nvarchar	8	Allow NULL?
83	ISPCART	IS-M: EDI Participant Type	char	1	Allow NULL?
84	VDZNR	IS-M: VDZ Number	nvarchar	20	Allow NULL?
85	RECALLCALENDER	Recall Calendar	nvarchar	2	Allow NULL?
86	RC_ALLOWED_MO	Recall Allowed on Monday	char	1	Allow NULL?
87	RC_ALLOWED_TU	Recall Allowed on Tuesday	char	1	Allow NULL?
88	RC_ALLOWED_WD	Recall Allowed on Wednesday	char	1	Allow NULL?
89	RC_ALLOWED_TH	Recall Allowed on Thursday	char	1	Allow NULL?
90	RC_ALLOWED_FR	Recall Allowed on Friday	char	1	Allow NULL?
91	RC_ALLOWED_SA	Recall Allowed on Saturday	char	1	Allow NULL?
92	RC_ALLOWED_SU	Recall Allowed on Sunday	char	1	Allow NULL?
93	RECALLGROUP	Recall Group	nvarchar	4	Allow NULL?
94	VERKGB	IS-M: Sales Region	nvarchar	50	Allow NULL?
95	VGEINW	IS-M: Population of Sales Area	nvarchar	10	Allow NULL?
96	XREMRECHT	IS-M: Right of Return	char	1	Allow NULL?
97	REMART	Return Type	char	1	Allow NULL?
98	REMWEISE	Return Method	char	1	Allow NULL?
99	REMSP	IS-M: Billing Block for Return Notification	char	1	Allow NULL?
100	KOMMENT	IS-M: Comment 50 Characters in Length	nvarchar	50	Allow NULL?
101	RETURNGPNR	IS-M: Retailer	nvarchar	10	Allow NULL?
102	LAST_CHANGE	Time Stamp of Last Change for BI Delta Exchange	decimal	15

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

102 COLUMNS | 1 INDEXES | ERP 6.0 | JGTEUWV TABLE

TOP ERP 6.0 | JGTEUWV COLUMNS

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

102 COLUMNS | 1 INDEXES | ERP 6.0 | JGTEUWV TABLE

TOPERP 6.0 | JGTEUWV COLUMNS

TOPERP 6.0 | JGTEUWV INDEXES

TOP ERP 6.0 | JGTEUWV COLUMNS

TOP ERP 6.0 | JGTEUWV INDEXES