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