SAP ABAP View V_JSBW_REMIND (IS-M/SD: BW View for Reading Renewal Cycles)

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_REMIND
Short Description	IS-M/SD: BW View for Reading Renewal Cycles
Root table	JKAK	Sales Order Header Data

Table

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

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	JKREMIND	MANDT	JL	EQ				0	0
6	JKAK	MANDT	JR	EQ			AND	0	0
7	JKREMIND	VBELN	JL	EQ				0	0
8	JKAP	VBELN	JR	EQ			AND	0	0
9	JKREMIND	POSNR_UR	JL	EQ				0	0
10	JKAP	POSNR	JR	EQ			AND	0	0
11	JKAK	VBTYP		EQ	'C'		AND	0	0
12	JKAK	TRVOG		EQ	'0'		AND	0	0
13	JKAK	AUARTGRP		EQ	'1'			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	VBTYP	JKAK	VBTYP		☐	VBTYP_ISP	☐	Sales document category, IS-M
4	TRVOG	JKAK	TRVOG		☐	TRVOG_ISP	☐	Transaction Group for IS-M Order Processing
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	XFKVDICHT	JKAK	XFKVDICHT		☐	XFKVDICHT	☐	IS-M: Summarize deliveries according to billing item
8	XRENEWAL	JKAK	XRENEWAL		☐	XRENEWAL	☐	IS-M/SD: Order extended by renewal offer
9	POSNR	JKAP	POSNR		☐	APNR	☐	Sales Order Item
10	GUELTIGVON	JKAP	GUELTIGVON		☐	JKAPVON	☐	Valid-From Date of Sales Order Item
11	GUELTIGBIS	JKAP	GUELTIGBIS		☐	JKAPBIS	☐	Date to which Sales Order Item is Valid
12	POART	JKAP	POART		☐	POART_ISP	☐	Internal Item Type for Sales Order
13	POSEX	JKAP	POSEX		☐	POSEX_ISP	☐	External Item Number (Purchase Order Item)
14	DRERZ	JKAP	DRERZ		☐	DRERZ	☐	Publication
15	PVA	JKAP	PVA		☐	PVA	☐	Edition
16	BEZUGSTYP	JKAP	BEZUGSTYP		☐	BEZUGSTYP_JE_PVA	☐	Mix Type
17	LIEFERART	JKAP	LIEFERART		☐	LIEFERART	☐	Delivery Type
18	UNTBRGRD	JKAP	UNTBRGRD		☐	UNTBRGRD	☐	Reason for Suspension
19	XURPOS	JKAP	XURPOS		☐	XURPOS	☐	Original item in publishing sales order
20	POSNR_UR	JKAP	POSNR_UR		☐	APNR_UR	☐	Original Item in Publishing Sales Order
21	POSNR_VG	JKAP	POSNR_VG		☐	APNR_VG	☐	Preceding Item in Publishing Sales Order
22	VBELN_VL	JKAP	VBELN_VL		☐	AVNR_VL	☐	Reference Document
23	POSNR_VL	JKAP	POSNR_VL		☐	APNR_VL	☐	Reference Document Item
24	XSTORNO	JKAP	XSTORNO		☐	XJSTORNO	☐	Indicator: Reversed
25	STORNOGRD	JKAP	STORNOGRD		☐	STORNOGRD	☐	Reversal Reason
26	POSNR_MAIN	JKAP	POSNR_MAIN		☐	APNR_MAIN	☐	IS-M/SD: Main Item in Sales Order
27	POSNR_SUB	JKAP	POSNR_SUB		☐	APNR_SUB	☐	IS-M/SD: Sub-Item in Sales Order
28	XMAINSPLIT	JKAP	XMAINSPLIT		☐	XMAINSPLIT	☐	Item for this Alternating Add. Element is a Main Sub-Item
29	X_MONTAG	JKAP	X_MONTAG		☐	X_MONTAG	☐	IS-M: Monday
30	X_DIENSTAG	JKAP	X_DIENSTAG		☐	X_DIENSTAG	☐	IS-M: Tuesday
31	X_MITTWOCH	JKAP	X_MITTWOCH		☐	X_MITTWOCH	☐	IS-M: Wednesday
32	X_DONNETAG	JKAP	X_DONNETAG		☐	X_DONNETAG	☐	IS-M: Thursday
33	X_FREITAG	JKAP	X_FREITAG		☐	X_FREITAG	☐	IS-M: Friday
34	X_SAMSTAG	JKAP	X_SAMSTAG		☐	X_SAMSTAG	☐	IS-M: Saturday
35	X_SONNTAG	JKAP	X_SONNTAG		☐	X_SONNTAG	☐	IS-M: Sunday
36	CAMPAIGN	JKAP	CAMPAIGN		☐	ISM_MARKETING_CAMPAIGN	☐	IS-M: Marketing Campaign
37	CYCLENR	JKREMIND	CYCLENR		☐	RR_CYCLENR	☐	IS-M/SD: Renewal Cycle Number
38	POSNR_BASE	JKREMIND	POSNR_BASE		☐	POSNR_BASE	☐	IS-M/SD: Item number for which renewal offer applies
39	POSNR_RENEW	JKREMIND	POSNR_RENEW		☐	POSNR_RENEW	☐	IS-M/SD: Item number that was renewed
40	REMSM	JKREMIND	REMSM		☐	REMSM	☐	IS-M/SD: Monitoring Procedure
41	REMLEVEL	JKREMIND	REMLEVEL		☐	REMLEVEL	☐	IS-M/SD: Number of last step in monitoring proc.processed
42	REMDATUM	JKREMIND	REMDATUM		☐	REM_DATUM	☐	IS-M/SD: Last date on which monitoring step was processed
43	REMSTATUS	JKREMIND	REMSTATUS		☐	REMSTATUS	☐	IS-M/SD: Monitoring Status
44	VBELN_OFFER	JKREMIND	VBELN_OFFER		☐	VBELN_OFFER	☐	IS-M/SD: Offer number for renewal offer
45	POSNR_OFFER	JKREMIND	POSNR_OFFER		☐	POSNR_OFFER	☐	IS-M/SD: Item Accepted in Renewal Offer
46	KALSM	JKREMIND	KALSM		☐	KALSMB	☐	Output determination procedure
47	XNOMESS	JKREMIND	XNOMESS		☐	XNOMESS	☐	IS-M: Indicator - Do Not Perform Output Determination
48	LOCK_DATE	JKREMIND	LOCK_DATE		☐	LOCK_DATE	☐	IS-M/SD: Block date for monitoring control
49	RENEWAL_DATE	JKREMIND	RENEWAL_DATE		☐	RENEWAL_DATE	☐	IS-M/SD: Date on which subscription was renewed
50	DUEDATE_BASE	JKREMIND	DUEDATE_BASE		☐	DUE_DATE_BASE	☐	IS-M/SD: Due Date for Next Payment in Acceptance
51	DUEDATE_SHIFT	JKREMIND	DUEDATE_SHIFT		☐	DUEDATE_SHIFT	☐	IS-M/SD: Renewals, Move Due Date
52	DP_ACTION	JKREMIND	DP_ACTION		☐	DP_ACTION	☐	IS-M/SD: Action when Payment Delayed
53	ERFUSER	JKREMIND	ERFUSER		☐	ERFUSER	☐	Created By
54	ERFDATE	JKREMIND	ERFDATE		☐	ERFDATE	☐	Created On
55	ERFTIME	JKREMIND	ERFTIME		☐	ERFTIME	☐	Time Created
56	AENUSER	JKREMIND	AENUSER		☐	AENUSER	☐	Last Changed By
57	AENDATE	JKREMIND	AENDATE		☐	AENDATE	☐	Date of Last Change
58	AENTIME	JKREMIND	AENTIME		☐	AENTIME	☐	Time of Last Change

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