| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OPT/AT_APPR_HIS | Approval History for Level Based Approvals | 30 | FUND | Fund | nvarchar | 10 | 0 | | |
2 | /OPT/AT_LBA_LOG | Approval History for Level Based Approvals | 31 | FUND | Fund | nvarchar | 10 | 0 | | |
3 | /SAPPSSRM/SPFSET | Selective Release - Blocking Options by Account | 4 | FUND | Fund | nvarchar | 10 | 0 | | |
4 | /SAPPSSRM/TGMACC | IBU PS: link table between Contract data and earmarked funds | 11 | FUND | Fund | nvarchar | 10 | 0 | | |
5 | BBP_FUND_FAV | User-Specific Favorites for Permitted Funds | 4 | FUND | Fund | nvarchar | 10 | 0 | | |
6 | BBP_PCACC | Procurement Card: Accounting Data | 28 | FUND | Fund | nvarchar | 10 | 0 | | |
7 | BBP_PCMOD | Procurement Card: Modified Statement Data | 30 | FUND | Fund | nvarchar | 10 | 0 | | |
8 | BBP_PDACC | Account Assignment | 32 | FUND | Fund | nvarchar | 10 | 0 | | |
9 | BCKTRDT_MULTASSG | Multiple Account Assignment of Flows | 6 | FUND | Fund | nvarchar | 10 | 0 | | |
10 | FMBASOBJNR_TRACE | Trace for table FMBASOBJNR | 4 | FUND | Fund | nvarchar | 10 | 0 | | |
11 | FMBCS_FMBL_CD | Empty table for change documents on FMBL incl. local. fields | 11 | FUND | Fund | nvarchar | 10 | 0 | | |
12 | REQACCT | Account Assignment for the Req. Coverage Request Lines | 36 | FUND | Fund | nvarchar | 10 | 0 | | |
13 | ZCATSDB | Records changed with processing status '10' | 22 | FUND | | nvarchar | 10 | 0 | | |
14 | ZCATSDB2 | Records changed with processing status '10' | 23 | FUND | | nvarchar | 10 | 0 | | |
TOPAvailability Control |
15 | FMAVCO | Object table 1 | 8 | FUND | Fund | nvarchar | 10 | 0 | | |
TOPBack Office |
16 | TRET_END2POOL | Pools Permitted for Each Endowment | 3 | FUND | Fund | nvarchar | 10 | 0 | | |
17 | TRET_ENDOWMENT | Additional Fund/Grant Data for Endowments | 3 | FUND | Fund | nvarchar | 10 | 0 | | |
18 | TRET_POOL | Additional Pool Data for Fund | 3 | FUND | Fund | nvarchar | 10 | 0 | | |
19 | TRET_SEC_POOL | Additional Pool Data for Security | 4 | FUND | Fund | nvarchar | 10 | 0 | | |
20 | TRST_CLASFLO | CFM: Class Flows in Securities Account | 9 | FUND | Fund | nvarchar | 10 | 0 | | |
21 | TRST_CLASFLO_REV | CFM: Reversed Class Flows in Securities Account | 9 | FUND | Fund | nvarchar | 10 | 0 | | |
22 | TRST_CLASPOS | Treasury: Class position in Securities Account | 8 | FUND | Fund | nvarchar | 10 | 0 | | |
TOPBasis Components |
23 | /XFT/INV_Q_11 | Account assignment data | 27 | FUND | Fund | nvarchar | 10 | 0 | | |
24 | /XFT/INV_Q_11_S | Account assignment data | 27 | FUND | Fund | nvarchar | 10 | 0 | | |
TOPBudget Control System |
25 | FMBASOBJNR | Object numbers for FM addresses | 6 | FUND | Fund | nvarchar | 10 | 0 | | |
TOPBudgeting |
26 | BUCC_RULE | Consistency Checks - Rules | 13 | FUND | Key Figures - Fund aggregation | nvarchar | 1 | 0 | | |
27 | FMBDO | Object table 1 - Budget address | 8 | FUND | Fund | nvarchar | 10 | 0 | | |
28 | FMBL | Funds management budget document lines (entry documents) | 11 | FUND | Fund | nvarchar | 10 | 0 | | |
29 | FMBUMANAGER | Management of budgeting enironment in FM | 6 | FUND | Fund | nvarchar | 10 | 0 | | |
30 | FMCONSUM_FUND | Consumable budget type for Fund | 3 | FUND | Fund | nvarchar | 10 | 0 | | |
31 | FMHBL | Funds management budget document lines (held documents) | 11 | FUND | Fund | nvarchar | 10 | 0 | | |
32 | FMMIGOV | Overview of Migration Status | 3 | FUND | Fund | nvarchar | 10 | 0 | | |
33 | FMMIGPAR | Partially Migrated Documents | 8 | FUND | Fund | nvarchar | 10 | 0 | | |
34 | FMOPENPER_FUND | Control Budgeting Periods per Fund | 6 | FUND | Fund | nvarchar | 10 | 0 | | |
35 | FMPEP_VARIANTL | Session variants (line part) for transaction FMPEP | 11 | FUND | Fund | nvarchar | 10 | 0 | | |
36 | FMRBO | Object table 1 | 8 | FUND | Fund | nvarchar | 10 | 0 | | |
37 | FMREL_FUND | Release settings for Fund | 3 | FUND | Fund | nvarchar | 10 | 0 | | |
38 | FMROLLUP_FUND | Preclosing Rollup: Transfer Rules for Fund | 3 | FUND | Fund | nvarchar | 10 | 0 | | |
TOPBudgeting and Availability Control |
39 | GMBASOBJNR | Object numbers of GM addresses | 7 | FUND | Fund | nvarchar | 10 | 0 | | |
40 | GMBDGTFYDLINE | GM Budgeting Fiscal Year Distribution Lines | 11 | FUND | Fund | nvarchar | 10 | 0 | | |
41 | GMBDGTLINE | Budget Document Line | 10 | FUND | Fund | nvarchar | 10 | 0 | | |
42 | GMFMRECS | GM RIB: FM Receivers (obsolete) | 3 | FUND | Fund | nvarchar | 10 | 0 | | |
43 | GMHBDGTFYDLINE | GM Budgeting Fiscal Year Distribution Lines | 12 | FUND | Fund | nvarchar | 10 | 0 | | |
44 | GMHBDGTLINE | Budget Line: Held Documents | 11 | FUND | Fund | nvarchar | 10 | 0 | | |
TOPCost Element Accounting |
45 | COFIO1 | Object Table for Reconciliation Ledger COFIT | 14 | FUND | Fund | nvarchar | 10 | 0 | | |
TOPESS Based on WD ABAP |
46 | HRESS_D_CATS_FAV | CATS Favorites: database table | 29 | FUND | Receiver fund | nvarchar | 10 | 0 | | |
TOPFunctions for U.S. Federal Government |
47 | FMFGYECLAA | US Federal Gov't : Y/E Pre-Closing of Anticipated Accounts | 3 | FUND | Fund | nvarchar | 10 | 0 | | |
TOPFund Accounting |
48 | FMCCAVCO | Object table 1 | 9 | FUND | Fund | nvarchar | 10 | 0 | | |
49 | FMCCAVCRESERVE | CCAVC aux table for reserved items | 8 | FUND | Fund | nvarchar | 10 | 0 | | |
50 | FMCCBASOBJNR | Object numbers for CC addresses | 7 | FUND | Fund | nvarchar | 10 | 0 | | |
TOPFunds Management |
51 | FMBPCLOSE_FUND | Preclosing Rollup: Transfer Rules for Fund | 3 | FUND | Fund | nvarchar | 10 | 0 | | |
52 | FMBUDACL | Rules for Closing Residual Ledger Accounts | 6 | FUND | Sender fund | nvarchar | 10 | 0 | | |
53 | FMFG_YBA_AVC | FMFG: Year of Budget Authority - AVC | 7 | FUND | Fund | nvarchar | 10 | 0 | | |
54 | FMSPLITO | Object table 1 | 14 | FUND | Fund | nvarchar | 10 | 0 | | |
55 | FMUSFGFACTS1O | Object table 1 | 9 | FUND | Fund | nvarchar | 10 | 0 | | |
56 | FMUSFGFACTS2O | Object table 1 | 9 | FUND | Fund | nvarchar | 10 | 0 | | |
57 | FMUSFGO | Object table 1 for US Federal Government | 14 | FUND | Fund | nvarchar | 10 | 0 | | |
58 | FUMA_EVENT | Fund Management Events | 6 | FUND | Fund | nvarchar | 10 | 0 | | |
59 | IAOM_GTR_EXAT | Grantor: Account Assignment Manager External Characteristics | 6 | FUND | Fund | nvarchar | 10 | 0 | | |
60 | TBPAS_FUND | Budget Subtypes for Availability Control Per Fund | 4 | FUND | Fund | nvarchar | 10 | 0 | | |
TOPFunds Management-Specific Postings |
61 | FMCJ | IS-PS: Documents in Cash Desk Subsidiary Ledger | 20 | FUND | Fund | nvarchar | 10 | 0 | | |
TOPGrantee Management |
62 | GMAVCO | Object table 1 | 9 | FUND | Fund | nvarchar | 10 | 0 | | |
63 | GMIO | Object table GMIO | 12 | FUND | Fund | nvarchar | 10 | 0 | | |
TOPIncentive and Commission Management ICM |
64 | CACSHR_DOCHR_PD | Settlement to PY: Reference Line Item | 19 | FUND | Fund | nvarchar | 10 | 0 | | |
65 | YCRM01_ACCAS | Account Assignment Type/Cost Information for Remuneration | 25 | FUND | Fund | nvarchar | 10 | 0 | | |
66 | YTEL01_ACCAS | Account Assignment Type/Cost Information for Remuneration | 32 | FUND | Fund | nvarchar | 10 | 0 | | |
TOPInformation System |
67 | FTI_BI_REP_ODS | Reparation Records for Inconsistent Data in ODS 0CFM_O01 /BW | 31 | FUND | Fund | nvarchar | 10 | 0 | | |
TOPMaster Data |
68 | GMFUNDRECOVER_O | Fund recovery for outgoing grants | 5 | FUND | Fund | nvarchar | 10 | 0 | | |
69 | GMGFUND | Grant specific fund details | 4 | FUND | Fund | nvarchar | 10 | 0 | | |
70 | GMGRCOSTSHARE | Cost sharing master data | 4 | FUND | Fund | nvarchar | 10 | 0 | | |
71 | GMGRFUNDRECOVER | Fund recovery | 3 | FUND | Fund | nvarchar | 10 | 0 | | |
72 | GMGRSPONSOREDOBJ | Grant sponsored objects | 6 | FUND | Fund | nvarchar | 10 | 0 | | |
TOPRental Accounting |
73 | VIEXCFCNDNS | Cash Flow Summarization | 26 | FUND | Fund | nvarchar | 24 | 0 | | |
74 | VIRADOCITEM | RE Document Item | 31 | FUND | Fund | nvarchar | 24 | 0 | | |
75 | VITMOA | Term: Organizational Assignment | 11 | FUND | Fund | nvarchar | 24 | 0 | | |
TOPRevenues and Earnings |
76 | AD01DLI | Dynamic items (DI) | 53 | FUND | Fund | nvarchar | 10 | 0 | | |
TOPTime Sheet |
77 | CATSCO | Cross-Application Time Sheet (CATS): Transfer to CO | 37 | FUND | Receiver fund | nvarchar | 10 | 0 | | |
78 | CATSDB | CATS: Database Table for Time Sheet | 22 | FUND | Receiver fund | nvarchar | 10 | 0 | | |
79 | CATS_TEMP | CATS: Database Table for Templates | 24 | FUND | Receiver fund | nvarchar | 10 | 0 | | |
TOPTransaction Manager |
80 | DIFT_POS_IDENT | Persistent Flow Selectors | 22 | FUND | Fund | nvarchar | 10 | 0 | | |
81 | FDC1 | Cash Management Shadow table | 18 | FUND | Fund | nvarchar | 10 | 0 | | |
82 | IDCFM_DATA_SEC | Valuation-Area-Independent Data for Securities | 9 | FUND | Fund | nvarchar | 10 | 0 | | |
83 | IDCFM_FRIM_DATA | Impairment Main Data | 14 | FUND | Fund | nvarchar | 10 | 0 | | |
84 | IDCFM_FRIM_DEXP | Impairment: BAdI Example Values: Expected & Expert Values | 14 | FUND | Fund | nvarchar | 10 | 0 | | |
85 | POGT_POS_GUARD | Lock Objects | 36 | FUND | Fund | nvarchar | 10 | 0 | | |
86 | SLDT_FLOW | Subledger Distributor Transactions | 21 | FUND | Fund | nvarchar | 10 | 0 | | |
87 | TRCT_FLOW | Table of business transactions flows | 11 | FUND | Fund | nvarchar | 10 | 0 | | |
88 | TRDTT_DATA_ADMIN | Legacy Data Transfer Admin. Entries Business Transactions | 12 | FUND | Fund | nvarchar | 10 | 0 | | |
89 | TRDTT_DATA_SEC | Valuation-Area-Independent Data for Securities | 8 | FUND | Fund | nvarchar | 10 | 0 | | |
90 | TRDTT_IGTDATA_SE | Intragroup Transaction (IGT) Data for Securities | 9 | FUND | Fund | nvarchar | 10 | 0 | | |
91 | TRDTT_POS_ADMIN | Legacy Data Transfer Admin. Entries Subledger Positions | 10 | FUND | Fund | nvarchar | 10 | 0 | | |
92 | TRDTT_POS_SEC | Position Information for Securities | 8 | FUND | Fund | nvarchar | 10 | 0 | | |
93 | TRDTT_VADATA_FUT | Valuation-Area-Dependent Data for Futures | 9 | FUND | Fund | nvarchar | 10 | 0 | | |
94 | TRDTT_VADATA_OTC | Valuation-Area-Dependent Data for MM, FX, OTC Derivatives. | 7 | FUND | Fund | nvarchar | 10 | 0 | | |
95 | TRDTT_VADATA_SEC | Valuation-Area-Dependent Data for Securities | 9 | FUND | Fund | nvarchar | 10 | 0 | | |
96 | TRDT_FLOW | Persistent distributor flows | 22 | FUND | Fund | nvarchar | 10 | 0 | | |
97 | TRDT_MULTASSGN | Multiple Account Assignment of Flows | 5 | FUND | Fund | nvarchar | 10 | 0 | | |
98 | TRGT_MIGPS_OTC | Assignment of PS Account Assignments to Transactions | 4 | FUND | Fund | nvarchar | 10 | 0 | | |
99 | TRGT_MIGPS_SEC | Assignment of PS Account Assignments to Securities Positions | 7 | FUND | Fund | nvarchar | 10 | 0 | | |
100 | TRLT_VCL_FLOW | Flows Valuation Class Transfer | 24 | FUND | Fund | nvarchar | 10 | 0 | | |
101 | VTBFASGT | Account Assignment of a Financial Transaction Flow | 4 | FUND | Fund | nvarchar | 10 | 0 | | |
102 | VTBFATIT | Acct Assmt Templates for PS Mult. Acct Assmts: Line Info. | 5 | FUND | Fund | nvarchar | 10 | 0 | | |
103 | VTBFHA | Transaction | 56 | FUND | Fund | nvarchar | 10 | 0 | | |
TOPTransfer to Financial Accounting |
104 | TLVT_MANUAL_VAL | Book Values for Manual Valuation of Positions | 13 | FUND | Fund | nvarchar | 10 | 0 | | |
105 | TRLT_INIT_IGT_SE | Initialization Values for Intragroup Transactions | 12 | FUND | Fund | nvarchar | 10 | 0 | | |
106 | TRLT_INIT_VAL_FU | Initialization Values for TRL Futures Positions | 9 | FUND | Fund | nvarchar | 10 | 0 | | |
107 | TRLT_INIT_VAL_SE | Initialization Values for TRL Positions: Securities | 12 | FUND | Fund | nvarchar | 10 | 0 | | |
108 | VALT_SP_VAL_SEC | Security Prices and NPV for Special Valuation | 14 | FUND | Fund | nvarchar | 10 | 0 | | |
TOPTravel Expenses |
109 | PTRV_COMM_ITM | Header Data: Transfer to FM When Trip Saved | 22 | FUND | Fund | nvarchar | 10 | 0 | | |
110 | PTRV_SCOS | Trip Statistics - Cost Assignment | 20 | FUND | Fund | nvarchar | 10 | 0 | | |