SAP ABAP Table VIGW_R_VIMVF01 (Immobilien gew.: Mieteinheiten / Mietvertrag)
Hierarchy
☛
EA-FIN (Software Component) EA-FIN
⤷ RE-FX-MI (Application Component) Migration
⤷ RE_MI_CR (Package) RE: Migration CRE (Data Dictionary Only)
⤷ RE-FX-MI (Application Component) Migration
⤷ RE_MI_CR (Package) RE: Migration CRE (Data Dictionary Only)
Basic Data
Table Category | INTTAB | Structure |
Structure | VIGW_R_VIMVF01 | Table Relationship Diagram |
Short Description | Immobilien gew.: Mieteinheiten / Mietvertrag |
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 | Immobilien gew.: Reporting Mieteinheiten/Mietvertrag Sticht. | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
3 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
4 | SWENR | SWENR | SWENR | CHAR | 8 | 0 | Business Entity Number | * | |
5 | SMENR | SMENR | SMENR | CHAR | 8 | 0 | Number of Rental Unit | * | |
6 | .INCLUDE | 0 | 0 | Immobilien gew.: Struktur Reporting Mieteinheiten | |||||
7 | SGRNR | SGRNR | SGRNR | CHAR | 8 | 0 | Land Number for BE | * | |
8 | SGENR | SGENR | SGENR | CHAR | 8 | 0 | Building Number | * | |
9 | SGEBSWENR | SGEBSWENR | SWENR | CHAR | 8 | 0 | BE no.of rental unit to which the RU is linked | * | |
10 | SGEBSMENR | SGEBSMENR | SMENR | CHAR | 8 | 0 | RU no. of rental unit to which the RU is linked | * | |
11 | SHEIZNR | SHEIZNR | SHEIZNR | NUMC | 4 | 0 | Real Estate heating system number | ||
12 | SNUNR | SNUNR | SNUNR | NUMC | 4 | 0 | Rental unit external usage type | TIV01 | |
13 | DBEZU | DBEZU | DDAT | DATS | 8 | 0 | Date of initial usage | ||
14 | DWTVERM | DWTVERM | DATUM | DATS | 8 | 0 | Date: Subsequent rental | ||
15 | UMBRAUM | BUBRA | DEC8_3 | DEC | 11 | 3 | Cubic Volume | ||
16 | AZIMM | AZIMM | DEC3 | DEC | 3 | 0 | Number of rooms | ||
17 | AHALBZI | AHALBZI | DEC2 | DEC | 2 | 0 | Number of half rooms | ||
18 | STOCK | RGESCH | CHAR2 | CHAR | 2 | 0 | Dummy (previously storey, replaced by VVSSTOCKW) | ||
19 | SBELART | SBELA | SBELA | NUMC | 1 | 0 | Occupancy type indicator | ||
20 | SHEIZART | SHEIZ | SHEIZ | CHAR | 1 | 0 | Heating type | ||
21 | DRESAB | DRESA | DDAT | DATS | 8 | 0 | Date: Reserved from | ||
22 | DRESBIS | DRESB | DDAT | DATS | 8 | 0 | Date: Reserved upto | ||
23 | SGEBT | SGEBT | SGEBT | CHAR | 2 | 0 | Part of Building | TIV12 | |
24 | SBWNR | SBWNR | SBWNR | NUMC | 7 | 0 | Application number | VIMI11 | |
25 | XAUSTKL | SAUSKL | SAUSKL | NUMC | 2 | 0 | Fixtures and fittings category | * | |
26 | XLAGE | SLAGK | SLAGK | NUMC | 2 | 0 | Location class | * | |
27 | SMOEBL | SMOEB | SMOEB | CHAR | 1 | 0 | Furniture indicator | ||
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 | 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 | * | |
43 | XSTANDNR | VVXSTANDNR | VVXSTANDNR | CHAR | 5 | 0 | Number of garage / parking space | ||
44 | JEIGWOHN | VVJEIGWOHN | JANE | CHAR | 1 | 0 | Rental Unit in Separate Ownership (COA) | ||
45 | RFAKT | VVRFAKT | VVRFAKT | NUMC | 6 | 0 | Conversion factor for fractional share of property | ||
46 | SSTOCKW | VVSSTOCKW | VVSSTOCKW | NUMC | 3 | 0 | Floor | TIV37 | |
47 | JKONDMV | VVJKONDMV | XFELD | CHAR | 1 | 0 | Transfer conditions to RU when lease-out expires? | ||
48 | PKONDMV | VVPKONDMV | PRZ32 | DEC | 5 | 2 | Percentage rate for transfer of terms from LO to RU | ||
49 | DFSTRBIS | VVDFSTRBIS | DATUM | DATS | 8 | 0 | Date up to when the rental unit cash flow is created | ||
50 | SSTCKBIS | VVSSTCKBIS | VVSSTOCKW | NUMC | 3 | 0 | For RUs with Multiple Floors: Top Floor of RU | TIV37 | |
51 | DHPZSAKT | VVDHPZSAKT | DATUM | DATS | 8 | 0 | CH rent adj.:Date of mort.loan rate status for current rent | ||
52 | DUTBKAKT | VVDUTBKAKT | DATUM | DATS | 8 | 0 | CH rnt adj.:Dte maint./oper.costs index status for new rent | ||
53 | DTEURAKT | VVDTEURAKT | DATUM | DATS | 8 | 0 | CH rnt adj.:Dte of living stndrd index status for curr.rent | ||
54 | BRDBRTZZ | VVBRDBRTZZ | DECV3_7 | DEC | 10 | 7 | CH rent adj: Actual gross yield earned | ||
55 | BRDBRTKD | VVBRDBRTKD | DECV3_7 | DEC | 10 | 7 | Marginal Gross Yield | ||
56 | INTRENO | VVINTRENO | VVINTRENO | CHAR | 13 | 0 | Internal Real Estate Master Data Code | ||
57 | XMETXT | VVXMETXT2 | XMBEZ | CHAR | 30 | 0 | Text for rental unit | ||
58 | SBASTEU | VVSBASTEU | BASJHR | NUMC | 4 | 0 | Swiss rent adj.: Base year for standard of living index | * | |
59 | DRESTAUR | VVDRESTAUR | DATUM | DATS | 8 | 0 | Date of reconstruction/extensive modernization | ||
60 | .INCLUDE | 0 | 0 | Immobilien gew.: VIMIMV | |||||
61 | SMIVE | SMIVE | VVSMIVE | CHAR | 13 | 0 | Lease-Out Number | ||
62 | VERKT_MV | SMIVE | VVSMIVE | CHAR | 13 | 0 | Lease-Out Number | ||
63 | VERKT_WE | SWENR | SWENR | CHAR | 8 | 0 | Business Entity Number | * | |
64 | VERKT_ME | SMENR | SMENR | CHAR | 8 | 0 | Number of Rental Unit | * | |
65 | DMIBEG | DMIBE | DDAT | DATS | 8 | 0 | Rental start date | ||
66 | DMIEND | DMIEN | DDAT | DATS | 8 | 0 | Rental end date | ||
67 | DERZAHL | DERZA | DDAT | DATS | 8 | 0 | Date of 1st debit position | ||
68 | SMVART | SMVART | SMVART | CHAR | 4 | 0 | External Real Estate contract type | TIV26 | |
69 | SMVANART | SMVAR | SMVAR | CHAR | 1 | 0 | Lease-Out Adjustment Type | TIV27 | |
70 | DUNTBIS | DUNBI | DDAT | DATS | 8 | 0 | Date provisional agreement from | ||
71 | BKAUTION | BKAUT | WRTV7 | CURR | 13 | 2 | Security deposit amount | ||
72 | SKAUTART | SKAUA | SKAUA | CHAR | 1 | 0 | Type of Rental Collateral | TIV18 | |
73 | DEINKUE | DEKUE | DDAT | DATS | 8 | 0 | Date of receipt of notice | ||
74 | DKUEZU | DKUZU | DDAT | DATS | 8 | 0 | Contract Notice Per | ||
75 | JMAHNSP | JMASP | JANE | CHAR | 1 | 0 | Dunning block indicator - no longer used! | ||
76 | STECHEM | STECHEM | STECHEM | CHAR | 13 | 0 | Heating expenses settlement company evaluation group | ||
77 | JMINDER | JMINDER | JANEI | CHAR | 1 | 0 | Rent reduction indicator | ||
78 | AMELDIN | AMELDIN | INTVJ | NUMC | 2 | 0 | Sales reporting interval | ||
79 | BUMSPROJ | BUMSPRNUSD | WRTV7 | CURR | 13 | 2 | not used (copy of BUMSPROJ) | ||
80 | BMINUMS | BUMS1NUSD | WRTV7 | CURR | 13 | 2 | not used (copy of BUMSATZ1) | ||
81 | PPROZ0 | PPROZ0 | DEC3_2 | DEC | 5 | 2 | Minimum percentage rate | ||
82 | DSTAEN | DSTAEN | DSTAEN | DATS | 8 | 0 | Status change date | ||
83 | DAKTV | DAKTV | DATUM | DATS | 8 | 0 | Contract activation | ||
84 | JLOESCH | JLOESCH | JLOESCH | CHAR | 1 | 0 | Real Estate Deletion Indicator/Flag | ||
85 | BUSAB | BUSAB | BUSAB | CHAR | 2 | 0 | Accounting clerk | * | |
86 | JVERL | JVERL | VVVERL | CHAR | 1 | 0 | Contract renewal | ||
87 | JSKUEND | JSKUEND | JANEI | CHAR | 1 | 0 | Special right of notice | ||
88 | JKAUFOPT | JKAUFOPT | JANEI | CHAR | 1 | 0 | Option to buy | ||
89 | DKAUFOPT | DKAUFOPT | DDAT | DATS | 8 | 0 | Purchase option date | ||
90 | SNKS | SNKS | J_OBJNR | CHAR | 22 | 0 | Service Charge Collector Number | * | |
91 | RERF | RERF | SYCHAR12 | CHAR | 12 | 0 | Entered by | ||
92 | DERF | DERF | DATUM | DATS | 8 | 0 | First Entered on | ||
93 | TERF | TERF | TIMES | TIMS | 6 | 0 | Time of Initial Entry | ||
94 | REHER | REHER | CHAR10 | CHAR | 10 | 0 | Source of initial entry | ||
95 | RBEAR | RBEAR | SYCHAR12 | CHAR | 12 | 0 | Employee ID | ||
96 | DBEAR | DBEAR | DATUM | DATS | 8 | 0 | Last Edited on | ||
97 | TBEAR | TBEAR | TIMES | TIMS | 6 | 0 | Last Edited at | ||
98 | RBHER | RBHER | CHAR10 | CHAR | 10 | 0 | Editing Source | ||
99 | DKUEFR | DKUEFR | NUMC2 | NUMC | 2 | 0 | Notice period in months | ||
100 | ANKUEN | ANKUEN | NUMC2 | NUMC | 2 | 0 | Notification until (for renewal of contract) | ||
101 | DABTR | DABTR | DATUM | DATS | 8 | 0 | Declaration of assignment | ||
102 | DFREIS | DFREIS | DATUM | DATS | 8 | 0 | Exemption (bank) | ||
103 | DABLF | DABLF | DATUM | DATS | 8 | 0 | Expiration Date | ||
104 | VERLG | VERLG | NUMC3 | NUMC | 3 | 0 | Contract renewal by ... months | ||
105 | ZSICH | VVZSICH | JANEI | CHAR | 1 | 0 | Indicator that other collateral is available | ||
106 | JBETRST | JBETRST | JANEI | CHAR | 1 | 0 | Security deposit granted | ||
107 | DBKERH | DBKERH | DATUM | DATS | 8 | 0 | Cash deposit received on | ||
108 | ABNNR | ABNNR | TEXT20 | CHAR | 20 | 0 | Identification of lease-out at settlement company | ||
109 | ABNUNR | ABNUNR | NUM3 | NUMC | 3 | 0 | Customer subnumber | ||
110 | BANKKS | BANKK | BANKK | CHAR | 15 | 0 | Bank Keys | ||
111 | SKUEFR | SKUEFR | SKUEFR | NUMC | 1 | 0 | Type of notice period | ||
112 | IMKEY | IMKEY | IMKEY | CHAR | 8 | 0 | Internal Key for Real Estate Object | ||
113 | KUNNR | VVRDEBIHVP | KUNNR | CHAR | 10 | 0 | Customer number main contract partner | KNA1 | |
114 | SPARTNR | VVRPARTABW | SPARTNR | CHAR | 10 | 0 | Alternative payer (partner number) | SPRT1 | |
115 | GSART | VVSART | VVSART | CHAR | 3 | 0 | Product Type | TZPA | |
116 | MADAT | MADAT | DATUM | DATS | 8 | 0 | Date of Last Dunning Notice | ||
117 | MANST | MAHNS_D | MAHNS | NUMC | 1 | 0 | Dunning Level | ||
118 | JBKRZ | VVJBKRZ | JANEI | CHAR | 1 | 0 | Cash deposit instalment payment | ||
119 | DEINZG | VVDEINZG | DATS | DATS | 8 | 0 | Move-in date | ||
120 | DAUSZG | VVDAUSZG | DATS | DATS | 8 | 0 | Move-out date | ||
121 | JANPIB | VVJANPIB | JANE | CHAR | 1 | 0 | Adjustment being processed (indicator) | ||
122 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | CEPC | |
123 | MABER | MABER | MABER | CHAR | 2 | 0 | Dunning Area | * | |
124 | PROFL | VVAPROF | APROF | CHAR | 6 | 0 | Settlement profile for costs | TKB1A | |
125 | KOKRS | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | TKA01 | |
126 | ZUSP | VVZUSP | JANE | CHAR | 1 | 0 | Subsidies available, indicator | ||
127 | REFNR | VVREFNR | TEXT30 | CHAR | 30 | 0 | Reference number for collateral securities | ||
128 | SBELEGNG | VVSBELEGNG | VVSBELEGNG | CHAR | 1 | 0 | RU occupancy by LO (used by third-prty/private/corp.grp) | ||
129 | MANSP | MANSP | MANSP | CHAR | 1 | 0 | Dunning block | T040S | |
130 | DERSTDR | VVDERSTDR | DATUM | DATS | 8 | 0 | Date When the Lease-Out was First Printed | ||
131 | DAENDDR | VVDAENDDR | DATUM | DATS | 8 | 0 | Date When the Lease-Out was Changed and Printed Out | ||
132 | JMFREI | VVJMFREI | JANE | CHAR | 1 | 0 | Condition is not checked | ||
133 | DVMUN | VVDVMUN | DATUM | DATS | 8 | 0 | Contract signed by landlord | ||
134 | JRMSCHPR | VVJRMSCHPR | XFELD | CHAR | 1 | 0 | Tenant service charge settlement? | ||
135 | TDNAME | TDOBNAME | TDOBNAME | CHAR | 70 | 0 | Name | ||
136 | KBK_PARTNR | SPARTNR | SPARTNR | CHAR | 10 | 0 | Partner number | SPRT1 | |
137 | GERSTD | VVXGERSTD | TEXT35 | CHAR | 35 | 0 | Jurisdiction | ||
138 | KONDPJ | VVKONDPJ | JFLAGG | CHAR | 1 | 0 | Conditions on lease-out effective per year (display) | ||
139 | JMABGR | VVJMABGR | JFLAGG | CHAR | 1 | 0 | Accrual/deferral method | ||
140 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | TGSB | |
141 | SKUEKEY | SKUEKEY | SKUEKEY | CHAR | 12 | 0 | Notice rule | ||
142 | SKUEART | SMVKUEART | SMVKUEART | CHAR | 1 | 0 | Notice Type of Lease-Out | ||
143 | E_SMIVE | VVESMIVE | VVSMIVE | CHAR | 13 | 0 | Contract No. of Collective Lease-Outs | ||
144 | HBKID | HBKID | HBKID | CHAR | 5 | 0 | Short key for a house bank | * | |
145 | FEHLBEL | VVFEHLBEL | VVFEHLBEL | CHAR | 20 | 0 | Reference code false occupancy charges | ||
146 | R1DATUM | VVR1DATUM | DATUM | DATS | 8 | 0 | 1st date for vacating | ||
147 | R2DATUM | VVR2DATUM | DATUM | DATS | 8 | 0 | 2nd date for vacating | ||
148 | KLDATUM | VVKLDATUM | DATUM | DATS | 8 | 0 | Date of complaint | ||
149 | KLAKTZEI | VVKLAKTZEI | CHAR20 | CHAR | 20 | 0 | Complaint reference code | ||
150 | IND_SECTOR | VVMVINDSEC | BRSCH | CHAR | 4 | 0 | Industry of master tenant | T016 | |
151 | TXJCD | TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | * | |
152 | DFLOWFIX | VVDFLOWFIX | DATUM | DATS | 8 | 0 | Flows fixed upto | ||
153 | .INCLUDE | 0 | 0 | Immobilien gew.: VIGWOBJZU (Teil) | |||||
154 | INTRENO_MFL | VVINTRENO | VVINTRENO | CHAR | 13 | 0 | Internal Real Estate Master Data Code | ||
155 | DGUELAB | VIGWGUELAB | DDAT | DATS | 8 | 0 | Valid-from date | ||
156 | DGUELBIS | VIGWSGUELBIS | DDAT | DATS | 8 | 0 | Date: Valid To | ||
157 | FLG_LME | VIGWFLGLME | JANE | CHAR | 1 | 0 | Flag zugeordnete Mieteinheit ist eine Leerstands-ME | ||
158 | GFLFAK | VIGWGFLNUFAK | VIGWGFLNUFAK | QUAN | 12 | 2 | Nutzungsanteil(%%) je Mieter bei Gemeinsch.Räumen u.-Flächen | ||
159 | GFAKEH | VIGWGFNFAKEH | VIGWQPROMILLE | UNIT | 2 | 0 | |||
160 | AUTOTYP | VIGWGFAUTOTYP | VIGWZUAUTOTYP | CHAR | 1 | 0 | Rolle der Zuordnung bei autom. Kalkulation Nutzungsfaktoren |
Foreign Keys
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |