SAP ABAP View V_JSBW_RETURN (IS-M/SD: BW View for Returns)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M-IS (Application Component) Information System
     ⤷ JSBW (Package) IS-M: Link to Business Information Warehouse

Basic Data

View Type	D	Database View
Database View	V_JSBW_RETURN
Short Description	IS-M/SD: BW View for Returns
Root table	JKAK	Sales Order Header Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JKAK	JKAK
2	JKAP
3	JKEP

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JKAK	MANDT	JL	EQ				0	0
2	JKAP	MANDT	JR	EQ			AND	0	0
3	JKAK	VBELN	JL	EQ				0	0
4	JKAP	VBELN	JR	EQ			AND	0	0
5	JKAP	MANDT	JL	EQ				0	0
6	JKEP	MANDT	JR	EQ			AND	0	0
7	JKAP	VBELN	JL	EQ				0	0
8	JKEP	VBELN	JR	EQ			AND	0	0
9	JKAP	POSNR	JL	EQ				0	0
10	JKEP	POSNR	JR	EQ			AND	0	0
11	JKAK	VBTYP		EQ	'H'		AND	0	0
12	JKAK	TRVOG		EQ	'8'		AND	0	0
13	JKAK	AUARTGRP		EQ	'5'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JKAK	MANDT		☐	MANDT	☐	Client
2	VBELN	JKAK	VBELN		☐	AVNR	☐	IS-M/SD: Publishing Sales Order
3	GPAG	JKAK	GPAG		☐	GPAG	☐	Business Partner: Sold-to Party
4	JPARVWGPAG	JKAK	JPARVWGPAG		☐	JPARVWGPAG	☐	IS-M: Partner usage of sold-to party
5	AUART	JKAK	AUART		☐	AUART_ISP	☐	IS-M/SD: Sales Document Types
6	AUARTGRP	JKAK	AUARTGRP		☐	JAUARTGRP	☐	IS-M/SD: Sales document type grouping
7	VKORG	JKAK	VKORG		☐	VKORG	☐	Sales Organization
8	VTWEG	JKAK	VTWEG		☐	VTWEG	☐	Distribution Channel
9	SPART	JKAK	SPART		☐	SPART_AK	☐	Division for order header
10	VKGRP	JKAK	VKGRP		☐	VKGRP	☐	Sales group
11	VKBUR	JKAK	VKBUR		☐	JVKBUR	☐	IS-M/SD: Receiving Sales Office
12	REMDATUM	JKAK	REMDATUM		☐	REMDAT_ISP	☐	IS-M: Date of return notification
13	REMSCHEIN	JKAK	REMSCHEIN		☐	RSCHEIN_IS	☐	IS-M: Return slip number
14	IVWDATUM	JKAK	IVWDATUM		☐	IVWDATUM	☐	Date of Audit Report for Returns
15	POSNR	JKAP	POSNR		☐	APNR	☐	Sales Order Item
16	POART	JKAP	POART		☐	POART_ISP	☐	Internal Item Type for Sales Order
17	KUNWE	JKAP	KUNWE		☐	GPNR_WE	☐	IS-M: Business Partner Ship-to Party
18	LANDE	JKAP	LANDE		☐	LANDE_ISP	☐	Current country being supplied
19	LAND1	JKAP	LAND1		☐	LAND1_ISP	☐	Normal delivery country
20	DRERZ	JKAP	DRERZ		☐	DRERZ	☐	Publication
21	PVA	JKAP	PVA		☐	PVA	☐	Edition
22	IVWKN	JKAP	IVWKN		☐	IVWKN	☐	Circulation Audit Report Category ID
23	LIEFERART	JKAP	LIEFERART		☐	LIEFERART	☐	Delivery Type
24	DRUCKEREI	JKAP	DRUCKEREI		☐	JWERK	☐	Plant
25	REMART	JKAP	REMART		☐	REMART	☐	Return Type
26	REMWEISE	JKAP	REMWEISE		☐	REMWEISE	☐	Return Method
27	VKBURZUS	JKAP	VKBURZUS		☐	VKBURZUS	☐	Sales office responsible
28	POSNR_MAIN	JKAP	POSNR_MAIN		☐	APNR_MAIN	☐	IS-M/SD: Main Item in Sales Order
29	POSNR_SUB	JKAP	POSNR_SUB		☐	APNR_SUB	☐	IS-M/SD: Sub-Item in Sales Order
30	ETENR	JKEP	ETENR		☐	JAENR	☐	Sales Order Schedule Line
31	GUELTIGVON	JKEP	GUELTIGVON		☐	JKEPVON	☐	Date from Which Schedule Line in Sales Order is Valid
32	GUELTIGBIS	JKEP	GUELTIGBIS		☐	JKEPBIS	☐	Date to Which Schedule Line in Sales Order is Valid
33	BEZPER	JKEP	BEZPER		☐	BEZPER	☐	Service Type
34	ETART	JKEP	ETART		☐	ETART_ISP	☐	Schedule Line Type for Internal Sales Order Schedule Line
35	ETMENGE	JKEP	ETMENGE		☐	ETMENGE	☐	IS-M: Sales Order Schedule Line Quantity
36	ETMEINS	JKEP	ETMEINS		☐	ETMEINS	☐	IS-M: Sales Unit for Sales Order
37	ETVORZEI	JKEP	ETVORZEI		☐	ETVORZEI	☐	Plus/Minus Sign for Schedule Line Quantity in Sales Order
38	VAUSGB	JKEP	VAUSGB		☐	VAUSGB	☐	Issue

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

Last changed by/on	SAP	20110901
SAP Release Created in