| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /OPT/AT_APPR_HIS | Approval History for Level Based Approvals | 49 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 2 | /OPT/AT_LBA_LOG | Approval History for Level Based Approvals | 50 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 3 | /OPT/VIM_1ITEM_S | Document Item | 53 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 4 | /OPT/VIM_TITEM | Document Item | 53 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 5 | REMOB_T_COND | Assign Condition Type & Measurement Type | 6 | SMENR | Number of Rental Object | nvarchar | 8 | 0 | | |
| 6 | REMOB_T_LOG | Visit History | 7 | SMENR | Number of Rental Object | nvarchar | 8 | 0 | | |
| 7 | YVIM_1ITEM | Document Item | 53 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 8 | ZEIM_VBAK | Sales Document: Header Data | 125 | SMENR | Number of Sales Unit | nvarchar | 8 | 0 | | |
| TOPBasic Data |
| 9 | VIBDPLANOBJ | Plan Pooled Space | 6 | SMENR | Number of Rental Object | nvarchar | 8 | 0 | | |
| 10 | VIBDPLANPS | Plan Pooled Spaces | 4 | SMENR | Number of Rental Object | nvarchar | 8 | 0 | | |
| 11 | VIBDRO | Rental Object | 5 | SMENR | Number of Rental Object | nvarchar | 8 | 0 | | |
| 12 | VIBDROOCC | Occupancy History | 11 | SMENR | Number of Rental Object | nvarchar | 8 | 0 | | |
| TOPDunning |
| 13 | MHNK | Dunning data (account entries) | 56 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| TOPFinancial Accounting |
| 14 | /OPT/VIM_1ITEM | Document Item | 53 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 15 | KMZEI | FI: Account Assignment Model Item Information | 83 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 16 | KOMU | Account Assignment Templates for G/L Account Items | 83 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| TOPFlexible Real Estate Management |
| 17 | VIAKHO13 | WEG-Verwaltung: Umlage Eigentümerabrechnung | 12 | SMENR | Nummer der Mieteinheit | nvarchar | 8 | 0 | | |
| 18 | VIAKHO20 | WEG-Verwaltung: Guthaben/Forderungen Eigentümerabrechnung | 5 | SMENR | Nummer der Mieteinheit | nvarchar | 8 | 0 | | |
| 19 | VIAKHOPO | WEG-Verwaltung: Jahresübersicht Umlage Bank/Rücklagen | 10 | SMENR | Nummer der Mieteinheit | nvarchar | 8 | 0 | | |
| 20 | VICAINTRENO | Assignment of INTRENO / OBJNR / IMKEY | 12 | SMENR | Number of Rental Object | nvarchar | 8 | 0 | | |
| 21 | VIXCSCCHTPITEM | Item Data for External Heating Expenses Settlement | 6 | SMENR | Number of Rental Object | nvarchar | 8 | 0 | | |
| TOPInput Tax Treatment |
| 22 | VIBECOME | Mietobjekte zum Berichtigungsobjekt (Optionssatzermittlung) | 5 | SMENR | Nummer der Mieteinheit | nvarchar | 8 | 0 | | |
| TOPProfit Center Accounting |
| 23 | KE1_WU_IM_ITEM | PCA Where-Used List: Itemization for Real Estate | 16 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| TOPReal Estate Management |
| 24 | ONRIM | Rental unit object number index | 5 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 25 | ONRIV | Rental agreement item object number index | 6 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 26 | S401 | RE standard analysis partner | 17 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 27 | S406 | Rental units | 19 | SMENR | Rental unit: number | nvarchar | 8 | 0 | | |
| 28 | S407 | Rental agreements | 114 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 29 | VIAK02 | Settlement Participation for Service Charge Settlement | 5 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 30 | VIAK11 | Inclusion of acct settlement results from D-tape | 5 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 31 | VIAK13 | Apportionment Result for List Evaluation (SCSettlement) | 11 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 32 | VIAK14 | RA credit memo/receivable:now only used as structure! | 5 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 33 | VIAK17 | Interface for settlement / transfer of advance payments | 6 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 34 | VIAK18 | Management fee surcharge for service charges settlement | 6 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 35 | VIAK20 | RA credit memo/receivable (incid.exp.sttlmnt created) | 5 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 36 | VIAK24 | Service charges settlement: Allocate RU to set of part. RUs | 6 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 37 | VIAKBSEG | Document Line Item from SCS for Interface | 101 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 38 | VIARMV | Key for archived lease-outs | 5 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 39 | VIAROBJ | Archived real estate objects | 13 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 40 | VIBEME | Assign rental units to correction items | 5 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 41 | VIBEPP | Flow data - Planned items for real estate management | 10 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 42 | VILIC | ICI Historical Data | 7 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 43 | VILID | ICI Historical Data of D-Building | 6 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 44 | VILIR | IRE Historical data | 8 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 45 | VIMI01 | Rental unit - Master data | 4 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 46 | VIMI02 | Fixtures and Fittings Characteristics of a Rental Unit | 4 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 47 | VIMI04 | Old. replaced in 3.0 with VIMIMV | 5 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 48 | VIMI07 | Reported Sales for Sales-Based Lease-Out | 5 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 49 | VIMI08 | Apportionment units per rental unit | 4 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 50 | VIMI09 | Graded Lease-Out | 5 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 51 | VIMI10 | Rental agreement additional text | 6 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 52 | VIMI14 | RA: Adjustment block for terms types | 5 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 53 | VIMI16 | RE: Records of a Rent Adjustment Run | 5 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 54 | VIMI18 | Rent Adjustment History for Lease-Out | 5 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 55 | VIMI20 | Compar.accommod.:Assign RU or ext. comp.aprtmnt to accommod. | 7 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 56 | VIMI21 | Alloc. rental unit - comparative accomm. for rent adjustment | 4 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 57 | VIMI22 | Assignment / Rental unit - rental request offers | 4 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 58 | VIMI23 | Determination of Year and Percent for Sls-Bsd LO | 5 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 59 | VIMI24 | Percentage for Sales for Sales-Based Lease-Out | 5 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 60 | VIMI25 | Sales reports | 5 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 61 | VIMI26 | Notice of rental agreement | 5 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 62 | VIMI28 | Sales settlement histories | 5 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 63 | VIMI31 | Allocation of rental units to modernization measure | 5 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 64 | VIMI32 | Other collateral | 5 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 65 | VIMI33 | Offers for a rental unit (-> VIMIMV) | 5 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 66 | VIMI34 | Determine year and percent for sales-based agreement (offer) | 5 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 67 | VIMI35 | Percent for sales for sales-based rental agrmnt (offer) | 5 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 68 | VIMI36 | Index-Linked Lease-Out Offer | 5 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 69 | VIMI37 | RA offer: Adjustment block for term types | 5 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 70 | VIMI39 | Tenant change; data for apartment inspection | 5 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 71 | VIMI40 | Tenant change: Data on release of rental deposits | 5 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 72 | VIMI43 | Allocation of expert opinion to rental units | 5 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 73 | VIMI47 | Tenant change: Alloc.of maint.orders to sec.deposit release | 5 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 74 | VIMIMV | Lease-Out | 6 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 75 | VIMITH | Rental agreement number and doc.number for printing invoices | 4 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 76 | VIOB08 | Room | 5 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 77 | VIOB09 | Areas for each Rental Unit (Obsolete) | 4 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 78 | VIOB10 | Number of rooms per rental unit | 4 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 79 | VIOB11 | Assignment of rooms to rental units | 4 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 80 | VIOB28 | OLD, replaced by VIOB39 for 3.0 | 9 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 81 | VIOB29 | OLD, replaced by VIOB39 for 3.0 | 9 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 82 | VIOB38 | Relationship between Real Estate objects and SAP-PS | 9 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 83 | VIOB39 | Relationship between Real Estate objects and SAP-PM | 9 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 84 | VIRPS406 | Rental units | 19 | SMENR | Rental unit: number | nvarchar | 8 | 0 | | |
| 85 | VIRPS407 | Rental agreements | 114 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 86 | VIVW05 | Management contract: Managed objects | 12 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 87 | VIVW08 | Events for management contracts | 13 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| 88 | VIWB10 | Mieteinheitenzuordnung der Wirtschaftlichkeitsberechnung | 5 | SMENR | Nummer der Mieteinheit | nvarchar | 8 | 0 | | |
| 89 | VIWB52 | WB: Laufende Aufwendungen II - ME-Zuordnung zu Bewirtschaft. | 7 | SMENR | Nummer der Mieteinheit | nvarchar | 8 | 0 | | |
| 90 | VIZNRN | Assignment: Real Estate numbers <-> IMKEY <-> INTRENO | 8 | SMENR | Number of Rental Unit | nvarchar | 8 | 0 | | |
| TOPSales |
| 91 | VBAK | Sales Document: Header Data | 125 | SMENR | Number of Sales Unit | nvarchar | 8 | 0 | | |
