SAP ABAP Table VDHOBJ (Collateral Objects)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CML (Application Component) Loans Management
     ⤷ FVVD (Package) Treasury Loans

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VDHOBJ	Table Relationship Diagram
Short Description	Collateral Objects

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	ROBJNR	☑	ROBJNR	SBOBJNR	NUMC	10	0	Collateral object number
3	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
4	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
5	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
6	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
7	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
8	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
9	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
10	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
11	SGRUNDB	☐	SGRUNDB	SGRUNDB	NUMC	8	0	Land register number	*
12	SOBJART	☐	SOBJART	SOBJART	NUMC	2	0	Object type	TIV5A
13	SNUTZART	☐	VVSNUTZ	SNUNR	NUMC	4	0	Main usage type of object	TIV01
14	SOBJBAU	☐	SOBJBAU	SOBJBAU	NUMC	2	0	Object building method indicator	TDO1
15	SOBJGEB	☐	SOBJGEB	SOBJGEB	NUMC	2	0	Indicator: Area Description for Object	TDO12
16	SOBJLAGE	☐	SOBJLAGE	RESOBJLAGE	NUMC	2	0	Indicator - District of Object	TIV45
17	SVERKEHR	☐	SVERKEHR	SVERKEHR	CHAR	1	0	Transport Connections of Business Entity	TIV44
18	SOBJZUST	☐	SOBJZUST	SOBJZUST	NUMC	2	0	Indicator for Condition of Object	TDO10
19	SOBJAUST	☐	SOBJAUST	SOBJAUST	NUMC	2	0	Object fixtures/fittings indicator	TDO11
20	DANTBAU	☐	DANTBAU	DATUM	DATS	8	0	Application for building permit
21	DBAUGENE	☐	DBAUGENE	DDAT	DATS	8	0	Building permit
22	XBAUGENE	☐	XBAUGENE	XMBEZ	CHAR	30	0	Note on building permit
23	DBEZUGSF	☐	DBEZUGSF	DDAT	DATS	8	0	Ready for occupancy
24	DFERTIG	☐	DFERTIG	DDAT	DATS	8	0	Completion
25	DSCHLUSS	☐	DSCHLUSS	DDAT	DATS	8	0	Final Inspection
26	YBAUJ	☐	VVYBAUJ	GJAHR	NUMC	4	0	ConstYr
27	YLMOD	☐	VVYLMOD	GJAHR	NUMC	4	0	Year of last modernization
28	SGVER	☐	SGVER	SGVER	CHAR	2	0	Property conditions	TDO8
29	NWOHNNR	☐	NWOHNNR	CHAR5	CHAR	5	0	Apartment number for condominium
30	NGESCHNR	☐	NGESCHNR	CHAR5	CHAR	5	0	Floor Number for Condominium
31	BBAUW13	☐	BBAUW13	WRBTR	CURR	11	2	Building value
32	BKAUF	☐	BKAUF	BWHR	CURR	13	2	Purchase price/total prime costs
33	SKAUFWHR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
34	DKAUF	☐	DKAUF	DATUM	DATS	8	0	Object purchase date
35	FEINS	☐	FEINS	MEINS	UNIT	3	0	Area unit	T006
36	REINS	☐	REINS	MEINS	UNIT	3	0	Unit for cubic volume	T006
37	SZWANG	☐	VVSZWANG	VVSZWANG	CHAR	1	0	Collateral object legal measures ID
38	JERBBAU	☐	SOBJERBBAU	SOBJERBBAU	CHAR	1	0	Heritable building right indicator for collateral objects	TDO9
39	JREICHSH	☐	JREICHSH	JANEI	CHAR	1	0	Reichsheimstätte indicator
40	DERBBAU	☐	DERBBAU	DATUM	DATS	8	0	Inheritable building leasehold end
41	JDENKMAL	☐	JDENKMAL	JANE	CHAR	1	0	Protection of Historical Sites
42	RFAKT	☐	VVRFAKT	VVRFAKT	NUMC	6	0	Conversion factor for fractional share of property
43	BMITEIG	☐	BMITEIG	DEC6_3	DEC	9	3	Co-ownership share
44	RKLAMMER	☐	VVROBJSTM	VVRSTANR	CHAR	13	0	Object master number
45	JHAUPT	☐	VVJHAUPT	JANEI	CHAR	1	0	Indicator for the main object within a complete object
46	XOBJALT	☐	XOBJALT	XKBEZ	CHAR	15	0	Previous object number
47	SFGKZ	☐	VVSFGKZ	VVSFGKZ	CHAR	1	0	Release Indicator
48	BOBADRNR	☐	BOBADRNR	AD_ADDRNUM	CHAR	10	0	Address number for collateral object	ADRC

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VDHOBJ	BOBADRNR	ADRC	ADDRNUMBER	KEY	1	C
2	VDHOBJ	FEINS	T006	MSEHI	KEY	1	CN
3	VDHOBJ	JERBBAU	TDO9	SOBJERBBAU	KEY	C	CN
4	VDHOBJ	MANDT	T000	MANDT	KEY	1	CN
5	VDHOBJ	REINS	T006	MSEHI	KEY	1	CN
6	VDHOBJ	SGVER	TDO8	SGVER	KEY	C	CN
7	VDHOBJ	SKAUFWHR	TCURC	WAERS	KEY	1	CN
8	VDHOBJ	SNUTZART	TIV01	SNUNR	KEY	1	CN
9	VDHOBJ	SOBJART	TIV5A	SOBJART	KEY	1	CN
10	VDHOBJ	SOBJAUST	TDO11	SOBJAUST	KEY	C	CN
11	VDHOBJ	SOBJBAU	TDO1	SOBJBAU	KEY	1	CN
12	VDHOBJ	SOBJGEB	TDO12	SOBJGEB	KEY	C	CN
13	VDHOBJ	SOBJLAGE	TIV45	SOBJLAGE	KEY	1	CN
14	VDHOBJ	SOBJZUST	TDO10	SOBJZUST	KEY	C	CN
15	VDHOBJ	SVERKEHR	TIV44	SVERKEHR

History

Last changed by/on	SAP	20110901
SAP Release Created in