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