SAP ABAP Table VILINKEDRU (RE: Rental Unit - Linked RU Master Data 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
⤷ 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 | VILINKEDRU | Table Relationship Diagram |
Short Description | RE: Rental Unit - Linked RU Master Data 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 | Structure with fields from VIMI01 and addit. fields | |||||
2 | .INCLUDE | 0 | 0 | Rental unit - Master data | |||||
3 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
4 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
5 | SWENR | SWENR | SWENR | CHAR | 8 | 0 | Business Entity Number | VIOB01 | |
6 | SMENR | SMENR | SMENR | CHAR | 8 | 0 | Number of Rental Unit | * | |
7 | SGRNR | SGRNR | SGRNR | CHAR | 8 | 0 | Land Number for BE | VIOB02 | |
8 | SGENR | SGENR | SGENR | CHAR | 8 | 0 | Building Number | VIOB03 | |
9 | SGEBSWENR | SGEBSWENR | SWENR | CHAR | 8 | 0 | BE no.of rental unit to which the RU is linked | VIOB01 | |
10 | SGEBSMENR | SGEBSMENR | SMENR | CHAR | 8 | 0 | RU no. of rental unit to which the RU is linked | VIMI01 | |
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 | TIV23 | |
26 | XLAGE | SLAGK | SLAGK | NUMC | 2 | 0 | Location class | TIV22 | |
27 | SMOEBL | SMOEB | SMOEB | CHAR | 1 | 0 | Furniture indicator | ||
28 | STECHEM | STECHEM | STECHEM | CHAR | 13 | 0 | Heating expenses settlement company evaluation group | ||
29 | SALTNR | SALTNR | SALTNR | CHAR | 20 | 0 | Number of rental unit in existing real estate system | ||
30 | DBEGEH | DBEGEH | DDAT | DATS | 8 | 0 | Date of last RU inspection | ||
31 | XBEGEH | XBEGEH | XKBEZ | CHAR | 15 | 0 | Inspected by | ||
32 | JLOESCH | JLOESCH | JLOESCH | CHAR | 1 | 0 | Real Estate Deletion Indicator/Flag | ||
33 | PZUABSP | PZUABSP | PZUABSP | DEC | 4 | 2 | Surcharge or reduction for representative list of rents | ||
34 | PERHOE | PERHOE | DEC3_2 | DEC | 5 | 2 | Percentage rate increase | ||
35 | RPROZGRD | RPROZGRD | RPROZGRD | CHAR | 2 | 0 | Reason for variance in rate of percentage increase | TIV43 | |
36 | DBINDBIS | DBINDBIS | DATUM | DATS | 8 | 0 | Obligation period until | ||
37 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
38 | RBELBIND | RBELBIND | RBELBIND | CHAR | 4 | 0 | Occupancy obligation key | TIV31 | |
39 | RLIFT | RLIFT | RLIFT | NUMC | 2 | 0 | Type of elevator installation | TIV32 | |
40 | RMEDIEN | RMEDIEN | RMEDIEN | NUMC | 3 | 0 | Media reception | TIV33 | |
41 | RWASSER | RWASSER | RWASSER | NUMC | 2 | 0 | Type of water mains connection | TIV34 | |
42 | RLGESCH | RLGESCH | RLGESCH | CHAR | 2 | 0 | Location on Floor | TIV38 | |
43 | JVORSTEIG | JVORSTEIG | OPTIERT | CHAR | 1 | 0 | Input tax deduction for vacancy | ||
44 | SADRME | SADRME | SOBJNR | NUMC | 10 | 0 | Object number of rental unit for address purposes | SANO1 | |
45 | SNKS | SNKS | J_OBJNR | CHAR | 22 | 0 | Service Charge Collector Number | ONR00 | |
46 | IMKEY | IMKEY | IMKEY | CHAR | 8 | 0 | Internal Key for Real Estate Object | ||
47 | RERF | RERF | SYCHAR12 | CHAR | 12 | 0 | Entered by | ||
48 | DERF | DERF | DATUM | DATS | 8 | 0 | First Entered on | ||
49 | TERF | TERF | TIMES | TIMS | 6 | 0 | Time of Initial Entry | ||
50 | REHER | REHER | CHAR10 | CHAR | 10 | 0 | Source of initial entry | ||
51 | RBEAR | RBEAR | SYCHAR12 | CHAR | 12 | 0 | Employee ID | ||
52 | DBEAR | DBEAR | DATUM | DATS | 8 | 0 | Last Edited on | ||
53 | TBEAR | TBEAR | TIMES | TIMS | 6 | 0 | Last Edited at | ||
54 | RBHER | RBHER | CHAR10 | CHAR | 10 | 0 | Editing Source | ||
55 | ABNNR | ABNNR | TEXT20 | CHAR | 20 | 0 | Identification of lease-out at settlement company | ||
56 | XSTANDNR | VVXSTANDNR | VVXSTANDNR | CHAR | 5 | 0 | Number of garage / parking space | ||
57 | JEIGWOHN | VVJEIGWOHN | JANE | CHAR | 1 | 0 | Rental Unit in Separate Ownership (COA) | ||
58 | RFAKT | VVRFAKT | VVRFAKT | NUMC | 6 | 0 | Conversion factor for fractional share of property | ||
59 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | CEPC | |
60 | PROFL | VVAPROF | APROF | CHAR | 6 | 0 | Settlement profile for costs | TKB1A | |
61 | KOKRS | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | TKA01 | |
62 | SSTOCKW | VVSSTOCKW | VVSSTOCKW | NUMC | 3 | 0 | Floor | TIV37 | |
63 | JKONDMV | VVJKONDMV | XFELD | CHAR | 1 | 0 | Transfer conditions to RU when lease-out expires? | ||
64 | PKONDMV | VVPKONDMV | PRZ32 | DEC | 5 | 2 | Percentage rate for transfer of terms from LO to RU | ||
65 | DFSTRBIS | VVDFSTRBIS | DATUM | DATS | 8 | 0 | Date up to when the rental unit cash flow is created | ||
66 | SSTCKBIS | VVSSTCKBIS | VVSSTOCKW | NUMC | 3 | 0 | For RUs with Multiple Floors: Top Floor of RU | TIV37 | |
67 | JRMSCHPR | VVJRMSCHPR | XFELD | CHAR | 1 | 0 | Tenant service charge settlement? | ||
68 | DHPZSAKT | VVDHPZSAKT | DATUM | DATS | 8 | 0 | CH rent adj.:Date of mort.loan rate status for current rent | ||
69 | DUTBKAKT | VVDUTBKAKT | DATUM | DATS | 8 | 0 | CH rnt adj.:Dte maint./oper.costs index status for new rent | ||
70 | DTEURAKT | VVDTEURAKT | DATUM | DATS | 8 | 0 | CH rnt adj.:Dte of living stndrd index status for curr.rent | ||
71 | BRDBRTZZ | VVBRDBRTZZ | DECV3_7 | DEC | 10 | 7 | CH rent adj: Actual gross yield earned | ||
72 | BRDBRTKD | VVBRDBRTKD | DECV3_7 | DEC | 10 | 7 | Marginal Gross Yield | ||
73 | INTRENO | VVINTRENO | VVINTRENO | CHAR | 13 | 0 | Internal Real Estate Master Data Code | ||
74 | XMETXT | VVXMETXT2 | XMBEZ | CHAR | 30 | 0 | Text for rental unit | ||
75 | SBASTEU | VVSBASTEU | BASJHR | NUMC | 4 | 0 | Swiss rent adj.: Base year for standard of living index | * | |
76 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | TGSB | |
77 | DRESTAUR | VVDRESTAUR | DATUM | DATS | 8 | 0 | Date of reconstruction/extensive modernization | ||
78 | TXJCD | TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | * | |
79 | DFLOWFIX | VVDFLOWFIX | DATUM | DATS | 8 | 0 | Flows fixed upto | ||
80 | KOEIGR | VVWERTN_AD | VVWERTN_AD | CHAR | 10 | 0 | Account determination key for account determination | TIVC6 | |
81 | BERGRP | VVBERGRP | VVBERGRP | CHAR | 40 | 0 | Authorization group | ||
82 | SPOSINMSP | VVSPOSINMSP | VVSADJBASE | CHAR | 1 | 0 | Base value for grouping RU in RLR group | ||
83 | PPOSINMSP | VVPPOSINMSP | DECV3_2 | DEC | 5 | 2 | Percentage value for grouping RU in RLR category group | ||
84 | DFRDVON | VVDFRDVON | DATUM | DATS | 8 | 0 | Public funding from | ||
85 | DFRDBIS | VVDFRDBIS | DATUM | DATS | 8 | 0 | Public funding to | ||
86 | SGRUNDB | SGRUNDB | SGRUNDB | NUMC | 8 | 0 | Land register number | VIGBUCH | |
87 | PAUSFW | VVPAUSFW | DEC3_2 | DEC | 5 | 2 | Service charge stt. apport.loss risk percentage surcharge | ||
88 | RESADXEYECATCH | RESADXEYECATCH | RESADXEYECATCH | CHAR | 85 | 0 | Short Description of Real Estate Object on Offer | ||
89 | RESADJINTERNET | RESADJINTERNET | XFELD | CHAR | 1 | 0 | Indicator Internet Release | ||
90 | REFANG | VVREFANG | RANL | CHAR | 13 | 0 | Reference offer | VIMI33 | |
91 | .INCLUDE | 0 | 0 | ||||||
92 | .INCLU--AP | 0 | 0 | OBSOLETE: Rental Object Append Fields | |||||
93 | .INCLUDE | 0 | 0 | OBSOLETE: Rental Object Append Fields | |||||
94 | ROTYPE | REBDROTYPE | REBDROTYPE | CHAR | 2 | 0 | Rental Object Type | ||
95 | ROTYPEEX | REBDROTYPEEX | REBDROTYPEEX | CHAR | 1 | 0 | OBSOLETE: Type of Rental Object (External) | ||
96 | FLID | REBDALTROID | REBDALTROID | CHAR | 13 | 0 | OBSOLETE: Alternative ID for Rental Object (from CRE) | ||
97 | CANBECOMMON | REBDCANBECOMMON | RECABOOL | CHAR | 1 | 0 | Common Usage Possible | ||
98 | FIRSTPOSTING | REBDFIRSTPOSTING | RECADATE | DATS | 8 | 0 | Obsolete: Date of First Posting | ||
99 | .INCLUDE | 0 | 0 | OBSOLETE: Shared Master Data Fields: Append Fields | |||||
100 | VALIDFROM | REBDOBJVALIDFROM | RECADATEBEG | DATS | 8 | 0 | Date: Object Valid From | ||
101 | VALIDTO | REBDOBJVALIDTO | RECADATEEND | DATS | 8 | 0 | Date: Object Valid To | ||
102 | CREATIONTYPE | RECACREATIONTYPE | RECACREATIONTYPE | CHAR | 1 | 0 | How the Object Was Created | ||
103 | RESPONSIBLE | RECARESPONSIBLE | XUBNAME | CHAR | 12 | 0 | Person Responsible | * | |
104 | USEREXCLUSIVE | RECAUSEREXCLUSIVE | XUBNAME | CHAR | 12 | 0 | User with Exclusive Change Authorization | * | |
105 | CFARCHIVEDTO | RECDCFARCHIVEDTO | RECADATE | DATS | 8 | 0 | Date Up to Which the Cash Flow Is Archived | ||
106 | CFLOCKEDTO | RECDCFLOCKEDTO | RECADATE | DATS | 8 | 0 | Date Until Which the Cash Flow Is Locked | ||
107 | XNUNRK | XNUNRK | XKBEZ | CHAR | 15 | 0 | Short description of external usage type of rental unit | ||
108 | XNUNRM | XNUNRM | XMBEZ | CHAR | 30 | 0 | Description of external usage type of rental unit | ||
109 | XBELA | XBELA | AS4TEXT | CHAR | 60 | 0 | Description of occupancy type of rental unit | ||
110 | XHEIZ | XHEIZ | AS4TEXT | CHAR | 60 | 0 | Description of heating type of rental unit | ||
111 | XGEBK | XGEBK | XKBEZ | CHAR | 15 | 0 | Short name for parts of building | ||
112 | XGEBM | XGEBM | XMBEZ | CHAR | 30 | 0 | Building parts long text | ||
113 | BBASI | FVVIBBAS | WERTV6 | CURR | 11 | 2 | Base amount | ||
114 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
115 | XAUSTKLL | XAUSTKLL | XTEXT50 | CHAR | 50 | 0 | Long text of fixture and fitting category | ||
116 | XLAGKM | XLAGKM | XMBEZ | CHAR | 30 | 0 | Description of location class acc.to rep.list of rents | ||
117 | XMOEB | XMOEB | AS4TEXT | CHAR | 60 | 0 | Description of furnished extent of rental unit | ||
118 | XKBELBEZ | XKBELBEZ | XKBEZ | CHAR | 15 | 0 | Occupancy obligation short text | ||
119 | XMBELBEZ | XMBELBEZ | XMBEZ | CHAR | 30 | 0 | Occupancy obligation name | ||
120 | XKMED | XKMED | XKBEZ | CHAR | 15 | 0 | Media reception | ||
121 | XMMED | XMMED | XMBEZ | CHAR | 30 | 0 | Media reception | ||
122 | XKWASSER | XKWASSER | XKBEZ | CHAR | 15 | 0 | Short name: Type of water mains connection | ||
123 | XMWASSER | XMWASSER | XMBEZ | CHAR | 30 | 0 | Long name: Type of water mains connection | ||
124 | XSTOCKK | VVXSTOCKK | VVXSTOCKK | CHAR | 4 | 0 | Short name of floor | ||
125 | XSTOCKM | XGKBEZ | XKBEZ | CHAR | 15 | 0 | Short Description for Floor | ||
126 | XSTOCKL | XGMBEZ | XMBEZ | CHAR | 30 | 0 | Long Description for Floor | ||
127 | XKLGESCH | XKLGESCH | XKBEZ | CHAR | 15 | 0 | Location in floor short name | ||
128 | XMLGESCH | XMLGESCH | XMBEZ | CHAR | 30 | 0 | Location in floor long description | ||
129 | XSTOCKBISK | XSTOCKBISK | VVXSTOCKK | CHAR | 4 | 0 | Short description of highest storey of RU | ||
130 | XSTOCKBISM | XSTOCKBISM | XKBEZ | CHAR | 15 | 0 | Description of highest storey of RU | ||
131 | XSTOCKBISL | XSTOCKBISL | XMBEZ | CHAR | 30 | 0 | Long text of highest storey in RU | ||
132 | SNUNRINT | SNUNRINT | SNUNRINT | NUMC | 2 | 0 | Internal usage type | * | |
133 | .INCLUDE | 0 | 0 | Land Register Data Fields Part 1a | |||||
134 | PARTNR | BP_PARTNR | BP_PARTNR | CHAR | 10 | 0 | Business Partner Number | * | |
135 | XGBVON | XGBVON | XTEXT25 | CHAR | 25 | 0 | Land register district | ||
136 | NBANDNR | NBANDNR | TEXT15 | CHAR | 15 | 0 | Land register volume number | ||
137 | NBLATTNR | NBLATTNR | TEXT15 | CHAR | 15 | 0 | Land register page number | ||
138 | .INCLUDE | 0 | 0 | Land Register Data Fields Part 1c | |||||
139 | SGRBA | SGRBA | SGRBA | NUMC | 2 | 0 | Land register type | * | |
140 | FEINS | FEINS | MEINS | UNIT | 3 | 0 | Area unit | * | |
141 | .INCLUDE | 0 | 0 | Land Register Data Fields Part 3 | |||||
142 | XGBAMT | XGBAMT | XTEXT25 | CHAR | 25 | 0 | Land registry ID | ||
143 | .INCLUDE | 0 | 0 | Land Register Text Fields | |||||
144 | XGRBAK | XGRBAK | XKBEZ | CHAR | 15 | 0 | Short description of land register type | ||
145 | XGRBAM | XGRBAM | XMBEZ | CHAR | 30 | 0 | Description of land register type | ||
146 | XGRBAL | XGRBAL | XTEXT50 | CHAR | 50 | 0 | Long Description of Land Register Type | ||
147 | XFEINSK | XFEINSK | TEXT10 | CHAR | 10 | 0 | Description of area unit | ||
148 | XFEINSL | XFEINSL | TEXT30 | CHAR | 30 | 0 | Description of area unit |
Foreign Keys
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |