| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /BIC/B0000165000 | PSA for 0FI_AP_4 T90CLNT090 FI-AP: Items Delta | 67 | UMSKS | | nvarchar | 1 | 0 | | |
| 2 | /BIC/B0000166000 | PSA for 0FI_AR_4 T90CLNT090 FI-AR Items Delta | 67 | UMSKS | | nvarchar | 1 | 0 | | |
| 3 | /BIC/B0000168000 | PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items | 50 | UMSKS | | nvarchar | 1 | 0 | | |
| 4 | /BIC/B0000169000 | PSA for 0FI_GL_41 T90CLNT090 Documents, Compact | 50 | UMSKS | | nvarchar | 1 | 0 | | |
| 5 | /BIC/B0000172000 | PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items | 58 | UMSKS | | nvarchar | 1 | 0 | | |
| 6 | /CEECV/BVFI_PVN | Documents for VAT Declaration | 27 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 7 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 4 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 8 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 4 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 9 | BSEG | Accounting Document Segment | 13 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 10 | BSID_BAK | Accounting: Secondary Index for Customers | 4 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 11 | BSIK_BAK | Accounting: Secondary index for vendors | 4 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 12 | BSSEG | Accounting Document Segment | 13 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 13 | CNVTDMS_05_BSAD | Header table for BSAD | 5 | UMSKS | AKTBO for CNVTDMS_05_CE | nvarchar | 1 | 0 | | |
| 14 | CNVTDMS_05_BSAD1 | Header table for BSAD | 5 | UMSKS | AKTBO for CNVTDMS_05_CE | nvarchar | 1 | 0 | | |
| 15 | CNVTDMS_05_BSAK | Header table for BSAK | 5 | UMSKS | AKTBO for CNVTDMS_05_CE | nvarchar | 1 | 0 | | |
| 16 | CNVTDMS_05_BSAK1 | Header table for BSAK | 5 | UMSKS | AKTBO for CNVTDMS_05_CE | nvarchar | 1 | 0 | | |
| 17 | FIEUD_FIDOC_I | SAFT: FI Transaction Document Item | 63 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 18 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 13 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 19 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 13 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 20 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 13 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 21 | GLPOS_C_CT | FI Document: Entry View | 246 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 22 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 246 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 23 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 246 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 24 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 246 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 25 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 255 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 26 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 255 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 27 | MHND | Dunning Data | 37 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 28 | REGUP | Processed items from payment program | 29 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 29 | T074A | Special G/L Transaction Type Names | 3 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 30 | TFB06 | Financial Transaction Reporting | 5 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| TOPBasic Functions |
| 31 | BSIW | Index table for customer bills of exchange used | 11 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 32 | BSIX | Index table for customer bills of exchange used | 11 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| TOPCross-Application Components |
| 33 | BBSID | Accounting: Secondary index for customers | 4 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| TOPFinancial Accounting |
| 34 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 4 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 35 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 4 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 36 | BSID | Accounting: Secondary Index for Customers | 4 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 37 | BSIK | Accounting: Secondary Index for Vendors | 4 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 38 | T074U | Special G/L Indicator Properties | 4 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 39 | TBAER | Rules for Changing Documents | 3 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 40 | TMODU | Cross Reference Field Name - MODIF1 | 6 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 41 | VBSEGD | Document Segment for Customer Document Parking | 10 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 42 | VBSEGK | Document Segment for Vendor Document Parking | 10 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| TOPFunds Management-Specific Postings |
| 43 | PAYAC10 | Posting Key per DR/CR Indicator | 3 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 44 | PSOSEGD | Document Segment: Recurring Request, Customer | 11 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 45 | PSOSEGK | Recurring Request Document Segment, Vendors | 11 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| TOPGeneral Ledger Reorganization |
| 46 | FAGL_R_APAR | Reorganization: Object List for Receivables and Payables | 22 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| TOPInformation System |
| 47 | BWPOS | Valuations for Open Items | 31 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 48 | DKKOP | Balance Audit Trail | 8 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 49 | DKOKP | Open Item Account Balance Audit Trail | 9 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 50 | DSKOP | Balance Audit Trail | 8 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| TOPLocal Currency Changeover |
| 51 | EWUFI_SCA | EMU conversion: Table of the clearings to be adjusted | 37 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 52 | EWUFI_SOP | EMU conversion: Table for open items total | 10 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| TOPLocalization |
| 53 | J_3RFTAX_EXTRD | Tax Extract Detail Lines | 60 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 54 | RFITEMAP_NO_ITEM | Item wise detail for the Vendor Transactions | 59 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 55 | RFITEMAR_NO_ITEM | Item wise detail for the Customer Transactions | 59 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 56 | RFITEMGL_NO_ITEM | Item wise detail for the GL Account Transactions | 59 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| TOPPegging, Grouping, and Distribution |
| 57 | TBLP_MODU | Cross Reference Field Name - MODIF1 | 6 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| TOPReal Estate Management |
| 58 | VIMIIP | Invoice Items | 9 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| TOPRemaining Beverage - Obsolete Objects |
| 59 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 15 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| TOPTechnical Application Support |
| 60 | CNV_20425_SCA | EMU conversion: Table of the clearings to be adjusted | 34 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
| 61 | CNV_20425_SOP | EMU conversion: Table for open items total | 9 | UMSKS | Special G/L Transaction Type | nvarchar | 1 | 0 | | |
