SAP ABAP Table MCJVBP (IS-PSD: Billing Item Data, LIS Communication Structure)
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 MCJVBP   Table Relationship Diagram
Short Description IS-PSD: Billing Item Data, LIS Communication Structure    
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: Billing Document - Item Data  
2 MANDT MANDT MANDT CLNT 3   0   Client T000
3 VBELN ISPVBELN ISPVBELN CHAR 10   0   IS-M/SD: Billing Document JFRK
4 POSNR ISPPOSNR ISPPOSNR NUMC 6   0   IS-M: Billing Item *
5 FKIMG FKIMG MENG13 QUAN 13   3   Actual billed quantity  
6 VRKME VRKME MEINS UNIT 3   0   Sales unit T006
7 MEINS MEINS MEINS UNIT 3   0   Base Unit of Measure T006
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 NETWR NETWR_FP WERTV8 CURR 15   2   Net value of the billing item in document currency  
13 MATKL MATKL MATKL CHAR 9   0   Material Group T023
14 SPART SPART SPART CHAR 2   0   Division TSPA
15 POSPA ISPPOSPA ISPPOSNR NUMC 6   0   IS-M: Item Number of Partner Segment JFRP
16 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
17 ALAND ALAND LAND1 CHAR 3   0   Departure country (country from which the goods are sent) T005
18 WKREG WKREG REGIO CHAR 3   0   Region in which plant is located T005S
19 WKCOU WKCOU CHAR3 CHAR 3   0   County in which plant is located  
20 WKCTY WKCTY CHAR4 CHAR 4   0   City in which plant is located  
21 TAXM1 TAXM1 TAXKM CHAR 1   0   Tax classification material *
22 TAXM2 TAXM2 TAXKM CHAR 1   0   Tax classification material *
23 TAXM3 TAXM3 TAXKM CHAR 1   0   Tax classification material *
24 TAXM4 TAXM4 TAXKM CHAR 1   0   Tax Classification 4 Material *
25 TAXM5 TAXM5 TAXKM CHAR 1   0   Tax classification 5 for material *
26 TAXM6 TAXM6 TAXKM CHAR 1   0   Tax classification 6 for material *
27 TAXM7 TAXM7 TAXKM CHAR 1   0   Tax classification 7 for material *
28 TAXM8 TAXM8 TAXKM CHAR 1   0   Tax Classification 8 Material *
29 TAXM9 TAXM9 TAXKM CHAR 1   0   Tax Classification 9 Material *
30 SKTOF SKTOF XFELD CHAR 1   0   Cash discount indicator  
31 SKFBP SKFBP WERTV7 CURR 13   2   Amount eligible for cash discount in document currency  
32 SPARA SPART_AK SPART CHAR 2   0   Division for order header TSPA
33 SHKZG SHKZG_VA XFELD CHAR 1   0   Returns Item  
34 ERNAM ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
35 ERDAT ERDAT DATUM DATS 8   0   Date on which the record was created  
36 ERZET ERZET UZEIT TIMS 6   0   Entry time  
37 STAFO STAFO STAFO CHAR 6   0   Update group for statistics update *
38 WAVWR WAVWR WERTV7 CURR 13   2   Cost in document currency  
39 KZWI1 KZWI1 WERTV7 CURR 13   2   Subtotal 1 from pricing procedure for condition  
40 KZWI2 KZWI2 WERTV7 CURR 13   2   Subtotal 2 from pricing procedure for condition  
41 KZWI3 KZWI3 WERTV7 CURR 13   2   Subtotal 3 from pricing procedure for condition  
42 KZWI4 KZWI4 WERTV7 CURR 13   2   Subtotal 4 from pricing procedure for condition  
43 KZWI5 KZWI5 WERTV7 CURR 13   2   Subtotal 5 from pricing procedure for condition  
44 KZWI6 KZWI6 WERTV7 CURR 13   2   Subtotal 6 from pricing procedure for condition  
45 STCUR STCUR_AP KURRF DEC 9   5   Exchange rate for statistics (Exch.rate at time of creation)  
46 UVPRS UVPRS XFELD CHAR 1   0   Incomplete with respect to pricing  
47 TXJCD TXJCD TXJCD CHAR 15   0   Tax Jurisdiction *
48 .INCLUDE       0   0   IS-M/SD: Item Data for Billing  
49 ISPAUART AUART_ISP AUART_ISP CHAR 4   0   IS-M/SD: Sales Document Types TJAK
50 ISPAUAGRP ISPAUAGRP JAUARTGRP CHAR 1   0   IS-M: Sales Document Type Grouping for Sales Order  
51 ISPKOSTL_L ISPKOSTL_L KOSTL CHAR 10   0   IS-M: Cost Center to be Charged *
52 ISPDRERZ DRERZ DRERZ CHAR 8   0   Publication JDTDRER
53 ISPPVA PVA PVA CHAR 8   0   Edition JDTPVA
54 ISPBEZ BEZUGSTYP_JE_PVA BEZUGSTYP_JE_PVA CHAR 2   0   Mix Type JDTBEZTYP
55 ISPLIFART LIEFERART LIEFERART CHAR 2   0   Delivery Type TJV01
56 ISPDRUCK ISPDRUCK WERKS CHAR 4   0   IS-M: Plant (Printing Works) T001W
57 ISPGUTSCH ISPGUTSCH GUTSCHEIN NUMC 8   0   IS-M: Coupon Number  
58 ISPXLOGO XLOGO XFELD CHAR 1   0   Print Logo  
59 ISPPVAKNTG ISPPVAKNTG KTGRM CHAR 2   0   IS-M: Account Assignment Grouping for Edition TVKM
60 ISPPVAKONG ISPPVAKONG KONDM CHAR 2   0   IS-M: Edition Condition Grouping T178
61 ISPPVABONG ISPPVABONG BONUS CHAR 2   0   IS-M: Bonus Grouping for Edition TVBO
62 ISPFKPER FKPER FKPER CHAR 2   0   Billing Frequency TJK01
63 ISPPERFK PERFK WFCID CHAR 2   0   Invoice dates (calendar identification) TFACD
64 ISPZAHLW JZAHLW JZAHLW CHAR 1   0   Billing method  
65 ISPPOSEX POSEX_ISP POSEX_ISP NUMC 6   0   External Item Number (Purchase Order Item)  
66 ISPJPERIOD JPERIOD XFELD CHAR 1   0   IS-M: Periodic settlement  
67 ISPVBELN AVNR AVNR CHAR 10   0   IS-M/SD: Publishing Sales Order JKAK
68 ISPPOSNR APNR APNR NUMC 6   0   Sales Order Item JKAP
69 ISPETENR JAENR AENR NUMC 4   0   Sales Order Schedule Line JKEP
70 ISPETEEX ETEEX_ISP ETEEX NUMC 6   0   IS-M: External Schedule Line Number  
71 ISPETART ETART_ISP ETART_ISP CHAR 2   0   Schedule Line Type for Internal Sales Order Schedule Line TJEP
72 ISPETMENGE ETMENGE MENGGPOS QUAN 10   0   IS-M: Sales Order Schedule Line Quantity  
73 ISPETMEINS ETMEINS MEINS UNIT 3   0   IS-M: Sales Unit for Sales Order T006
74 ISPETVOR ISPETVOR VORZEI CHAR 1   0   IS-M: Plus/Minus Sign for Sch. Line Quantity in Sales Order  
75 ISPKPOSN KPOSN NUM6 NUMC 6   0   Condition Item Number  
76 ISPPRBAS ISPPRBAS PRBAS_ISP CHAR 1   0   IS-M: Price Basis  
77 ISPPRSPER ISPPRSPER PRSPER CHAR 2   0   IS-M: Price Frequency TJK03
78 ISPBZPERF ISPBZPERF BEZPER CHAR 5   0   IS-M: Service Type for Billing TJD09
79 ISPPRSMLT ISPPRSMLT PRSMLT DEC 5   0   IS-M: Numerator in Conversion Factor for Frequencies  
80 ISPPRSDIV ISPPRSDIV PRSDIV DEC 5   0   IS-M: Denominator for Frequency Conversion Factor  
81 ISPAEART ISPAEART AEART_JSDK CHAR 1   0   IS-M: Order Change Type  
82 ISPANZET ISPANZET ANZET DEC 5   0   IS-M: Number of Publication Dates  
83 ISPERSDAT ERSCHDAT DATUM DATS 8   0   Publication Date  
84 ISPWRBAKT WERBEAKT WERBEAKT CHAR 8   0   Sales Promotion TJWAK
85 ISPFAKVON FAKVON DATUM DATS 8   0   IS-M: Billing Period From  
86 ISPFAKBIS FAKBIS DATUM DATS 8   0   IS-M: Billing Period To  
87 ISPKONDA KONDA KONDA CHAR 2   0   Price Group (Customer) T188
88 ISPKDGRP KDGRP KDGRP CHAR 2   0   Customer group T151
89 ISPPOART POART_ISP POART_ISP CHAR 2   0   Internal Item Type for Sales Order TJAP
90 ISPPRSANTZ PRSANTZ ISPWERT8 DEC 8   0   IS-M: Numerator for proportional prices  
91 ISPPRSANTN PRSANTN ISPWERT8 DEC 8   0   IS-M: Denominator for proportional prices  
92 ISPPRSANZP PRSANZP ISPWERT8 DEC 8   0   IS-M: Number of periods in billing period  
93 ISPBRTWR_P ISPBRTWR WERTV8 CURR 15   2   IS-M: Gross Value in Document Currency  
94 ISPPRBAS_V PRBAS_VK PRBAS_ISP CHAR 1   0   Price Basis for Shipping Costs  
95 ISPLAGRP_V LANDGRP_VK LANDGRP_VK CHAR 2   0   Country grouping for shipping costs TJG92
96 ISPXFKKOMP XFKKOMP XFELD CHAR 1   0   Indicator: Perform Billing in Full for Billing Period  
97 ISPXFKENDE XFKENDE XFELD CHAR 1   0   Indicator: Billing at end of calculation  
98 ISPSFPOS XSEPFKPOS XFELD CHAR 1   0   Separate billing document for order item  
99 ISPXKOMPP XKOMPP XFELD CHAR 1   0   IS-M: Full period (billing)  
100 ISPVERSDAT VRSNDDATUM DATUM DATS 8   0   IS-M: Shipping Date  
101 ISPLANDE LANDE_ISP LAND1 CHAR 3   0   Current country being supplied *
102 ISPRKAUFNR J_RK_AUFNR J_RK_AUFNR CHAR 8   0   Order Number of RK Order for Account Assignment  
103 ISPRKPOSNR J_RK_POSNR J_RK_POSNR NUMC 2   0   Item Number of RK Order for Account Assignment  
104 ISPCOAUFNR J_CO_AUFNR AUFNR CHAR 12   0   Order number of internal CO order for account assignment AUFK
105 ISPVAUSGB VAUSGB VAUSGB CHAR 10   0   Issue JDTVAUSGB
106 ISPXFKBALF XFKBASLIEF XFELD CHAR 1   0   IS-M: Billing based on delivery  
107 ISPXFKBAAU XFKBASAUFT XFELD CHAR 1   0   IS-M: Billing based on order  
108 ISPVKBURZU VKBURZUS VKBUR CHAR 4   0   Sales office responsible *
109 ISPXSTABGR JXMWSTABGR XFELD CHAR 1   0   VAT to be accrued proportionally for payment in billing  
110 ISPXIMMAT XIMMATRIK XFELD CHAR 1   0   Indicator: Proof of matriculation provided  
111 ISPIMMATD IMMATDAT DATUM DATS 8   0   Matriculation Certificate Valid To  
112 ISPXFKRUEK XFKRUECK XFELD CHAR 1   0   IS-M: Retroactive Billing of Period Already Billed  
113 ISPIVWKN IVWKN IVWKN CHAR 8   0   Circulation Audit Report Category ID *
114 ISPXIVW XIVW XFELD CHAR 1   0   Indicator: Relevant for audit report  
115 ISPJKPAVRG JKPAVONREG DATUM DATS 8   0   Normal Start of Address Validity for Retro.Order Items  
116 ISPJKPABRG JKPABISREG DATUM DATS 8   0   End of Address Validity if End of Billing Delayed  
117 XNEGOPTION XNEGOPTION XFELD CHAR 1   0   IS-M: Item with Automatic Transformation to Chargeable  
118 IVWDATUM IVWDATUM DATUM DATS 8   0   Date of Audit Report for Returns  
119 CAMPAIGN ISM_MARKETING_CAMPAIGN ISM_MARKETING_CAMPAIGN RAW 16   0   IS-M: Marketing Campaign  
120 ISPBDPER BDPER DATUM DATS 8   0   IS-M: Basic Date for Billing Frequency  
121 FKPERVON FKPERVON DATUM DATS 8   0   IS-M: Initial Date of Full Billing Period  
122 FKPERBIS FKPERBIS DATUM DATS 8   0   IS-M: Closing Date of Full Billing Period  
123 ISPZSKLS JZSKLS JZSKLS CHAR 1   0   Time slice classification for sales order  
124 ISPWRBART WERBEART WERBEART CHAR 4   0   Sales Source TJWAR
125 POSNR_UR APNR_UR APNR NUMC 6   0   Original Item in Publishing Sales Order *
126 CYCLENR CYCLENR CYCLENR NUMC 3   0   IS-M/SD: Billing Cycle Number *
127 FAKNRRUECK ISPFAKNRRUECK ISPVBELN CHAR 10   0   IS-M: Recalculated Billing Document *
128 XFIXED XINDEXFIXED XFELD CHAR 1   0   Indicator: Billing Index Fixed and Cannot be Deleted  
129 RCODE RATE_CODE RATE_CODE CHAR 4   0   IS-M/SD: Rate Code *
130 XAUTO_REN XAUTO_REN XFELD CHAR 1   0   IS-M/SD: Customer Requests Automatic Renewal  
131 STBFREI JSTBFREI JSTBFREI CHAR 2   0   Type of Tax Exemption TJFSB
132 XNFAK ISPXNFAK XFELD CHAR 1   0   IS-M: Indicator - Repeat Billing After Reversal  
133 DELIVSPLIT DELIVSPLIT DELIVSPLIT CHAR 8   0   IS-M/SD: Alternating Address Element TJD23
134 DELIVSPLITGRP DELIVSPLITGRP DELIVSPLITGRP CHAR 10   0   IS-M/SD: Address Alternation Group TJD63
135 POSNR_MAIN APNR_MAIN APNR NUMC 6   0   IS-M/SD: Main Item in Sales Order JKAP
136 POSNR_SUB APNR_SUB APNR NUMC 6   0   IS-M/SD: Sub-Item in Sales Order JKAP
137 .INCLUDE       0   0   IS-M/SD: Field String for Weekdays  
138 X_MONTAG X_MONTAG XFELD CHAR 1   0   IS-M: Monday  
139 X_DIENSTAG X_DIENSTAG XFELD CHAR 1   0   IS-M: Tuesday  
140 X_MITTWOCH X_MITTWOCH XFELD CHAR 1   0   IS-M: Wednesday  
141 X_DONNETAG X_DONNETAG XFELD CHAR 1   0   IS-M: Thursday  
142 X_FREITAG X_FREITAG XFELD CHAR 1   0   IS-M: Friday  
143 X_SAMSTAG X_SAMSTAG XFELD CHAR 1   0   IS-M: Saturday  
144 X_SONNTAG X_SONNTAG XFELD CHAR 1   0   IS-M: Sunday  
145 VBELN_FROM AVNR AVNR CHAR 10   0   IS-M/SD: Publishing Sales Order *
146 POSNR_UR_FROM APNR APNR NUMC 6   0   Sales Order Item *
147 CYCLENR_FROM CYCLENR CYCLENR NUMC 3   0   IS-M/SD: Billing Cycle Number *
148 XPRICEALTER XPRICEALTERNATION XFELD CHAR 1   0   Indicator: Generated Index for Price Change  
149 REFUNDTYPE REFUNDTYPE REFUNDTYPE CHAR 2   0   IS-M/SD: Refund Type TJK19
150 XAUTO_ACCEPT XAUTO_ACCEPT XFELD CHAR 1   0   IS-M/SD: Indicator - Accept Cycle Without Payment  
151 BONUSTYPE JBONUSTYPE JBONUSTYPE CHAR 2   0   IS-M/SD: Bonus Type  
152 .INCLUDE       0   0   IS-M/SD: Partner Field String for LIS Connection  
153 GPNRAG GPAG GPNR CHAR 10   0   Business Partner: Sold-to Party *
154 GPNRWE GPNR_WE GPNR CHAR 10   0   IS-M: Business Partner Ship-to Party *
155 GPNRRE GPNR_RE GPNR CHAR 10   0   IS-M: Business Partner - Bill-To Party *
156 GPNRRG GPNR_RG GPNR CHAR 10   0   IS-M: Payer Business Partner *
157 GPNRVM GPVERM GPNR CHAR 10   0   Business Partner Sales Agent *
158 PLZWE JMCPLZWE PSTLZ CHAR 10   0   Postal code in ship-to party address from order  
159 PLZRE JMCPLZRE PSTLZ CHAR 10   0   Postal code in bill-to party address from order  
160 KGSWE JMCKGSWE KREISG_SCH CHAR 15   0   District municip. key for ship-to party address from order *
161 .INCLUDE       0   0   IS-PSD: Data Affix for Billing Item, LIS Communic.Structure  
162 PVABEZEI10 KBEZPVA TEXT10 CHAR 10   0   Short text for edition  
163 PVABERGRP1 PVABERGRP1 PVABERGRP1 CHAR 10   0   Report group 1 - edition *
164 PVABERGRP2 PVABERGRP2 PVABERGRP2 CHAR 10   0   Report group 2 - edition *
165 PVAPOVERKZ POVERKZ POVERKZ CHAR 8   0   IS-M: Postal distribution indicator  
166 PVAIVWNR IVWNR IVWNR NUMC 10   0   Circulation Audit Report ID for Edition  
167 PVAISPCNRO ISPCNROB ISPCNROB NUMC 6   0   ISPC Number of Object  
168 PVAISPCNRT ISPCNRTO ISPCNRTO NUMC 2   0   ISPC Number of Sub-Object  
169 VDZVERTRKZ JWBZVKENNZ JWBZVKENNZ CHAR 5   0   IS-M: WBZ, VDZ Sales Code (Num. Share Postal Sales Code) *
170 DRERZSPART SPARTDRERZ SPART CHAR 2   0   Division for publication *
171 LIEFBEZIRK BEZIRK BEZIRK CHAR 10   0   Carrier Route *
172 LIEFGEOEIN GEOEIN GEOEIN CHAR 10   0   Number of Geographical Unit *
173 IVWKN IVWKN IVWKN CHAR 8   0   Circulation Audit Report Category ID *
174 XIVW XIVW XFELD CHAR 1   0   Indicator: Relevant for audit report  
175 APOSGUEVON JKAPVON DATUM DATS 8   0   Valid-From Date of Sales Order Item  
176 APOSGUEBIS JKAPBIS DATUM DATS 8   0   Date to which Sales Order Item is Valid  
177 POART_VKAU POART_ISP POART_ISP CHAR 2   0   Internal Item Type for Sales Order *
178 XURPOS XURPOS XFELD CHAR 1   0   Original item in publishing sales order  
179 BEZUGGRD BEZUGGRD BEZUGGRD CHAR 3   0   Purchase Reason *
180 KUENDGRD KUENDGRD KUENDGRD CHAR 3   0   Reason for end of delivery *
181 WERBEART WERBEART WERBEART CHAR 4   0   Sales Source *
182 WERBEAKT WERBEAKT WERBEAKT CHAR 8   0   Sales Promotion *
183 WERBTRAEG WERBTRAEG WERBTRAEG CHAR 10   0   Advertising Medium *
184 SACHPRAEM MATNR_SAPR MATNR_ISP CHAR 18   0   IS-M: Material number for gift *
185 VKBUR VKBUR VKBUR CHAR 4   0   Sales office *
186 VKGRP VKGRP VKGRP CHAR 3   0   Sales group *
187 .INCLUDE       0   0   IS-PSD: User Fields for Billing/Item Data, LIS Commun.Struc.  
188 DUMMYUSR DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 MCJVBP ALAND T005 LAND1 REF 1 CN
2 MCJVBP DELIVSPLIT TJD23 DELIVSPLIT REF C CN
3 MCJVBP DELIVSPLITGRP TJD63 DELIVSPLITGRP REF C CN
4 MCJVBP GSBER TGSB GSBER REF C CN
5 MCJVBP ISPAUART TJAK AUART KEY 1 CN
6 MCJVBP ISPBEZ JDTBEZTYP BEZTYP    
7 MCJVBP ISPBZPERF TJD09 BEZPER    
8 MCJVBP ISPCOAUFNR AUFK AUFNR    
9 MCJVBP ISPDRERZ JDTDRER DRERZ    
10 MCJVBP ISPDRUCK T001W WERKS    
11 MCJVBP ISPETART TJEP ETART KEY 1 CN
12 MCJVBP ISPETENR JKEP ETENR KEY 1 CN
13 MCJVBP ISPETMEINS T006 MSEHI    
14 MCJVBP ISPFKPER TJK01 FKPER    
15 MCJVBP ISPKDGRP T151 KDGRP    
16 MCJVBP ISPKONDA T188 KONDA    
17 MCJVBP ISPLAGRP_V TJG92 LANDGRP_VK    
18 MCJVBP ISPLIFART TJV01 LIEFERART    
19 MCJVBP ISPPERFK TFACD IDENT    
20 MCJVBP ISPPOART TJAP POART    
21 MCJVBP ISPPOSNR JKAP POSNR KEY 1 CN
22 MCJVBP ISPPRSPER TJK03 PRSPER    
23 MCJVBP ISPPVA JDTPVA PVA    
24 MCJVBP ISPPVABONG TVBO BONUS    
25 MCJVBP ISPPVAKNTG TVKM KTGRM    
26 MCJVBP ISPPVAKONG T178 KONDM    
27 MCJVBP ISPVAUSGB JDTVAUSGB VAUSGB    
28 MCJVBP ISPVBELN JKAK VBELN KEY 1 CN
29 MCJVBP ISPWRBAKT TJWAK WERBEAKT    
30 MCJVBP ISPWRBART TJWAR WERBEART KEY C CN
31 MCJVBP MANDT T000 MANDT KEY 1 CN
32 MCJVBP MATKL T023 MATKL REF C CN
33 MCJVBP MEINS T006 MSEHI REF C CN
34 MCJVBP POSNR_MAIN JKAP POSNR REF C CN
35 MCJVBP POSNR_SUB JKAP POSNR REF C CN
36 MCJVBP POSPA JFRP POSNR    
37 MCJVBP REFUNDTYPE TJK19 REFUNDTYPE REF 1 CN
38 MCJVBP SPARA TSPA SPART REF C CN
39 MCJVBP SPART TSPA SPART REF C CN
40 MCJVBP STBFREI TJFSB STBFREI REF C CN
41 MCJVBP VBELN JFRK VBELN KEY 1 CN
42 MCJVBP VRKME T006 MSEHI REF C CN
43 MCJVBP WERKS T001W WERKS REF C CN
44 MCJVBP WKREG T005S BLAND REF C CN
History
Last changed by/on SAP  20110901 
SAP Release Created in