SAP ABAP View VISSR_VDBEVI (Bewegungsdaten Darlehen mit Vdarl-Information)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-SR (Application Component) Regulatory reporting for insurance companies
     ⤷ VVSRFISL (Package) Statutory Reporting for Insurance from FI-SL

Basic Data

View Type	D	Database View
Database View	VISSR_VDBEVI
Short Description	Bewegungsdaten Darlehen mit Vdarl-Information
Root table	VDBEKI	Flow Data: Document Header for Actual Record

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	VDBEKI	VDBEKI
2	VDBEPI
3	VDARL

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	VDBEKI	MANDT	JL	EQ				0	0
2	VDBEPI	MANDT	JR	EQ			AND	0	0
3	VDBEKI	BUKRS	JL	EQ				0	0
4	VDBEPI	BUKRS	JR	EQ			AND	0	0
5	VDBEKI	RBELKPFD	JL	EQ				0	0
6	VDBEPI	RBELKPFD	JR	EQ			AND	0	0
7	VDBEKI	MANDT	JL	EQ				0	0
8	VDARL	MANDT	JR	EQ			AND	0	0
9	VDBEKI	BUKRS	JL	EQ				0	0
10	VDARL	BUKRS	JR	EQ			AND	0	0
11	VDBEKI	RANL	JL	EQ				0	0
12	VDARL	RANL	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	VDBEKI	MANDT		☐	MANDT	☐	Client
2	BUKRS	VDBEKI	BUKRS		☐	BUKRS	☐	Company Code
3	RBELKPFD	VDBEKI	RBELKPFD		☐	RBELKPFD	☐	Document Number of Document Header (Loan)
4	RPOSNR	VDBEPI	RPOSNR		☐	NVORGANG	☐	Activity number
5	RDARNEHM	VDBEPI	RDARNEHM		☐	RDARNEHM_NEW	☐	Borrower/Applicant Number
6	RANL	VDBEKI	RANL		☐	RANL	☐	Contract Number
7	SANLF	VDBEKI	SANLF		☐	SANLF	☐	Product Category
8	GSART	VDARL	GSART		☐	VVSART	☐	Product Type
9	DBUDAT	VDBEKI	DBUDAT		☐	BUDAT	☐	Posting Date in the Document
10	DGJAHR	VDBEKI	DGJAHR		☐	GJAHR	☐	Fiscal Year
11	DMONAT	VDBEKI	DMONAT		☐	MONAT	☐	Fiscal period
12	SSTORNO	VDBEKI	SSTORNO		☐	SSTORNO	☐	Reversal indicator
13	RSTBLG	VDBEKI	RSTBLG		☐	STBLG	☐	Reverse Document Number
14	SBEWART	VDBEPI	SBEWART		☐	SBEWART	☐	Flow Type
15	BNWHR	VDBEPI	BNWHR		☐	BNWHR	☐	Nominal amount
16	SNWHR	VDBEPI	SNWHR		☐	SNWHR	☐	Currency of nominal amount
17	BBWHR	VDBEPI	BBWHR		☐	BBWHR	☐	Amount in position currency
18	SBWHR	VDBEPI	SBWHR		☐	SBWHR	☐	Position Currency (Currency of Position Amount)
19	BCWHR	VDBEPI	BCWHR		☐	BCWHR	☐	Settlement Amount
20	SCWHR	VDBEPI	SCWHR		☐	SCWHR	☐	Settlement Currency
21	BHWHR	VDBEPI	BHWHR		☐	BHWHR	☐	Amount in local currency
22	SSTATI	VDBEKI	SSTATI		☐	SSTATI	☐	Status of data record
23	SBEWZITI	VDBEPI	SBEWZITI		☐	SBEWZITI	☐	Flow category
24	VVSSOLHAB	VDBEPI	SSOLHAB		☐	VVSSOLHAB	☐	Debit/credit indicator
25	RSOLL	VDBEPI	RSOLL		☐	RSOLL	☐	Account for debit posting
26	RHABEN	VDBEPI	RHABEN		☐	RHABEN	☐	Account for credit posting
27	RERF	VDBEPI	RERF		☐	RERF	☐	Entered by
28	DERF	VDBEPI	DERF		☐	DERF	☐	First Entered on
29	TERF	VDBEPI	TERF		☐	TERF	☐	Time of Initial Entry
30	RBEAR	VDBEPI	RBEAR		☐	RBEAR	☐	Employee ID
31	DBEAR	VDBEPI	DBEAR		☐	DBEAR	☐	Last Edited on
32	TBEAR	VDBEPI	TBEAR		☐	TBEAR	☐	Last Edited at
33	RPNNR	VDBEKI	RPNNR		☐	VVRPNNR	☐	Daybook no.
34	RVZBLG	VDBEKI	RVZBLG		☐	BELNR_D	☐	Accounting Document Number
35	BUCHTXT	VDBEPI	BUCHTXT		☐	SGTXT	☐	Item Text
36	BZUSAGE	VDARL	BZUSAGE		☐	BZUSAGE	☐	Commitment capital
37	SANTWHR	VDARL	SANTWHR		☐	SWHR	☐	Currency
38	RPORTB	VDARL	RPORTB		☐	RPORTB	☐	Portfolio
39	OBJNR	VDARL	OBJNR		☐	TB_FINOBJNR	☐	Object Number for Financial Transactions
40	SWHRORG	VDARL	SWHRORG		☐	SWHRORG	☐	Loan currency before conversion to EURO
41	DCONVERT	VDARL	DCONVERT		☐	DCONVERT	☐	Date loan was converted to EURO
42	DCORRECT	VDARL	DCORRECT		☐	DCORRECT	☐	Date for adjustment flows resulting from EURO conversion
43	SAKTPAS	VDARL	SAKTPAS		☐	VVSAKTPAS	☐	Indicator: Asset/Liability Transaction
44	COM_VAL_CLASS	VDARL	COM_VAL_CLASS		☐	TPM_COM_VAL_CLASS	☐	General Valuation Class
45	RREFKONT	VDBEKI	RREFKONT		☐	RREFKONT	☐	Account Assignment Reference in Financial Assets Management
46	DBLDAT	VDBEKI	DBLDAT		☐	BLDAT	☐	Document Date in Document
47	DVALUT	VDBEPI	DVALUT		☐	DVALUT	☐	Calculation Date
48	DFAELL	VDBEPI	DFAELL		☐	DFAELL	☐	Due date
49	DDISPO	VDBEPI	DDISPO		☐	DDISPO	☐	Payment Date
50	KOSTL	VDBEPI	KOSTL		☐	KOSTL	☐	Cost Center
51	GSBER	VDBEKI	GSBER		☐	GSBER	☐	Business Area
52	RZEBEL	VDBEKI	RZEBEL		☐	RZEBEL	☐	Doc.no. of debit pos. doc.header (only for inc.pmnt records)
53	SVORGKZ	VDBEPI	SVORGKZ		☐	VVSVORGKZ	☐	Activity indicator for debit/credit control
54	SARCHIV	VDARL	SARCHIV		☐	SARCHIV	☐	Archiving Category Indicator

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in	463_20