SAP ABAP View V_JSBW_COMPLAINT (IS-M: BW View for Complaints)

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_COMPLAINT
Short Description	IS-M: BW View for Complaints
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	'K'		AND	0	0
12	JKAK	TRVOG		EQ	'7'		AND	0	0
13	JKAK	AUARTGRP		EQ	'6'			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	AUART	JKAK	AUART		☐	AUART_ISP	☐	IS-M/SD: Sales Document Types
4	AUARTGRP	JKAK	AUARTGRP		☐	JAUARTGRP	☐	IS-M/SD: Sales document type grouping
5	VKORG	JKAK	VKORG		☐	VKORG	☐	Sales Organization
6	VTWEG	JKAK	VTWEG		☐	VTWEG	☐	Distribution Channel
7	SPART	JKAK	SPART		☐	SPART_AK	☐	Division for order header
8	VKGRP	JKAK	VKGRP		☐	VKGRP	☐	Sales group
9	VKBUR	JKAK	VKBUR		☐	JVKBUR	☐	IS-M/SD: Receiving Sales Office
10	GPAG	JKAK	GPAG		☐	GPAG	☐	Business Partner: Sold-to Party
11	JPARVWGPAG	JKAK	JPARVWGPAG		☐	JPARVWGPAG	☐	IS-M: Partner usage of sold-to party
12	REKLERGB	JKAK	REKLERGB		☐	ISM_REKLERGB	☐	IS-M: Complaint Result
13	REKLTYP	JKAK	REKLTYP		☐	ISM_REKLTYP	☐	IS-M: Complaint Category
14	ERFDATE	JKAK	ERFDATE		☐	ERFDATE	☐	Created On
15	POSNR	JKAP	POSNR		☐	APNR	☐	Sales Order Item
16	POART	JKAP	POART		☐	POART_ISP	☐	Internal Item Type for Sales Order
17	GUELTIGVON	JKAP	GUELTIGVON		☐	JKAPVON	☐	Valid-From Date of Sales Order Item
18	GUELTIGBIS	JKAP	GUELTIGBIS		☐	JKAPBIS	☐	Date to which Sales Order Item is Valid
19	KUNWE	JKAP	KUNWE		☐	GPNR_WE	☐	IS-M: Business Partner Ship-to Party
20	LANDE	JKAP	LANDE		☐	LANDE_ISP	☐	Current country being supplied
21	LAND1	JKAP	LAND1		☐	LAND1_ISP	☐	Normal delivery country
22	DRERZ	JKAP	DRERZ		☐	DRERZ	☐	Publication
23	PVA	JKAP	PVA		☐	PVA	☐	Edition
24	IVWKN	JKAP	IVWKN		☐	IVWKN	☐	Circulation Audit Report Category ID
25	LIEFERART	JKAP	LIEFERART		☐	LIEFERART	☐	Delivery Type
26	DRUCKEREI	JKAP	DRUCKEREI		☐	JWERK	☐	Plant
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	XUNVLIEFER	JKAP	XUNVLIEFER		☐	XUNVLIEFER	☐	IS-M: Viability Data Incomplete for Item
31	GUELTIGVON_SH	JKEP	GUELTIGVON		☐	JKEPVON	☐	Date from Which Schedule Line in Sales Order is Valid
32	BEZPER	JKEP	BEZPER		☐	BEZPER	☐	Service Type
33	ETART	JKEP	ETART		☐	ETART_ISP	☐	Schedule Line Type for Internal Sales Order Schedule Line
34	ETMENGE	JKEP	ETMENGE		☐	ETMENGE	☐	IS-M: Sales Order Schedule Line Quantity
35	ETMEINS	JKEP	ETMEINS		☐	ETMEINS	☐	IS-M: Sales Unit for Sales Order
36	RKMENGE	JKEP	RKMENGE		☐	RKMENGE	☐	Number of complaint copies
37	NLMENGE	JKEP	NLMENGE		☐	NLMENGE	☐	Number of Copies for Subsequent Delivery
38	ETVORZEI	JKEP	ETVORZEI		☐	ETVORZEI	☐	Plus/Minus Sign for Schedule Line Quantity in Sales Order
39	PRSPER	JKEP	PRSPER		☐	PRSPER	☐	IS-M: Price Frequency
40	BZPERF	JKEP	BZPERF		☐	BEZPERFAKT	☐	IS-M: Service Type for Billing
41	ERFDATE_SH	JKEP	ERFDATE		☐	ERFDATE	☐	Created On
42	VAUSGB	JKEP	VAUSGB		☐	VAUSGB	☐	Issue
43	ETENR	JKEP	ETENR		☐	JAENR	☐	Sales Order Schedule Line

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	20130529
SAP Release Created in	600