SAP ABAP Table RVIOB18 (RE: Rent Adjustment - Compar.Objects and Addit. Fields)

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	INTTAB	Structure
Structure	RVIOB18	Table Relationship Diagram
Short Description	RE: Rent Adjustment - Compar.Objects and Addit. Fields

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	.INCLUDE	☐				0	0	Comparative apartments for rent adjustment, external accomm.
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	RVGLWHN	☐	RVGLWHN	RVGLWHN	NUMC	8	0	Comparative apartment key	*
5	AZIMM	☐	AZIMM	DEC3	DEC	3	0	Number of rooms
6	AHALBZI	☐	AHALBZI	DEC2	DEC	2	0	Number of half rooms
7	STOCK	☐	RGESCH	CHAR2	CHAR	2	0	Dummy (previously storey, replaced by VVSSTOCKW)
8	XLAGE	☐	SLAGK	SLAGK	NUMC	2	0	Location class	TIV22
9	SMOEBL	☐	SMOEB	SMOEB	CHAR	1	0	Furniture indicator
10	SHEIZART	☐	SHEIZ	SHEIZ	CHAR	1	0	Heating type
11	SGEBT	☐	SGEBT	SGEBT	CHAR	2	0	Part of Building	TIV12
12	XAUSTKL	☐	SAUSKL	SAUSKL	NUMC	2	0	Fixtures and fittings category	TIV23
13	BGRUNDM	☐	BGRUNDM	WRTV7	CURR	13	2	Basic net rent of comparative apartment excl. heating
14	WGRUNDM	☐	WGRUNDM	WAERS	CUKY	5	0	Currency in which the basic rent is displayed	TCURC
15	FWOHNFL	☐	FWOHNFL	VVBFLART	QUAN	14	4	Rental unit living area
16	FEINS	☐	FEINS	MEINS	UNIT	3	0	Area unit	T006
17	YBAUJAHR	☐	VVYBAUJAHR	DATUM	DATS	8	0	ConstYr
18	SMIETSP	☐	SMIETSP	SMIETSP	CHAR	6	0	Representative list of rents assignment	TIV20
19	JLOESCH	☐	JLOESCH	JLOESCH	CHAR	1	0	Real Estate Deletion Indicator/Flag
20	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
21	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
22	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
23	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
24	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
25	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
26	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
27	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
28	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
29	SSTOCKW	☐	VVSSTOCKW	VVSSTOCKW	NUMC	3	0	Floor	TIV37
30	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
31	VGLADR	☐	VGLADR	CHAR70	CHAR	70	0	Address of compar.apartment, if necess. with name of tenant
32	BGRUNDMFE	☐	BGRUNDMFE	WRTV7	CURR	13	2	Basic rent net excl. utilities per area unit of comp.aprtmnt
33	SWENR	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	*
34	SMENR	☐	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	*
35	XMIETSPL	☐	XMIETSPL	XTEXT50	CHAR	50	0	Description of representative list of rents
36	XLAGK	☐	XLAGKM	XMBEZ	CHAR	30	0	Description of location class acc.to rep.list of rents
37	XHEIZ	☐	XHEIZ	AS4TEXT	CHAR	60	0	Description of heating type of rental unit
38	XGEBK	☐	XGEBK	XKBEZ	CHAR	15	0	Short name for parts of building
39	XGEBM	☐	XGEBM	XMBEZ	CHAR	30	0	Building parts long text
40	XAUSKL	☐	XAUSKL	XTEXT50	CHAR	50	0	Description of fixture and fitting category
41	XWGRUNDMK	☐	XWAERSK	TEXT15	CHAR	15	0	Currency key short text
42	XWGRUNDML	☐	XWAERSL	TEXT40	CHAR	40	0	Currency key long text
43	XFEINSK	☐	XFEINSK	TEXT10	CHAR	10	0	Description of area unit
44	XFEINSL	☐	XFEINSL	TEXT30	CHAR	30	0	Description of area unit
45	XSTOCKK	☐	VVXSTOCKK	VVXSTOCKK	CHAR	4	0	Short name of floor
46	XSTOCKL	☐	XGMBEZ	XMBEZ	CHAR	30	0	Long Description for Floor
47	XSTOCKM	☐	XGKBEZ	XKBEZ	CHAR	15	0	Short Description for Floor
48	RBUKANP	☐	RBUKANP	BUKRS	CHAR	4	0	Company code of lease-out for rent adjustment	*
49	DANPASS	☐	DANPASS	DATUM	DATS	8	0	Rental Adjustment Date Planned For
50	XIDENT	☐	XIDENT1	XBLNR1	CHAR	16	0	Identification of adjustment run
51	.INCLUDE	☐				0	0	Amounts from VIOB18 in second currency
52	WGRUNDMCUK	☐	SWHRKNDCUK	WAERS	CUKY	5	0	Second Currency for Correspondence	*
53	BGRUNDMCUK	☐	BGRUNDMCUK	WRTV7	CURR	13	2	Basic rent net w/o SC for comp.apartment in 2nd currency
54	BGRDMFECUK	☐	BGRDMFECUK	WRTV7	CURR	13	2	Basic rent net w/o SC per AU for comp.apartment in 2nd curr.

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in