SAP ABAP Table BAPICOLL_VDHOBJBL (Loans: Collateral Value Calculation/Expert Report on Object)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CML (Application Component) Loans Management
     ⤷ FVVD_BAPI (Package) Development Class for BAPIs and RFC Modules in Loans

Basic Data

Table Category	INTTAB	Structure
Structure	BAPICOLL_VDHOBJBL	Table Relationship Diagram
Short Description	Loans: Collateral Value Calculation/Expert Report on Object

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	COMP_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
2	CONTRACT_NO	☐	RANL	RANL	CHAR	13	0	Contract Number
3	COLL_NO	☑	VVRBLNR	VVRBLNR	NUMC	10	0	Collateral Number	*
4	CREATION_USER	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
5	CREATION_DATE	☐	DERF	DATUM	DATS	8	0	First Entered on
6	CREATION_TIME	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
7	SOUINTENTR	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
8	LASTCHANGE_USER	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
9	LASTCHANGE_DATE	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
10	LASTCHANGE_TIME	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
11	EDITSOURCE	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
12	OBJECT_NO	☐	ROBJNR	SBOBJNR	NUMC	10	0	Collateral object number	*
13	RPOW	☐	VVJWTEIG	JANEI	CHAR	1	0	Resid./Part Ownership
14	PARTNER	☐	RGUTACHT	BU_PARTNER	CHAR	10	0	Expert/Surveyor Identity Key	*
15	ISSUED_ON	☐	DURK	DATUM	DATS	8	0	Document date/expert opinion date
16	TH_P_EX_OP	☐	JFREGUT	JANEI	CHAR	1	0	Third-party expert opinion indicator
17	SALES_VAL	☐	FVD_BVERKEHR	BAPICURR	DEC	23	4	Market Value
18	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
19	CURRENCY_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
20	COLLAT_VAL	☐	FVD_BBELEIH	BAPICURR	DEC	23	4	Collateral Value
21	ASSET_VAL	☐	FVD_BSACH	BAPICURR	DEC	23	4	Real Value
22	SELL_VAL	☐	FVD_VVBVERKAUF	BAPICURR	DEC	23	4	Selling Value
23	RED_IN_VAL_1	☐	FVD_VVBALTWMIN	BAPICURR	DEC	23	4	Long-Standing Encumbrances Reduc.in Value
24	EXP_REN	☐	FVD_VVBAUFMOD	BAPICURR	DEC	23	4	Expense for Renovation/Modernization/Reconstruct./Expansion
25	CONSTYR	☐	VVYBAUJ	GJAHR	NUMC	4	0	ConstYr
26	RED_IN_VAL_2	☐	FVD_VVBBAUWMIN	BAPICURR	DEC	23	4	Construction Charges Reduction in Value
27	COLLVDED	☐	FVD_VVBBLABZ	BAPICURR	DEC	23	4	Collateral Value Deduction (Imputed)
28	COLVADED	☐	FVD_VVBBLVNABZ	BAPICURR	DEC	23	4	Collateral Value Deduction (Imputed)
29	VALCOLV	☐	FVD_VVBBLVTAX	BAPICURR	DEC	23	4	Proposal of Valuer for Collateral Value
30	COLVBDED	☐	FVD_VVBBLVVABZ	BAPICURR	DEC	23	4	Collateral Value Before Imputed Deduction
31	ADD_DESCR_1	☐	VVXTEXT78	VVXTEXT78	CHAR	78	0	Text Field for Additional Descriptions
32	INSDTE	☐	VVDBESICHT	DATUM	DATS	8	0	Date of inspection of object
33	P_CST_PRIC	☐	FVD_BKAUF	BAPICURR	DEC	23	4	Purchase Price/Total Prime Costs
34	SHLPSHA	☐	FVD_VVBSELBST	BAPICURR	DEC	23	4	Self-Help Share Amount (Estimated)
35	VAL_TYPE	☐	VVSBWART	VVSBWART	NUMC	2	0	Type of Valuation Procedure	*
36	VALSTAT	☐	VVSBWST	VVSBWST	NUMC	1	0	Valuation status
37	DTEEXPC	☐	VVDAUFER	DATUM	DATS	8	0	Date of expense creation
38	DTECOLF	☐	VVBLFEST	DATUM	DATS	8	0	Date collateral value fixed
39	DTE_SALE	☐	VVDKAUF	DATUM	DATS	8	0	Date of sales agreement
40	VALCHKDTE	☐	VVDWEPRUEF	DATUM	DATS	8	0	Date of valuation check
41	COLL_VAL	☐	FVD_VVBOBJWERT	BAPICURR	DEC	23	4	Determined Object Value
42	YEAR_MOD	☐	VVYLMOD	GJAHR	NUMC	4	0	Year of last modernization
43	COMPLETED	☐	VVPFERTIG	DEC3_7	DEC	10	7	Degree of completion of object
44	ADD_DESCR_2	☐	VVXTEXT78	VVXTEXT78	CHAR	78	0	Text Field for Additional Descriptions
45	ADD_DESCR_3	☐	VVXTEXT78	VVXTEXT78	CHAR	78	0	Text Field for Additional Descriptions
46	RED_IN_VAL_3	☐	FVD_VVBA2MIND	BAPICURR	DEC	23	4	Reduction in Value Due to Land Register Sect. II
47	PRODEXPR	☐	FVD_VVBHEREGS	BAPICURR	DEC	23	4	Production Costs Excluding Property
48	PRINCPRO	☐	FVD_VVBHERIGS	BAPICURR	DEC	23	4	Production Costs Including Property
49	YRRNTIN	☐	FVD_VVBMIET	BAPICURR	DEC	23	4	Planned or Realized Rental Income per Year
50	CHECKED_1	☐	VVSALTLAST	VVJANE	CHAR	1	0	Existing encumbrances check carried out
51	RED_IN_VAL_4	☐	VVSALWMIND	VVJANE	CHAR	1	0	Reduction in value due to existing encumbrances
52	RATING_ID	☐	VVSBEURT	VVSBEURT	NUMC	2	0	Valuation rating base	*
53	CHECKED_2	☐	VVSBLPR	VVJANE	CHAR	1	0	Easement register checked
54	RED_IN_VAL_5	☐	VVSBLWMIND	VVJANE	CHAR	1	0	Reduction in value due to construction encumbrances checked
55	COLLRSK	☐	VVSBLRISI	VVSBLRISI	CHAR	1	0	Collateral risk
56	REFERENCE	☐	VVSAOBJ	VVJANE	CHAR	1	0	Reference to more detailed object description available
57	OWN_USE	☐	VVSEIGEN	VVSEIGEN	CHAR	1	0	Own Use
58	RENOV_ID	☐	VVSRENOV	VVSRENOV	CHAR	1	0	Indicator for expansion/modernization/clearance measure
59	BUILRATING	☐	VVSGEBURT	VVSZUST	CHAR	1	0	Building rating
60	GEN_IMPR	☐	VVSOBJGES	VVSZUST	CHAR	1	0	General impression of object
61	RED_IN_VAL_6	☐	VVSA2WMIND	VVJANE	CHAR	1	0	Decrease in valuation due to section II
62	CHECKED_3	☐	VVSA2OK	VVJANE	CHAR	1	0	Section II of the Land Register Checked
63	PURCPR	☐	VVSKAUFPR	VVSKAUFPR	CHAR	1	0	Purchase price rating
64	LOCATION	☐	VVSLAGE	VVSZUST	CHAR	1	0	Location Rating of Object
65	VACANCIES	☐	VVSLEER	VVSLEER	CHAR	1	0	Vacancies
66	RNTSTMT	☐	VVSMIETNW	VVSMIETNW	CHAR	1	0	Rent statement
67	RGHTOWAY	☐	VVSZUWEG	VVJANE	CHAR	1	0	Public right of way exists
68	SELF_HELP	☐	VVSSELANT	VVSSELANT	CHAR	1	0	Self-Help Share
69	WORK	☐	VVSTARB	VVJANE	CHAR	1	0	Work on Object Started
70	ADD_DESCR_4	☐	VVXTEXT78	VVXTEXT78	CHAR	78	0	Text Field for Additional Descriptions
71	ADD_DESCR_5	☐	VVXTEXT78	VVXTEXT78	CHAR	78	0	Text Field for Additional Descriptions
72	OBJECTTYPE	☐	SOBJART	SOBJART	NUMC	2	0	Object type	*
73	HEBURREL	☐	VVAJRLFZ	DEC03	DEC	3	0	Heritable building right remaining life in years
74	DTACRNT	☐	VVDIMIETE	DATUM	DATS	8	0	Date fixing actual rent/rent expectation
75	ADD_DESCR_6	☐	VVXTEXT78	VVXTEXT78	CHAR	78	0	Text Field for Additional Descriptions
76	ADD_DESCR_7	☐	VVXTEXT78	VVXTEXT78	CHAR	78	0	Text Field for Additional Descriptions
77	ADD_DESCR_8	☐	VVXTEXT78	VVXTEXT78	CHAR	78	0	Text Field for Additional Descriptions
78	ADD_DESCR_9	☐	VVXTEXT78	VVXTEXT78	CHAR	78	0	Text Field for Additional Descriptions
79	ADD_DESCR_10	☐	VVXTEXT78	VVXTEXT78	CHAR	78	0	Text Field for Additional Descriptions
80	REL_INDIC	☐	VVSFGKZ	VVSFGKZ	CHAR	1	0	Release Indicator
81	MEAN	☐	FVD_VVBMITTEL	BAPICURR	DEC	23	4	Mean Value Between Asset and Revenue Values

History

Last changed by/on	SAP	20110901
SAP Release Created in	200