SAP ABAP Table MCJKAP (IS-M/SD: Order Item, 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 MCJKAP   Table Relationship Diagram
Short Description IS-M/SD: Order Item, 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   Sales Order - Item Data  
2 MANDT MANDT MANDT CLNT 3   0   Client T000
3 VBELN AVNR AVNR CHAR 10   0   IS-M/SD: Publishing Sales Order JKAK
4 POSNR APNR APNR NUMC 6   0   Sales Order Item *
5 GUELTIGVON JKAPVON DATUM DATS 8   0   Valid-From Date of Sales Order Item  
6 GUELTIGBIS JKAPBIS DATUM DATS 8   0   Date to which Sales Order Item is Valid  
7 POART POART_ISP POART_ISP CHAR 2   0   Internal Item Type for Sales Order TJAP
8 AEART AEART_JSDK AEART_JSDK CHAR 1   0   Order Change Type  
9 ZSKLS JZSKLS JZSKLS CHAR 1   0   Time slice classification for sales order  
10 POSEX POSEX_ISP POSEX_ISP NUMC 6   0   External Item Number (Purchase Order Item)  
11 KUNWE GPNR_WE GPNR CHAR 10   0   IS-M: Business Partner Ship-to Party JGTGPNR
12 KUNWEFREMD JKUNNRVERL JKUNNRVERL CHAR 15   0   Cust.No. with External Company (External Deliveries/Retail)  
13 LANDE LANDE_ISP LAND1 CHAR 3   0   Current country being supplied T005
14 LAND1 LAND1_ISP LAND1 CHAR 3   0   Normal delivery country T005
15 DRERZ DRERZ DRERZ CHAR 8   0   Publication JDTDRER
16 PVA PVA PVA CHAR 8   0   Edition JDTPVA
17 BEZUGSTYP BEZUGSTYP_JE_PVA BEZUGSTYP_JE_PVA CHAR 2   0   Mix Type JDTBEZTYP
18 XRUECKABO XRUECKABO XFELD CHAR 1   0   IS-M: Backdated subscription created  
19 LIEFVON LIEFVON DATUM DATS 8   0   Regular start of delivery for item in sales order  
20 SPART SPARTDRERZ SPART CHAR 2   0   Division for publication TSPA
21 MATKL MATKL MATKL CHAR 9   0   Material Group T023
22 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
23 VOREF VOREF XFELD CHAR 1   0   Complete reference indicator  
24 ERLRE ERLRE ERLRE CHAR 1   0   Completion rule for quotation / contract  
25 TAXM1 TAXMT TAXKD CHAR 1   0   Tax classification material *
26 TAXM2 TAXMT TAXKD CHAR 1   0   Tax classification material *
27 TAXM3 TAXMT TAXKD CHAR 1   0   Tax classification material *
28 TAXM4 TAXMT TAXKD CHAR 1   0   Tax classification material *
29 TAXM5 TAXMT TAXKD CHAR 1   0   Tax classification material *
30 TAXM6 TAXMT TAXKD CHAR 1   0   Tax classification material *
31 TAXM7 TAXMT TAXKD CHAR 1   0   Tax classification material *
32 TAXM8 TAXMT TAXKD CHAR 1   0   Tax classification material *
33 TAXM9 TAXMT TAXKD CHAR 1   0   Tax classification material *
34 VGREF VGREF XFELD CHAR 1   0   Preceding document has resulted from reference  
35 STAFO STAFO STAFO CHAR 6   0   Update group for statistics update *
36 STCUR STCUR_AP KURRF DEC 9   5   Exchange rate for statistics (Exch.rate at time of creation)  
37 IVWKN IVWKN IVWKN CHAR 8   0   Circulation Audit Report Category ID TJI01
38 IVWKNFREI IVWKNFREI IVWKN CHAR 8   0   Circulation Report Category ID for Non-Calculation Period TJI01
39 XLIEFSE XLIEFSE XFELD CHAR 1   0   Delivery to social facility  
40 LIEFERART LIEFERART LIEFERART CHAR 2   0   Delivery Type TJV01
41 LIEFXUHR LIEFXUHR UZEIT TIMS 6   0   Time of latest delivery  
42 DRUCKEREI JWERK WERKS CHAR 4   0   Plant T001W
43 VSAUSSTART VSAUSSTART VSAUSSTART CHAR 2   0   Shipping outsorting type TJV09
44 UNTBRGRD UNTBRGRD UNTBRGRD CHAR 3   0   Reason for Suspension TJK85
45 BEZUGGRD BEZUGGRD BEZUGGRD CHAR 3   0   Purchase Reason TJK87
46 KORRGRD KORRGRD KORRGRD CHAR 3   0   IS-M: Reason for correction TJK81
47 GUTSCHEIN GUTSCHEIN GUTSCHEIN NUMC 8   0   Coupon Number  
48 XGUTSCHEIN XGUTSCHEIN XFELD CHAR 1   0   Indicator: Vouchers allowed  
49 XDISPO XDISPO XFELD CHAR 1   0   Indicator: relevant to planning  
50 XUNVLIEFER XUNVLIEFER XFELD CHAR 1   0   IS-M: Viability Data Incomplete for Item  
51 XUNVLAUTO XUNVLAUTO XFELD CHAR 1   0   IS-M: Via.data incomp.for item (due to automatic change)  
52 RECHBEGINN RECHBEGINN DATUM DATS 8   0   Billing From  
53 RECHENDE RECHENDE DATUM DATS 8   0   Billing To  
54 XLIEFBAR XLIEFBAR XFELD CHAR 1   0   Determine delivery viability  
55 XIVW XIVW XFELD CHAR 1   0   Indicator: Relevant for audit report  
56 XFAKTURA XFAKTURA XFELD CHAR 1   0   Indicator: Relevant for billing  
57 PRSFD PRSFD PRSFD CHAR 1   0   Carry out pricing  
58 SBFREI SBFREI USNAM CHAR 12   0   Administrator responsible for free copies  
59 WDVDAT WDVDAT DATUM DATS 8   0   Resubmission date  
60 KUENDGRD KUENDGRD KUENDGRD CHAR 3   0   Reason for end of delivery TJK83
61 XLOGO XLOGO XFELD CHAR 1   0   Print Logo  
62 FAKSP FAKTSPERRE FAKSP CHAR 2   0   Billing Block TVFS
63 XFAKTSPERR XFAKTSPERR XFELD CHAR 1   0   IS-M: Billing block set  
64 XREMRECHT XREMRECHT XFELD CHAR 1   0   IS-M: Right of Return  
65 XBAGABR XBAGABR XFELD CHAR 1   0   Indicator: BAG billing procedure  
66 XURPOS XURPOS XFELD CHAR 1   0   Original item in publishing sales order  
67 POSNR_UR APNR_UR APNR NUMC 6   0   Original Item in Publishing Sales Order JKAP
68 POSNR_VG APNR_VG APNR NUMC 6   0   Preceding Item in Publishing Sales Order JKAP
69 VBELN_VL AVNR_VL AVNR CHAR 10   0   Reference Document JKAK
70 POSNR_VL APNR_VL APNR NUMC 6   0   Reference Document Item JKAP
71 PVAKNTGRP PVAKNTGRP KTGRM CHAR 2   0   Account Assignment Grouping for Edition TVKM
72 PVAKONGRP PVAKONGRP JKONDM CHAR 2   0   Condition Grouping for Edition TJD47
73 PVABONGRP PVABONGRP JBONUS CHAR 2   0   Edition bonus grouping TJD49
74 XTECHVORB XTECHVORB XFELD CHAR 1   0   Indicator: Technical problem  
75 REMART REMART REMART CHAR 1   0   Return Type  
76 REMWEISE REMWEISE REMWEISE CHAR 1   0   Return Method  
77 REMQUOTE REMQUOTE ISPNUM32 DEC 5   2   Expected return rate in percent  
78 XMAXREMMG XMAXREMMG XFELD CHAR 1   0   Expected return quantity is maximum return quantity  
79 ETENR_LAST ETENR_LAST AENR NUMC 4   0   Last Schedule Line Number Assigned JKEP
80 ETEEX_LAST ETEEX_LAST ETEEX NUMC 6   0   Last Schedule Line Number Assigned  
81 KOKRS KOKRS CACCD CHAR 4   0   Controlling Area TKA01
82 KOSTL_L KOSTL_L KOSTL CHAR 10   0   Debit Cost Center CSKS
83 XPATE XPATE XFELD CHAR 1   0   IS-M: Sponsored subscription  
84 BEZIRK BEZIRK BEZIRK CHAR 10   0   Carrier Route JVTBEZIRK
85 XLIEFGP XLIEFGP XFELD CHAR 1   0   IS-M: Delivery to business partner  
86 XLIEFBEZ XLIEFBEZ XFELD CHAR 1   0   IS-M: Delivery to a carrier route (reserve)  
87 XNEGOPTION XNEGOPTION XFELD CHAR 1   0   IS-M: Item with Automatic Transformation to Chargeable  
88 BEZPERSE BEZPERSE BEZPER CHAR 5   0   IS-M: Service Type for Social Facility TJD09
89 VSOZMENGE VSOZMENGE MENGGPOS QUAN 10   0   IS-M: Maximum schedule line quantity for social facility  
90 LFBARDAT LFBARDAT DATUM DATS 8   0   Delivery viability set for sales order item valid from  
91 SHKZG SHKZG_ISP XFELD CHAR 1   0   IS-M: Debit indicator for schedule line  
92 VKBURZUS VKBURZUS VKBUR CHAR 4   0   Sales office responsible TVBUR
93 .INCLUDE       0   0   Created-By Data (Medium Scope)  
94 ERFUSER ERFUSER USNAM CHAR 12   0   Created By  
95 ERFDATE ERFDATE DATUM DATS 8   0   Created On  
96 ERFTIME ERFTIME UZEIT TIMS 6   0   Time Created  
97 AENUSER AENUSER USNAM CHAR 12   0   Last Changed By  
98 AENDATE AENDATE DATUM DATS 8   0   Date of Last Change  
99 AENTIME AENTIME UZEIT TIMS 6   0   Time of Last Change  
100 XSTORNO XJSTORNO XFELD CHAR 1   0   Indicator: Reversed  
101 STORNOGRD STORNOGRD STORNOGRD CHAR 3   0   Reversal Reason TJK91
102 REFBELEG REMELD_ISP CHAR20 CHAR 20   0   IS-M/SD: Reference Document in Legacy System  
103 XSCRIPT XSCRIPT XFELD CHAR 1   0   SAPscript comment recorded  
104 .INCLUDE       0   0   IS-PSD: WBZ Fields Relevant in Order Item  
105 WBZSATZART JWBZSTZART JWBZSTZART CHAR 3   0   IS-M: WBZ, Record Type TJKW1
106 WBZVORGART JWBZVORART JWBZVORART CHAR 3   0   IS-M: WBZ, Operation Type TJKW3
107 WERBKZSCHL JWBZWKZSCH JWBZWKZSCH CHAR 1   0   IS-M: WBZ, Promotion Rebate Key TJKW9
108 WBZABOKUNR JWBZABOKNR JWBZABOKNR CHAR 9   0   IS-M: Subscription Customer Number  
109 XWBZRUECKU XJWBZRUECK XFELD CHAR 1   0   IS-M: WBZ, reply to WBZ company required  
110 WBZKUNNR JWBZKUNNR JWBZKUNNR CHAR 6   0   IS-M: WBZ, VDZ Number of WBZ Company  
111 VERTRKENNZ JWBZVKENNZ JWBZVKENNZ CHAR 5   0   IS-M: WBZ, VDZ Sales Code (Num. Share Postal Sales Code) *
112 WBZTERMIN JWBZTERMIN CHAR9 CHAR 9   0   IS-M: WBZ, Date (Format: MMYYYYCCCC)  
113 WBZVERTRETER JWBZVERTR CHAR07 CHAR 7   0   IS-M: WBZ, representative indicator  
114 XSEPARATVS JXSEPRATVS XFELD CHAR 1   0   IS-M: Separate first delivery  
115 HEFTNUMVON HEFTNUMVON HEFTNUMMER CHAR 9   0   Copy Number of First Issue to be Delivered  
116 HEFTNUMBIS HEFTNUMBIS HEFTNUMMER CHAR 9   0   Copy Number of Last Issue for Delivery  
117 XNOMESS XNOMESS XFELD CHAR 1   0   IS-M: Indicator - Do Not Perform Output Determination  
118 JNBRIEFTYP JNBRIEFTYP JNBRIEFTYP CHAR 4   0   Letter type for generating letters using output control TJN11
119 XFMODRUECK XFMODRUECK XFELD CHAR 1   0   IS-M: Backdated changes to billing method  
120 XEXPDATE XEXPDATE XFELD CHAR 1   0   Limited order change affects expiration date  
121 TXJCD TXJCD TXJCD CHAR 15   0   Tax Jurisdiction *
122 XDELIV_FIXED XDELIV_FIXED XFELD CHAR 1   0   IS-M/SD: No Del.Viability Optimization (Parameters Fixed)  
123 XNEW_PUBL XNEW_PUBL XFELD CHAR 1   0   IS-M/SD: Item created by change of publication  
124 DELIVSPLITGRP DELIVSPLITGRP DELIVSPLITGRP CHAR 10   0   IS-M/SD: Address Alternation Group TJD63
125 DELIVSPLIT DELIVSPLIT DELIVSPLIT CHAR 8   0   IS-M/SD: Alternating Address Element TJD23
126 POSNR_MAIN APNR_MAIN APNR NUMC 6   0   IS-M/SD: Main Item in Sales Order JKAP
127 POSNR_SUB APNR_SUB APNR NUMC 6   0   IS-M/SD: Sub-Item in Sales Order JKAP
128 XMAINSPLIT XMAINSPLIT XFELD CHAR 1   0   Item for this Alternating Add. Element is a Main Sub-Item  
129 .INCLUDE       0   0   IS-M/SD: Field String for Weekdays  
130 X_MONTAG X_MONTAG XFELD CHAR 1   0   IS-M: Monday  
131 X_DIENSTAG X_DIENSTAG XFELD CHAR 1   0   IS-M: Tuesday  
132 X_MITTWOCH X_MITTWOCH XFELD CHAR 1   0   IS-M: Wednesday  
133 X_DONNETAG X_DONNETAG XFELD CHAR 1   0   IS-M: Thursday  
134 X_FREITAG X_FREITAG XFELD CHAR 1   0   IS-M: Friday  
135 X_SAMSTAG X_SAMSTAG XFELD CHAR 1   0   IS-M: Saturday  
136 X_SONNTAG X_SONNTAG XFELD CHAR 1   0   IS-M: Sunday  
137 CAMPAIGN ISM_MARKETING_CAMPAIGN ISM_MARKETING_CAMPAIGN RAW 16   0   IS-M: Marketing Campaign  
138 REFUNDTYPE REFUNDTYPE REFUNDTYPE CHAR 2   0   IS-M/SD: Refund Type TJK19
139 XVACPACK XVACPACK XFELD CHAR 1   0   IS-M/SD: Vacation Service: Postponed Delivery  
140 BONUSTYPE JBONUSTYPE JBONUSTYPE CHAR 2   0   IS-M/SD: Bonus Type  
141 .INCLUDE       0   0   IS-M/SD: Partner Field String for LIS Connection  
142 GPNRAG GPAG GPNR CHAR 10   0   Business Partner: Sold-to Party *
143 GPNRWE GPNR_WE GPNR CHAR 10   0   IS-M: Business Partner Ship-to Party *
144 GPNRRE GPNR_RE GPNR CHAR 10   0   IS-M: Business Partner - Bill-To Party *
145 GPNRRG GPNR_RG GPNR CHAR 10   0   IS-M: Payer Business Partner *
146 GPNRVM GPVERM GPNR CHAR 10   0   Business Partner Sales Agent *
147 PLZWE JMCPLZWE PSTLZ CHAR 10   0   Postal code in ship-to party address from order  
148 PLZRE JMCPLZRE PSTLZ CHAR 10   0   Postal code in bill-to party address from order  
149 KGSWE JMCKGSWE KREISG_SCH CHAR 15   0   District municip. key for ship-to party address from order *
150 .INCLUDE       0   0   IS-M/SD: LIS Comm.Structure, Additional Order Data on Item  
151 KURSK KURSK KURRF DEC 9   5   Exchange Rate for Pricing and Statistics  
152 PVABEZEI10 KBEZPVA TEXT10 CHAR 10   0   Short text for edition  
153 PVABERGRP1 PVABERGRP1 PVABERGRP1 CHAR 10   0   Report group 1 - edition *
154 PVABERGRP2 PVABERGRP2 PVABERGRP2 CHAR 10   0   Report group 2 - edition *
155 PVAPOVERKZ POVERKZ POVERKZ CHAR 8   0   IS-M: Postal distribution indicator  
156 PVAIVWNR IVWNR IVWNR NUMC 10   0   Circulation Audit Report ID for Edition  
157 PVAISPCNRO ISPCNROB ISPCNROB NUMC 6   0   ISPC Number of Object  
158 PVAISPCNRT ISPCNRTO ISPCNRTO NUMC 2   0   ISPC Number of Sub-Object  
159 VDZVERTRKZ JWBZVKENNZ JWBZVKENNZ CHAR 5   0   IS-M: WBZ, VDZ Sales Code (Num. Share Postal Sales Code) *
160 PVARKAUFNR J_RK_AUFNR J_RK_AUFNR CHAR 8   0   Order Number of RK Order for Account Assignment  
161 PVARKPOSNR J_RK_POSNR J_RK_POSNR NUMC 2   0   Item Number of RK Order for Account Assignment  
162 PVACOAUFNR J_CO_AUFNR AUFNR CHAR 12   0   Order number of internal CO order for account assignment *
163 WERBEART WERBEART WERBEART CHAR 4   0   Sales Source *
164 WERBEAKT WERBEAKT WERBEAKT CHAR 8   0   Sales Promotion *
165 WERBTRAEG WERBTRAEG WERBTRAEG CHAR 10   0   Advertising Medium *
166 SACHPRAEM MATNR_SAPR MATNR_ISP CHAR 18   0   IS-M: Material number for gift *
167 BEZIRKPOS JMCBEZIRKP BEZIRK CHAR 10   0   Carrier route for each return/complaint item *
168 GEOEINPOS JMCGEOEINP GEOEIN CHAR 10   0   Geographical unit for each return/complaint item *
169 XLPOS_UP JXLPOS_UP XFELD CHAR 1   0   Last item in a chain of original items  
170 XFPOSDRE JXFPOSDRE XFELD CHAR 1   0   Indicator 'first item' after change of publication  
171 XLPOSDRE JXLPOSDRE XFELD CHAR 1   0   Indicator 'last item' before change of publication  
172 XFPOSPVA JXFPOSPVA XFELD CHAR 1   0   Indicator 'first item' after change of edition  
173 XLPOSPVA JXLPOSPVA XFELD CHAR 1   0   Indicator 'last item' before change of publication  
174 .INCLUDE       0   0   IS-M/SD: LIS Comm.Str., Complaint Item, Dist.Error Message  
175 FVGRUND FVGRUND FVGRUND CHAR 4   0   IS-M: Reason for Shipping Problem Message or Complaint *
176 FVVERURS FVVERURS FVVERURS CHAR 4   0   IS-M: Origin of Shipping Problem Message or Complaint *
177 FVLFARTLOG LFARTLOG LIEFERART CHAR 2   0   Logistical delivery type *
178 FVZUSTELLR JZUSTELLER GPNR CHAR 10   0   IS-M: Carrier *
179 FVVSGZUSTL VSGZUSTLR GPNR CHAR 10   0   IS-M/SD: Service Company to Which Carrier Belongs *
180 FVBEZIRK BEZIRK BEZIRK CHAR 10   0   Carrier Route *
181 FVBEZRUNDE BEZRUNDE BEZRUNDE CHAR 10   0   IS-M: Delivery Round *
182 FVXNACHLIE XNACHLIEF XFELD CHAR 1   0   IS-M: Indicator 'Execute Subsequent Delivery'  
183 FVJZIVERSD JZIVERSDAT DATUM DATS 8   0   IS-M: Shipping date in carrier information  
184 FVXKEINEAB XKEINEABLG XFELD CHAR 1   0   IS-M: Error message does not reference a drop-off  
185 FVXAUFPOSU XUNVLIEFER XFELD CHAR 1   0   IS-M: Viability Data Incomplete for Item  
186 .INCLUDE       0   0   IS-M/SD: LIS Comm.Structure - Order Item, User Data  
187 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 MCJKAP BEZIRK JVTBEZIRK BEZIRK REF C CN
2 MCJKAP BEZPERSE TJD09 BEZPER REF C CN
3 MCJKAP BEZUGGRD TJK87 BEZUGGRD REF C CN
4 MCJKAP BEZUGSTYP JDTBEZTYP BEZTYP REF 1 CN
5 MCJKAP DELIVSPLIT TJD23 DELIVSPLIT REF C CN
6 MCJKAP DELIVSPLITGRP TJD63 DELIVSPLITGRP REF C CN
7 MCJKAP DRERZ JDTDRER DRERZ REF C CN
8 MCJKAP DRUCKEREI T001W WERKS REF C CN
9 MCJKAP ETENR_LAST JKEP ETENR REF C CN
10 MCJKAP FAKSP TVFS FAKSP REF C CN
11 MCJKAP GSBER TGSB GSBER REF C CN
12 MCJKAP IVWKN TJI01 IVWKN REF C CN
13 MCJKAP IVWKNFREI TJI01 IVWKN REF C CN
14 MCJKAP JNBRIEFTYP TJN11 JNBRIEFTYP REF C CN
15 MCJKAP KOKRS TKA01 KOKRS REF C CN
16 MCJKAP KORRGRD TJK81 KORRGRD REF C CN
17 MCJKAP KOSTL_L CSKS KOSTL REF C CN
18 MCJKAP KUENDGRD TJK83 KUENDGRD REF C CN
19 MCJKAP KUNWE JGTGPNR GPNR REF C CN
20 MCJKAP LAND1 T005 LAND1 REF C CN
21 MCJKAP LANDE T005 LAND1 REF C CN
22 MCJKAP LIEFERART TJV01 LIEFERART REF C CN
23 MCJKAP MANDT T000 MANDT KEY 1 CN
24 MCJKAP MATKL T023 MATKL REF C CN
25 MCJKAP POART TJAP POART REF 1 CN
26 MCJKAP POSNR_MAIN JKAP POSNR REF C CN
27 MCJKAP POSNR_SUB JKAP POSNR REF C CN
28 MCJKAP POSNR_UR JKAP POSNR REF 1 CN
29 MCJKAP POSNR_VG JKAP POSNR REF 1 CN
30 MCJKAP POSNR_VL JKAP POSNR REF C CN
31 MCJKAP PVA JDTPVA PVA REF C CN
32 MCJKAP PVABONGRP TJD49 PVABONGRP REF C CN
33 MCJKAP PVAKNTGRP TVKM KTGRM REF C CN
34 MCJKAP PVAKONGRP TJD47 PVAKONGRP REF C CN
35 MCJKAP REFUNDTYPE TJK19 REFUNDTYPE REF    
36 MCJKAP SPART TSPA SPART REF C CN
37 MCJKAP STORNOGRD TJK91 STORNOGRD REF C CN
38 MCJKAP UNTBRGRD TJK85 UNTBRGRD REF C CN
39 MCJKAP VBELN JKAK VBELN KEY 1 CN
40 MCJKAP VBELN_VL JKAK VBELN REF C CN
41 MCJKAP VKBURZUS TVBUR VKBUR REF C CN
42 MCJKAP VSAUSSTART TJV09 VSAUSSTART REF C CN
43 MCJKAP WBZSATZART TJKW1 SATZART    
44 MCJKAP WBZVORGART TJKW3 VORGANGART    
45 MCJKAP WERBKZSCHL TJKW9 WERBKZSCHL 1 CN
History
Last changed by/on SAP  20110901 
SAP Release Created in