1. Home
  2. Resources
  3. SAP Tables
  4. V_JSBW_RETURN - Generated Table for View

SAP Table V_JSBW_RETURN

Generated Table for View

V_JSBW_RETURN (Generated Table for View) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link V_JSBW_RETURN to other SAP tables.

V_JSBW_RETURN table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
VBELN IS-M/SD: Publishing Sales Order AVNR CHAR 10 0
GPAG Business Partner: Sold-to Party GPAG JGTGPNR CHAR 10 0
JPARVWGPAG IS-M: Partner usage of sold-to party JPARVWGPAG CHAR 1 0
1 Sales customer
2 Retailer
3 Social facility
4 Internal business partner
5 External publisher
6 General business partner
AUART IS-M/SD: Sales Document Types AUART_ISP TJAK CHAR 4 0
AUARTGRP IS-M/SD: Sales document type grouping JAUARTGRP CHAR 1 0
1 Subscription Order
2 Single Unit Sales Order
3 Reserve Order
4 Free Copy Delivery Order
5 Return Notification
6 Credit/Debit Memo Requirements
7 Charitable Transfer
8 Ad Pre-Print Order
9 Coupon Order
B Voucher Copy Order
C Coupon Confirmation
VKORG Sales Organization VKORG TVKO CHAR 4 0
VTWEG Distribution Channel VTWEG TVKOV CHAR 2 0
SPART Division for order header SPART_AK TVTA CHAR 2 0
VKGRP Sales Group VKGRP TVBVK CHAR 3 0
VKBUR IS-M/SD: Receiving Sales Office JVKBUR TVKBZ CHAR 4 0
REMDATUM IS-M: Date of return notification REMDAT_ISP DATS 8 0
REMSCHEIN IS-M: Return slip number RSCHEIN_IS NUMC 6 0
IVWDATUM Date of Audit Report for Returns IVWDATUM DATS 8 0
POSNR Sales Order Item APNR NUMC 6 0
POART Internal Item Type for Sales Order POART_ISP TJAP CHAR 2 0
KUNWE IS-M: Business Partner Ship-to Party GPNR_WE JGTGPNR CHAR 10 0
LANDE Current country being supplied LANDE_ISP T005 CHAR 3 0
LAND1 Normal delivery country LAND1_ISP T005 CHAR 3 0
DRERZ Publication DRERZ JDTDRER CHAR 8 0
PVA Edition PVA JDTPVA CHAR 8 0
IVWKN Circulation Audit Report Category ID IVWKN TJI01 CHAR 8 0
LIEFERART Delivery Type LIEFERART TJV01 CHAR 2 0
DRUCKEREI Plant JWERK T001W CHAR 4 0
REMART Return Type REMART CHAR 1 0
1 Single Issue Return
2 Summarized Return
3 Summarized Return with Advance Return
REMWEISE Return Method REMWEISE CHAR 1 0
1 Certificated Return
2 Full-Copy Return
VKBURZUS Sales office responsible VKBURZUS TVBUR CHAR 4 0
POSNR_MAIN IS-M/SD: Main Item in Sales Order APNR_MAIN JKAP NUMC 6 0
POSNR_SUB IS-M/SD: Sub-Item in Sales Order APNR_SUB JKAP NUMC 6 0
ETENR Sales Order Schedule Line JAENR NUMC 4 0
GUELTIGVON Date from Which Schedule Line in Sales Order is Valid JKEPVON DATS 8 0
GUELTIGBIS Date to Which Schedule Line in Sales Order is Valid JKEPBIS DATS 8 0
BEZPER Service Type BEZPER TJD09 CHAR 5 0
ETART Schedule Line Type for Internal Sales Order Schedule Line ETART_ISP TJEP CHAR 2 0
ETMENGE IS-M: Sales Order Schedule Line Quantity ETMENGE QUAN 10 0
ETMEINS IS-M: Sales Unit for Sales Order ETMEINS T006 UNIT 3 0
ETVORZEI Plus/Minus Sign for Schedule Line Quantity in Sales Order ETVORZEI CHAR 1 0
+ positive
- negative
VAUSGB Issue VAUSGB JDTVAUSGB CHAR 10 0

