| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | BBP_PCGEN | Procurement Card Statements: General Data | 3 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| 2 | BBP_PCLOG | Procurement Card Statement: Logistic data | 3 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| 3 | BBP_PCMOD | Procurement Card: Modified Statement Data | 3 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| 4 | BBP_PCPOS | Procurement Card Statement: Position Data | 3 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| 5 | BBP_PCTAX | Procurement Card: Tax Data | 3 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| 6 | BBP_PCTOT | Procurement Card: Total Invoice Data | 3 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| 7 | EWA_WA_WEIGHPC_B | Information Relevant for Payment Process | 7 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| TOPActual Update and Commitment Update |
| 8 | GTR_TRSLR_SUBKEY | Grantor Translator - Subkey | 5 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| TOPBudgeting |
| 9 | FMCCFBDGT_CUST | Customizing settings: creation of budget during ccf | 3 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| TOPData Retention Tool |
| 10 | TXW_DIR | Data file log (replaced by txw_dir2, use of guids) | 6 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| 11 | TXW_DIR2 | Data file log | 8 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| 12 | TXW_DIRAL | Data file log - ArchiveLink (obsolete after rel 99) | 4 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| 13 | TXW_DIRAL2 | Data file log - ArchiveLink | 5 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| 14 | TXW_VWLOG | View query log (replaced by txw_vwlog2: uuids) | 2 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| 15 | TXW_VWLOG2 | View query log | 4 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| TOPDepreciation Simulation |
| 16 | IMCKF | IM Summarization: Key figures | 7 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| TOPDown Payment Chains |
| 17 | /SAPPCE/TDPC20 | Down Payment Chain: Document Header | 12 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| TOPDownloadUpload |
| 18 | /DSD/HH_RACL | DSD Route Settlement: Clearing | 6 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| 19 | /DSD/HH_RAEC | DSD Route Settlement: Receipts/Expenditures | 17 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| TOPDSD Connector |
| 20 | /DSD/ME_CLR_HD | DSD CN: Clearing header data | 10 | FISC_YEAR | DSD Connector: Fiscal year | nvarchar | 4 | 0 | | |
| TOPFlexible Real Estate Management |
| 21 | VICAPROCESSID | Process | 5 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| TOPFunctions for U.S. Federal Government |
| 22 | FMFG_BL_YRCL | Customizing Budgetary Ledger Year End closing | 3 | FISC_YEAR | Fiscal year with star character allowed | nvarchar | 4 | 0 | | |
| 23 | FMFG_BL_YRCL_TOP | Customizing Budgetary Ledger Year End Multiple Closing Rules | 3 | FISC_YEAR | Fiscal year with star character allowed | nvarchar | 4 | 0 | | |
| 24 | FMFG_BL_YRCL_TXT | Multiple Closing Rule Texts | 4 | FISC_YEAR | Fiscal year with star character allowed | nvarchar | 4 | 0 | | |
| TOPFunds Management |
| 25 | FMBUDACL | Rules for Closing Residual Ledger Accounts | 4 | FISC_YEAR | From year | nvarchar | 4 | 0 | | |
| 26 | FMBUDBCS | Budgetary ledger account derivation: BCS | 5 | FISC_YEAR | From year | nvarchar | 4 | 0 | | |
| 27 | FMBUDDIS | Budgetary ledger account derivation: Budgeting (old) | 5 | FISC_YEAR | From year | nvarchar | 4 | 0 | | |
| 28 | FMBUDRES | Budgetary ledger account derivation: Revenue/Statistical | 5 | FISC_YEAR | From year | nvarchar | 4 | 0 | | |
| 29 | FMBUDREV | Revenue/Statistical Postings & Open items/actuals Resource | 5 | FISC_YEAR | From year | nvarchar | 4 | 0 | | |
| 30 | FMBUDSTA | Budgetary ledger account derivation: Open items/Actuals bdgt | 5 | FISC_YEAR | From year | nvarchar | 4 | 0 | | |
| 31 | FMFG_HEAD_INV | Header Data for Improper Invoices | 3 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| 32 | FMIUR | Open Interval Rules for updating FM | 5 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| 33 | IAOM_GTR_EXAT | Grantor: Account Assignment Manager External Characteristics | 20 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| 34 | TBPBWRET20 | FM Plan Data Transfer Header Transfer | 5 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| TOPGL Account Posting |
| 35 | TCJ_CHECK_STACKS | Check Lists in Cash Journal | 4 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| 36 | TCJ_CPD | FBCJ: One-Time Account Data of Cash Journal Document Items | 4 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| 37 | TCJ_DOCUMENTS | Cash Journal Documents (Header Data) | 4 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| 38 | TCJ_POSITIONS | Cash Journal Document Items | 4 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| 39 | TCJ_WTAX_ITEMS | Withholding Tax Items for Cash Journal Document Items | 4 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| TOPIncentive and Commission Management ICM |
| 40 | CACSFI_DOCFI_HD | Settlement to FI: Reference Document Header | 9 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| TOPLocalization |
| 41 | J_1BECD_HISTORY | Electronic-Accounting-File History | 7 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| 42 | VIXCFRPROCID | Localized Process | 4 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| 43 | VIXCPTSIPT | Digital Signature for Invoices | 5 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| TOPRental Accounting |
| 44 | VIRADOC | RE Document Header | 7 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| 45 | VIRAINV | RE Invoice Header | 5 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| TOPSAP Retail Store |
| 46 | WSTI_DB_TMP_HEAD | SAP Retail Store temporay persistence header table | 4 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| 47 | WSTI_DB_TMP_ITEM | SAP Retail Store temporary persistence item table | 6 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
| TOPUS Prompt Payment Act |
| 48 | FMFG_REASONS | Reason Codes for Accounting Documents (Item Level) | 3 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
