SAP ABAP Table V_JSBW_RETURN (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_JSBW_RETURN	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	VBELN	☑	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order
3	GPAG	☑	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	JGTGPNR
4	JPARVWGPAG	☑	JPARVWGPAG	JPARVWGPAG	CHAR	1	0	IS-M: Partner usage of sold-to party
5	AUART	☑	AUART_ISP	AUART_ISP	CHAR	4	0	IS-M/SD: Sales Document Types	TJAK
6	AUARTGRP	☑	JAUARTGRP	JAUARTGRP	CHAR	1	0	IS-M/SD: Sales document type grouping
7	VKORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
8	VTWEG	☑	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
9	SPART	☑	SPART_AK	SPART	CHAR	2	0	Division for order header	TVTA
10	VKGRP	☑	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
11	VKBUR	☑	JVKBUR	VKBUR	CHAR	4	0	IS-M/SD: Receiving Sales Office	TVKBZ
12	REMDATUM	☑	REMDAT_ISP	DATUM	DATS	8	0	IS-M: Date of return notification
13	REMSCHEIN	☑	RSCHEIN_IS	NUM6	NUMC	6	0	IS-M: Return slip number
14	IVWDATUM	☑	IVWDATUM	DATUM	DATS	8	0	Date of Audit Report for Returns
15	POSNR	☑	APNR	APNR	NUMC	6	0	Sales Order Item
16	POART	☑	POART_ISP	POART_ISP	CHAR	2	0	Internal Item Type for Sales Order	TJAP
17	KUNWE	☑	GPNR_WE	GPNR	CHAR	10	0	IS-M: Business Partner Ship-to Party	JGTGPNR
18	LANDE	☑	LANDE_ISP	LAND1	CHAR	3	0	Current country being supplied	T005
19	LAND1	☑	LAND1_ISP	LAND1	CHAR	3	0	Normal delivery country	T005
20	DRERZ	☑	DRERZ	DRERZ	CHAR	8	0	Publication	JDTDRER
21	PVA	☑	PVA	PVA	CHAR	8	0	Edition	JDTPVA
22	IVWKN	☑	IVWKN	IVWKN	CHAR	8	0	Circulation Audit Report Category ID	TJI01
23	LIEFERART	☑	LIEFERART	LIEFERART	CHAR	2	0	Delivery Type	TJV01
24	DRUCKEREI	☑	JWERK	WERKS	CHAR	4	0	Plant	T001W
25	REMART	☑	REMART	REMART	CHAR	1	0	Return Type
26	REMWEISE	☑	REMWEISE	REMWEISE	CHAR	1	0	Return Method
27	VKBURZUS	☑	VKBURZUS	VKBUR	CHAR	4	0	Sales office responsible	TVBUR
28	POSNR_MAIN	☑	APNR_MAIN	APNR	NUMC	6	0	IS-M/SD: Main Item in Sales Order	JKAP
29	POSNR_SUB	☑	APNR_SUB	APNR	NUMC	6	0	IS-M/SD: Sub-Item in Sales Order	JKAP
30	ETENR	☑	JAENR	AENR	NUMC	4	0	Sales Order Schedule Line
31	GUELTIGVON	☐	JKEPVON	DATUM	DATS	8	0	Date from Which Schedule Line in Sales Order is Valid
32	GUELTIGBIS	☐	JKEPBIS	DATUM	DATS	8	0	Date to Which Schedule Line in Sales Order is Valid
33	BEZPER	☐	BEZPER	BEZPER	CHAR	5	0	Service Type	TJD09
34	ETART	☐	ETART_ISP	ETART_ISP	CHAR	2	0	Schedule Line Type for Internal Sales Order Schedule Line	TJEP
35	ETMENGE	☐	ETMENGE	MENGGPOS	QUAN	10	0	IS-M: Sales Order Schedule Line Quantity
36	ETMEINS	☐	ETMEINS	MEINS	UNIT	3	0	IS-M: Sales Unit for Sales Order	T006
37	ETVORZEI	☐	ETVORZEI	VORZEI	CHAR	1	0	Plus/Minus Sign for Schedule Line Quantity in Sales Order
38	VAUSGB	☐	VAUSGB	VAUSGB	CHAR	10	0	Issue	JDTVAUSGB

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_JSBW_RETURN	AUART	TJAK	AUART	REF	1	CN
2	V_JSBW_RETURN	BEZPER	TJD09	BEZPER	REF	1	CN
3	V_JSBW_RETURN	DRERZ	JDTDRER	DRERZ	REF	C	CN
4	V_JSBW_RETURN	DRUCKEREI	T001W	WERKS	REF	C	CN
5	V_JSBW_RETURN	ETART	TJEP	ETART	REF	1	CN
6	V_JSBW_RETURN	ETMEINS	T006	MSEHI	REF	C	CN
7	V_JSBW_RETURN	GPAG	JGTGPNR	GPNR	KEY	1	CN
8	V_JSBW_RETURN	IVWKN	TJI01	IVWKN	REF	C	CN
9	V_JSBW_RETURN	KUNWE	JGTGPNR	GPNR	REF	C	CN
10	V_JSBW_RETURN	LAND1	T005	LAND1	REF	C	CN
11	V_JSBW_RETURN	LANDE	T005	LAND1	REF	C	CN
12	V_JSBW_RETURN	LIEFERART	TJV01	LIEFERART	REF	C	CN
13	V_JSBW_RETURN	MANDT	T000	MANDT	KEY	1	CN
14	V_JSBW_RETURN	POART	TJAP	POART	REF	1	CN
15	V_JSBW_RETURN	POSNR_MAIN	JKAP	POSNR	REF	C	CN
16	V_JSBW_RETURN	POSNR_SUB	JKAP	POSNR	REF	C	CN
17	V_JSBW_RETURN	PVA	JDTPVA	PVA	REF	C	CN
18	V_JSBW_RETURN	SPART	TVTA	SPART	KEY	1	CN
19	V_JSBW_RETURN	VAUSGB	JDTVAUSGB	VAUSGB	REF	1	CN
20	V_JSBW_RETURN	VKBUR	TVKBZ	VKBUR	REF	C	CN
21	V_JSBW_RETURN	VKBURZUS	TVBUR	VKBUR	REF	C	CN
22	V_JSBW_RETURN	VKGRP	TVBVK	VKGRP	REF	C	CN
23	V_JSBW_RETURN	VKORG	TVKO	VKORG	KEY	1	CN
24	V_JSBW_RETURN	VTWEG	TVKOV	VTWEG	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in