SAP ABAP Table JLRP (IS-M/SD: Item Data for Settlement)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	JLRP	Table Relationship Diagram
Short Description	IS-M/SD: Item Data for Settlement

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JLRP	BEZTYP	JDTBEZTYP	BEZTYP
2	JLRP	BZPERF	TJD09	BEZPER	REF	C	CN
3	JLRP	DRERZ	JDTDRER	DRERZ	REF	C	CN
4	JLRP	DRERZTRAEG	JDTDRER	DRERZ		1	CN
5	JLRP	EFAHRK	T006	MSEHI
6	JLRP	FKPER	TJK01	FKPER
7	JLRP	GSBER	TGSB	GSBER	KEY	1	CN
8	JLRP	JVBELN	JLRK	VBELN	KEY	1	CN
9	JLRP	MANDT	T000	MANDT	KEY	1	CN
10	JLRP	MATNR	MARA	MATNR	REF	1	CN
11	JLRP	MEINS	T006	MSEHI	KEY	1	CN
12	JLRP	MINEIN	T006	MSEHI	REF	C	CN
13	JLRP	POART	TJAP	POART	REF	1	CN
14	JLRP	POSNR	JKCOMM	POSNR	REF	1	CN
15	JLRP	PROMNR	JKCOMM	PROMNR		C	CN
16	JLRP	PVA	JDTPVA	PVA	REF	C	CN
17	JLRP	PVATRAEG	JDTPVA	PVA		1	CN
18	JLRP	TAET_KLASS	TJV49	TAET_KLASS
19	JLRP	VBELN	JKAK	VBELN	REF	1	CN
20	JLRP	VERKMITART	TJL55	VERKMITART		1	CN
21	JLRP	VERTYP	TJG11	VERTYP
22	JLRP	VKORG	TVKO	VKORG
23	JLRP	WERBKZSCHL	TJKW9	WERBKZSCHL	REF	1	CN
24	JLRP	WRBAKT	TJWAK	WERBEAKT	REF	C	CN
25	JLRP	WRBART	TJWAR	WERBEART	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in