| 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 | | |