| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /BIC/B0000168000 | PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items | 59 | VERTT | | nvarchar | 1 | 0 | | |
| 2 | /BIC/B0000169000 | PSA for 0FI_GL_41 T90CLNT090 Documents, Compact | 59 | VERTT | | nvarchar | 1 | 0 | | |
| 3 | /BIC/B0000172000 | PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items | 67 | VERTT | | nvarchar | 1 | 0 | | |
| 4 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 91 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 5 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 158 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 6 | BSEG | Accounting Document Segment | 213 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 7 | BSID_BAK | Accounting: Secondary Index for Customers | 91 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 8 | BSIK_BAK | Accounting: Secondary index for vendors | 158 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 9 | BSSEG | Accounting Document Segment | 202 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 10 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 202 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 11 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 202 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 12 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 202 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 13 | GLPOS_C_CT | FI Document: Entry View | 258 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 14 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 258 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 15 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 258 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 16 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 258 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 17 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 267 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 18 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 267 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 19 | MHND | Dunning Data | 56 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 20 | REGUP | Processed items from payment program | 151 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| TOPAccounting Interface |
| 21 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 331 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 22 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 331 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| TOPBasic Functions |
| 23 | FEBEP | Electronic Bank Statement Line Items | 46 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| TOPBilling |
| 24 | VBRP | Billing Document: Item Data | 169 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| TOPConditions |
| 25 | KONP | Conditions (Item) | 55 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| TOPContract Accounts Receivable and Payable |
| 26 | FKKBEP | Electronic Bank Statement Line Items | 46 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| TOPCross-Application Components |
| 27 | BBSID | Accounting: Secondary index for customers | 91 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| TOPData Retention Tool |
| 28 | TXW_S_BSEG | Retrieve BSEG from archive | 99 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| TOPDunning |
| 29 | MHNK | Dunning data (account entries) | 35 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 30 | MHNKO | Dunning data (acct entries) version before the next change | 35 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| TOPFinancial Accounting |
| 31 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 91 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 32 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 158 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 33 | BSID | Accounting: Secondary Index for Customers | 91 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 34 | BSIK | Accounting: Secondary Index for Vendors | 158 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 35 | VBSEGD | Document Segment for Customer Document Parking | 82 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 36 | VBSEGK | Document Segment for Vendor Document Parking | 95 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 37 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 70 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| TOPFunds Management-Specific Postings |
| 38 | FMFUNDTRANSYEAR | Additional Documents for Funds Transfer to Diff. Years | 69 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 39 | PSOSEGD | Document Segment: Recurring Request, Customer | 83 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 40 | PSOSEGK | Recurring Request Document Segment, Vendors | 96 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 41 | PSOSEGS | Recurring Request Document Segment, G/L Accounts | 68 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| TOPLoans Management |
| 42 | LOANREF_O | Records of Loan Reference Unit for Open Items | 7 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 43 | LOANREF_OS | Saved Ref. Records Open Items per Business Operation No. | 8 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 44 | MZDAT | Dunning and interest data for batch input | 7 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 45 | VDZNB_PAYINFO | Payment Postprocessing: Payment Inform. for a PPP Activity | 38 | VERTT | Contract Number | nvarchar | 13 | 0 | | |
| TOPLocalization |
| 46 | J_3RFTAX_EXTRD | Tax Extract Detail Lines | 69 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 47 | RFITEMAP_NO_ITEM | Item wise detail for the Vendor Transactions | 68 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 48 | RFITEMAR_NO_ITEM | Item wise detail for the Customer Transactions | 68 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 49 | RFITEMGL_NO_ITEM | Item wise detail for the GL Account Transactions | 68 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| TOPReal Estate Management |
| 50 | VIAKBSEG | Document Line Item from SCS for Interface | 108 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 51 | VIMIIP | Invoice Items | 16 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 52 | VIMIRA | Instalments for Lease-Out | 10 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| TOPRemaining Beverage - Obsolete Objects |
| 53 | /BEV1/BO_CONT | Contract Data for Rebate Agreements | 3 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 54 | /BEV1/RBKP | Copy Table for KONP for Accrual (Field KBRUE) | 55 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 55 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 204 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 56 | /BEV3/CHCEV1030X | CH BTE Allowed 00001030 Data | 4 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 57 | /BEV3/CHCEV103X | CH BTE Permissible Events Res. frm Combination CHD/1030 Data | 6 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| 58 | /BEV3/CHCEVLCAC | CH BTE Customizing Event Listener ACCOUNT | 5 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
| TOPRental Accounting |
| 59 | VIRALSRHD | Statistics - Returned Debit Memos in RE: Header Data | 12 | VERTT | Contract Type | nvarchar | 1 | 0 | | |
