SAP ABAP Table VIMI01_AE (Rental units for SU (for logical database))

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	VIMI01_AE	Table Relationship Diagram
Short Description	Rental units for SU (for logical database)

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	Rental unit - Master data
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	SWENR	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
5	SMENR	☐	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	*
6	SGRNR	☐	SGRNR	SGRNR	CHAR	8	0	Land Number for BE	VIOB02
7	SGENR	☐	SGENR	SGENR	CHAR	8	0	Building Number	VIOB03
8	SGEBSWENR	☐	SGEBSWENR	SWENR	CHAR	8	0	BE no.of rental unit to which the RU is linked	VIOB01
9	SGEBSMENR	☐	SGEBSMENR	SMENR	CHAR	8	0	RU no. of rental unit to which the RU is linked	VIMI01
10	SHEIZNR	☐	SHEIZNR	SHEIZNR	NUMC	4	0	Real Estate heating system number
11	SNUNR	☐	SNUNR	SNUNR	NUMC	4	0	Rental unit external usage type	TIV01
12	DBEZU	☐	DBEZU	DDAT	DATS	8	0	Date of initial usage
13	DWTVERM	☐	DWTVERM	DATUM	DATS	8	0	Date: Subsequent rental
14	UMBRAUM	☐	BUBRA	DEC8_3	DEC	11	3	Cubic Volume
15	AZIMM	☐	AZIMM	DEC3	DEC	3	0	Number of rooms
16	AHALBZI	☐	AHALBZI	DEC2	DEC	2	0	Number of half rooms
17	STOCK	☐	RGESCH	CHAR2	CHAR	2	0	Dummy (previously storey, replaced by VVSSTOCKW)
18	SBELART	☐	SBELA	SBELA	NUMC	1	0	Occupancy type indicator
19	SHEIZART	☐	SHEIZ	SHEIZ	CHAR	1	0	Heating type
20	DRESAB	☐	DRESA	DDAT	DATS	8	0	Date: Reserved from
21	DRESBIS	☐	DRESB	DDAT	DATS	8	0	Date: Reserved upto
22	SGEBT	☐	SGEBT	SGEBT	CHAR	2	0	Part of Building	TIV12
23	SBWNR	☐	SBWNR	SBWNR	NUMC	7	0	Application number	VIMI11
24	XAUSTKL	☐	SAUSKL	SAUSKL	NUMC	2	0	Fixtures and fittings category	TIV23
25	XLAGE	☐	SLAGK	SLAGK	NUMC	2	0	Location class	TIV22
26	SMOEBL	☐	SMOEB	SMOEB	CHAR	1	0	Furniture indicator
27	STECHEM	☐	STECHEM	STECHEM	CHAR	13	0	Heating expenses settlement company evaluation group
28	SALTNR	☐	SALTNR	SALTNR	CHAR	20	0	Number of rental unit in existing real estate system
29	DBEGEH	☐	DBEGEH	DDAT	DATS	8	0	Date of last RU inspection
30	XBEGEH	☐	XBEGEH	XKBEZ	CHAR	15	0	Inspected by
31	JLOESCH	☐	JLOESCH	JLOESCH	CHAR	1	0	Real Estate Deletion Indicator/Flag
32	PZUABSP	☐	PZUABSP	PZUABSP	DEC	4	2	Surcharge or reduction for representative list of rents
33	PERHOE	☐	PERHOE	DEC3_2	DEC	5	2	Percentage rate increase
34	RPROZGRD	☐	RPROZGRD	RPROZGRD	CHAR	2	0	Reason for variance in rate of percentage increase	TIV43
35	DBINDBIS	☐	DBINDBIS	DATUM	DATS	8	0	Obligation period until
36	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
37	RBELBIND	☐	RBELBIND	RBELBIND	CHAR	4	0	Occupancy obligation key	TIV31
38	RLIFT	☐	RLIFT	RLIFT	NUMC	2	0	Type of elevator installation	TIV32
39	RMEDIEN	☐	RMEDIEN	RMEDIEN	NUMC	3	0	Media reception	TIV33
40	RWASSER	☐	RWASSER	RWASSER	NUMC	2	0	Type of water mains connection	TIV34
41	RLGESCH	☐	RLGESCH	RLGESCH	CHAR	2	0	Location on Floor	TIV38
42	JVORSTEIG	☐	JVORSTEIG	OPTIERT	CHAR	1	0	Input tax deduction for vacancy
43	SADRME	☐	SADRME	SOBJNR	NUMC	10	0	Object number of rental unit for address purposes	SANO1
44	SNKS	☐	SNKS	J_OBJNR	CHAR	22	0	Service Charge Collector Number	ONR00
45	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
46	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
47	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
48	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
49	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
50	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
51	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
52	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
53	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
54	ABNNR	☐	ABNNR	TEXT20	CHAR	20	0	Identification of lease-out at settlement company
55	XSTANDNR	☐	VVXSTANDNR	VVXSTANDNR	CHAR	5	0	Number of garage / parking space
56	JEIGWOHN	☐	VVJEIGWOHN	JANE	CHAR	1	0	Rental Unit in Separate Ownership (COA)
57	RFAKT	☐	VVRFAKT	VVRFAKT	NUMC	6	0	Conversion factor for fractional share of property
58	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
59	PROFL	☐	VVAPROF	APROF	CHAR	6	0	Settlement profile for costs	TKB1A
60	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
61	SSTOCKW	☐	VVSSTOCKW	VVSSTOCKW	NUMC	3	0	Floor	TIV37
62	JKONDMV	☐	VVJKONDMV	XFELD	CHAR	1	0	Transfer conditions to RU when lease-out expires?
63	PKONDMV	☐	VVPKONDMV	PRZ32	DEC	5	2	Percentage rate for transfer of terms from LO to RU
64	DFSTRBIS	☐	VVDFSTRBIS	DATUM	DATS	8	0	Date up to when the rental unit cash flow is created
65	SSTCKBIS	☐	VVSSTCKBIS	VVSSTOCKW	NUMC	3	0	For RUs with Multiple Floors: Top Floor of RU	TIV37
66	JRMSCHPR	☐	VVJRMSCHPR	XFELD	CHAR	1	0	Tenant service charge settlement?
67	DHPZSAKT	☐	VVDHPZSAKT	DATUM	DATS	8	0	CH rent adj.:Date of mort.loan rate status for current rent
68	DUTBKAKT	☐	VVDUTBKAKT	DATUM	DATS	8	0	CH rnt adj.:Dte maint./oper.costs index status for new rent
69	DTEURAKT	☐	VVDTEURAKT	DATUM	DATS	8	0	CH rnt adj.:Dte of living stndrd index status for curr.rent
70	BRDBRTZZ	☐	VVBRDBRTZZ	DECV3_7	DEC	10	7	CH rent adj: Actual gross yield earned
71	BRDBRTKD	☐	VVBRDBRTKD	DECV3_7	DEC	10	7	Marginal Gross Yield
72	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
73	XMETXT	☐	VVXMETXT2	XMBEZ	CHAR	30	0	Text for rental unit
74	SBASTEU	☐	VVSBASTEU	BASJHR	NUMC	4	0	Swiss rent adj.: Base year for standard of living index	*
75	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
76	DRESTAUR	☐	VVDRESTAUR	DATUM	DATS	8	0	Date of reconstruction/extensive modernization
77	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
78	DFLOWFIX	☐	VVDFLOWFIX	DATUM	DATS	8	0	Flows fixed upto
79	KOEIGR	☐	VVWERTN_AD	VVWERTN_AD	CHAR	10	0	Account determination key for account determination	TIVC6
80	BERGRP	☐	VVBERGRP	VVBERGRP	CHAR	40	0	Authorization group
81	SPOSINMSP	☐	VVSPOSINMSP	VVSADJBASE	CHAR	1	0	Base value for grouping RU in RLR group
82	PPOSINMSP	☐	VVPPOSINMSP	DECV3_2	DEC	5	2	Percentage value for grouping RU in RLR category group
83	DFRDVON	☐	VVDFRDVON	DATUM	DATS	8	0	Public funding from
84	DFRDBIS	☐	VVDFRDBIS	DATUM	DATS	8	0	Public funding to
85	SGRUNDB	☐	SGRUNDB	SGRUNDB	NUMC	8	0	Land register number	VIGBUCH
86	PAUSFW	☐	VVPAUSFW	DEC3_2	DEC	5	2	Service charge stt. apport.loss risk percentage surcharge
87	RESADXEYECATCH	☐	RESADXEYECATCH	RESADXEYECATCH	CHAR	85	0	Short Description of Real Estate Object on Offer
88	RESADJINTERNET	☐	RESADJINTERNET	XFELD	CHAR	1	0	Indicator Internet Release
89	REFANG	☐	VVREFANG	RANL	CHAR	13	0	Reference offer	VIMI33
90	.INCLUDE	☐				0	0
91	.INCLU--AP	☐				0	0	OBSOLETE: Rental Object Append Fields
92	.INCLUDE	☐				0	0	OBSOLETE: Rental Object Append Fields
93	ROTYPE	☐	REBDROTYPE	REBDROTYPE	CHAR	2	0	Rental Object Type
94	ROTYPEEX	☐	REBDROTYPEEX	REBDROTYPEEX	CHAR	1	0	OBSOLETE: Type of Rental Object (External)
95	FLID	☐	REBDALTROID	REBDALTROID	CHAR	13	0	OBSOLETE: Alternative ID for Rental Object (from CRE)
96	CANBECOMMON	☐	REBDCANBECOMMON	RECABOOL	CHAR	1	0	Common Usage Possible
97	FIRSTPOSTING	☐	REBDFIRSTPOSTING	RECADATE	DATS	8	0	Obsolete: Date of First Posting
98	.INCLUDE	☐				0	0	OBSOLETE: Shared Master Data Fields: Append Fields
99	VALIDFROM	☐	REBDOBJVALIDFROM	RECADATEBEG	DATS	8	0	Date: Object Valid From
100	VALIDTO	☐	REBDOBJVALIDTO	RECADATEEND	DATS	8	0	Date: Object Valid To
101	CREATIONTYPE	☐	RECACREATIONTYPE	RECACREATIONTYPE	CHAR	1	0	How the Object Was Created
102	RESPONSIBLE	☐	RECARESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	*
103	USEREXCLUSIVE	☐	RECAUSEREXCLUSIVE	XUBNAME	CHAR	12	0	User with Exclusive Change Authorization	*
104	CFARCHIVEDTO	☐	RECDCFARCHIVEDTO	RECADATE	DATS	8	0	Date Up to Which the Cash Flow Is Archived
105	CFLOCKEDTO	☐	RECDCFLOCKEDTO	RECADATE	DATS	8	0	Date Until Which the Cash Flow Is Locked

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIMI01_AE	BUKRS	T001	BUKRS
2	VIMI01_AE	GSBER	TGSB	GSBER	KEY	1	CN
3	VIMI01_AE	KOEIGR	TIVC6	KOEIGR
4	VIMI01_AE	KOKRS	TKA01	KOKRS
5	VIMI01_AE	PRCTR	CEPC	PRCTR
6	VIMI01_AE	PROFL	TKB1A	APROF
7	VIMI01_AE	RBELBIND	TIV31	RBELBIND
8	VIMI01_AE	REFANG	VIMI33	SMVANG	KEY	1	1
9	VIMI01_AE	RLGESCH	TIV38	RLGESCH
10	VIMI01_AE	RLIFT	TIV32	RLIFT
11	VIMI01_AE	RMEDIEN	TIV33	RMEDIEN
12	VIMI01_AE	RPROZGRD	TIV43	RPROZGRD
13	VIMI01_AE	RWASSER	TIV34	RWASSER
14	VIMI01_AE	SADRME	SANO1	OBJNR
15	VIMI01_AE	SBWNR	VIMI11	SBWNR
16	VIMI01_AE	SGEBSMENR	VIMI01	SMENR
17	VIMI01_AE	SGEBSWENR	VIOB01	SWENR
18	VIMI01_AE	SGEBT	TIV12	SGEBT
19	VIMI01_AE	SGENR	VIOB03	SGENR
20	VIMI01_AE	SGRNR	VIOB02	SGRNR
21	VIMI01_AE	SGRUNDB	VIGBUCH	SGRUNDB	KEY	1	CN
22	VIMI01_AE	SNKS	ONR00	OBJNR
23	VIMI01_AE	SNUNR	TIV01	SNUNR
24	VIMI01_AE	SSTCKBIS	TIV37	SSTOCKW
25	VIMI01_AE	SSTOCKW	TIV37	SSTOCKW
26	VIMI01_AE	SWENR	VIOB01	SWENR
27	VIMI01_AE	XAUSTKL	TIV23	SMKLASS
28	VIMI01_AE	XLAGE	TIV22	SLAGK

History

Last changed by/on	SAP	20130529
SAP Release Created in