JKAPA SAP (Sales Order: Limited Item) Structure details
Description: Sales Order: Limited Item
Structure field list including key, data, relationships and ABAP select examples
JKAPA is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Sales Order: Limited Item" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_JKAPA TYPE JKAPA.
The JKAPA table consists of various fields, each holding specific information or linking keys about Sales Order: Limited Item data available in SAP. These include MANDT (Client), VBELN (IS-M/SD: Publishing Sales Order), POSNR (Sales Order Item), GUELTIGVON (Valid-From Date of Sales Order Item).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP JKAPA structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
VBELN | IS-M/SD: Publishing Sales Order | AVNR | CHAR | 10 | JKAK | ALPHA | AVNR | JK1 | MJK1 |
POSNR | Sales Order Item | APNR | NUMC | 6 | Assigned to domain | APNR | |||
GUELTIGVON | Valid-From Date of Sales Order Item | JKAPVON | DATS | 8 | DATUM | JC1 | |||
GUELTIGBIS | Date to which Sales Order Item is Valid | JKAPBIS | DATS | 8 | DATUM | JC2 | |||
POART | Internal Item Type for Sales Order | POART_ISP | CHAR | 2 | TJAP | POART_ISP | JAP | ||
AEART | Order Change Type | AEART_JSDK | CHAR | 1 | AEART_JSDK | ||||
ZSKLS | Time slice classification for sales order | JZSKLS | CHAR | 1 | JZSKLS | ||||
POSEX | External Item Number (Purchase Order Item) | POSEX_ISP | NUMC | 6 | POSEX_ISP | JK2 | |||
KUNWE | IS-M: Business Partner Ship-to Party | GPNR_WE | CHAR | 10 | JGTGPNR | ALPHA | GPNR | JGP | |
KUNWEFREMD | Cust.No. with External Company (External Deliveries/Retail) | JKUNNRVERL | CHAR | 15 | JKUNNRVERL | ||||
LANDE | Current country being supplied | LANDE_ISP | CHAR | 3 | T005 | LAND1 | LND | ||
LAND1 | Normal delivery country | LAND1_ISP | CHAR | 3 | T005 | LAND1 | LND | ||
DRERZ | Publication | DRERZ | CHAR | 8 | JDTDRER | ALPHA | DRERZ | JD1 | MJD1 |
PVA | Edition | PVA | CHAR | 8 | JDTPVA | ALPHA | PVA | JD2 | |
BEZUGSTYP | Mix Type | BEZUGSTYP_JE_PVA | CHAR | 2 | JDTBEZTYP | BEZUGSTYP_JE_PVA | JD3 | MJD7 | |
XRUECKABO | IS-M: Backdated subscription created | XRUECKABO | CHAR | 1 | XFELD | ||||
LIEFVON | Regular start of delivery for item in sales order | LIEFVON | DATS | 8 | DATUM | JK3 | |||
SPART | Division for publication | SPARTDRERZ | CHAR | 2 | TSPA | SPART | SPA | ||
MATKL | Material Group | MATKL | CHAR | 9 | T023 | MATKL | MKL | S_WBWG | |
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
VOREF | Complete reference indicator | VOREF | CHAR | 1 | XFELD | ||||
ERLRE | Completion rule for quotation / contract | ERLRE | CHAR | 1 | ERLRE | ||||
TAXM1 | Tax classification material | TAXMT | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXM2 | Tax classification material | TAXMT | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXM3 | Tax classification material | TAXMT | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXM4 | Tax classification material | TAXMT | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXM5 | Tax classification material | TAXMT | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXM6 | Tax classification material | TAXMT | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXM7 | Tax classification material | TAXMT | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXM8 | Tax classification material | TAXMT | CHAR | 1 | Assigned to domain | TAXKD | |||
TAXM9 | Tax classification material | TAXMT | CHAR | 1 | Assigned to domain | TAXKD | |||
VGREF | Preceding document has resulted from reference | VGREF | CHAR | 1 | XFELD | ||||
STAFO | Update group for statistics update | STAFO | CHAR | 6 | Assigned to domain | ALPHA | STAFO | MCF | |
STCUR | Exchange rate for statistics (Exch.rate at time of creation) | STCUR_AP | DEC | 9(5) | KURRF | ||||
IVWKN | Circulation Audit Report Category ID | IVWKN | CHAR | 8 | TJI01 | IVWKN | |||
IVWKNFREI | Circulation Report Category ID for Non-Calculation Period | IVWKNFREI | CHAR | 8 | TJI01 | IVWKN | |||
XLIEFSE | Delivery to social facility | XLIEFSE | CHAR | 1 | XFELD | ||||
LIEFERART | Delivery Type | LIEFERART | CHAR | 2 | TJV01 | LIEFERART | JLA | ||
LIEFXUHR | Time of latest delivery | LIEFXUHR | TIMS | 6 | UZEIT | ||||
DRUCKEREI | Plant | JWERK | CHAR | 4 | T001W | WERKS | WRK | ||
VSAUSSTART | Shipping outsorting type | VSAUSSTART | CHAR | 2 | TJV09 | VSAUSSTART | |||
UNTBRGRD | Reason for Suspension | UNTBRGRD | CHAR | 3 | TJK85 | UNTBRGRD | JK9 | ||
BEZUGGRD | Purchase Reason | BEZUGGRD | CHAR | 3 | TJK87 | BEZUGGRD | JK8 | ||
KORRGRD | IS-M: Reason for correction | KORRGRD | CHAR | 3 | TJK81 | KORRGRD | JK7 | ||
GUTSCHEIN | Coupon Number | GUTSCHEIN | NUMC | 8 | GUTSCHEIN | ||||
XGUTSCHEIN | Indicator: Vouchers allowed | XGUTSCHEIN | CHAR | 1 | XFELD | ||||
XDISPO | Indicator: relevant to planning | XDISPO | CHAR | 1 | XFELD | ||||
XUNVLIEFER | IS-M: Viability Data Incomplete for Item | XUNVLIEFER | CHAR | 1 | XFELD | ||||
XUNVLAUTO | IS-M: Via.data incomp.for item (due to automatic change) | XUNVLAUTO | CHAR | 1 | XFELD | ||||
RECHBEGINN | Billing From | RECHBEGINN | DATS | 8 | DATUM | ||||
RECHENDE | Billing To | RECHENDE | DATS | 8 | DATUM | ||||
XLIEFBAR | Determine delivery viability | XLIEFBAR | CHAR | 1 | XFELD | ||||
XIVW | Indicator: Relevant for audit report | XIVW | CHAR | 1 | XFELD | ||||
XFAKTURA | Indicator: Relevant for billing | XFAKTURA | CHAR | 1 | XFELD | ||||
PRSFD | Carry out pricing | PRSFD | CHAR | 1 | PRSFD | ||||
SBFREI | Administrator responsible for free copies | SBFREI | CHAR | 12 | USNAM | ||||
WDVDAT | Resubmission date | WDVDAT | DATS | 8 | DATUM | ||||
KUENDGRD | Reason for end of delivery | KUENDGRD | CHAR | 3 | TJK83 | KUENDGRD | |||
XLOGO | Print Logo | XLOGO | CHAR | 1 | XFELD | ||||
FAKSP | Billing Block | FAKTSPERRE | CHAR | 2 | TVFS | FAKSP | |||
XFAKTSPERR | IS-M: Billing block set | XFAKTSPERR | CHAR | 1 | XFELD | ||||
XREMRECHT | IS-M: Right of Return | XREMRECHT | CHAR | 1 | XFELD | ||||
XBAGABR | Indicator: BAG billing procedure | XBAGABR | CHAR | 1 | XFELD | ||||
XURPOS | Original item in publishing sales order | XURPOS | CHAR | 1 | XFELD | ||||
POSNR_UR | Original Item in Publishing Sales Order | APNR_UR | NUMC | 6 | JKAP | APNR | |||
POSNR_VG | Preceding Item in Publishing Sales Order | APNR_VG | NUMC | 6 | JKAP | APNR | |||
VBELN_VL | Reference Document | AVNR_VL | CHAR | 10 | JKAK | ALPHA | AVNR | ||
POSNR_VL | Reference Document Item | APNR_VL | NUMC | 6 | JKAP | APNR | |||
PVAKNTGRP | Account Assignment Grouping for Edition | PVAKNTGRP | CHAR | 2 | TVKM | KTGRM | |||
PVAKONGRP | Condition Grouping for Edition | PVAKONGRP | CHAR | 2 | TJD47 | JKONDM | JDPVAKONGRP | ||
PVABONGRP | Edition bonus grouping | PVABONGRP | CHAR | 2 | TJD49 | JBONUS | |||
XTECHVORB | Indicator: Technical problem | XTECHVORB | CHAR | 1 | XFELD | ||||
REMART | Return Type | REMART | CHAR | 1 | REMART | ||||
REMWEISE | Return Method | REMWEISE | CHAR | 1 | REMWEISE | ||||
REMQUOTE | Expected return rate in percent | REMQUOTE | DEC | 5(2) | ISPNUM32 | ||||
XMAXREMMG | Expected return quantity is maximum return quantity | XMAXREMMG | CHAR | 1 | XFELD | ||||
ETENR_LAST | Last Schedule Line Number Assigned | ETENR_LAST | NUMC | 4 | JKEP | AENR | |||
ETEEX_LAST | Last Schedule Line Number Assigned | ETEEX_LAST | NUMC | 6 | ETEEX | ||||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
KOSTL_L | Debit Cost Center | KOSTL_L | CHAR | 10 | CSKS | ALPHA | KOSTL | KOS | |
XPATE | IS-M: Sponsored subscription | XPATE | CHAR | 1 | XFELD | ||||
BEZIRK | Carrier Route | BEZIRK | CHAR | 10 | JVTBEZIRK | ALPHA | BEZIRK | BEZ | MJVC |
XLIEFGP | IS-M: Delivery to business partner | XLIEFGP | CHAR | 1 | XFELD | ||||
XLIEFBEZ | IS-M: Delivery to a carrier route (reserve) | XLIEFBEZ | CHAR | 1 | XFELD | ||||
XNEGOPTION | IS-M: Item with Automatic Transformation to Chargeable | XNEGOPTION | CHAR | 1 | XFELD | ||||
BEZPERSE | IS-M: Service Type for Social Facility | BEZPERSE | CHAR | 5 | TJD09 | BEZPER | JD4 | ||
VSOZMENGE | IS-M: Maximum schedule line quantity for social facility | VSOZMENGE | QUAN | 10 | MENGGPOS | ||||
LFBARDAT | Delivery viability set for sales order item valid from | LFBARDAT | DATS | 8 | DATUM | ||||
SHKZG | IS-M: Debit indicator for schedule line | SHKZG_ISP | CHAR | 1 | XFELD | ||||
VKBURZUS | Sales office responsible | VKBURZUS | CHAR | 4 | TVBUR | VKBUR | |||
ERFUSER | Created By | ERFUSER | CHAR | 12 | USNAM | ||||
ERFDATE | Created On | ERFDATE | DATS | 8 | DATUM | ||||
ERFTIME | Time Created | ERFTIME | TIMS | 6 | UZEIT | ||||
AENUSER | Last Changed By | AENUSER | CHAR | 12 | USNAM | ||||
AENDATE | Date of Last Change | AENDATE | DATS | 8 | DATUM | ||||
AENTIME | Time of Last Change | AENTIME | TIMS | 6 | UZEIT | ||||
XSTORNO | Indicator: Reversed | XJSTORNO | CHAR | 1 | XFELD | ||||
STORNOGRD | Reversal Reason | STORNOGRD | CHAR | 3 | TJK91 | STORNOGRD | JK6 | ||
REFBELEG | IS-M/SD: Reference Document in Legacy System | REMELD_ISP | CHAR | 20 | CHAR20 | ||||
XSCRIPT | SAPscript comment recorded | XSCRIPT | CHAR | 1 | XFELD | ||||
WBZSATZART | IS-M: WBZ, Record Type | JWBZSTZART | CHAR | 3 | TJKW1 | JWBZSTZART | |||
WBZVORGART | IS-M: WBZ, Operation Type | JWBZVORART | CHAR | 3 | TJKW3 | JWBZVORART | |||
WERBKZSCHL | IS-M: WBZ, Promotion Rebate Key | JWBZWKZSCH | CHAR | 1 | TJKW9 | JWBZWKZSCH | |||
WBZABOKUNR | IS-M: Subscription Customer Number | JWBZABOKNR | CHAR | 9 | JKWBZ | JWBZABOKNR | |||
XWBZRUECKU | IS-M: WBZ, reply to WBZ company required | XJWBZRUECK | CHAR | 1 | XFELD | ||||
WBZKUNNR | IS-M: WBZ, VDZ Number of WBZ Company | JWBZKUNNR | CHAR | 6 | JKWBZ | JWBZKUNNR | |||
VERTRKENNZ | IS-M: WBZ, VDZ Sales Code (Num. Share Postal Sales Code) | JWBZVKENNZ | CHAR | 5 | Assigned to domain | JKWBZ | JWBZVKENNZ | ||
WBZTERMIN | IS-M: WBZ, Date (Format: MMYYYYCCCC) | JWBZTERMIN | CHAR | 9 | CHAR9 | ||||
WBZVERTRETER | IS-M: WBZ, representative indicator | JWBZVERTR | CHAR | 7 | CHAR07 | ||||
XSEPARATVS | IS-M: Separate first delivery | JXSEPRATVS | CHAR | 1 | XFELD | ||||
HEFTNUMVON | Copy Number of First Issue to be Delivered | HEFTNUMVON | CHAR | 9 | HEFTNUMMER | ||||
HEFTNUMBIS | Copy Number of Last Issue for Delivery | HEFTNUMBIS | CHAR | 9 | HEFTNUMMER | ||||
XNOMESS | IS-M: Indicator - Do Not Perform Output Determination | XNOMESS | CHAR | 1 | XFELD | ||||
JNBRIEFTYP | Letter type for generating letters using output control | JNBRIEFTYP | CHAR | 4 | TJN11 | JNBRIEFTYP | |||
XFMODRUECK | IS-M: Backdated changes to billing method | XFMODRUECK | CHAR | 1 | XFELD | ||||
XEXPDATE | Limited order change affects expiration date | XEXPDATE | CHAR | 1 | XFELD | ||||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
XDELIV_FIXED | IS-M/SD: No Del.Viability Optimization (Parameters Fixed) | XDELIV_FIXED | CHAR | 1 | XFELD | JKDELIV_FIXED | |||
XNEW_PUBL | IS-M/SD: Item created by change of publication | XNEW_PUBL | CHAR | 1 | XFELD | ||||
DELIVSPLITGRP | IS-M/SD: Address Alternation Group | DELIVSPLITGRP | CHAR | 10 | TJD63 | ALPHA | DELIVSPLITGRP | ||
DELIVSPLIT | IS-M/SD: Alternating Address Element | DELIVSPLIT | CHAR | 8 | TJD23 | ALPHA | DELIVSPLIT | ||
POSNR_MAIN | IS-M/SD: Main Item in Sales Order | APNR_MAIN | NUMC | 6 | JKAP | APNR | |||
POSNR_SUB | IS-M/SD: Sub-Item in Sales Order | APNR_SUB | NUMC | 6 | JKAP | APNR | |||
XMAINSPLIT | Item for this Alternating Add. Element is a Main Sub-Item | XMAINSPLIT | CHAR | 1 | XFELD | ||||
X_MONTAG | IS-M: Monday | X_MONTAG | CHAR | 1 | XFELD | ||||
X_DIENSTAG | IS-M: Tuesday | X_DIENSTAG | CHAR | 1 | XFELD | ||||
X_MITTWOCH | IS-M: Wednesday | X_MITTWOCH | CHAR | 1 | XFELD | ||||
X_DONNETAG | IS-M: Thursday | X_DONNETAG | CHAR | 1 | XFELD | ||||
X_FREITAG | IS-M: Friday | X_FREITAG | CHAR | 1 | XFELD | ||||
X_SAMSTAG | IS-M: Saturday | X_SAMSTAG | CHAR | 1 | XFELD | ||||
X_SONNTAG | IS-M: Sunday | X_SONNTAG | CHAR | 1 | XFELD | ||||
CAMPAIGN | IS-M: Marketing Campaign | ISM_MARKETING_CAMPAIGN | RAW | 16 | MCAMP | ISM_MARKETING_CAMPAIGN | PRPM_CGPL_K | ||
REFUNDTYPE | IS-M/SD: Refund Type | REFUNDTYPE | CHAR | 2 | TJK19 | REFUNDTYPE | |||
XVACPACK | Vacation Service: Postponed Delivery | XVACPACK | CHAR | 1 | XFELD | ||||
BONUSTYPE | IS-M/SD: Bonus Type | JBONUSTYPE | CHAR | 2 | JBONUSTYPE |
Key field | Non-key field |
How do I retrieve data from SAP structure JKAPA using ABAP code?
As JKAPA is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on JKAPA as there is no data to select.How to access SAP table JKAPA
Within an ECC or HANA version of SAP you can also view further information about JKAPA and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects