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 :: Media Sales and Distribution :: Periodical Sales and Distribution
1	ERP EHP7	6.0	JLRP	196	4	IS-M/SD: Item Data for Settlement	Periodical Sales and Distribution

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	JVBELN	IS-M: Settlement number	nvarchar	10	0	Allow NULL?
3	JPOSNR	IS-M: Settlement item number	nvarchar	6	0	Allow NULL?
4	ABIMG	IS-M: Actual Settlement Quantity	decimal	9	3
5	MEINS	Base Unit of Measure	nvarchar	3	0	Allow NULL?
6	SMENG	Scale quantity in base unit of measure	decimal	13	3
7	KTGRM	IS-M: Account assignment group for publication	nvarchar	2	0	Allow NULL?
8	GSBER	Business Area	nvarchar	4	0	Allow NULL?
9	PRSDT	Date for pricing and exchange rate	nvarchar	8	0	Allow NULL?
10	FBUDA	Date on which services rendered	nvarchar	8	0	Allow NULL?
11	KURSK	Exchange Rate for Price Determination	decimal	9	5
12	BRTWR	IS-M: Gross Value in Document Currency	decimal	15	2
13	NETWR	IS-M: Net Value of Settlement Item in Document Currency	decimal	15	2
14	VBELV	Originating document	nvarchar	10	0	Allow NULL?
15	POSNV	Originating item	nvarchar	6	0	Allow NULL?
16	VGBEL	Document number of the reference document	nvarchar	10	0	Allow NULL?
17	VGPOS	Item number of the reference item	nvarchar	6	0	Allow NULL?
18	VGTYP	SD document category	char	1	0	Allow NULL?
19	DIENL	IS-M: Service	nvarchar	18	0	Allow NULL?
20	ARKTX	Short text for sales order item	nvarchar	40	0	Allow NULL?
21	POSAR	Item type	char	1	0	Allow NULL?
22	JABRPOSART	IS-M: Settlement item type	nvarchar	2	0	Allow NULL?
23	TAXM1	Tax classification material	char	1	0	Allow NULL?
24	TAXM2	Tax classification 2 for material	char	1	0	Allow NULL?
25	TAXM3	Tax classification 3 for material	char	1	0	Allow NULL?
26	TAXM4	Tax Classification 4 Material	char	1	0	Allow NULL?
27	TAXM5	Tax classification 5 for material	char	1	0	Allow NULL?
28	TAXM6	Tax classification 6 for material	char	1	0	Allow NULL?
29	TAXM7	Tax classification 7 for material	char	1	0	Allow NULL?
30	TAXM8	Tax Classification 8 Material	char	1	0	Allow NULL?
31	TAXM9	Tax Classification 9 Material	char	1	0	Allow NULL?
32	KOWRR	Statistical values	char	1	0	Allow NULL?
33	PRSFD	Carry out pricing	char	1	0	Allow NULL?
34	KOSTL	Cost Center	nvarchar	10	0	Allow NULL?
35	ERNAM	Name of Person who Created the Object	nvarchar	12	0	Allow NULL?
36	ERDAT	Date on Which Record Was Created	nvarchar	8	0	Allow NULL?
37	ERZET	Entry time	nvarchar	6	0	Allow NULL?
38	STAFO	Update group for statistics update	nvarchar	6	0	Allow NULL?
39	WAVWR	Cost in document currency	decimal	13	2
40	KZWI1	Subtotal 1 from pricing procedure for condition	decimal	13	2
41	KZWI2	Subtotal 2 from pricing procedure for condition	decimal	13	2
42	KZWI3	Subtotal 3 from pricing procedure for condition	decimal	13	2
43	KZWI4	Subtotal 4 from pricing procedure for condition	decimal	13	2
44	KZWI5	Subtotal 5 from pricing procedure for condition	decimal	13	2
45	KZWI6	Subtotal 6 from pricing procedure for condition	decimal	13	2
46	STCUR	Exchange rate for statistics (Exch.rate at time of creation)	decimal	9	5
47	UVPRS	Incomplete with respect to pricing	char	1	0	Allow NULL?
48	UVALL	Generally incomplete	char	1	0	Allow NULL?
49	PRCTR	Profit Center	nvarchar	10	0	Allow NULL?
50	KOKRS	Controlling Area	nvarchar	4	0	Allow NULL?
51	PAOBJNR	Profitability Segment Number (CO-PA)	nvarchar	10	0	Allow NULL?
52	PS_PSP_PNR	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	Allow NULL?
53	RK_AUFNR	Order Number of RK Order for Account Assignment	nvarchar	8	0	Allow NULL?
54	RK_POSNR	Item Number of RK Order for Account Assignment	nvarchar	2	0	Allow NULL?
55	CO_AUFNR	Order number of internal CO order for account assignment	nvarchar	12	0	Allow NULL?
56	TXJCD	Tax Jurisdiction	nvarchar	15	0	Allow NULL?
57	XBEZPOS	IS-M/SD: Item Type in Service Settlement for Home Delivery	char	1	0	Allow NULL?
58	BEZTAT	Actual Carrier Route	nvarchar	10	0	Allow NULL?
59	BEZRUNDTAT	Actual Delivery Round	nvarchar	10	0	Allow NULL?
60	GP_ERS_ART	IS-M: Business Partner Substitution Type	nvarchar	2	0	Allow NULL?
61	VERSANDDAT	IS-M: Shipping Date	nvarchar	8	0	Allow NULL?
62	TRAGEZ	Distribution time category (for home delivery settlement)	nvarchar	2	0	Allow NULL?
63	JAUART	IS-M/SD: Sales Document Types	nvarchar	4	0	Allow NULL?
64	AUAGRP	IS-M/SD: Sales document type grouping	char	1	0	Allow NULL?
65	BEZTYP	Mix Type	nvarchar	2	0	Allow NULL?
66	DRUTAT	Actual Publication Delivered	nvarchar	8	0	Allow NULL?
67	DRUART	Publication Type	char	1	0	Allow NULL?
68	PVATAT	Actual edition delivered	nvarchar	8	0	Allow NULL?
69	BRGEW	IS-M: Gross weight (issue weight incl.weight of inserts)	decimal	13	3
70	NTGEW	IS-M: Net Weight (Weight of Issue Minus Inserts)	decimal	13	3
71	MEINHGW	IS-M: Unit of weight for total issue weight	nvarchar	3	0	Allow NULL?
72	BEILAGEN	IS-M: Number of inserts per issue	decimal	9	0
73	MEINHBL	IS-M: Unit of weight for inserts	nvarchar	3	0	Allow NULL?
74	NORMZG	Actual Qty Standard Units in a Home Del. Company's Delivery	decimal	9	0
75	NORMZU	Actual Quantity of Standard Units in a Carrier's Delivery	decimal	9	0
76	WRBMZG	Actual Quantity of Prom. Copies in a Del. Company's Delivery	decimal	9	0
77	WRBMZU	Actual Quantity of Prom. Copies in a Carrier's Delivery	decimal	9	0
78	NORMDZ	IS-M: Average quantity per period in carrier route (EE)	decimal	9	3
79	NORMDG	IS-M: Average quantity per period in carrier route (SC)	decimal	9	3
80	LFATAT	Actual delivery type (usually DT for dist.viability set)	nvarchar	2	0	Allow NULL?
81	XSCHLGELD	IS-M: Key compensation	char	1	0	Allow NULL?
82	XWEGGLDNT	IS-M/SD: Path compensation daily	char	1	0	Allow NULL?
83	XWEGGLDFG	IS-M/SD: Path compensation daily	char	1	0	Allow NULL?
84	XWEGGLDFN	IS-M/SD: Path compensation daily	char	1	0	Allow NULL?
85	XWGGELDPA	IS-M/SD: Flat rate path compensation (monthly)	char	1	0	Allow NULL?
86	XFARGLDNT	IS-M/SD: Run compensation daily	char	1	0	Allow NULL?
87	XFARGLDFG	IS-M/SD: Run compensation daily	char	1	0	Allow NULL?
88	XFARGLDFN	IS-M/SD: Run compensation daily	char	1	0	Allow NULL?
89	XFAHRGELD	IS-M/SD: Run compensation	char	1	0	Allow NULL?
90	XBEILZUNT	Insert bonus	char	1	0	Allow NULL?
91	XBEILZUFG	Insert bonus	char	1	0	Allow NULL?
92	XBEILZUFN	Insert bonus	char	1	0	Allow NULL?
93	XGEWIZUNT	IS-M/SD: Weight surcharge	char	1	0	Allow NULL?
94	XGEWIZUFG	IS-M/SD: Weight surcharge	char	1	0	Allow NULL?
95	XGEWIZUFN	IS-M/SD: Weight surcharge	char	1	0	Allow NULL?
96	KTFEIERFG	IS-M/SD: Public holiday bonus category	nvarchar	2	0	Allow NULL?
97	KTFEIERFN	IS-M/SD: Public holiday bonus category	nvarchar	2	0	Allow NULL?
98	KTNACHTNT	IS-M/SD: Night bonus category	nvarchar	2	0	Allow NULL?
99	KTNACHTFG	IS-M/SD: Night bonus category	nvarchar	2	0	Allow NULL?
100	KTNACHTFN	IS-M/SD: Night bonus category	nvarchar	2	0	Allow NULL?
101	KTSONN_NT	IS-M/SD: Sunday bonus category	nvarchar	2	0	Allow NULL?
102	KTSONN_FG	IS-M/SD: Sunday bonus category	nvarchar	2	0	Allow NULL?
103	KTSONN_FN	IS-M/SD: Sunday bonus category	nvarchar	2	0	Allow NULL?
104	KTSLGD	IS-M: Key compensation category	nvarchar	2	0	Allow NULL?
105	KTWEGD	IS-M: Path length category	nvarchar	2	0	Allow NULL?
106	KTFAGD	Distance Traveled: Category (for Home Delivery Settlement)	nvarchar	2	0	Allow NULL?
107	KTTOPO	Topography category (for home delivery settlement)	nvarchar	2	0	Allow NULL?
108	KTTRAG	Distribution time category (for home delivery settlement)	nvarchar	2	0	Allow NULL?
109	BEZKT1	Carrier Route Flat Rate Category	nvarchar	2	0	Allow NULL?
110	BEZKT2	IS-M: Carrier Route Category 2	nvarchar	2	0	Allow NULL?
111	BEZKT3	IS-M: Carrier Route Category 3	nvarchar	2	0	Allow NULL?
112	BEZKT4	IS-M: Carrier Route Category 4	nvarchar	2	0	Allow NULL?
113	BEZKT5	IS-M: Carrier Route Category 5	nvarchar	2	0	Allow NULL?
114	GEWTVA	Calculated Issue Weight	decimal	9	3
115	GEWBEI	Weight of Inserts	decimal	9	3
116	GESGEW	Weight of carrying issue (including inserts)	decimal	9	3
117	ANZBEI	Number of inserts	nvarchar	3	0	Allow NULL?
118	MEINHG	Unit of weight for issue (calculated weight)	nvarchar	3	0	Allow NULL?
119	XFEIERTAG	Public holiday flag	char	1	0	Allow NULL?
120	WOTAG_N	Fatory calendar flag	char	1	0	Allow NULL?
121	WOTAG_A	IS-M: Abbreviation for weekday	nvarchar	2	0	Allow NULL?
122	XVERGPVAST	IS-M/SD: Remuneration according to editions per day	char	1	0	Allow NULL?
123	XVERGPVAPE	IS-M/SD: Remuneration according to edition period average	char	1	0	Allow NULL?
124	XVERGPVATD	IS-M/SD: Remuneration according to daily edition average	char	1	0	Allow NULL?
125	XVERGPVADU	IS-M/SD: Remuneration according to edition average	char	1	0	Allow NULL?
126	XVERGBEZPA	IS-M/SD: Remuneration by carrier route flat rate	char	1	0	Allow NULL?
127	DRERZ	Publication	nvarchar	8	0	Allow NULL?
128	PVA	Edition	nvarchar	8	0	Allow NULL?
129	BZPERF	IS-M: Service Type for Billing	nvarchar	5	0	Allow NULL?
130	WRBART	Sales Source	nvarchar	4	0	Allow NULL?
131	WRBAKT	Sales Promotion	nvarchar	8	0	Allow NULL?
132	MINBEZ	Minimum Length of Subscription	decimal	2	0
133	MINEIN	Time Unit for Minimum Length of Subscription	nvarchar	3	0	Allow NULL?
134	XWKZ	Indicator: Promotion rebate	char	1	0	Allow NULL?
135	POART	Internal Item Type for Sales Order	nvarchar	2	0	Allow NULL?
136	XEINML	Indicator: One-time commission	char	1	0	Allow NULL?
137	XRENDI	Renewal commission	char	1	0	Allow NULL?
138	XPATE	IS-M: Sponsored subscription	char	1	0	Allow NULL?
139	XFBLGABR	IS-M: Follow-on settlement documents	char	1	0	Allow NULL?
140	ZLSCH	IS-M: Order payment method	char	1	0	Allow NULL?
141	VTWEG	Distribution Channel	nvarchar	2	0	Allow NULL?
142	SPART	Division for order header	nvarchar	2	0	Allow NULL?
143	VBELN	IS-M/SD: Publishing Sales Order	nvarchar	10	0	Allow NULL?
144	GPAG	Business Partner: Sold-to Party	nvarchar	10	0	Allow NULL?
145	GPNR_LE	IS-M: Business Partner Service Provider	nvarchar	10	0	Allow NULL?
146	BSTDK	Customer purchase order date	nvarchar	8	0	Allow NULL?
147	POSNR	Sales Order Item	nvarchar	6	0	Allow NULL?
148	POSEX	External Item Number (Purchase Order Item)	nvarchar	6	0	Allow NULL?
149	ETENR	Delivery Schedule Line Number	nvarchar	4	0	Allow NULL?
150	GUELTIGVON	IS-M: Start of delivery of sales order item	nvarchar	8	0	Allow NULL?
151	RECHBEGINN	Billing From	nvarchar	8	0	Allow NULL?
152	PROVFDAT	Commission due date	nvarchar	8	0	Allow NULL?
153	XIMMAT	Indicator: Proof of matriculation provided	char	1	0	Allow NULL?
154	SHKZG	Debit/Credit Indicator	char	1	0	Allow NULL?
155	FKDAT	IS-M: Billing/Settlement Date	nvarchar	8	0	Allow NULL?
156	KONDA	Price group (customer)	nvarchar	2	0	Allow NULL?
157	ANZMONABRE	IS-M: No.Months for Sett./Retroactive Acctg - One-Time Comm.	decimal	2	0
158	XPROVRUECK	Indicator: Commission recalculation for order item	char	1	0	Allow NULL?
159	ANZET	IS-M: Number of Publication Dates	decimal	5	0
160	PROVRART	Commission clawback type	char	1	0	Allow NULL?
161	WERBKZSCHL	IS-M: WBZ, Promotion Rebate Key	char	1	0	Allow NULL?
162	FKPER	Billing Frequency	nvarchar	2	0	Allow NULL?
163	XNEGOP	IS-M: Item with Automatic Transformation to Chargeable	char	1	0	Allow NULL?
164	ZUSTTYP	IS-M: Carrier Type	char	1	0	Allow NULL?
165	WRBMDZ	IS-M: Average promotion qty per period in carr.route (EE)	decimal	9	3
166	WRBMDG	IS-M: Average promotion qty per period in carr.route (SC)	decimal	9	3
167	VKORG	Sales Organization	nvarchar	4	0	Allow NULL?
168	FAHRKM	Distance (for Home Delivery Settlement)	decimal	9	3
169	EFAHRK	Unit (km/m)	nvarchar	3	0	Allow NULL?
170	BBEWRT	IS-M: Valuation of carrier route for home del.settlement	nvarchar	5	0	Allow NULL?
171	VERKMITART	IS-M: Vehicle type	nvarchar	2	0	Allow NULL?
172	TAET_KLASS	IS-M: Activity classification	nvarchar	2	0	Allow NULL?
173	VORGAENGER	IS-M: Number of predecessor	nvarchar	12	0	Allow NULL?
174	NACHFOLGER	Number of successor	nvarchar	12	0	Allow NULL?
175	DRERZTRAEG	Carrying Publication	nvarchar	8	0	Allow NULL?
176	PVATRAEG	Carrying Edition	nvarchar	8	0	Allow NULL?
177	VERTYP	IS-M: Sales Agent Type	nvarchar	2	0	Allow NULL?
178	PROMNR	Sales order introduction	nvarchar	3	0	Allow NULL?
179	PROVPERCNT	IS-M/SD: Percentage rate of commission	nvarchar	3	0	Allow NULL?
180	EVENT	IS-M/SD: Event in order processing	nvarchar	4	0	Allow NULL?
181	XAQUISITION	IS-M/SD: Indicator - first introduction record	char	1	0	Allow NULL?
182	MATNR	Material Number	nvarchar	18	0	Allow NULL?
183	MONNRCOMPL	Number of Complaints	nvarchar	4	0	Allow NULL?
184	MONFACTOR	Weight Factor	nvarchar	6	0	Allow NULL?
185	TUENRCOMPL	Number of Complaints	nvarchar	4	0	Allow NULL?
186	TUEFACTOR	Weight Factor	nvarchar	6	0	Allow NULL?
187	WEDNRCOMPL	Number of Complaints	nvarchar	4	0	Allow NULL?
188	WEDFACTOR	Weight Factor	nvarchar	6	0	Allow NULL?
189	THUNRCOMPL	Number of Complaints	nvarchar	4	0	Allow NULL?
190	THUFACTOR	Weight Factor	nvarchar	6	0	Allow NULL?
191	FRINRCOMPL	Number of Complaints	nvarchar	4	0	Allow NULL?
192	FRIFACTOR	Weight Factor	nvarchar	6	0	Allow NULL?
193	SATNRCOMPL	Number of Complaints	nvarchar	4	0	Allow NULL?
194	SATFACTOR	Weight Factor	nvarchar	6	0	Allow NULL?
195	SUNNRCOMPL	Number of Complaints	nvarchar	4	0	Allow NULL?
196	SUNFACTOR	Weight Factor	nvarchar	6	0	Allow NULL?

Name	Primary	Unique	Type	Columns
JLRP~0	Yes	Yes	CLUSTERED	JPOSNR, JVBELN, MANDT
JLRP~1	No	No	NONCLUSTERED	POSNR, VBELN
JLRP~2	No	No	NONCLUSTERED	BEZTAT, XBEZPOS, GPNR_LE
JLRP~3	No	No	NONCLUSTERED	BEZTAT, VERSANDDAT, GPNR_LE

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

196 COLUMNS | 4 INDEXES | ERP 6.0 | JLRP TABLE

TOP ERP 6.0 | JLRP COLUMNS

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

196 COLUMNS | 4 INDEXES | ERP 6.0 | JLRP TABLE

TOPERP 6.0 | JLRP COLUMNS

TOPERP 6.0 | JLRP INDEXES

TOP ERP 6.0 | JLRP COLUMNS

TOP ERP 6.0 | JLRP INDEXES