SAP ABAP Table VIOB18 (Comparative apartments for rent adjustment, external accomm.)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FVVI (Package) R/3 appl.dev. for Financial Assets Management: Real estate

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VIOB18	Table Relationship Diagram
Short Description	Comparative apartments for rent adjustment, external accomm.

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	*
2	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	RVGLWHN	☑	RVGLWHN	RVGLWHN	NUMC	8	0	Comparative apartment key
4	AZIMM	☐	AZIMM	DEC3	DEC	3	0	Number of rooms
5	AHALBZI	☐	AHALBZI	DEC2	DEC	2	0	Number of half rooms
6	STOCK	☐	RGESCH	CHAR2	CHAR	2	0	Dummy (previously storey, replaced by VVSSTOCKW)
7	XLAGE	☐	SLAGK	SLAGK	NUMC	2	0	Location class	TIV22
8	SMOEBL	☐	SMOEB	SMOEB	CHAR	1	0	Furniture indicator
9	SHEIZART	☐	SHEIZ	SHEIZ	CHAR	1	0	Heating type
10	SGEBT	☐	SGEBT	SGEBT	CHAR	2	0	Part of Building	TIV12
11	XAUSTKL	☐	SAUSKL	SAUSKL	NUMC	2	0	Fixtures and fittings category	TIV23
12	BGRUNDM	☐	BGRUNDM	WRTV7	CURR	13	2	Basic net rent of comparative apartment excl. heating
13	WGRUNDM	☐	WGRUNDM	WAERS	CUKY	5	0	Currency in which the basic rent is displayed	TCURC
14	FWOHNFL	☐	FWOHNFL	VVBFLART	QUAN	14	4	Rental unit living area
15	FEINS	☐	FEINS	MEINS	UNIT	3	0	Area unit	T006
16	YBAUJAHR	☐	VVYBAUJAHR	DATUM	DATS	8	0	ConstYr
17	SMIETSP	☐	SMIETSP	SMIETSP	CHAR	6	0	Representative list of rents assignment	TIV20
18	JLOESCH	☐	JLOESCH	JLOESCH	CHAR	1	0	Real Estate Deletion Indicator/Flag
19	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
20	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
21	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
22	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
23	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
24	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
25	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
26	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
27	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
28	SSTOCKW	☐	VVSSTOCKW	VVSSTOCKW	NUMC	3	0	Floor	TIV37
29	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIOB18	BUKRS	T001	BUKRS	KEY	1	CN
2	VIOB18	FEINS	T006	MSEHI	KEY	1	CN
3	VIOB18	SGEBT	TIV12	SGEBT	KEY	1	CN
4	VIOB18	SMIETSP	TIV20	SMIETSP	KEY	1	CN
5	VIOB18	SSTOCKW	TIV37	SSTOCKW	KEY	1	CN
6	VIOB18	WGRUNDM	TCURC	WAERS	KEY	1	CN
7	VIOB18	XAUSTKL	TIV23	SMKLASS	KEY	1	CN
8	VIOB18	XLAGE	TIV22	SLAGK	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in