| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OPT/VIM_1ITEM_S | Document Item | 25 | SGENR | Building Number | nvarchar | 8 | 0 | | |
2 | /OPT/VIM_TITEM | Document Item | 25 | SGENR | Building Number | nvarchar | 8 | 0 | | |
3 | REMOB_T_COND | Assign Condition Type & Measurement Type | 4 | SGENR | Number of Building | nvarchar | 8 | 0 | | |
4 | REMOB_T_LOG | Visit History | 5 | SGENR | Number of Building | nvarchar | 8 | 0 | | |
5 | VIXCITCADRO | Temporary rental object data | 27 | SGENR | Number of Building | nvarchar | 8 | 0 | | |
6 | VIYCPG | Participation Group for CAM | 4 | SGENR | Number of Building | nvarchar | 8 | 0 | | |
7 | YVIM_1ITEM | Document Item | 25 | SGENR | Building Number | nvarchar | 8 | 0 | | |
TOPBasic Data |
8 | VIBDBU | Building | 5 | SGENR | Number of Building | nvarchar | 8 | 0 | | |
9 | VIBDPLANPS | Plan Pooled Spaces | 5 | SGENR | Number of Building | nvarchar | 8 | 0 | | |
10 | VIBDRO | Rental Object | 26 | SGENR | Number of Building | nvarchar | 8 | 0 | | |
TOPFinancial Accounting |
11 | /OPT/VIM_1ITEM | Document Item | 25 | SGENR | Building Number | nvarchar | 8 | 0 | | |
12 | KMZEI | FI: Account Assignment Model Item Information | 81 | SGENR | Building Number | nvarchar | 8 | 0 | | |
13 | KOMU | Account Assignment Templates for G/L Account Items | 81 | SGENR | Building Number | nvarchar | 8 | 0 | | |
TOPFlexible Real Estate Management |
14 | VICAINTRENO | Assignment of INTRENO / OBJNR / IMKEY | 11 | SGENR | Number of Building | nvarchar | 8 | 0 | | |
TOPLogistics - General |
15 | HBSAFF | Affected building in Home Building Solution | 4 | SGENR | Building Number | nvarchar | 8 | 0 | | |
16 | HBSFLS | Fit-List | 4 | SGENR | Building Number | nvarchar | 8 | 0 | | |
17 | HBSFSP | Help dummy table | 4 | SGENR | Building Number | nvarchar | 8 | 0 | | |
TOPMigration |
18 | VIGWARARFL | Schlüssel archivierter arch. Flächen | 4 | SGENR | Rakennuksen numero | nvarchar | 8 | 0 | | |
19 | VIGWARARRA | Schlüssel archivierter arch. Räume | 4 | SGENR | Rakennuksen numero | nvarchar | 8 | 0 | | |
20 | VIGWARFL | Immobilien gew.: Architektonische Fläche (statischer Teil) | 18 | SGENR | Rakennuksen numero | nvarchar | 8 | 0 | | |
21 | VIGWARRA | Immobilien gew.: Architektonischer Raum (statischer Teil) | 16 | SGENR | Rakennuksen numero | nvarchar | 8 | 0 | | |
22 | VIGWFLGGZU | Immobilien gew.: Fl.-Zuordnung zu Gebäude oder Grundstück | 9 | SGENR | Rakennuksen numero | nvarchar | 8 | 0 | | |
23 | VIGWRAGEZU | Immobilien gew.: Ra-Zuordnung zu Gebäude oder Gebäudeteil | 8 | SGENR | Rakennuksen numero | nvarchar | 8 | 0 | | |
24 | VIGWVMFLZ | Immobilien gew.:Stammdaten Vermietfldche (zeitabh.Teil) | 17 | SGENR | Rakennuksen numero | nvarchar | 8 | 0 | | |
25 | VIGWVOBW | Immobilien gew.: Vorbelegung d.Konditionen f. BuKr/WE/GE/G | 4 | SGENR | Rakennuksen numero | nvarchar | 8 | 0 | | |
26 | VIGWVOBW_UPD | Immobilien gew.: Änderungsprotokoll der Konditionsvorbeleg. | 4 | SGENR | Rakennuksen numero | nvarchar | 8 | 0 | | |
27 | VIGW_VOBW | CRE Ph.2.1 neu: Vorbelegung d.Konditionen f. BuKr/WE/GE/GR | 4 | SGENR | Rakennuksen numero | nvarchar | 8 | 0 | | |
28 | VIGW_VOBW_UPD | Immobilien gew.: Änderungsprotokoll der Konditionsvorbeleg. | 4 | SGENR | Rakennuksen numero | nvarchar | 8 | 0 | | |
TOPProfit Center Accounting |
29 | KE1_WU_IM_ITEM | PCA Where-Used List: Itemization for Real Estate | 15 | SGENR | Building Number | nvarchar | 8 | 0 | | |
TOPReal Estate Management |
30 | S401 | RE standard analysis partner | 16 | SGENR | Building Number | nvarchar | 8 | 0 | | |
31 | S405 | Building | 15 | SGENR | Building Number | nvarchar | 8 | 0 | | |
32 | S406 | Rental units | 18 | SGENR | Building: number | nvarchar | 8 | 0 | | |
33 | S407 | Rental agreements | 78 | SGENR | Building Number | nvarchar | 8 | 0 | | |
34 | VIAKBSEG | Document Line Item from SCS for Interface | 99 | SGENR | Building Number | nvarchar | 8 | 0 | | |
35 | VIARMV | Key for archived lease-outs | 7 | SGENR | Building Number | nvarchar | 8 | 0 | | |
36 | VIAROBJ | Archived real estate objects | 12 | SGENR | Building Number | nvarchar | 8 | 0 | | |
37 | VIBEPP | Flow data - Planned items for real estate management | 75 | SGENR | Building Number | nvarchar | 8 | 0 | | |
38 | VIMI01 | Rental unit - Master data | 6 | SGENR | Building Number | nvarchar | 8 | 0 | | |
39 | VIOB03 | Real estate building master | 4 | SGENR | Building Number | nvarchar | 8 | 0 | | |
40 | VIOB04 | Buildings: Fixtures and fittings characteristics | 4 | SGENR | Building Number | nvarchar | 8 | 0 | | |
41 | VIOB05 | Building option rate | 4 | SGENR | Building Number | nvarchar | 8 | 0 | | |
42 | VIOB08 | Room | 4 | SGENR | Building Number | nvarchar | 8 | 0 | | |
43 | VIOB14 | Areas for Building (Obsolete) | 4 | SGENR | Building Number | nvarchar | 8 | 0 | | |
44 | VIOB20 | Fixtures and fittings objects for building | 4 | SGENR | Building Number | nvarchar | 8 | 0 | | |
45 | VIOB22 | Rooms | 7 | SGENR | Building Number | nvarchar | 8 | 0 | | |
46 | VIOB24 | Rental units per usage type (plan) | 5 | SGENR | Building Number | nvarchar | 8 | 0 | | |
47 | VIOB27 | Relationship between properties and buildings | 5 | SGENR | Building Number | nvarchar | 8 | 0 | | |
48 | VIOB28 | OLD, replaced by VIOB39 for 3.0 | 8 | SGENR | Building Number | nvarchar | 8 | 0 | | |
49 | VIOB29 | OLD, replaced by VIOB39 for 3.0 | 8 | SGENR | Building Number | nvarchar | 8 | 0 | | |
50 | VIOB38 | Relationship between Real Estate objects and SAP-PS | 8 | SGENR | Building Number | nvarchar | 8 | 0 | | |
51 | VIOB39 | Relationship between Real Estate objects and SAP-PM | 8 | SGENR | Building Number | nvarchar | 8 | 0 | | |
52 | VIRPS405 | Building | 15 | SGENR | Building Number | nvarchar | 8 | 0 | | |
53 | VIRPS406 | Rental units | 18 | SGENR | Building: number | nvarchar | 8 | 0 | | |
54 | VIRPS407 | Rental agreements | 78 | SGENR | Building Number | nvarchar | 8 | 0 | | |
55 | VIVW05 | Management contract: Managed objects | 11 | SGENR | Building Number | nvarchar | 8 | 0 | | |
56 | VIVW08 | Events for management contracts | 12 | SGENR | Building Number | nvarchar | 8 | 0 | | |
57 | VIWEGB | Relation table between buildings and assets | 4 | SGENR | Building Number | nvarchar | 8 | 0 | | |
58 | VIZNRN | Assignment: Real Estate numbers <-> IMKEY <-> INTRENO | 7 | SGENR | Building Number | nvarchar | 8 | 0 | | |