V_JSBW_INVOICE SAP (Generated Table for View) Table View details
Dictionary Type: Table View
Description: Generated Table for View
Description: Generated Table for View
ABAP Code to SELECT data from V_JSBW_INVOICE
Related tables to V_JSBW_INVOICE
Access table V_JSBW_INVOICE
Related tables to V_JSBW_INVOICE
Access table V_JSBW_INVOICE
Table View field list including key, data, relationships and ABAP select examples
V_JSBW_INVOICE is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.
The V_JSBW_INVOICE table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include VBELN (IS-M/SD: Billing Document), FKART (IS-M: Billing/Settlement Type), VBTYP (SD document category), WAERK (SD Document Currency).. 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: Not classified
SAP V_JSBW_INVOICE table view 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: Billing Document | ISPVBELN | CHAR | 10 | ALPHA | ISPVBELN | VF | MJF0 | |
| FKART | IS-M: Billing/Settlement Type | JFKART | CHAR | 4 | TJFK | JFKART | |||
| VBTYP | SD document category | VBTYP | CHAR | 1 | VBTYP | ||||
| WAERK | SD Document Currency | WAERK | CUKY | 5 | TCURC | WAERS | FWS | ||
| VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
| VTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVTW | VTWEG | VTW | C_VTWEG | |
| KALSM | Sales and Distribution: Pricing Procedure in Pricing | KALSMASD | CHAR | 6 | T683 | KALSM | |||
| KNUMV | Number of the document condition | KNUMV | CHAR | 10 | KNUMV | ||||
| FKDAT | Billing date for billing index and printout | FKDAT | DATS | 8 | DATUM | ||||
| KONDA | Price group (customer) | KONDA | CHAR | 2 | T188 | KONDA | VKA | ||
| KDGRP | Customer group | KDGRP | CHAR | 2 | T151 | KDGRP | VKD | ||
| PLTYP | Price list type | PLTYP | CHAR | 2 | T189 | PLTYP | VPL | ||
| ZLSCH | Payment Method | SCHZW_BSEG | CHAR | 1 | ZLSCH | ||||
| KTGRD | Account assignment group for this customer | KTGRD | CHAR | 2 | TVKT | KTGRD | |||
| REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | REGIO | ||||
| COUNC | County Code | COUNC | CHAR | 3 | COUNC | ||||
| CITYC | City Code | CITYC | CHAR | 4 | CITYC | ||||
| BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
| KUNRG | Payer | KUNRG | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
| KUNAG | Sold-to party | KUNAG | CHAR | 10 | KNA1 | ALPHA | KUNNR | VAG | |
| ISPSHKZGK | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
| ISPSTOGRD | IS-M: Billing Document Reversal Reason | JSTOGRDF | CHAR | 3 | TJF27 | JSTOGRDF | |||
| ISPXINK | IS-M: Payment by field collector | XKINKASSO | CHAR | 1 | XFELD | ||||
| ISPXWBZABO | IS-M: WBZ subscription | XWBZABO | CHAR | 1 | XFELD | ||||
| ISPINKVSG | IS-M: Field Collector is Service Company | ISPINKVSG | CHAR | 10 | ALPHA | KUNNR | |||
| ISPINKGP | IS-M: Field Collector is Employee | ISPINKGP | CHAR | 10 | ALPHA | KUNNR | |||
| ISPXVDICHT | IS-M: Summarize deliveries according to billing item | XFKVDICHT | CHAR | 1 | XFELD | ||||
| XRENEWAL | IS-M/SD: Order extended by renewal offer | XRENEWAL | CHAR | 1 | XFELD | ||||
| POSNR | IS-M: Billing Item | ISPPOSNR | NUMC | 6 | ISPPOSNR | ||||
| FKIMG | Actual Invoiced Quantity | FKIMG | QUAN | 13(3) | MENG13 | ||||
| VRKME | Sales unit | VRKME | UNIT | 3 | T006 | CUNIT | MEINS | ||
| MEINS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
| GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
| FBUDA | Date on which services rendered | FBUDA | DATS | 8 | DATUM | ||||
| NETWR | Net value of the billing item in document currency | NETWR_FP | CURR | 15(2) | WERTV8 | ||||
| MATKL | Material Group | MATKL | CHAR | 9 | T023 | MATKL | MKL | S_WBWG | |
| SPART | Division | SPART | CHAR | 2 | TSPA | SPART | SPA | C_SPART | |
| WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
| ALAND | Departure country (country from which the goods are sent) | ALAND | CHAR | 3 | T005 | LAND1 | VAL | ||
| WKREG | Region in which plant is located | WKREG | CHAR | 3 | T005S | REGIO | |||
| WKCOU | County in which plant is located | WKCOU | CHAR | 3 | CHAR3 | ||||
| WKCTY | City in which plant is located | WKCTY | CHAR | 4 | CHAR4 | ||||
| SKFBP | Amount eligible for cash discount in document currency | SKFBP | CURR | 13(2) | WERTV7 | ||||
| SPARA | Division for order header | SPART_AK | CHAR | 2 | TSPA | SPART | SPA | ||
| SHKZG | Returns Item | SHKZG_VA | CHAR | 1 | XFELD | ||||
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
| ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
| ERZET | Entry time | ERZET | TIMS | 6 | UZEIT | ||||
| STAFO | Update group for statistics update | STAFO | CHAR | 6 | ALPHA | STAFO | MCF | ||
| WAVWR | Cost in document currency | WAVWR | CURR | 13(2) | WERTV7 | ||||
| ISPAUART | IS-M/SD: Sales Document Types | AUART_ISP | CHAR | 4 | TJAK | AUART_ISP | JAD | ||
| ISPAUAGRP | IS-M: Sales Document Type Grouping for Sales Order | ISPAUAGRP | CHAR | 1 | JAUARTGRP | ||||
| ISPKOSTL_L | IS-M: Cost Center to be Charged | ISPKOSTL_L | CHAR | 10 | ALPHA | KOSTL | KOS | ||
| ISPDRERZ | Publication | DRERZ | CHAR | 8 | JDTDRER | ALPHA | DRERZ | JD1 | MJD1 |
| ISPPVA | Edition | PVA | CHAR | 8 | JDTPVA | ALPHA | PVA | JD2 | |
| ISPBEZ | Mix Type | BEZUGSTYP_JE_PVA | CHAR | 2 | JDTBEZTYP | BEZUGSTYP_JE_PVA | JD3 | MJD7 | |
| ISPLIFART | Delivery Type | LIEFERART | CHAR | 2 | TJV01 | LIEFERART | JLA | ||
| ISPPOSEX | External Item Number (Purchase Order Item) | POSEX_ISP | NUMC | 6 | POSEX_ISP | JK2 | |||
| ISPVBELN | IS-M/SD: Publishing Sales Order | AVNR | CHAR | 10 | JKAK | ALPHA | AVNR | JK1 | MJK1 |
| ISPPOSNR | Sales Order Item | APNR | NUMC | 6 | JKAP | APNR | |||
| ISPETENR | Sales Order Schedule Line | JAENR | NUMC | 4 | JKEP | AENR | |||
| ISPETEEX | IS-M: External Schedule Line Number | ETEEX_ISP | NUMC | 6 | ETEEX | ||||
| ISPETART | Schedule Line Type for Internal Sales Order Schedule Line | ETART_ISP | CHAR | 2 | TJEP | ETART_ISP | JAE | ||
| ISPETMENGE | IS-M: Sales Order Schedule Line Quantity | ETMENGE | QUAN | 10 | MENGGPOS | ||||
| ISPETMEINS | IS-M: Sales Unit for Sales Order | ETMEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
| ISPETVOR | IS-M: Plus/Minus Sign for Sch. Line Quantity in Sales Order | ISPETVOR | CHAR | 1 | VORZEI | ||||
| ISPANZET | IS-M: Number of Publication Dates | ISPANZET | DEC | 5 | ANZET | ||||
| ISPERSDAT | Publication Date | ERSCHDAT | DATS | 8 | DATUM | JD9 | |||
| ISPWRBAKT | Sales Promotion | WERBEAKT | CHAR | 8 | TJWAK | ALPHA | WERBEAKT | JWT | MJW1 |
| ISPFAKVON | IS-M: Billing Period From | FAKVON | DATS | 8 | DATUM | ||||
| ISPFAKBIS | IS-M: Billing Period To | FAKBIS | DATS | 8 | DATUM | ||||
| ISPKONDA | Price group (customer) | KONDA | CHAR | 2 | T188 | KONDA | VKA | ||
| ISPKDGRP | Customer group | KDGRP | CHAR | 2 | T151 | KDGRP | VKD | ||
| ISPPOART | Internal Item Type for Sales Order | POART_ISP | CHAR | 2 | TJAP | POART_ISP | JAP | ||
| ISPBRTWR_P | IS-M: Gross Value in Document Currency | ISPBRTWR | CURR | 15(2) | WERTV8 | ||||
| ISPVERSDAT | IS-M: Shipping Date | VRSNDDATUM | DATS | 8 | DATUM | RFD | |||
| ISPLANDE | Current country being supplied | LANDE_ISP | CHAR | 3 | LAND1 | LND | |||
| ISPVAUSGB | Issue | VAUSGB | CHAR | 10 | JDTVAUSGB | ALPHA | VAUSGB | JD8 | MJD4 |
| ISPVKBURZU | Sales office responsible | VKBURZUS | CHAR | 4 | VKBUR | ||||
| ISPXFKRUEK | IS-M: Retroactive Billing of Period Already Billed | XFKRUECK | CHAR | 1 | XFELD | ||||
| ISPIVWKN | Circulation Audit Report Category ID | IVWKN | CHAR | 8 | IVWKN | ||||
| ISPXIVW | Indicator: Relevant for audit report | XIVW | CHAR | 1 | XFELD | ||||
| XNEGOPTION | IS-M: Item with Automatic Transformation to Chargeable | XNEGOPTION | CHAR | 1 | XFELD | ||||
| IVWDATUM | Date of Audit Report for Returns | IVWDATUM | DATS | 8 | DATUM | ||||
| CAMPAIGN | IS-M: Marketing Campaign | ISM_MARKETING_CAMPAIGN | RAW | 16 | MCAMP | ISM_MARKETING_CAMPAIGN | PRPM_CGPL_K | ||
| FKPERVON | IS-M: Initial Date of Full Billing Period | FKPERVON | DATS | 8 | DATUM | ||||
| FKPERBIS | IS-M: Closing Date of Full Billing Period | FKPERBIS | DATS | 8 | DATUM | ||||
| ISPZSKLS | Time slice classification for sales order | JZSKLS | CHAR | 1 | JZSKLS | ||||
| ISPWRBART | Sales Source | WERBEART | CHAR | 4 | TJWAR | ALPHA | WERBEART | JWA | |
| POSNR_UR | Original Item in Publishing Sales Order | APNR_UR | NUMC | 6 | APNR | ||||
| CYCLENR | IS-M/SD: Billing Cycle Number | CYCLENR | NUMC | 3 | CYCLENR | ||||
| FAKNRRUECK | IS-M: Recalculated Billing Document | ISPFAKNRRUECK | CHAR | 10 | ALPHA | ISPVBELN | VF | ||
| XAUTO_REN | IS-M/SD: Customer Requests Automatic Renewal | XAUTO_REN | 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 | ||||
| VBELN_FROM | IS-M/SD: Publishing Sales Order | AVNR | CHAR | 10 | ALPHA | AVNR | JK1 | MJK1 | |
| POSNR_UR_FROM | Sales Order Item | APNR | NUMC | 6 | APNR | ||||
| CYCLENR_FROM | IS-M/SD: Billing Cycle Number | CYCLENR | NUMC | 3 | CYCLENR | ||||
| PARVW | Partner Function | PARVW | CHAR | 2 | TPAR | PARVW | PARVW | PAR | |
| KUNNR | Customer Numbers | KUNNR | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | C_KUNNR |
| ADRNR | Address | ADRNR | CHAR | 10 | ALPHA | ADRNR | |||
| LAND1 | Country Key | LAND1 | CHAR | 3 | T005 | LAND1 | LND | ||
| ISPADRNR | IS-M: Address Number | JADRNR | CHAR | 10 | ALPHA | JADRNR | |||
| ISPADRVAR | IS-M: Address Variant | ADRESSVAR | CHAR | 1 | ERSTADR |
| Key field | Non-key field |
How do I retrieve data from SAP table V_JSBW_INVOICE using ABAP code
The following ABAP code Example will allow you to do a basic selection on V_JSBW_INVOICE to SELECT all data from the tableDATA: WA_V_JSBW_INVOICE TYPE V_JSBW_INVOICE.
SELECT SINGLE *
FROM V_JSBW_INVOICE
INTO CORRESPONDING FIELDS OF WA_V_JSBW_INVOICE
WHERE...
How to access SAP table V_JSBW_INVOICE
Within an ECC or HANA version of SAP you can also view further information about V_JSBW_INVOICE 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