| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BI0/SFISCYEAR | Master Data IDs: InfoObject Fiscal year | 2 | FISCYEAR | Fiscal year | nvarchar | 4 | 0 | | |
2 | /BIC/B0000219000 | PSA for 0CO_OM_OPA_3 T90CLNT090 Orders: Total plan | 6 | FISCYEAR | | nvarchar | 4 | 0 | | |
3 | /BIC/B0000221000 | PSA for 0CO_OM_OPA_2 T90CLNT090 Orders: Budget | 6 | FISCYEAR | | nvarchar | 4 | 0 | | |
4 | /SMD/MD_____001Z | SID-Tabelle fuer FISCYEAR | 3 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
5 | FMBCS_FMBL_CD | Empty table for change documents on FMBL incl. local. fields | 9 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
6 | RSR_TIME_REL_FIS | Time Relations for Planning | 5 | FISCYEAR | | nvarchar | 4 | 0 | | |
TOPAccounting Engine |
7 | /EACC/T_MSG_CTXT | Reduced Persistent View of Message Context Objects | 8 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
TOPBudgeting |
8 | FMBL | Funds management budget document lines (entry documents) | 9 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
9 | FMBS_BO | Budget Addresses | 4 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
10 | FMBS_CONTROL | Budget structure settings on FM area and fiscal year level | 3 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
11 | FMBS_CONTROL_LDR | BS settings FM area, fisc. year and posting ledger | 3 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
12 | FMBS_VERS_ASS | Budget Addresses settings on the version level | 3 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
13 | FMBUDTXT | Budget texts register | 8 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
14 | FMBUMANAGER | Management of budgeting enironment in FM | 3 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
15 | FMBUSTATUS | Status and budget addresses settings on the version level | 3 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
16 | FMCC_CUST_LIB | FM - Consistency checks - Assignment of libraries | 4 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
17 | FMCECGADDRS | Cover Groups: Assigned Budget Addresses | 3 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
18 | FMCECVGRP | Cover Groups | 3 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
19 | FMCECVGRPT | Texts for Cover Groups | 3 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
20 | FMDISTA | Distribution Activation | 4 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
21 | FMHBL | Funds management budget document lines (held documents) | 9 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
22 | FMHIEHEADERS | Hierarchy Nodes: Constant Parts ("Headers") | 3 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
23 | FMHIEIDS | Hierarchy IDs | 3 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
24 | FMHIEIDST | Texts for Hierarchy IDs | 3 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
25 | FMHIENODES | Hierarchy Nodes (Without Constant Part) | 3 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
26 | FMHIE_CHGCHK_FLG | Activate Checks for Hierarchy Change | 4 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
27 | FMKF_TERM | Key Figures - FM Terms | 12 | FISCYEAR | Key Figures - Fiscal Year | nvarchar | 4 | 0 | | |
28 | FMKF_TERM_AVC | Key Figures - FM AVC Term | 10 | FISCYEAR | Key Figures - Fiscal Year | nvarchar | 4 | 0 | | |
29 | FMKF_TERM_RB | Key Figures - FM Terms | 11 | FISCYEAR | Key Figures - Fiscal Year | nvarchar | 4 | 0 | | |
30 | FMMACGPERC | Percentage per cover group (Multi-annual budgeting) | 3 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
31 | FMMIGDOC | Migrated Documents | 7 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
32 | FMMIGOV | Overview of Migration Status | 6 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
33 | FMMIGPAR | Partially Migrated Documents | 7 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
34 | FMOPENPER | Control Budgeting Periods | 5 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
35 | FMOPENPER_FUND | Control Budgeting Periods per Fund | 5 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
36 | FMPEPLAY_COL | FMPEP: layout customizing settings for columns | 8 | FISCYEAR | FMPEP - Fiscal Year | nvarchar | 4 | 0 | | |
37 | FMPEP_VARIANTH | Session variants (header part) for transaction FMPEP | 6 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
38 | FMPEP_VARIANTL | Session variants (line part) for transaction FMPEP | 8 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
39 | FMRBBOBJECTS | Master Data For Revenue Increasing the Budget: RIB Objects | 3 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
40 | FMRBBRECS | Master Data For RIB: Budget Receivers per RIB Object | 3 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
TOPBudgeting and Availability Control |
41 | GMFMRECS | GM RIB: FM Receivers (obsolete) | 7 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
42 | GMFMRECS1 | GM RIB: FM Budget Receivers | 4 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
43 | GMRBFMREC | GM RIB: FM Budget Receivers | 5 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
TOPBusiness Consolidation |
44 | UCF9030 | Balance Carryforward: Restatement Assignment | 5 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
45 | UCST001 | SEM-BCS: Performance Statistics | 14 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
46 | UCT9100 | Workflow Documents: Status | 4 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
47 | UCT910C | Workflow Documents, Held Documents, Reference Documents | 7 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
48 | UCT9110 | Workflow Documents: Approval Actions | 4 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
49 | UCT9190 | Log for Methods Calling of BAdI UC_WFV_DOC | 4 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
TOPData Basis |
50 | RSR_REL_TIME_FIS | Time Relations for Planning | 4 | FISCYEAR | | nvarchar | 4 | 0 | | |
TOPFlexible Real Estate Management |
51 | TIVXCITCALCDBUD | ICI Calculation coefficient for D-Building | 2 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
TOPFund Accounting |
52 | FMCCAVCRESERVE | CCAVC aux table for reserved items | 13 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
TOPLocalization |
53 | TIVXCPTPOSTPAR | Technical Parameters for Postings and Payments (obsolate) | 2 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
54 | VIXCFRAPLOG | Log of Calculation of Complementary Budget Amounts | 3 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
TOPPortfolio Management |
55 | RPM_FIDATA | Financial Information | 7 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
56 | RPM_PROJECT_CO | Controlling Information about a project | 6 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
57 | RPM_SCENARIO_FIN | RPM : Scenario financial data | 4 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |
TOPPosition Budgeting and Control |
58 | HRFPM_BPREP_DATA | Preprocesses Data for BPREP Data Extraction | 6 | FISCYEAR | Fiscal Year | nvarchar | 4 | 0 | | |