SAP Table JKAP - Sales Order - Item Data

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
VBELN X AVNR CHAR 3 10 0 JKAK IS-M/SD: Publishing Sales Order
POSNR X APNR NUMC 13 6 0 JKAP Sales Order Item
GUELTIGVON JKAPVON DATS 19 8 0 Valid-From Date of Sales Order Item
GUELTIGBIS JKAPBIS DATS 27 8 0 Date to which Sales Order Item is Valid
POART POART_ISP CHAR 35 2 0 Internal Item Type for Sales Order
AEART AEART_JSDK CHAR 37 1 0 Order Change Type
ZSKLS JZSKLS CHAR 38 1 0 Time slice classification for sales order
POSEX POSEX_ISP NUMC 39 6 0 External Item Number (Purchase Order Item)
KUNWE GPNR_WE CHAR 45 10 0 JGTGPNR IS-M: Business Partner Ship-to Party
KUNWEFREMD JKUNNRVERL CHAR 55 15 0 Cust.No. with External Company (External Deliveries/Retail)
LANDE LANDE_ISP CHAR 70 3 0 T005 Current country being supplied
LAND1 LAND1_ISP CHAR 73 3 0 T005 Normal delivery country
DRERZ DRERZ CHAR 76 8 0 JDTDRER Publication
PVA PVA CHAR 84 8 0 JDTPVA Edition
BEZUGSTYP BEZUGSTYP_JE_PVA CHAR 92 2 0 JDTBEZTYP Mix Type
XRUECKABO XRUECKABO CHAR 94 1 0 IS-M: Backdated subscription created
LIEFVON LIEFVON DATS 95 8 0 Regular start of delivery for item in sales order
SPART SPARTDRERZ CHAR 103 2 0 TSPA Division for publication
MATKL MATKL CHAR 105 9 0 T023 Material Group
GSBER GSBER CHAR 114 4 0 TGSB Business Area
VOREF VOREF CHAR 118 1 0 Complete reference indicator
ERLRE ERLRE CHAR 119 1 0 Completion rule for quotation / contract
TAXM1 TAXMT CHAR 120 1 0 Tax classification material
TAXM2 TAXMT CHAR 121 1 0 Tax classification material
TAXM3 TAXMT CHAR 122 1 0 Tax classification material
TAXM4 TAXMT CHAR 123 1 0 Tax classification material
TAXM5 TAXMT CHAR 124 1 0 Tax classification material
TAXM6 TAXMT CHAR 125 1 0 Tax classification material
TAXM7 TAXMT CHAR 126 1 0 Tax classification material
TAXM8 TAXMT CHAR 127 1 0 Tax classification material
TAXM9 TAXMT CHAR 128 1 0 Tax classification material
VGREF VGREF CHAR 129 1 0 Preceding document has resulted from reference
STAFO STAFO CHAR 130 6 0 Update group for statistics update
STCUR STCUR_AP DEC 136 9 5 Exchange rate for statistics (Exch.rate at time of creation)
IVWKN IVWKN CHAR 141 8 0 Circulation Audit Report Category ID
IVWKNFREI IVWKNFREI CHAR 149 8 0 Circulation Report Category ID for Non-Calculation Period
XLIEFSE XLIEFSE CHAR 157 1 0 Delivery to social facility
LIEFERART LIEFERART CHAR 158 2 0 TJV01 Delivery Type
LIEFXUHR LIEFXUHR TIMS 160 6 0 Time of latest delivery
DRUCKEREI JWERK CHAR 166 4 0 T001W Plant
VSAUSSTART VSAUSSTART CHAR 170 2 0 Shipping outsorting type
UNTBRGRD UNTBRGRD CHAR 172 3 0 Reason for Suspension
BEZUGGRD BEZUGGRD CHAR 175 3 0 TJK87 Purchase Reason
KORRGRD KORRGRD CHAR 178 3 0 IS-M: Reason for correction
GUTSCHEIN GUTSCHEIN NUMC 181 8 0 Coupon Number
XGUTSCHEIN XGUTSCHEIN CHAR 189 1 0 Indicator: Vouchers allowed
XDISPO XDISPO CHAR 190 1 0 Indicator: relevant to planning
XUNVLIEFER XUNVLIEFER CHAR 191 1 0 IS-M: Viability Data Incomplete for Item
XUNVLAUTO XUNVLAUTO CHAR 192 1 0 IS-M: Via.data incomp.for item (due to automatic change)
RECHBEGINN RECHBEGINN DATS 193 8 0 Billing From
RECHENDE RECHENDE DATS 201 8 0 Billing To
XLIEFBAR XLIEFBAR CHAR 209 1 0 Determine delivery viability
XIVW XIVW CHAR 210 1 0 Indicator: Relevant for audit report
XFAKTURA XFAKTURA CHAR 211 1 0 Indicator: Relevant for billing
PRSFD PRSFD CHAR 212 1 0 Carry out pricing
SBFREI SBFREI CHAR 213 12 0 Administrator responsible for free copies
WDVDAT WDVDAT DATS 225 8 0 Resubmission date
KUENDGRD KUENDGRD CHAR 233 3 0 TJK83 Reason for end of delivery
XLOGO XLOGO CHAR 236 1 0 Print Logo
FAKSP FAKTSPERRE CHAR 237 2 0 TVFS Billing Block
XFAKTSPERR XFAKTSPERR CHAR 239 1 0 IS-M: Billing block set
XREMRECHT XREMRECHT CHAR 240 1 0 IS-M: Right of Return
XBAGABR XBAGABR CHAR 241 1 0 Indicator: BAG billing procedure
XURPOS XURPOS CHAR 242 1 0 Original item in publishing sales order
POSNR_UR APNR_UR NUMC 243 6 0 JKAP Original Item in Publishing Sales Order
POSNR_VG APNR_VG NUMC 249 6 0 JKAP Preceding Item in Publishing Sales Order
VBELN_VL AVNR_VL CHAR 255 10 0 JKAK Reference Document
POSNR_VL APNR_VL NUMC 265 6 0 JKAP Reference Document Item
PVAKNTGRP PVAKNTGRP CHAR 271 2 0 Account Assignment Grouping for Edition
PVAKONGRP PVAKONGRP CHAR 273 2 0 Condition Grouping for Edition
PVABONGRP PVABONGRP CHAR 275 2 0 Edition bonus grouping
XTECHVORB XTECHVORB CHAR 277 1 0 Indicator: Technical problem
REMART REMART CHAR 278 1 0 Return Type
REMWEISE REMWEISE CHAR 279 1 0 Return Method
REMQUOTE REMQUOTE DEC 280 5 2 Expected return rate in percent
XMAXREMMG XMAXREMMG CHAR 283 1 0 Expected return quantity is maximum return quantity
ETENR_LAST ETENR_LAST NUMC 284 4 0 Last Schedule Line Number Assigned
ETEEX_LAST ETEEX_LAST NUMC 288 6 0 Last Schedule Line Number Assigned
KOKRS KOKRS CHAR 294 4 0 TKA01 Controlling Area
KOSTL_L KOSTL_L CHAR 298 10 0 Debit Cost Center
XPATE XPATE CHAR 308 1 0 IS-M: Sponsored subscription
BEZIRK BEZIRK CHAR 309 10 0 JVTBEZIRK Carrier Route
XLIEFGP XLIEFGP CHAR 319 1 0 IS-M: Delivery to business partner
XLIEFBEZ XLIEFBEZ CHAR 320 1 0 IS-M: Delivery to a carrier route (reserve)
XNEGOPTION XNEGOPTION CHAR 321 1 0 IS-M: Item with Automatic Transformation to Chargeable
BEZPERSE BEZPERSE CHAR 322 5 0 IS-M: Service Type for Social Facility
VSOZMENGE VSOZMENGE QUAN 327 10 0 IS-M: Maximum schedule line quantity for social facility
LFBARDAT LFBARDAT DATS 333 8 0 Delivery viability set for sales order item valid from
SHKZG SHKZG_ISP CHAR 341 1 0 IS-M: Debit indicator for schedule line
VKBURZUS VKBURZUS CHAR 342 4 0 TVBUR Sales office responsible
ERFUSER ERFUSER CHAR 346 12 0 Created By
ERFDATE ERFDATE DATS 358 8 0 Created On
ERFTIME ERFTIME TIMS 366 6 0 Time Created
AENUSER AENUSER CHAR 372 12 0 Last Changed By
AENDATE AENDATE DATS 384 8 0 Date of Last Change
AENTIME AENTIME TIMS 392 6 0 Time of Last Change
XSTORNO XJSTORNO CHAR 398 1 0 Indicator: Reversed
STORNOGRD STORNOGRD CHAR 399 3 0 Reversal Reason
REFBELEG REMELD_ISP CHAR 402 20 0 IS-M/SD: Reference Document in Legacy System
XSCRIPT XSCRIPT CHAR 422 1 0 SAPscript comment recorded
WBZSATZART JWBZSTZART CHAR 423 3 0 IS-M: WBZ, Record Type
WBZVORGART JWBZVORART CHAR 426 3 0 TJKW3 IS-M: WBZ, Operation Type
WERBKZSCHL JWBZWKZSCH CHAR 429 1 0 IS-M: WBZ, Promotion Rebate Key
WBZABOKUNR JWBZABOKNR CHAR 430 9 0 IS-M: Subscription Customer Number
XWBZRUECKU XJWBZRUECK CHAR 439 1 0 IS-M: WBZ, reply to WBZ company required
WBZKUNNR JWBZKUNNR CHAR 440 6 0 IS-M: WBZ, VDZ Number of WBZ Company
VERTRKENNZ JWBZVKENNZ CHAR 446 5 0 TJKWE IS-M: WBZ, VDZ Sales Code (Num. Share Postal Sales Code)
WBZTERMIN JWBZTERMIN CHAR 451 9 0 IS-M: WBZ, Date (Format: MMYYYYCCCC)
WBZVERTRETER JWBZVERTR CHAR 460 7 0 IS-M: WBZ, representative indicator
XSEPARATVS JXSEPRATVS CHAR 467 1 0 IS-M: Separate first delivery
HEFTNUMVON HEFTNUMVON CHAR 468 9 0 Copy Number of First Issue to be Delivered
HEFTNUMBIS HEFTNUMBIS CHAR 477 9 0 Copy Number of Last Issue for Delivery
XNOMESS XNOMESS CHAR 486 1 0 IS-M: Indicator - Do Not Perform Output Determination
JNBRIEFTYP JNBRIEFTYP CHAR 487 4 0 Letter type for generating letters using output control
XFMODRUECK XFMODRUECK CHAR 491 1 0 IS-M: Backdated changes to billing method
XEXPDATE XEXPDATE CHAR 492 1 0 Limited order change affects expiration date
TXJCD TXJCD CHAR 493 15 0 TTXJ Tax Jurisdiction
XDELIV_FIXED XDELIV_FIXED CHAR 508 1 0 IS-M/SD: No Del.Viability Optimization (Parameters Fixed)
XNEW_PUBL XNEW_PUBL CHAR 509 1 0 IS-M/SD: Item created by change of publication
DELIVSPLITGRP DELIVSPLITGRP CHAR 510 10 0 IS-M/SD: Address Alternation Group
DELIVSPLIT DELIVSPLIT CHAR 520 8 0 IS-M/SD: Alternating Address Element
POSNR_MAIN APNR_MAIN NUMC 528 6 0 JKAP IS-M/SD: Main Item in Sales Order
POSNR_SUB APNR_SUB NUMC 534 6 0 JKAP IS-M/SD: Sub-Item in Sales Order
XMAINSPLIT XMAINSPLIT CHAR 540 1 0 Item for this Alternating Add. Element is a Main Sub-Item
X_MONTAG X_MONTAG CHAR 541 1 0 IS-M: Monday
X_DIENSTAG X_DIENSTAG CHAR 542 1 0 IS-M: Tuesday
X_MITTWOCH X_MITTWOCH CHAR 543 1 0 IS-M: Wednesday
X_DONNETAG X_DONNETAG CHAR 544 1 0 IS-M: Thursday
X_FREITAG X_FREITAG CHAR 545 1 0 IS-M: Friday
X_SAMSTAG X_SAMSTAG CHAR 546 1 0 IS-M: Saturday
X_SONNTAG X_SONNTAG CHAR 547 1 0 IS-M: Sunday
CAMPAIGN ISM_MARKETING_CAMPAIGN RAW 548 16 0 IS-M: Marketing Campaign
REFUNDTYPE REFUNDTYPE CHAR 564 2 0 IS-M/SD: Refund Type
XVACPACK XVACPACK CHAR 566 1 0 IS-M/SD: Vacation Service: Postponed Delivery
BONUSTYPE JBONUSTYPE CHAR 567 2 0 IS-M/SD: Bonus Type

985700M/SD: Date of services rendered in invoice
756826IS-MEDIA: Additional indexes for MaxDB
215076IS-M/SD: Amortization of trips with renewal subscription