V_JSBW_RETURN foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
V_JSBW_RETURN AUART V_JSBW_RETURN MANDT TJAK IS-M/SD: Sales Document Type MANDT
V_JSBW_RETURN AUART V_JSBW_RETURN AUART TJAK IS-M/SD: Sales Document Type AUART
V_JSBW_RETURN BEZPER V_JSBW_RETURN MANDT TJD09 IS-M/SD: Service Type MANDT
V_JSBW_RETURN BEZPER V_JSBW_RETURN BEZPER TJD09 IS-M/SD: Service Type BEZPER
V_JSBW_RETURN DRERZ V_JSBW_RETURN DRERZ JDTDRER IS-M/SD: Publications DRERZ
V_JSBW_RETURN DRERZ V_JSBW_RETURN MANDT JDTDRER IS-M/SD: Publications MANDT
V_JSBW_RETURN DRUCKEREI V_JSBW_RETURN MANDT T001W Plants/Branches MANDT
V_JSBW_RETURN DRUCKEREI V_JSBW_RETURN DRUCKEREI T001W Plants/Branches WERKS
V_JSBW_RETURN ETART V_JSBW_RETURN ETART TJEP Sales Order: Schedule Line Types ETART
V_JSBW_RETURN ETART V_JSBW_RETURN MANDT TJEP Sales Order: Schedule Line Types MANDT
V_JSBW_RETURN ETMEINS V_JSBW_RETURN MANDT T006 Units of Measurement MANDT
V_JSBW_RETURN ETMEINS V_JSBW_RETURN ETMEINS T006 Units of Measurement MSEHI
V_JSBW_RETURN GPAG V_JSBW_RETURN MANDT JGTGPNR IS-M: Central Business Partner Table MANDT
V_JSBW_RETURN GPAG V_JSBW_RETURN GPAG JGTGPNR IS-M: Central Business Partner Table GPNR
V_JSBW_RETURN IVWKN V_JSBW_RETURN MANDT TJI01 Audit Report Categories MANDT
V_JSBW_RETURN IVWKN V_JSBW_RETURN IVWKN TJI01 Audit Report Categories IVWKN
V_JSBW_RETURN KUNWE V_JSBW_RETURN MANDT JGTGPNR IS-M: Central Business Partner Table MANDT
V_JSBW_RETURN KUNWE V_JSBW_RETURN KUNWE JGTGPNR IS-M: Central Business Partner Table GPNR
V_JSBW_RETURN LAND1 V_JSBW_RETURN MANDT T005 Countries MANDT
V_JSBW_RETURN LAND1 V_JSBW_RETURN LAND1 T005 Countries LAND1
V_JSBW_RETURN LANDE V_JSBW_RETURN MANDT T005 Countries MANDT
V_JSBW_RETURN LANDE V_JSBW_RETURN LANDE T005 Countries LAND1
V_JSBW_RETURN LIEFERART V_JSBW_RETURN MANDT TJV01 Delivery type for issue MANDT
V_JSBW_RETURN LIEFERART V_JSBW_RETURN LIEFERART TJV01 Delivery type for issue LIEFERART
V_JSBW_RETURN MANDT V_JSBW_RETURN MANDT T000 Clients MANDT
V_JSBW_RETURN POART V_JSBW_RETURN MANDT TJAP Sales Order: Item Types MANDT
V_JSBW_RETURN POART V_JSBW_RETURN POART TJAP Sales Order: Item Types POART
V_JSBW_RETURN POSNR_MAIN V_JSBW_RETURN VBELN JKAP Sales Order - Item Data VBELN
V_JSBW_RETURN POSNR_MAIN V_JSBW_RETURN POSNR_MAIN JKAP Sales Order - Item Data POSNR
V_JSBW_RETURN POSNR_MAIN V_JSBW_RETURN MANDT JKAP Sales Order - Item Data MANDT
V_JSBW_RETURN POSNR_SUB V_JSBW_RETURN MANDT JKAP Sales Order - Item Data MANDT
V_JSBW_RETURN POSNR_SUB V_JSBW_RETURN VBELN JKAP Sales Order - Item Data VBELN
V_JSBW_RETURN POSNR_SUB V_JSBW_RETURN POSNR_SUB JKAP Sales Order - Item Data POSNR
V_JSBW_RETURN PVA V_JSBW_RETURN MANDT JDTPVA IS-M/SD: Editions MANDT
V_JSBW_RETURN PVA V_JSBW_RETURN DRERZ JDTPVA IS-M/SD: Editions DRERZ
V_JSBW_RETURN PVA V_JSBW_RETURN PVA JDTPVA IS-M/SD: Editions PVA
V_JSBW_RETURN SPART V_JSBW_RETURN VKORG TVTA Organizational Unit: Sales Area(s) VKORG
V_JSBW_RETURN SPART V_JSBW_RETURN VTWEG TVTA Organizational Unit: Sales Area(s) VTWEG
V_JSBW_RETURN SPART V_JSBW_RETURN SPART TVTA Organizational Unit: Sales Area(s) SPART
V_JSBW_RETURN SPART V_JSBW_RETURN MANDT TVTA Organizational Unit: Sales Area(s) MANDT
V_JSBW_RETURN VAUSGB V_JSBW_RETURN VAUSGB JDTVAUSGB IS-M/SD: Issues VAUSGB
V_JSBW_RETURN VAUSGB V_JSBW_RETURN MANDT JDTVAUSGB IS-M/SD: Issues MANDT
V_JSBW_RETURN VKBUR V_JSBW_RETURN VKORG TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VKORG
V_JSBW_RETURN VKBUR V_JSBW_RETURN VTWEG TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VTWEG
V_JSBW_RETURN VKBUR V_JSBW_RETURN SPART TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit SPART
V_JSBW_RETURN VKBUR V_JSBW_RETURN VKBUR TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VKBUR
V_JSBW_RETURN VKBUR V_JSBW_RETURN MANDT TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit MANDT
V_JSBW_RETURN VKBURZUS V_JSBW_RETURN MANDT TVBUR Organizational Unit: Sales Offices MANDT
V_JSBW_RETURN VKBURZUS V_JSBW_RETURN VKBURZUS TVBUR Organizational Unit: Sales Offices VKBUR
V_JSBW_RETURN VKGRP V_JSBW_RETURN MANDT TVBVK Organizational Unit: Sales Groups per Sales Office MANDT
V_JSBW_RETURN VKGRP V_JSBW_RETURN VKBUR TVBVK Organizational Unit: Sales Groups per Sales Office VKBUR
V_JSBW_RETURN VKGRP V_JSBW_RETURN VKGRP TVBVK Organizational Unit: Sales Groups per Sales Office VKGRP
V_JSBW_RETURN VKORG V_JSBW_RETURN VKORG TVKO Organizational Unit: Sales Organizations VKORG
V_JSBW_RETURN VKORG V_JSBW_RETURN MANDT TVKO Organizational Unit: Sales Organizations MANDT
V_JSBW_RETURN VTWEG V_JSBW_RETURN MANDT TVKOV Org. Unit: Distribution Channels per Sales Organization MANDT
V_JSBW_RETURN VTWEG V_JSBW_RETURN VKORG TVKOV Org. Unit: Distribution Channels per Sales Organization VKORG
V_JSBW_RETURN VTWEG V_JSBW_RETURN VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization VTWEG