SAP ABAP View V_JSBW_RECL_ITEM (IS-M/SD: BW View for Reading Complaints (Item))

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_RECL_ITEM
Short Description	IS-M/SD: BW View for Reading Complaints (Item)
Root table	JKAK	Sales Order Header Data

Table

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

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JKAP	MANDT	JL	EQ				0	0
2	JKAK	MANDT	JR	EQ			AND	0	0
3	JKAP	VBELN	JL	EQ				0	0
4	JKAK	VBELN	JR	EQ			AND	0	0
5	JKAK	TRVOG		EQ	'7'		AND	0	0
6	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	GPAG	JKAK	GPAG		☐	GPAG	☐	Business Partner: Sold-to Party
4	JPARVWGPAG	JKAK	JPARVWGPAG		☐	JPARVWGPAG	☐	IS-M: Partner usage of sold-to party
5	VBTYP	JKAK	VBTYP		☐	VBTYP_ISP	☐	Sales document category, IS-M
6	TRVOG	JKAK	TRVOG		☐	TRVOG_ISP	☐	Transaction Group for IS-M Order Processing
7	AUART	JKAK	AUART		☐	AUART_ISP	☐	IS-M/SD: Sales Document Types
8	AUARTGRP	JKAK	AUARTGRP		☐	JAUARTGRP	☐	IS-M/SD: Sales document type grouping
9	WAERK	JKAK	WAERK		☐	WAERK	☐	SD document currency
10	NETWR	JKAK	NETWR		☐	NETWR_AK	☐	Net Value of the Sales Order in Document Currency
11	VKORG	JKAK	VKORG		☐	VKORG	☐	Sales Organization
12	VTWEG	JKAK	VTWEG		☐	VTWEG	☐	Distribution Channel
13	SPART	JKAK	SPART		☐	SPART_AK	☐	Division for order header
14	VKGRP	JKAK	VKGRP		☐	VKGRP	☐	Sales group
15	VKBUR	JKAK	VKBUR		☐	JVKBUR	☐	IS-M/SD: Receiving Sales Office
16	KNUMV	JKAK	KNUMV		☐	KNUMV	☐	Number of the document condition
17	FAKSP	JKAK	FAKSP		☐	FAKTSPERRE	☐	Billing Block
18	KALSM	JKAK	KALSM		☐	KALSMASD	☐	Sales and Distribution: Pricing Procedure in Pricing
19	KURST	JKAK	KURST		☐	KURST	☐	Exchange Rate Type
20	STAFO	JKAK	STAFO		☐	STAFO	☐	Update group for statistics update
21	STWAE	JKAK	STWAE		☐	STWAE	☐	Statistics currency
22	XIMMATRIK	JKAK	XIMMATRIK		☐	XIMMATRIK	☐	Indicator: Proof of matriculation provided
23	IMMATDAT	JKAK	IMMATDAT		☐	IMMATDAT	☐	Matriculation Certificate Valid To
24	KORRGRD	JKAK	KORRGRD		☐	KORRGRD	☐	IS-M: Reason for correction
25	REMVON	JKAK	REMVON		☐	REMVON_ISP	☐	IS-M: Return date from
26	REMBIS	JKAK	REMBIS		☐	REMBIS_ISP	☐	IS-M: Return date valid to
27	REFBELEG	JKAK	REFBELEG		☐	REMELD_ISP	☐	IS-M/SD: Reference Document in Legacy System
28	REMDATUM	JKAK	REMDATUM		☐	REMDAT_ISP	☐	IS-M: Date of return notification
29	REMSCHEIN	JKAK	REMSCHEIN		☐	RSCHEIN_IS	☐	IS-M: Return slip number
30	XFKBASAUFT	JKAK	XFKBASAUFT		☐	XFKBASAUFT	☐	IS-M: Billing based on order
31	XFKBASLIEF	JKAK	XFKBASLIEF		☐	XFKBASLIEF	☐	IS-M: Billing based on delivery
32	XJKSOFAKT	JKAK	XJKSOFAKT		☐	XJKSOFAKT	☐	IS-M/SD: Immed.billing for credit memo request (subsc.only)
33	XRENEWAL	JKAK	XRENEWAL		☐	XRENEWAL	☐	IS-M/SD: Order extended by renewal offer
34	REKLERGB	JKAK	REKLERGB		☐	ISM_REKLERGB	☐	IS-M: Complaint Result
35	REKLTYP	JKAK	REKLTYP		☐	ISM_REKLTYP	☐	IS-M: Complaint Category
36	REKLDATUM	JKAK	REKLDATUM		☐	ISM_COMPLDATE	☐	IS-M/SD: Complaint Date
37	POSNR	JKAP	POSNR		☐	APNR	☐	Sales Order Item
38	GUELTIGVON	JKAP	GUELTIGVON		☐	JKAPVON	☐	Valid-From Date of Sales Order Item
39	GUELTIGBIS	JKAP	GUELTIGBIS		☐	JKAPBIS	☐	Date to which Sales Order Item is Valid
40	POART	JKAP	POART		☐	POART_ISP	☐	Internal Item Type for Sales Order
41	AEART	JKAP	AEART		☐	AEART_JSDK	☐	Order Change Type
42	ZSKLS	JKAP	ZSKLS		☐	JZSKLS	☐	Time slice classification for sales order
43	POSEX	JKAP	POSEX		☐	POSEX_ISP	☐	External Item Number (Purchase Order Item)
44	DRERZ	JKAP	DRERZ		☐	DRERZ	☐	Publication
45	PVA	JKAP	PVA		☐	PVA	☐	Edition
46	BEZUGSTYP	JKAP	BEZUGSTYP		☐	BEZUGSTYP_JE_PVA	☐	Mix Type
47	XRUECKABO	JKAP	XRUECKABO		☐	XRUECKABO	☐	IS-M: Backdated subscription created
48	MATKL	JKAP	MATKL		☐	MATKL	☐	Material Group
49	IVWKNFREI	JKAP	IVWKNFREI		☐	IVWKNFREI	☐	Circulation Report Category ID for Non-Calculation Period
50	XLIEFSE	JKAP	XLIEFSE		☐	XLIEFSE	☐	Delivery to social facility
51	LIEFERART	JKAP	LIEFERART		☐	LIEFERART	☐	Delivery Type
52	UNTBRGRD	JKAP	UNTBRGRD		☐	UNTBRGRD	☐	Reason for Suspension
53	BEZUGGRD	JKAP	BEZUGGRD		☐	BEZUGGRD	☐	Purchase Reason
54	RECHBEGINN	JKAP	RECHBEGINN		☐	RECHBEGINN	☐	Billing From
55	RECHENDE	JKAP	RECHENDE		☐	RECHENDE	☐	Billing To
56	XIVW	JKAP	XIVW		☐	XIVW	☐	Indicator: Relevant for audit report
57	XFAKTURA	JKAP	XFAKTURA		☐	XFAKTURA	☐	Indicator: Relevant for billing
58	KUENDGRD	JKAP	KUENDGRD		☐	KUENDGRD	☐	Reason for end of delivery
59	XURPOS	JKAP	XURPOS		☐	XURPOS	☐	Original item in publishing sales order
60	POSNR_UR	JKAP	POSNR_UR		☐	APNR_UR	☐	Original Item in Publishing Sales Order
61	POSNR_VG	JKAP	POSNR_VG		☐	APNR_VG	☐	Preceding Item in Publishing Sales Order
62	KOKRS	JKAP	KOKRS		☐	KOKRS	☐	Controlling Area
63	KOSTL_L	JKAP	KOSTL_L		☐	KOSTL_L	☐	Debit Cost Center
64	XSTORNO	JKAP	XSTORNO		☐	XJSTORNO	☐	Indicator: Reversed
65	STORNOGRD	JKAP	STORNOGRD		☐	STORNOGRD	☐	Reversal Reason
66	HEFTNUMVON	JKAP	HEFTNUMVON		☐	HEFTNUMVON	☐	Copy Number of First Issue to be Delivered
67	HEFTNUMBIS	JKAP	HEFTNUMBIS		☐	HEFTNUMBIS	☐	Copy Number of Last Issue for Delivery
68	DELIVSPLITGRP	JKAP	DELIVSPLITGRP		☐	DELIVSPLITGRP	☐	IS-M/SD: Address Alternation Group
69	DELIVSPLIT	JKAP	DELIVSPLIT		☐	DELIVSPLIT	☐	IS-M/SD: Alternating Address Element
70	POSNR_MAIN	JKAP	POSNR_MAIN		☐	APNR_MAIN	☐	IS-M/SD: Main Item in Sales Order
71	POSNR_SUB	JKAP	POSNR_SUB		☐	APNR_SUB	☐	IS-M/SD: Sub-Item in Sales Order
72	XMAINSPLIT	JKAP	XMAINSPLIT		☐	XMAINSPLIT	☐	Item for this Alternating Add. Element is a Main Sub-Item
73	X_MONTAG	JKAP	X_MONTAG		☐	X_MONTAG	☐	IS-M: Monday
74	X_DIENSTAG	JKAP	X_DIENSTAG		☐	X_DIENSTAG	☐	IS-M: Tuesday
75	X_MITTWOCH	JKAP	X_MITTWOCH		☐	X_MITTWOCH	☐	IS-M: Wednesday
76	X_DONNETAG	JKAP	X_DONNETAG		☐	X_DONNETAG	☐	IS-M: Thursday
77	X_FREITAG	JKAP	X_FREITAG		☐	X_FREITAG	☐	IS-M: Friday
78	X_SAMSTAG	JKAP	X_SAMSTAG		☐	X_SAMSTAG	☐	IS-M: Saturday
79	X_SONNTAG	JKAP	X_SONNTAG		☐	X_SONNTAG	☐	IS-M: Sunday
80	CAMPAIGN	JKAP	CAMPAIGN		☐	ISM_MARKETING_CAMPAIGN	☐	IS-M: Marketing Campaign
81	SPART_DRZ	JKAP	SPART		☐	SPARTDRERZ	☐	Division for publication

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	471