| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OPT/VIM_1ITEM_S | Document Item | 47 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
2 | /OPT/VIM_TITEM | Document Item | 47 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
3 | REMOB_T_COND | Assign Condition Type & Measurement Type | 5 | SGRNR | Number of Land | nvarchar | 8 | 0 | | |
4 | REMOB_T_LOG | Visit History | 6 | SGRNR | Number of Land | nvarchar | 8 | 0 | | |
5 | VIXCITCADRO | Temporary rental object data | 26 | SGRNR | Number of Land | nvarchar | 8 | 0 | | |
6 | VIYCPG | Participation Group for CAM | 5 | SGRNR | Number of Land | nvarchar | 8 | 0 | | |
7 | YVIM_1ITEM | Document Item | 47 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
TOPBasic Data |
8 | VIBDPLANPS | Plan Pooled Spaces | 6 | SGRNR | Number of Land | nvarchar | 8 | 0 | | |
9 | VIBDPR | Land | 5 | SGRNR | Number of Land | nvarchar | 8 | 0 | | |
10 | VIBDRO | Rental Object | 25 | SGRNR | Number of Land | nvarchar | 8 | 0 | | |
TOPFinancial Accounting |
11 | /OPT/VIM_1ITEM | Document Item | 47 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
12 | KMZEI | FI: Account Assignment Model Item Information | 82 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
13 | KOMU | Account Assignment Templates for G/L Account Items | 82 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
TOPFlexible Real Estate Management |
14 | VICAINTRENO | Assignment of INTRENO / OBJNR / IMKEY | 10 | SGRNR | Number of Land | nvarchar | 8 | 0 | | |
TOPMigration |
15 | VIGWARARFL | Schlüssel archivierter arch. Flächen | 5 | SGRNR | Tontin numero - talousyksikkö | nvarchar | 8 | 0 | | |
16 | VIGWARFL | Immobilien gew.: Architektonische Fläche (statischer Teil) | 17 | SGRNR | Tontin numero - talousyksikkö | nvarchar | 8 | 0 | | |
17 | VIGWFLGGZU | Immobilien gew.: Fl.-Zuordnung zu Gebäude oder Grundstück | 8 | SGRNR | Tontin numero - talousyksikkö | nvarchar | 8 | 0 | | |
18 | VIGWVMFLZ | Immobilien gew.:Stammdaten Vermietfldche (zeitabh.Teil) | 18 | SGRNR | Tontin numero - talousyksikkö | nvarchar | 8 | 0 | | |
19 | VIGWVOBW | Immobilien gew.: Vorbelegung d.Konditionen f. BuKr/WE/GE/G | 5 | SGRNR | Tontin numero - talousyksikkö | nvarchar | 8 | 0 | | |
20 | VIGWVOBW_UPD | Immobilien gew.: Änderungsprotokoll der Konditionsvorbeleg. | 5 | SGRNR | Tontin numero - talousyksikkö | nvarchar | 8 | 0 | | |
21 | VIGW_VOBW | CRE Ph.2.1 neu: Vorbelegung d.Konditionen f. BuKr/WE/GE/GR | 5 | SGRNR | Tontin numero - talousyksikkö | nvarchar | 8 | 0 | | |
22 | VIGW_VOBW_UPD | Immobilien gew.: Änderungsprotokoll der Konditionsvorbeleg. | 5 | SGRNR | Tontin numero - talousyksikkö | nvarchar | 8 | 0 | | |
TOPProfit Center Accounting |
23 | KE1_WU_IM_ITEM | PCA Where-Used List: Itemization for Real Estate | 14 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
TOPReal Estate Management |
24 | S401 | RE standard analysis partner | 15 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
25 | S404 | Properties | 52 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
26 | S406 | Rental units | 17 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
27 | S407 | Rental agreements | 88 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
28 | S408 | Land registers | 89 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
29 | VIAKBSEG | Document Line Item from SCS for Interface | 100 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
30 | VIARMV | Key for archived lease-outs | 6 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
31 | VIAROBJ | Archived real estate objects | 11 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
32 | VIBEPP | Flow data - Planned items for real estate management | 74 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
33 | VIGBSTD | Real estate register of land register | 18 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
34 | VILIC | ICI Historical Data | 8 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
35 | VILID | ICI Historical Data of D-Building | 7 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
36 | VIMI01 | Rental unit - Master data | 5 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
37 | VIOB02 | Property master data | 4 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
38 | VIOB06 | Property option rate | 4 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
39 | VIOB15 | Areas for properties | 4 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
40 | VIOB24 | Rental units per usage type (plan) | 4 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
41 | VIOB27 | Relationship between properties and buildings | 4 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
42 | VIOB28 | OLD, replaced by VIOB39 for 3.0 | 7 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
43 | VIOB29 | OLD, replaced by VIOB39 for 3.0 | 7 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
44 | VIOB35 | Productive Holdings | 7 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
45 | VIOB38 | Relationship between Real Estate objects and SAP-PS | 7 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
46 | VIOB39 | Relationship between Real Estate objects and SAP-PM | 7 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
47 | VIRPS406 | Rental units | 17 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
48 | VIRPS407 | Rental agreements | 88 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
49 | VIVW05 | Management contract: Managed objects | 10 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
50 | VIVW08 | Events for management contracts | 11 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
51 | VIWEGR | Relation table between property and assets | 4 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
52 | VIZNRN | Assignment: Real Estate numbers <-> IMKEY <-> INTRENO | 6 | SGRNR | Property Number for BE | nvarchar | 8 | 0 | | |
TOPReal Estate Slovakia |
53 | VIXCSKSDANP | Property Tax - Master data | 6 | SGRNR | Number of Land | nvarchar | 8 | 0 | | |