JSBW_SD_ORDERSTOCK_1 SAP (IS-M/SD: BW Structure For 0ME_ISM_SD_ORDERSTOCK_1) Structure details
Description: IS-M/SD: BW Structure For 0ME_ISM_SD_ORDERSTOCK_1
Related tables to JSBW_SD_ORDERSTOCK_1
Access table JSBW_SD_ORDERSTOCK_1
Structure field list including key, data, relationships and ABAP select examples
JSBW_SD_ORDERSTOCK_1 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 0ME_ISM_SD_ORDERSTOCK_1" 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_ORDERSTOCK_1 TYPE JSBW_SD_ORDERSTOCK_1.
The JSBW_SD_ORDERSTOCK_1 table consists of various fields, each holding specific information or linking keys about IS-M/SD: BW Structure For 0ME_ISM_SD_ORDERSTOCK_1 data available in SAP. These include VBELN (IS-M/SD: Publishing Sales Order), AUART (IS-M/SD: Sales Document Types), VKORG (Sales Organization), VTWEG (Distribution Channel).. 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_ORDERSTOCK_1 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 |
STICHTAG | Key Date for Selection According to Time-Related Validity | STICHTAG | DATS | 8 | DATUM | ||||
VBELN | IS-M/SD: Publishing Sales Order | AVNR | CHAR | 10 | Assigned to domain | ALPHA | AVNR | JK1 | MJK1 |
AUART | IS-M/SD: Sales Document Types | AUART_ISP | CHAR | 4 | Assigned to domain | AUART_ISP | JAD | ||
VKORG | Sales Organization | VKORG | CHAR | 4 | Assigned to domain | VKORG | VKO | C_VKORG | |
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | Assigned to domain | VTWEG | VTW | C_VTWEG | |
SPART | Division for order header | SPART_AK | CHAR | 2 | Assigned to domain | SPART | SPA | ||
VKGRP | Sales Group | VKGRP | CHAR | 3 | Assigned to domain | VKGRP | VKG | ||
VKBUR | Sales Office | VKBUR | CHAR | 4 | Assigned to domain | VKBUR | VKB | ||
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
GSKST | Business area from cost center | GSKST | CHAR | 4 | Assigned to domain | GSBER | |||
GPAG | Business Partner: Sold-to Party | GPAG | CHAR | 10 | Assigned to domain | ALPHA | GPNR | ||
POSNR | Sales Order Item | APNR | NUMC | 6 | Assigned to domain | APNR | |||
POART | Internal Item Type for Sales Order | POART_ISP | CHAR | 2 | Assigned to domain | POART_ISP | JAP | ||
AEART_ITEM | Order Change Type | AEART_JSDK | CHAR | 1 | AEART_JSDK | ||||
XNEGOPTION | IS-M: Item with Automatic Transformation to Chargeable | XNEGOPTION | CHAR | 1 | XFELD | ||||
KUNWE | IS-M: Business Partner Ship-to Party | GPNR_WE | CHAR | 10 | Assigned to domain | ALPHA | GPNR | JGP | |
LANDE | Current country being supplied | LANDE_ISP | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
LAND1 | Normal delivery country | LAND1_ISP | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
DRERZ | Order Publication | DRERZAUFTR | CHAR | 8 | Assigned to domain | ALPHA | DRERZ | JD1 | |
PVA | Order-related edition | PVAAUFTR | 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 | ||||
IVWKN | Circulation Audit Report Category ID | IVWKN | CHAR | 8 | Assigned to domain | IVWKN | |||
LIEFERART | Delivery Type | LIEFERART | CHAR | 2 | Assigned to domain | LIEFERART | JLA | ||
BEZUGGRD | Purchase Reason | BEZUGGRD | CHAR | 3 | Assigned to domain | BEZUGGRD | JK8 | ||
UNTBRGRD | Reason for Suspension | UNTBRGRD | CHAR | 3 | Assigned to domain | UNTBRGRD | JK9 | ||
XREMRECHT | IS-M: Right of Return | XREMRECHT | CHAR | 1 | XFELD | ||||
XURPOS | Original item in publishing sales order | XURPOS | CHAR | 1 | XFELD | ||||
VKBURZUS | Sales office responsible | VKBURZUS | CHAR | 4 | Assigned to domain | VKBUR | |||
ERFDATE | Created On | ERFDATE | DATS | 8 | DATUM | ||||
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 | |||
CAMPAIGN | IS-M: Marketing Campaign | ISM_MARKETING_CAMPAIGN | RAW | 16 | MCAMP | ISM_MARKETING_CAMPAIGN | PRPM_CGPL_K | ||
CAMPAIGN_PSP | Work Breakdown Structure Element (WBS Element) | PS_POSID | CHAR | 24 | PROJN | PS_POSID | PRO | ||
XUNVLIEFER | IS-M: Viability Data Incomplete for Item | XUNVLIEFER | CHAR | 1 | XFELD | ||||
ETENR | Sales Order Schedule Line | JAENR | NUMC | 4 | Assigned to domain | AENR | |||
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 | ||
AEART_SCHD | Order Change Type | AEART_JSDK | CHAR | 1 | AEART_JSDK | ||||
XUREINT | Original schedule line in publishing sales order | XUREINT | CHAR | 1 | XFELD | ||||
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 | ||||
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 | |||
XSTORNO | Indicator: Reversed | XJSTORNO | CHAR | 1 | XFELD | ||||
GPNR_RG | IS-M: Payer Business Partner | GPNR_RG | CHAR | 10 | Assigned to domain | ALPHA | GPNR | ||
PLZWE | Postal code in ship-to party address from order | JMCPLZWE | CHAR | 10 | PSTLZ | ||||
PLZRE | Postal code in bill-to party address from order | JMCPLZRE | CHAR | 10 | PSTLZ | ||||
KREISG_SCH | IS-M: District municipality key of ship-to party | KGS_ORDER | CHAR | 15 | Assigned to domain | ALPHA | KREISG_SCH | ||
ZLSCH | IS-M: Payment Method | JZLSCH | CHAR | 1 | Assigned to domain | ZLSCH | |||
WERBEART | Sales Source | WERBEART | CHAR | 4 | Assigned to domain | ALPHA | WERBEART | JWA | |
WERBEAKT | Sales Promotion | WERBEAKT | CHAR | 8 | Assigned to domain | ALPHA | WERBEAKT | JWT | MJW1 |
WERBTRAEG | Advertising Medium | WERBTRAEG | CHAR | 10 | Assigned to domain | WERBTRAEG | |||
GPNR | IS-M: Commission Recipient | GPPROV | CHAR | 10 | Assigned to domain | ALPHA | GPNR | ||
VERSERVGES | Service company for commission payee | VSGPROV | CHAR | 10 | Assigned to domain | ALPHA | GPNR | MJG0V | |
XEINMALPRV | Indicator: One-time commission | XEINMALPRV | CHAR | 1 | XFELD | ||||
XRENDITE | Renewal commission | XRENDITE | CHAR | 1 | XFELD | ||||
MATNRWERB | IS-M: Material number for gift | MATNR_SAPR | CHAR | 18 | Assigned to domain | MATN1 | MATNR_ISP | JMA | |
BEZIRK | Carrier Route | BEZIRK | CHAR | 10 | Assigned to domain | ALPHA | BEZIRK | BEZ | MJVC |
GEOEIN | Number of Geographical Unit | GEOEIN | CHAR | 10 | Assigned to domain | ALPHA | GEOEIN | GEO | |
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 |
Key field | Non-key field |
How do I retrieve data from SAP structure JSBW_SD_ORDERSTOCK_1 using ABAP code?
As JSBW_SD_ORDERSTOCK_1 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_ORDERSTOCK_1 as there is no data to select.How to access SAP table JSBW_SD_ORDERSTOCK_1
Within an ECC or HANA version of SAP you can also view further information about JSBW_SD_ORDERSTOCK_1 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