| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000172000 | PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items | 141 | IMKEY | | nvarchar | 8 | 0 | | |
2 | AUAA | Settlement Document: Receiver Segment | 37 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
3 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 124 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
4 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 130 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
5 | BSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 60 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
6 | BSEG | Accounting Document Segment | 218 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
7 | BSID_BAK | Accounting: Secondary Index for Customers | 124 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
8 | BSIK_BAK | Accounting: Secondary index for vendors | 130 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
9 | BSIS_BAK | Accounting: Secondary Index for G/L Accounts | 60 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
10 | BSSEG | Accounting Document Segment | 207 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
11 | CNVA_PCREA_AA_C | PC Reorg Analysis: FI-AA Profit Center assignments | 16 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
12 | FAGLBSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 60 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
13 | FAGLBSIS_BAK | Accounting: Secondary Index for G/L Accounts | 60 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
14 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 207 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
15 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 207 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
16 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 207 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
17 | GLPCA_CT | Profit Center Documents | 76 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
18 | GLPCA_T_CT | Profit Center Documents | 92 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
19 | GLPOS_C_CT | FI Document: Entry View | 139 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
20 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 139 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
21 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 139 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
22 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 139 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
23 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 141 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
24 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 141 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
25 | REGUP | Processed items from payment program | 122 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
26 | VIXCITCADRO | Temporary rental object data | 8 | IMKEY | Internal Key of Real Estate Object (FI) | nvarchar | 8 | 0 | | |
TOPAccounting Interface |
27 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 167 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
28 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 167 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
TOPAlternative Valuation Run |
29 | CKMLAVRDOCIT | Lines for Cumulation Posting Document | 60 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
TOPBasic Data |
30 | VIBDBE | Business Entity | 6 | IMKEY | Internal Key of Real Estate Object (FI) | nvarchar | 8 | 0 | | |
31 | VIBDBU | Building | 7 | IMKEY | Internal Key of Real Estate Object (FI) | nvarchar | 8 | 0 | | |
32 | VIBDPR | Land | 7 | IMKEY | Internal Key of Real Estate Object (FI) | nvarchar | 8 | 0 | | |
33 | VIBDRO | Rental Object | 7 | IMKEY | Internal Key of Real Estate Object (FI) | nvarchar | 8 | 0 | | |
TOPBasic Functions |
34 | ANLP | Asset Periodic Values | 50 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
35 | ANLZ | Time-Dependent Asset Allocations | 36 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
36 | FDI1 | Cash Management Line Item for RE Classic Planning Records | 2 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
TOPCapital Investments |
37 | ANIA | Depr. simulation for invest. projects | 25 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
TOPCross-Application Components |
38 | BBSID | Accounting: Secondary index for customers | 124 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
TOPData Retention Tool |
39 | TXW_S_BSEG | Retrieve BSEG from archive | 102 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
TOPDunning |
40 | MHNK | Dunning data (account entries) | 36 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
41 | MHNKO | Dunning data (acct entries) version before the next change | 36 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
TOPElectronic Bank Statement |
42 | FEB_ACCNT_SAVE | Saving of Posting Lines for Postprocessing (Account Assign.) | 65 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
43 | FEB_ACT | Acct Assignment Templates | 65 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
TOPExternal Services |
44 | ESKN | Account Assignment in Service Package | 30 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
TOPFinancial Accounting |
45 | ACCTIT | Compressed Data from FI/CO Document | 61 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
46 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 124 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
47 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 130 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
48 | BSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 60 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
49 | BSID | Accounting: Secondary Index for Customers | 124 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
50 | BSIK | Accounting: Secondary Index for Vendors | 130 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
51 | BSIS | Accounting: Secondary Index for G/L Accounts | 60 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
52 | EBSEG | Doc.Segment of Fin.Accntng External Documents | 67 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
53 | KMZEI | FI: Account Assignment Model Item Information | 45 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
54 | KOMU | Account Assignment Templates for G/L Account Items | 45 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
55 | VBSEGA | Document Segment for Document Parking - Asset Database | 57 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
56 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 40 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
TOPFlexible Real Estate Management |
57 | VICAAROBJ | Archived Data Object | 13 | IMKEY | Internal Key of Real Estate Object (FI) | nvarchar | 8 | 0 | | |
58 | VICAINTRENO | Assignment of INTRENO / OBJNR / IMKEY | 6 | IMKEY | Internal Key of Real Estate Object (FI) | nvarchar | 8 | 0 | | |
59 | VIGBOOK | LUM: Grundbuch | 19 | IMKEY | Interner Schlüssel für Immobilienobjekt | nvarchar | 8 | 0 | | |
TOPFreight Processing |
60 | VFKN | Account Determination in Shipment Costs Item | 29 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
TOPFunds Management |
61 | KBLP | Document Item: Manual Document Entry | 93 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
TOPFunds Management-Specific Postings |
62 | FMFUNDTRANSYEAR | Additional Documents for Funds Transfer to Diff. Years | 41 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
63 | PSOSEGS | Recurring Request Document Segment, G/L Accounts | 40 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
TOPGeneral Ledger Accounting |
64 | FAGLBSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 60 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
65 | FAGLBSIS | Accounting: Secondary Index for G/L Accounts | 60 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
66 | FAGL_SPLINFO | Splittling Information of Open Items | 18 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
TOPGL Account Posting |
67 | TCJ_POSITIONS | Cash Journal Document Items | 72 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
TOPInventory Management |
68 | MSEG | Document Segment: Material | 109 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
69 | MWXMSEG | ZMSEG: Interface for Posting of Value | 109 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
70 | MWZMSEG | ZMSEG:Interface for Posting of Value | 109 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
71 | RKPF | Document Header: Reservation | 26 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
TOPInvoice Verification |
72 | RBCO | Document Item, Incoming Invoice, Account Assignment | 18 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
TOPLocal Currency Changeover |
73 | EWUFI_SCA | EMU conversion: Table of the clearings to be adjusted | 34 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
TOPMigration |
74 | VIGWARFL | Immobilien gew.: Architektonische Fläche (statischer Teil) | 5 | IMKEY | Kiinteistökohteen sisäinen avain | nvarchar | 8 | 0 | | |
75 | VIGWFLOBJ | Immobilien gew.: Stammdaten Fläche (statischer Teil) | 4 | IMKEY | Kiinteistökohteen sisäinen avain | nvarchar | 8 | 0 | | |
76 | VIGWVMFL | Immobilien gew.: Stammdaten Vermietfläche (statischer Teil | 6 | IMKEY | Kiinteistökohteen sisäinen avain | nvarchar | 8 | 0 | | |
77 | VIMIMAPCNNR | Conversion Decisions: Contract Numbers | 7 | IMKEY | Internal Key of Real Estate Object (FI) | nvarchar | 8 | 0 | | |
TOPProfit Center Accounting |
78 | GLPCA | EC-PCA: Actual Line Items | 95 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
79 | GLPCP | EC-PCA: Plan Line Items | 148 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
TOPPurchasing |
80 | EBKN | Purchase Requisition Account Assignment | 32 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
81 | EKKN | Account Assignment in Purchasing Document | 35 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
TOPQuality Inspection |
82 | QALS | Inspection lot record | 192 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
TOPQuality Notifications |
83 | TQ8CO | Assignment of reference orders to notification type | 14 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
TOPReal Estate Contract |
84 | VICNCN | Real Estate Contract | 6 | IMKEY | Internal Key of Real Estate Object (FI) | nvarchar | 8 | 0 | | |
TOPReal Estate Management |
85 | VIAK03 | Settlement Unit Master Record | 16 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
86 | VIAK08 | DME Settlement Units Master Data | 31 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
87 | VIAK11 | Inclusion of acct settlement results from D-tape | 20 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
88 | VIAKBSEG | Document Line Item from SCS for Interface | 118 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
89 | VIAKUV | Sales settlement histories | 14 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
90 | VIAROBJ | Archived real estate objects | 8 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
91 | VIBEBE | Correction items for input tax treatment | 21 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
92 | VIBEPP | Flow data - Planned items for real estate management | 2 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
93 | VICN01 | Real Estate Contract: Contract Data | 25 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
94 | VIEIGT | OLD, replaced by VIEIGE in 3.0 | 2 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
95 | VIGBUCH | Land register | 19 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
96 | VIMI01 | Rental unit - Master data | 44 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
97 | VIMI04 | Old. replaced in 3.0 with VIMIMV | 77 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
98 | VIMI11 | Applications - Real Estate Management | 36 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
99 | VIMI16 | RE: Records of a Rent Adjustment Run | 33 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
100 | VIMI28 | Sales settlement histories | 14 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
101 | VIMI33 | Offers for a rental unit (-> VIMIMV) | 49 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
102 | VIMI41 | Expert opinion on rent adjustment | 9 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
103 | VIMI44 | OLD, replaced by VIMI54 for 3.0 | 2 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
104 | VIMI45 | OLD, replaced by VIMI55 for 3.0 | 2 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
105 | VIMI46 | OLD, replaced by VIMI56 for 3.0 | 2 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
106 | VIMIMV | Lease-Out | 57 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
107 | VIOB01 | Business entities | 33 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
108 | VIOB02 | Property master data | 39 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
109 | VIOB03 | Real estate building master | 43 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
110 | VIOB18 | Comparative apartments for rent adjustment, external accomm. | 19 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
111 | VIOB28 | OLD, replaced by VIOB39 for 3.0 | 2 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
112 | VIOB29 | OLD, replaced by VIOB39 for 3.0 | 2 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
113 | VITAXD | Tax Shares per Real Estate Account Assignment | 17 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
114 | VIVSTB | Document reference for input tax treatment | 31 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
115 | VIVW01 | Management contract: General data | 4 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
116 | VIVW03 | Management contract: Calculation forms with selections | 12 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
117 | VIVW05 | Management contract: Managed objects | 7 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
118 | VIVW07 | Allocation periods: Real estate obj. to management contract | 7 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
119 | VIVW08 | Events for management contracts | 15 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
120 | VIVW09 | Postings for management costs settlements | 25 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
121 | VIZNRN | Assignment: Real Estate numbers <-> IMKEY <-> INTRENO | 2 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
122 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 209 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
TOPRepetitive Manufacturing |
123 | COMPMOVE | Goods Movement of Components | 125 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
TOPSelf-Service Procurement |
124 | /SRMERP/D_ACC_IT | Account assignment item | 29 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
TOPService Charge Settlement |
125 | VISCSU | Settlement unit | 8 | IMKEY | Internal Key of Real Estate Object (FI) | nvarchar | 8 | 0 | | |
TOPSimulation |
126 | VSEBKN_CN | Version: Purchase requisition account assignment | 33 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |
TOPTechnical Application Support |
127 | CNV_20425_SCA | EMU conversion: Table of the clearings to be adjusted | 31 | IMKEY | Internal Key for Real Estate Object | nvarchar | 8 | 0 | | |