	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

	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

	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	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

196 COLUMNS | 4 INDEXES | ERP 6.0 | JLRP TABLE

	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

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, JVBELN, JPOSNR, ABIMG, MEINS, SMENG, KTGRM, GSBER, PRSDT, FBUDA, KURSK, BRTWR, NETWR, VBELV, POSNV, VGBEL, VGPOS, VGTYP, DIENL, ARKTX, POSAR, JABRPOSART, TAXM1, TAXM2, TAXM3, TAXM4, TAXM5, TAXM6, TAXM7, TAXM8, TAXM9, KOWRR, PRSFD, KOSTL, ERNAM, ERDAT, ERZET, STAFO, WAVWR, KZWI1, KZWI2, KZWI3, KZWI4, KZWI5, KZWI6, STCUR, UVPRS, UVALL, PRCTR, KOKRS, PAOBJNR, PS_PSP_PNR, RK_AUFNR, RK_POSNR, CO_AUFNR, TXJCD, XBEZPOS, BEZTAT, BEZRUNDTAT, GP_ERS_ART, VERSANDDAT, TRAGEZ, JAUART, AUAGRP, BEZTYP, DRUTAT, DRUART, PVATAT, BRGEW, NTGEW, MEINHGW, BEILAGEN, MEINHBL, NORMZG, NORMZU, WRBMZG, WRBMZU, NORMDZ, NORMDG, LFATAT, XSCHLGELD, XWEGGLDNT, XWEGGLDFG, XWEGGLDFN, XWGGELDPA, XFARGLDNT, XFARGLDFG, XFARGLDFN, XFAHRGELD, XBEILZUNT, XBEILZUFG, XBEILZUFN, XGEWIZUNT, XGEWIZUFG, XGEWIZUFN, KTFEIERFG, KTFEIERFN, KTNACHTNT, KTNACHTFG, KTNACHTFN, KTSONN_NT, KTSONN_FG, KTSONN_FN, KTSLGD, KTWEGD, KTFAGD, KTTOPO, KTTRAG, BEZKT1, BEZKT2, BEZKT3, BEZKT4, BEZKT5, GEWTVA, GEWBEI, GESGEW, ANZBEI, MEINHG, XFEIERTAG, WOTAG_N, WOTAG_A, XVERGPVAST, XVERGPVAPE, XVERGPVATD, XVERGPVADU, XVERGBEZPA, DRERZ, PVA, BZPERF, WRBART, WRBAKT, MINBEZ, MINEIN, XWKZ, POART, XEINML, XRENDI, XPATE, XFBLGABR, ZLSCH, VTWEG, SPART, VBELN, GPAG, GPNR_LE, BSTDK, POSNR, POSEX, ETENR, GUELTIGVON, RECHBEGINN, PROVFDAT, XIMMAT, SHKZG, FKDAT, KONDA, ANZMONABRE, XPROVRUECK, ANZET, PROVRART, WERBKZSCHL, FKPER, XNEGOP, ZUSTTYP, WRBMDZ, WRBMDG, VKORG, FAHRKM, EFAHRK, BBEWRT, VERKMITART, TAET_KLASS, VORGAENGER, NACHFOLGER, DRERZTRAEG, PVATRAEG, VERTYP, PROMNR, PROVPERCNT, EVENT, XAQUISITION, MATNR, MONNRCOMPL, MONFACTOR, TUENRCOMPL, TUEFACTOR, WEDNRCOMPL, WEDFACTOR, THUNRCOMPL, THUFACTOR, FRINRCOMPL, FRIFACTOR, SATNRCOMPL, SATFACTOR, SUNNRCOMPL, SUNFACTOR FROM JLRP

TOP ERP 6.0 | JLRP COLUMNS

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

TOP ERP 6.0 | JLRP INDEXES

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