JSBW_AM_INV_1 SAP (IS-M/AM: BW Structure for 0ME_ISM_AM_INV_1) Structure details
Description: IS-M/AM: BW Structure for 0ME_ISM_AM_INV_1
Related tables to JSBW_AM_INV_1
Access table JSBW_AM_INV_1
Structure field list including key, data, relationships and ABAP select examples
JSBW_AM_INV_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/AM: BW Structure for 0ME_ISM_AM_INV_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_AM_INV_1 TYPE JSBW_AM_INV_1.
The JSBW_AM_INV_1 table consists of various fields, each holding specific information or linking keys about IS-M/AM: BW Structure for 0ME_ISM_AM_INV_1 data available in SAP. These include STORNO_KZ (IS-M: Reversal BW (0Recordmode)), VBELN (IS-M/AM: Billing Document), POSNR (IS-M/AM: Item (number) in settlement document), FKART (IS-M/AM: Billing/Settlement Document Type).. 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_AM_INV_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 |
STORNO_KZ | IS-M: Reversal BW (0Recordmode) | XSTORNO_KZ | CHAR | 1 | XFELD | ||||
VBELN | IS-M/AM: Billing Document | JJBELNR | CHAR | 10 | Assigned to domain | ALPHA | JJBELNR | JHB | MJHF |
POSNR | IS-M/AM: Item (number) in settlement document | JJPOSNR | NUMC | 6 | Assigned to domain | JJPOSNR | |||
FKART | IS-M/AM: Billing/Settlement Document Type | FKART_PAM | CHAR | 4 | Assigned to domain | FKART_PAM | MJHFKART | ||
FKTYP | IS-M/AM: Billing Category | JHFKTYP | CHAR | 1 | Assigned to domain | JHFKTYP | |||
STWAE | Statistics currency | STWAE | CUKY | 5 | Assigned to domain | WAERS | |||
STAFO | IS-M: Update group for statistics update | JHSTAFO | CHAR | 6 | Assigned to domain | ALPHA | STAFO | MCF | |
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
KUNRG | IS-M: Payer | REGULIERER | CHAR | 10 | Assigned to domain | ALPHA | GPNR | MJG0 | |
KUNRE | IS-M: Business Partner - Bill-To Party | GPNR_RECH | CHAR | 10 | Assigned to domain | ALPHA | GPNR | KUN | |
VKORG | Sales Organization | VKORG | CHAR | 4 | Assigned to domain | VKORG | VKO | C_VKORG | |
EKORG | Purchasing Organization | EKORG | CHAR | 4 | Assigned to domain | EKORG | EKO | ||
KREZE | IS-M: Payee | JHKREZE | CHAR | 10 | Assigned to domain | ALPHA | GPNR | ||
KRERS | IS-M: Invoicing Party | JHKRERS | CHAR | 10 | Assigned to domain | ALPHA | GPNR | ||
VNR | IS-M: Media Sales Agent Contract Number | JVMVVNR | CHAR | 10 | Assigned to domain | ALPHA | JVMVVNR | JJA | MJJV |
VTYP | IS-M: Contract Category for Media Sales Agent Contract | JVERMVTYP | CHAR | 1 | JVERMVTYP | ||||
VTNR | IS-M: Contract Number | ABS_VTNR | NUMC | 6 | Assigned to domain | ABS_VTNR | JHW | MJHW | |
FKDAT | IS-M: Actual Billing/Settlement Date | JHFKDAT | DATS | 8 | DATUM | ||||
ZLSCH | Payment Method | SCHZW_BSEG | CHAR | 1 | Assigned to domain | ZLSCH | |||
BRTWK | IS-M: Gross Value in Document Currency (Header) | JHBRTWRK | CURR | 15(2) | WERTV8 | ||||
NETWK | Net Value in Document Currency | NETWR | CURR | 15(2) | WERTV8 | ||||
STTYP | IS-M: Reversal Type | STORNOTYP | CHAR | 1 | STORNOTYP | ||||
VBTYP | IS-M/AM: Sales Document Category | ISPVBTYP | CHAR | 1 | ISPVBTYP | ||||
WAERK | SD Document Currency | WAERK | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
KUNAG | Business Partner: Sold-to Party | GPAG | CHAR | 10 | Assigned to domain | ALPHA | GPNR | ||
FBUDA | Date on which services rendered | FBUDA | DATS | 8 | DATUM | ||||
BEINH | IS-M/AM: Booking Unit | BELEGEINH | CHAR | 10 | Assigned to domain | ALPHA | BELEINH | JBE | MJJ1 |
BEINH_BAS | IS-M: Basic Booking Unit | BE_BASIS | CHAR | 10 | Assigned to domain | ALPHA | BELEINH | JBE | |
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | Assigned to domain | VTWEG | VTW | C_VTWEG | |
SPART | Division | SPART | CHAR | 2 | Assigned to domain | SPART | SPA | C_SPART | |
KDGRP | Customer group | KDGRP | CHAR | 2 | Assigned to domain | KDGRP | VKD | ||
DRERZ | IS-M: Publication | JHDRERZ | CHAR | 8 | Assigned to domain | ALPHA | DRERZ | JD1 | |
PVA | Edition | PVA | CHAR | 8 | Assigned to domain | ALPHA | PVA | JD2 | |
IHKOMP | IS-M: Content component for pricing call | IKO_PREIS | CHAR | 8 | Assigned to domain | ALPHA | INHALTSKOM | ||
INHK_KFM | IS-M: Business Content Component | INHK_KFM | CHAR | 8 | Assigned to domain | ALPHA | INHALTSKOM | JJ1 | |
INHK_TECH2 | IS-M: Special Publication Content Component | INHK_SOVER | CHAR | 8 | Assigned to domain | ALPHA | INHALTSKOM | JJ1 | |
VKBUR | Sales Office | VKBUR | CHAR | 4 | Assigned to domain | VKBUR | VKB | ||
VKGRP | Sales Group | VKGRP | CHAR | 3 | Assigned to domain | VKGRP | VKG | ||
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
POSAR | IS-M: Order-Publishing-Media - Item Type | AVMPOS_ART | CHAR | 2 | Assigned to domain | AVMPOS_ART | |||
PRODH | IS-M/AM: Product Hierarchy | J_PRODH | CHAR | 18 | Assigned to domain | J_PRODH | |||
PSTYV | IS-M: Item Category for Sales Document | PSTYV_PAM | CHAR | 4 | Assigned to domain | PSTYV_PAM | |||
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
FKIMG | Actual Invoiced Quantity | FKIMG | QUAN | 13(3) | MENG13 | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
VRKME | Sales unit | VRKME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
BRTWP | IS-M: Gross Value in Document Currency (Item) | JHBRTWRP | CURR | 15(2) | WERTV8 | ||||
NETWP | Net value of the billing item in document currency | NETWR_FP | CURR | 15(2) | WERTV8 | ||||
MWSBP | Tax amount in document currency | MWSBP | CURR | 13(2) | WERTV7 | ||||
KZWI1 | Subtotal 1 from pricing procedure for condition | KZWI1 | CURR | 13(2) | WERTV7 | ||||
KZWI2 | Subtotal 2 from pricing procedure for condition | KZWI2 | CURR | 13(2) | WERTV7 | ||||
KZWI3 | Subtotal 3 from pricing procedure for condition | KZWI3 | CURR | 13(2) | WERTV7 | ||||
KZWI4 | Subtotal 4 from pricing procedure for condition | KZWI4 | CURR | 13(2) | WERTV7 | ||||
KZWI5 | Subtotal 5 from pricing procedure for condition | KZWI5 | CURR | 13(2) | WERTV7 | ||||
KZWI6 | Subtotal 6 from pricing procedure for condition | KZWI6 | CURR | 13(2) | WERTV7 | ||||
VKORG_AUFT | IS-M: Sales Organization for Customer Order | JHVKORGAUF | CHAR | 4 | Assigned to domain | VKORG | VKO | ||
PRSDT | Date for pricing and exchange rate | PRSDT | DATS | 8 | DATUM | ||||
SHKZG | IS-M: Debit/Credit indicator | JHSHKZG | CHAR | 1 | JHSHKZG | ||||
ERFDATE | Created On | ERFDATE | DATS | 8 | DATUM | ||||
AENDATE | Date of Last Change | AENDATE | DATS | 8 | DATUM | ||||
AUBEL | IS-M/AM: Sales Document Number | AVM_NR | CHAR | 10 | Assigned to domain | ALPHA | AVM_NR | JHA | MJHA |
AUPOS | IS-M: Order Item Number | POS_NR | NUMC | 3 | Assigned to domain | AVM_PNR | |||
AUGRP | IS-M/AM: Billing Dataset | GRUPPABRNR | NUMC | 3 | Assigned to domain | GRUPPABR | |||
RRREL | IS-M/AM: Revenue Recognition Category | ISMRR_RELTYP | CHAR | 1 | ISMRR_RELTYP | ||||
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 | ||
INSERENT | IS-M: Advertiser | INSERENT | CHAR | 10 | Assigned to domain | ALPHA | GPNR | JGP | MJG0M |
KONDA | Price group (customer) | KONDA | CHAR | 2 | Assigned to domain | KONDA | VKA | ||
VERMKURZ | IS-M: Media Sales Agent Identification Code for Fast Input | JVERMKURZ | CHAR | 4 | JVERMKURZ | ||||
SMENG | Scale quantity in base unit of measure | SMENG | QUAN | 13(3) | MENG13 | ||||
BRGEW | Gross Weight | BRGEW | QUAN | 13(3) | MENG13 | ||||
NTGEW | Net Weight | NTGEW | QUAN | 13(3) | MENG13 | ||||
PBBASIS | IS-M/AM: Commission/Bonus Basis Amount (Percentage Calc.) | JPBBASIS | CURR | 13(2) | WERTV7 | ||||
GEWEI | Weight Unit | GEWEI | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
BW_STICHTAG | IS-M/AM: Key Date For BW Key Date Logic | BW_STICHTAG | DATS | 8 | DATUM | ||||
PACKAGE_ID | Package | ISM_PACKAGE_ID | CHAR | 10 | JJTPC | ALPHA | ISM_PACKAGE_ID | ||
PK_REF_AVM_NR | Order Number for Package Reference Order | ISM_PK_REF_AVM_NR | CHAR | 10 | Assigned to domain | ALPHA | AVM_NR | ||
PK_REF_POS_NR | Item Number of Package Item to be Referenced | ISM_PK_REF_POS_NR | NUMC | 3 | Assigned to domain | AVM_PNR |
Key field | Non-key field |
How do I retrieve data from SAP structure JSBW_AM_INV_1 using ABAP code?
As JSBW_AM_INV_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_AM_INV_1 as there is no data to select.How to access SAP table JSBW_AM_INV_1
Within an ECC or HANA version of SAP you can also view further information about JSBW_AM_INV_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