| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | FMBCS_FMBL_CD | Empty table for change documents on FMBL incl. local. fields | 19 | BUDCAT | Budget Category | nvarchar | 2 | 0 | | |
TOPBudgeting |
2 | BUBUDCAT | List of budget category instances | 1 | BUDCAT | Budget Category | nvarchar | 2 | 0 | | |
3 | BUBUDCATT | Texts for Budget Categories | 1 | BUDCAT | Budget Category | nvarchar | 2 | 0 | | |
4 | BUWRTTP | Mapping rules for migration from FBS to BCS - Field WRTTP | 3 | BUDCAT | Budget Category | nvarchar | 2 | 0 | | |
5 | FMBL | Funds management budget document lines (entry documents) | 19 | BUDCAT | Budget Category | nvarchar | 2 | 0 | | |
6 | FMBS_BO | Budget Addresses | 5 | BUDCAT | Budget Category | nvarchar | 2 | 0 | | |
7 | FMBUDCAT | Budget category activation | 3 | BUDCAT | Budget Category | nvarchar | 2 | 0 | | |
8 | FMBUDTXT | Budget texts register | 4 | BUDCAT | Budget Category | nvarchar | 2 | 0 | | |
9 | FMBUMANAGER | Management of budgeting enironment in FM | 5 | BUDCAT | dummy budget category - always initial | nvarchar | 2 | 0 | | |
10 | FMBWUS | Budgeting Workbench User settings | 5 | BUDCAT | Budget Category | nvarchar | 2 | 0 | | |
11 | FMCECGADDRS | Cover Groups: Assigned Budget Addresses | 4 | BUDCAT | Budget Category | nvarchar | 2 | 0 | | |
12 | FMCECVGRP | Cover Groups | 4 | BUDCAT | Budget Category | nvarchar | 2 | 0 | | |
13 | FMCECVGRPT | Texts for Cover Groups | 4 | BUDCAT | Budget Category | nvarchar | 2 | 0 | | |
14 | FMCY_COPI | For CO plan data transfer | 11 | BUDCAT | Ledger | nvarchar | 2 | 0 | | |
15 | FMDISTA | Distribution Activation | 5 | BUDCAT | Budget Category | nvarchar | 2 | 0 | | |
16 | FMHBL | Funds management budget document lines (held documents) | 19 | BUDCAT | Budget Category | nvarchar | 2 | 0 | | |
17 | FMHIEHEADERS | Hierarchy Nodes: Constant Parts ("Headers") | 5 | BUDCAT | Budget Category | nvarchar | 2 | 0 | | |
18 | FMHIEIDS | Hierarchy IDs | 5 | BUDCAT | Budget Category | nvarchar | 2 | 0 | | |
19 | FMHIEIDST | Texts for Hierarchy IDs | 5 | BUDCAT | Budget Category | nvarchar | 2 | 0 | | |
20 | FMHIENODES | Hierarchy Nodes (Without Constant Part) | 5 | BUDCAT | Budget Category | nvarchar | 2 | 0 | | |
21 | FMHIE_CHGCHK_FLG | Activate Checks for Hierarchy Change | 5 | BUDCAT | Budget Category | nvarchar | 2 | 0 | | |
22 | FMKF_TERM | Key Figures - FM Terms | 7 | BUDCAT | Key Figures - Budget Category | nvarchar | 2 | 0 | | |
23 | FMMAACT | Activation of Multi-annual Budgeting | 3 | BUDCAT | Budget Category | nvarchar | 2 | 0 | | |
24 | FMMAPERC | Standard percentage set for multi-annual budgeting | 3 | BUDCAT | Budget Category | nvarchar | 2 | 0 | | |
25 | FMOPENPER | Control Budgeting Periods | 3 | BUDCAT | Budget Category | nvarchar | 2 | 0 | | |
26 | FMOPENPER_FUND | Control Budgeting Periods per Fund | 3 | BUDCAT | Budget Category | nvarchar | 2 | 0 | | |
27 | FMPEPLAY_COL | FMPEP: layout customizing settings for columns | 5 | BUDCAT | Budget Category | nvarchar | 2 | 0 | | |
28 | FMPEP_VARIANTL | Session variants (line part) for transaction FMPEP | 19 | BUDCAT | Budget Category | nvarchar | 2 | 0 | | |
29 | FMPTCOMBA | Allowed combinations (process / budget type) for status | 4 | BUDCAT | Budget Category | nvarchar | 2 | 0 | | |
30 | FMPTCOMBAG | Allowed combinations process / budget type group for status | 4 | BUDCAT | Budget Category | nvarchar | 2 | 0 | | |
TOPFunds Management |
31 | BPREP_HRFPM_BCS | Variants of Budget Creation for PBC | 5 | BUDCAT | Budget Category | nvarchar | 2 | 0 | | |
32 | FM2BLACT1 | FM2BL - Activate of FM area and FM Budget Category | 3 | BUDCAT | Budget Category | nvarchar | 2 | 0 | | |
33 | FM2BLACTB | FM2BL - Activation of Budget Value Types | 3 | BUDCAT | Budget Category | nvarchar | 2 | 0 | | |
34 | FM2BLACTC | FM2BL - Activation of Commitment/Actual Value Types | 3 | BUDCAT | Budget Category | nvarchar | 2 | 0 | | |
TOPPlant Maintenance |
35 | MCB_BUD | MCB Retraction data for Budget check | 4 | BUDCAT | Budget category for MCB Retraction data | nvarchar | 2 | 0 | | |