JSBW_SD_ORDER_ITEM_COMPL SAP (IS-M/SD: BW Structure for Internal Order Item) Structure details
Dictionary Type: Structure
Description: IS-M/SD: BW Structure for Internal Order Item
Description: IS-M/SD: BW Structure for Internal Order Item
ABAP Code to SELECT data from JSBW_SD_ORDER_ITEM_COMPL
Related tables to JSBW_SD_ORDER_ITEM_COMPL
Access table JSBW_SD_ORDER_ITEM_COMPL
Related tables to JSBW_SD_ORDER_ITEM_COMPL
Access table JSBW_SD_ORDER_ITEM_COMPL
Structure field list including key, data, relationships and ABAP select examples
JSBW_SD_ORDER_ITEM_COMPL 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 "IS-M/SD: BW Structure for Internal Order 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_JSBW_SD_ORDER_ITEM_COMPL TYPE JSBW_SD_ORDER_ITEM_COMPL.
The JSBW_SD_ORDER_ITEM_COMPL table consists of various fields, each holding specific information or linking keys about IS-M/SD: BW Structure for Internal Order Item data available in SAP. These include VBELN (IS-M/SD: Publishing Sales Order), POSNR (Sales Order Item), GUELTIGVON (Valid-From Date of Sales Order Item), GUELTIGBIS (Date to which Sales Order Item is Valid).. 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 JSBW_SD_ORDER_ITEM_COMPL 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 |
| STORNO_KZ | IS-M: Reversal BW (0Recordmode) | XSTORNO_KZ | CHAR | 1 | XFELD | ||||
| VBELN | IS-M/SD: Publishing Sales Order | AVNR | CHAR | 10 | Assigned to domain | 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 | Assigned to domain | 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 | |||
| DRERZ | Publication | DRERZ | CHAR | 8 | Assigned to domain | ALPHA | DRERZ | JD1 | MJD1 |
| PVA | Edition | PVA | CHAR | 8 | Assigned to domain | ALPHA | PVA | JD2 | |
| BEZUGSTYP | Mix Type | BEZUGSTYP_JE_PVA | CHAR | 2 | Assigned to domain | 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 | Assigned to domain | SPART | SPA | ||
| MATKL | Material Group | MATKL | CHAR | 9 | Assigned to domain | MATKL | MKL | S_WBWG | |
| GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
| IVWKN | Circulation Audit Report Category ID | IVWKN | CHAR | 8 | Assigned to domain | IVWKN | |||
| IVWKNFREI | Circulation Report Category ID for Non-Calculation Period | IVWKNFREI | CHAR | 8 | Assigned to domain | IVWKN | |||
| XLIEFSE | Delivery to social facility | XLIEFSE | CHAR | 1 | XFELD | ||||
| LIEFERART | Delivery Type | LIEFERART | CHAR | 2 | Assigned to domain | LIEFERART | JLA | ||
| UNTBRGRD | Reason for Suspension | UNTBRGRD | CHAR | 3 | Assigned to domain | UNTBRGRD | JK9 | ||
| BEZUGGRD | Purchase Reason | BEZUGGRD | CHAR | 3 | Assigned to domain | BEZUGGRD | JK8 | ||
| RECHBEGINN | Billing From | RECHBEGINN | DATS | 8 | DATUM | ||||
| RECHENDE | Billing To | RECHENDE | DATS | 8 | DATUM | ||||
| XIVW | Indicator: Relevant for audit report | XIVW | CHAR | 1 | XFELD | ||||
| XFAKTURA | Indicator: Relevant for billing | XFAKTURA | CHAR | 1 | XFELD | ||||
| KUENDGRD | Reason for end of delivery | KUENDGRD | CHAR | 3 | Assigned to domain | KUENDGRD | |||
| XURPOS | Original item in publishing sales order | XURPOS | CHAR | 1 | XFELD | ||||
| POSNR_UR | Original Item in Publishing Sales Order | APNR_UR | NUMC | 6 | Assigned to domain | APNR | |||
| POSNR_VG | Preceding Item in Publishing Sales Order | APNR_VG | NUMC | 6 | Assigned to domain | APNR | |||
| KOKRS | Controlling Area | KOKRS | CHAR | 4 | Assigned to domain | CACCD | CAC | ||
| KOSTL_L | Debit Cost Center | KOSTL_L | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
| XSTORNO | Indicator: Reversed | XJSTORNO | CHAR | 1 | XFELD | ||||
| STORNOGRD | Reversal Reason | STORNOGRD | CHAR | 3 | Assigned to domain | STORNOGRD | JK6 | ||
| 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 | ||||
| DELIVSPLITGRP | IS-M/SD: Address Alternation Group | DELIVSPLITGRP | CHAR | 10 | Assigned to domain | ALPHA | DELIVSPLITGRP | ||
| DELIVSPLIT | IS-M/SD: Alternating Address Element | DELIVSPLIT | CHAR | 8 | Assigned to domain | ALPHA | DELIVSPLIT | ||
| POSNR_MAIN | IS-M/SD: Main Item in Sales Order | APNR_MAIN | NUMC | 6 | Assigned to domain | APNR | |||
| POSNR_SUB | IS-M/SD: Sub-Item in Sales Order | APNR_SUB | NUMC | 6 | Assigned to domain | 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_ORDER | Character field length 24 | CHAR24 | CHAR | 24 | CHAR24 | ||||
| LAND1 | Normal delivery country | LAND1_ISP | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
| ETEEX | IS-M: External Schedule Line Number | ETEEX_ISP | NUMC | 6 | ETEEX | ||||
| BEZPER | Service Type | BEZPER | CHAR | 5 | Assigned to domain | BEZPER | JD4 | ||
| ETART | Schedule Line Type for Internal Sales Order Schedule Line | ETART_ISP | CHAR | 2 | Assigned to domain | ETART_ISP | JAE | ||
| ETMENGE | IS-M: Sales Order Schedule Line Quantity | ETMENGE | QUAN | 10 | MENGGPOS | ||||
| ETMEINS | IS-M: Sales Unit for Sales Order | ETMEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| UNTMENGE | IS-M: Suspension quantity | UNTMENGE | QUAN | 10 | MENGGPOS | ||||
| NETWR | IS-M: Net price in document currency | NETWR_ISP | CURR | 15(2) | WERTV8 | ||||
| MWSBP | Tax amount in document currency | MWSBP | CURR | 13(2) | WERTV7 | ||||
| WAERK | SD Document Currency | WAERK | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
| PRSBINDDAT | To-date for price fixing | PRSBINDDAT | DATS | 8 | DATUM | ||||
| PRSDT | Date for pricing and exchange rate | PRSDT | DATS | 8 | DATUM | ||||
| PRSPER | IS-M: Price Frequency | PRSPER | CHAR | 2 | Assigned to domain | PRSPER | JPRSPER | ||
| BZPERF | IS-M: Service Type for Billing | BEZPERFAKT | CHAR | 5 | Assigned to domain | BEZPER | |||
| LFARTLOG | Logistical delivery type | LFARTLOG | CHAR | 2 | Assigned to domain | LIEFERART | ISM_HELP_FOR_LOGDELIVTYPE | ||
| KDGRP | Customer group | KDGRP | CHAR | 2 | Assigned to domain | KDGRP | VKD | ||
| PLTYP | Price list type | PLTYP | CHAR | 2 | Assigned to domain | PLTYP | VPL | ||
| ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
| FKPER | Billing Frequency | FKPER | CHAR | 2 | Assigned to domain | FKPER | JFKPER | ||
| ZAHLW | Billing method | JZAHLW | CHAR | 1 | JZAHLW | JKZAHLW | |||
| PRBAS | Price Basis | PRBAS_ISP | CHAR | 1 | PRBAS_ISP | ||||
| PRBAS_VK | Price Basis for Shipping Costs | PRBAS_VK | CHAR | 1 | PRBAS_ISP | JKPRBAS_VK | |||
| XFKKOMP | Indicator: Perform Billing in Full for Billing Period | XFKKOMP | CHAR | 1 | XFELD | ||||
| XFKENDE | Indicator: Billing at end of calculation | XFKENDE | CHAR | 1 | XFELD | ||||
| JUEBART | IS-M: Transfer Type | JUEBART | CHAR | 1 | JUEBART | ||||
| XSEPFKPOS | Separate billing document for order item | XSEPFKPOS | CHAR | 1 | XFELD | ||||
| XKINKASSO | IS-M: Payment by field collector | XKINKASSO | CHAR | 1 | XFELD | ||||
| RCODE | IS-M/SD: Rate Code | RATE_CODE | CHAR | 4 | Assigned to domain | RATE_CODE | JKM | ||
| XAUTO_REN | IS-M/SD: Customer Requests Automatic Renewal | XAUTO_REN | CHAR | 1 | XFELD | ||||
| XNORENEWAL | IS-M/SD: No Further Renewal Required | XNORENEWAL | CHAR | 1 | XFELD | ||||
| VKONT | Contract Account Number | VKONT_KK | CHAR | 12 | Assigned to domain | ALPHA | VKONT_KK | KTO | FKKVKP_F4 |
| DUEDAY | IS-M/SD: Renewals, Due Day | DUEDAY | NUMC | 2 | DUEDAY | ||||
| KUENDEING | Date of Receipt of Termination | KUENDEING | DATS | 8 | DATUM | ||||
| LIEFENDEG | Requested end of delivery | LIEFENDEG | DATS | 8 | DATUM | ||||
| LIEFENDEI | Actual end of delivery | LIEFENDEI | DATS | 8 | DATUM | ||||
| RECHENDE_KUEND | Billing To | RECHENDE | DATS | 8 | DATUM | ||||
| GPRECH | IS-M: Researcher | GPRECH | CHAR | 10 | Assigned to domain | ALPHA | GPNR | MJG0R | |
| VSGRCHEUR | Researcher's Service Company | VSGRCHEUR | CHAR | 10 | Assigned to domain | ALPHA | GPNR | MJG0G | |
| XABGRECH | IS-M: Generate Termination Research | XABGRECH | CHAR | 1 | XFELD | ||||
| XKUEND_AKT | IS-M: Perform termination | XKUEND_AKT | CHAR | 1 | XFELD | ||||
| CCINS | Payment cards: Card type | CCINS | CHAR | 4 | Assigned to domain | CCINS | |||
| CCNUM | Payment cards: Card number | CCNUM | CHAR | 25 | Assigned to domain | CCNUM | |||
| CCFOL | Payment cards: Payment card suffix | CCFOL | CHAR | 10 | CHAR10 | ||||
| DATAB | Payment cards: Valid from | DATAB_CC | DATS | 8 | DATUM | ||||
| DATBI | Payment Cards: Valid To | DATBI_CC | DATS | 8 | DATUM | ||||
| CCNAME | Payment cards: Name of cardholder | CCNAME | CHAR | 40 | TEXT40 | ||||
| CSOUR | Payment cards: Entry mode | CSOUR | CHAR | 1 | CSOUR | ||||
| ETMENGE_GEW | Quantity in Sales Order Schedule Line w/Part.Subs.Weighting | JBW_ETMENGE_GEW | QUAN | 16(3) | JBW_ETMENGE_GEW | ||||
| UNTMENGE_GEW | Suspension qty for order sched.line with partial sub.wghtg | JBW_UNTMENGE_GEW | QUAN | 16(3) | JBW_ETMENGE_GEW | ||||
| TEILABOGEW | Quantity in Sales Order Schedule line w/Part.Subs.Weighting | JBW_TEILABOGEW | DEC | 17(3) | JBW_TEILABOGEW | ||||
| GPNR | IS-M: Business Partner Key | GPNR | CHAR | 10 | Assigned to domain | ALPHA | GPNR | JGP | MJG0 |
| ADRNR | IS-M: Address Number | JADRNR | CHAR | 10 | Assigned to domain | ALPHA | JADRNR | ||
| ZLSCH | IS-M: Payment Method | JZLSCH | CHAR | 1 | Assigned to domain | ZLSCH |
| Key field | Non-key field |
How do I retrieve data from SAP structure JSBW_SD_ORDER_ITEM_COMPL using ABAP code?
As JSBW_SD_ORDER_ITEM_COMPL 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 JSBW_SD_ORDER_ITEM_COMPL as there is no data to select.How to access SAP table JSBW_SD_ORDER_ITEM_COMPL
Within an ECC or HANA version of SAP you can also view further information about JSBW_SD_ORDER_ITEM_COMPL 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