SAP ABAP Table VREDB_VIMI01_PY (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VREDB_VIMI01_PY	Table Relationship Diagram
Short Description	Generated Table for View

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

History

Last changed by/on	SAP	20130529
SAP Release Created in