SAP ABAP Table V_JSBW_REMIND (Generated Table for View)

Basic Data

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_JSBW_REMIND	AUART	TJAK	AUART	REF	1	CN
2	V_JSBW_REMIND	BEZUGSTYP	JDTBEZTYP	BEZTYP	REF	1	CN
3	V_JSBW_REMIND	CYCLENR	JKACCOUNT	CYCLENR	KEY	1	CN
4	V_JSBW_REMIND	DP_ACTION	TJKRRDP	DP_ACTION
5	V_JSBW_REMIND	DRERZ	JDTDRER	DRERZ	REF	C	CN
6	V_JSBW_REMIND	KALSM	T683	KALSM	REF	C	CN
7	V_JSBW_REMIND	LIEFERART	TJV01	LIEFERART	REF	C	CN
8	V_JSBW_REMIND	MANDT	T000	MANDT	KEY	1	CN
9	V_JSBW_REMIND	POART	TJAP	POART	REF	1	CN
10	V_JSBW_REMIND	POSNR_BASE	JKAP	POSNR	REF	C	CN
11	V_JSBW_REMIND	POSNR_MAIN	JKAP	POSNR	REF	C	CN
12	V_JSBW_REMIND	POSNR_RENEW	JKAP	POSNR	REF	C	CN
13	V_JSBW_REMIND	POSNR_SUB	JKAP	POSNR	REF	C	CN
14	V_JSBW_REMIND	POSNR_UR	JKAP	POSNR	REF	1	CN
15	V_JSBW_REMIND	POSNR_VG	JKAP	POSNR	REF	1	CN
16	V_JSBW_REMIND	POSNR_VL	JKAP	POSNR	REF	C	CN
17	V_JSBW_REMIND	PVA	JDTPVA	PVA	REF	C	CN
18	V_JSBW_REMIND	REMLEVEL	TJKRRSSTEP	REMSTEP	REF	C	CN
19	V_JSBW_REMIND	REMSM	TJKRRS	REMSM	REF	C	CN
20	V_JSBW_REMIND	STORNOGRD	TJK91	STORNOGRD	REF	C	CN
21	V_JSBW_REMIND	UNTBRGRD	TJK85	UNTBRGRD	REF	C	CN
22	V_JSBW_REMIND	VBELN_VL	JKAK	VBELN	REF	C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in