| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SAPPSSRM/SPCTR | Selective Release - Blocking Options for Funded Contracts | 3 | FUNDS_CTR | Indicator: Block All Funded Contracts | nvarchar | 1 | 0 | | |
2 | /SAPPSSRM/SPFSET | Selective Release - Blocking Options by Account | 5 | FUNDS_CTR | Funds Center | nvarchar | 16 | 0 | | |
3 | /SAPPSSRM/TGMACC | IBU PS: link table between Contract data and earmarked funds | 12 | FUNDS_CTR | Funds Center | nvarchar | 16 | 0 | | |
4 | BBP_PCACC | Procurement Card: Accounting Data | 27 | FUNDS_CTR | Funds Center | nvarchar | 16 | 0 | | |
5 | BBP_PCMOD | Procurement Card: Modified Statement Data | 29 | FUNDS_CTR | Funds Center | nvarchar | 16 | 0 | | |
6 | BBP_PDACC | Account Assignment | 31 | FUNDS_CTR | Funds Center | nvarchar | 16 | 0 | | |
7 | REQACCT | Account Assignment for the Req. Coverage Request Lines | 35 | FUNDS_CTR | Funds Center | nvarchar | 16 | 0 | | |
TOPAP-LIM Logistics Inventory Management Engine |
8 | /LIME/COLL_APS | Collection for Planning System | 102 | FUNDS_CTR | Funds Center | nvarchar | 16 | 0 | | |
9 | /LIME/COLL_BW | Collection for Business Warehouse | 102 | FUNDS_CTR | Funds Center | nvarchar | 16 | 0 | | |
10 | /LIME/COLL_FIN | Collection for Financial System | 102 | FUNDS_CTR | Funds Center | nvarchar | 16 | 0 | | |
11 | /LIME/COLL_INV | Collection for Inventory System | 102 | FUNDS_CTR | Funds Center | nvarchar | 16 | 0 | | |
12 | /LIME/COLL_LEG | Collection for External System | 102 | FUNDS_CTR | Funds Center | nvarchar | 16 | 0 | | |
13 | /LIME/COLL_MMIM | Collection for R/3 Inventory Management | 102 | FUNDS_CTR | Funds Center | nvarchar | 16 | 0 | | |
14 | /LIME/COLL_W2IM | Collection for WME after ERP-MMIM | 102 | FUNDS_CTR | Funds Center | nvarchar | 16 | 0 | | |
TOPBasis Components |
15 | /XFT/INV_Q_11 | Account assignment data | 25 | FUNDS_CTR | Funds Center | nvarchar | 16 | 0 | | |
16 | /XFT/INV_Q_11_S | Account assignment data | 25 | FUNDS_CTR | Funds Center | nvarchar | 16 | 0 | | |
TOPFunctions for U.S. Federal Government |
17 | FMFGYECLAA | US Federal Gov't : Y/E Pre-Closing of Anticipated Accounts | 5 | FUNDS_CTR | Funds Center | nvarchar | 16 | 0 | | |
TOPFunds Management |
18 | FMBUDBCS | Budgetary ledger account derivation: BCS | 10 | FUNDS_CTR | Funds Center | nvarchar | 16 | 0 | | |
19 | FMBUDDIS | Budgetary ledger account derivation: Budgeting (old) | 10 | FUNDS_CTR | Funds Center | nvarchar | 16 | 0 | | |
TOPGrantee Management |
20 | GMIA | Actual Line Item Table | 55 | FUNDS_CTR | Funds Center | nvarchar | 16 | 0 | | |
TOPIncentive and Commission Management ICM |
21 | YCRM01_ACCAS | Account Assignment Type/Cost Information for Remuneration | 23 | FUNDS_CTR | Funds Center | nvarchar | 16 | 0 | | |
22 | YTEL01_ACCAS | Account Assignment Type/Cost Information for Remuneration | 10 | FUNDS_CTR | Funds Center | nvarchar | 16 | 0 | | |
TOPRevenues and Earnings |
23 | AD01DLI | Dynamic items (DI) | 52 | FUNDS_CTR | Funds Center | nvarchar | 16 | 0 | | |
TOPStructures Workbench |
24 | /ISDFPS/CMATPLN | Parameters for Material Planning | 16 | FUNDS_CTR | Funds Center | nvarchar | 16 | 0 | | |
TOPTravel Expenses |
25 | PTRV_COMM_ITM | Header Data: Transfer to FM When Trip Saved | 23 | FUNDS_CTR | Funds Center | nvarchar | 16 | 0 | | |
26 | PTRV_SCOS | Trip Statistics - Cost Assignment | 18 | FUNDS_CTR | Funds Center | nvarchar | 16 | 0 | | |