SAP ABAP View VBKKTERMPRENOT (Prenotification Selection for Term Deposits)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ IS-B-BCA (Application Component) Bank Customer Accounts
     ⤷ FKBT (Package) Bank Customer Account: Term Control

Basic Data

View Type	D	Database View
Database View	VBKKTERMPRENOT
Short Description	Prenotification Selection for Term Deposits
Root table	BKKTERM	Term Agreement for Fixed-Term Deposit and Installmt Savings

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	BKKTERM	BKKTERM
2	BKK58
3	BKK42
4	FIPR_PRODUCT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	BKKTERM	MANDT	JL	EQ				0	0
2	BKK58	MANDT	JR	EQ			AND	0	0
3	BKKTERM	BKKRS	JL	EQ				0	0
4	BKK58	BKKRS	JR	EQ			AND	0	0
5	BKKTERM	ACNUM_INT	JL	EQ				0	0
6	BKK58	ACNUM_INT	JR	EQ			AND	0	0
7	BKKTERM	MANDT	JL	EQ				0	0
8	BKK42	MANDT	JR	EQ			AND	0	0
9	BKKTERM	BKKRS	JL	EQ				0	0
10	BKK42	BKKRS	JR	EQ			AND	0	0
11	BKKTERM	ACNUM_INT	JL	EQ				0	0
12	BKK42	ACNUM_INT	JR	EQ			AND	0	0
13	FIPR_PRODUCT	MANDT	JL	EQ				0	0
14	BKK42	MANDT	JR	EQ			AND	0	0
15	FIPR_PRODUCT	PRODINT	JL	EQ				0	0
16	BKK42	PRODINT	JR	EQ			AND	0	0
17	BKKTERM	TERM_STATUS		EQ	'02'		AND	0	0
18	BKK58	X_PRINT_PRENOT		EQ	'X'		AND	0	0
19	BKKTERM	X_PRENOT_PRINTED		NE	'X'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	BKKTERM	MANDT		☐	MANDT	☐	Client
2	BKKRS	BKKTERM	BKKRS		☐	BKK_BKKRS	☐	Bank Area
3	ACNUM_INT	BKKTERM	ACNUM_INT		☐	BKK_ACCNT	☐	Internal Account Number for Current Account
4	CERT_NO	BKKTERM	CERT_NO		☐	BCA_US_CERT_NO	☐	BCA Time deposit certificate number
5	TERM_TYPE	BKKTERM	TERM_TYPE		☐	BKK_TERMTYPE	☐	Term Agreement Category
6	TERM_STATUS	BKKTERM	TERM_STATUS		☐	BKK_TERMSTAT	☐	Term Agreement Status
7	TERM	BKKTERM	TERM		☐	BKK_TERM	☐	Term Duration
8	TERM_PUNIT	BKKTERM	TERM_PUNIT		☐	BKK_TERMUNIT	☐	Period Unit for Term
9	X_CURRENT	BKKTERM	X_CURRENT		☐	BCA_US_XCURR_CD	☐	BCA Time deposit current certificate indicator
10	K_DATE	BKKTERM	K_DATE		☐	BKK_KDATE	☐	Key date
11	DEPOSIT	BKKTERM	DEPOSIT		☐	BKK_DEPOSIT	☐	Contract Total, Deposit
12	TERMSTART	BKKTERM	TERMSTART		☐	BKK_TERMSTART	☐	Term Start
13	LATEST_TERMSTART	BKKTERM	LATEST_TERMSTART		☐	BKK_TERMSTART	☐	Term Start
14	TERM_END	BKKTERM	TERM_END		☐	BKK_TERM_END	☐	End of Term
15	X_EINZUG	BKKTERM	X_EINZUG		☐	BKK_XEINZUG	☐	Fixed Term Deposit Was Collected
16	MATURITY_DATE	BKKTERM	MATURITY_DATE		☐	BKKTERM_CALLBALANCE	☐	Maturity Date of Term Agreement
17	REDUCTION	BKKTERM	REDUCTION		☐	BKK_AMOUNT	☐	Amount
18	INCREASE	BKKTERM	INCREASE		☐	BKK_AMOUNT	☐	Amount
19	COLLECTION_DATE	BKKTERM	COLLECTION_DATE		☐	BKKT_TARGETDATE	☐	Collection date of term initial amount
20	PAYMENTORDER_NO	BKKTERM	PAYMENTORDER_NO		☐	BKK_PAORN	☐	Payment order number
21	X_PRENOT_PRINTED	BKKTERM	X_PRENOT_PRINTED		☐	BKK_PRINTED	☐	Flag indicating if Prenotification document was printed
22	X_PRINT_PRENOT	BKK58	X_PRINT_PRENOT		☐	BKK_PRNT_CHG	☐	Print Correspondence
23	NUM_DAYS_BEFORE	BKK58	NUM_DAYS_BEFORE		☐	BKK_PRENOT_NODAYS	☐	Number of Days Before Maturity
24	ACNUM_EXT	BKK42	ACNUM_EXT		☐	BKK_ACEXT	☐	Account number for current account
25	PRODINT	FIPR_PRODUCT	PRODINT		☐	FIPR_PRODINT	☐	Internal Product ID

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