| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /ATL/AANLC | Asset-value fields, like anlc, for areas 11,12... | 6 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
2 | /ATL/AANLCP | Periodic Asset-value fields, like anlc, for all areas | 7 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
3 | /ATL/AATRNSF | Asset transfers | 9 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
4 | /CCEE/RSFIAA_RVA | Activate Revaluation Split | 3 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
5 | CNVA_PCREA_AA_O | LT PC Reorg Analysis: Asset Reconciliation results (Level 2) | 5 | AFABE | Depreciation area real or derived | nvarchar | 2 | 0 | | |
6 | CNVA_PCREA_AA_P | PC Reorg Analysis: Parameters for Fixed Asset Recon | 4 | AFABE | Depreciation area real or derived | nvarchar | 2 | 0 | | |
7 | CNV_20200_T093B | Differences in Comp.code-related depreciation area specific. | 5 | AFABE | | nvarchar | 2 | 0 | | |
8 | CNV_40305_POST_A | Aggregated amount to be reposted | 4 | AFABE | Depreciation area | nvarchar | 2 | 0 | | |
9 | CNV_40305_POST_D | Values to be reposted for a given asset | 6 | AFABE | Depreciation area | nvarchar | 2 | 0 | | |
10 | CNV_40305_SIM_PA | Aggregated amount to be reposted | 5 | AFABE | Depreciation area | nvarchar | 2 | 0 | | |
11 | CNV_40305_SIM_PD | Values to be reposted for a given asset | 7 | AFABE | Depreciation area | nvarchar | 2 | 0 | | |
12 | CNV_40305_T095 | CNV Backup of T095 | 5 | AFABE | Depreciation area | nvarchar | 2 | 0 | | |
13 | CNV_40305_T095B | CNV Backup of T095B | 5 | AFABE | Depreciation area | nvarchar | 2 | 0 | | |
14 | FIAASKD_SUBACQUI | Slovakia: FIAA Subsequent Acquisition Postings | 7 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
15 | FIKZD_PROPTAX | Property tax Kazakstan | 11 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
16 | FILUD_AA_ITEMS | SAFT: FI Asset line item details | 6 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
17 | FILUD_AA_MASTER | SAFT: FI Asset master data and values | 6 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
18 | GLPCA_CT | Profit Center Documents | 37 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
19 | GLPCA_T_CT | Profit Center Documents | 53 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
20 | T090I | Depreciation simulation (Reporting) | 3 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
21 | T093U | Options for asset legacy data transfer | 4 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
22 | T093Y | Shortened fiscal year | 4 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
23 | TGLO_JP_IMP | Depreciation areas to Impairment data mapping | 4 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
TOPAccounting Interface |
24 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 280 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
25 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 280 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
TOPActual CostingMaterial Ledger |
26 | FCML_FIAACO | Control Table Transfer of Depreciation to CO | 3 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
TOPAsset Accounting |
27 | APERB_ITEMS | Log Table for Dep. Areas Posted Directly to FI | 7 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
28 | BWFIAA_AEDAT_AB | FIAA-BW: Modified Valuation Area Data for Delta Upload | 5 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
29 | BWFIAA_AEDAT_TR | FIAA-BW: New and Modified Transactions for Delta Upload | 7 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
30 | IDPT_A011 | Revaluation Areas for Asset Reports | 3 | AFABE | Depreciation area real or derived | nvarchar | 2 | 0 | | |
TOPBasic Functions |
31 | ANEA | Asset Line Items for Proportional Values | 7 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
32 | ANEP | Asset Line Items | 7 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
33 | ANGB | Asset catalog deprec. area | 4 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
34 | ANKB | Asset class: depreciation area | 4 | AFABE | Depreciation area real or derived | nvarchar | 2 | 0 | | |
35 | ANLB | Depreciation terms | 5 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
36 | ANLBZA | Time-Dependent Depreciation Terms | 5 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
37 | ANLBZW | Asset-specific base values | 5 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
38 | ANLC | Asset Value Fields | 6 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
39 | T090M | Table for maximum depreciation amounts | 4 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
40 | T093A | Real depreciation area | 3 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
41 | T093B | Company code-related depreciation area specifications | 3 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
42 | T093B_RSL | Company Code-Related Depreciation Area Specifications | 3 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
43 | T095 | Balance sheet accounts for depreciation areas | 4 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
44 | T095B | G/L accounts value adjustment | 4 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
45 | T099 | Insurance types | 3 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
46 | TABWA | Transaction types/dep. areas | 4 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
47 | TABWU | Special Treatment of Retirements | 4 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
TOPCapital Investments |
48 | ANIB | Investment projects depr. simulation depr. areas | 4 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
TOPConstruction Equipment Management |
49 | J_3GPLKAT | Assignment Price List - Condition Types - Catalogs | 10 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
TOPData Retention Tool |
50 | TXW_S_ANEA | Retrieve ANEA from archive | 17 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
51 | TXW_S_ANEP | Retrieve ANEP from archive | 17 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
TOPFinancial Accounting |
52 | /BGLOCS/FITAXDPR | Asset transaction types for Tax Depr. Plan | 3 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
TOPFunctions for U.S. Federal Government |
53 | FMFG_T095 | Contra accounts asset accounting | 4 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
TOPGeneral Ledger Accounting |
54 | FAGL_HST_T095 | Old Acct Determin. for Asset Value Adjustment and Portfolio | 4 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
TOPHandling of Inflation |
55 | J_1AAOLDTA | Inflation Adjustment AA - Historic transact. period Balances | 6 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
TOPInformation System |
56 | GLOFAAJPT093 | FI-AA: Japan / Additional attribute for Depreciation Areas | 3 | AFABE | Depreciation area real or derived | nvarchar | 2 | 0 | | |
TOPInterest |
57 | TPI02 | Interest Calculation Profile and Interest Indicator | 11 | AFABE | Depreciation Area of Base Value for Interest Calculation | nvarchar | 2 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
58 | T8JHF | Fields to transport from sending to new receiving asset | 7 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
59 | T8JHR | Depreciation areas not to update by recovery indicator | 4 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
TOPLease Accounting |
60 | TFILA_FA_002 | Assignment Accounting Principle -> Depreciation Area | 5 | AFABE | Depreciation area real or derived | nvarchar | 2 | 0 | | |
TOPLocal Currency Changeover |
61 | EWUAFABE | EMU: Currencies for the participating depreciation areas | 4 | AFABE | Depreciation Area | nvarchar | 2 | 0 | | |
TOPLocalization |
62 | J_1ITAXDEP | Depreciation computation as per Income Tax (India) | 5 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
63 | J_3RF_WW_AREA | Depreciation area for Working wear | 3 | AFABE | Depreciation area real or derived | nvarchar | 2 | 0 | | |
64 | J_3RPTAXVAL | Define Depreciation Areas for Property Tax Calculation | 4 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
65 | J_3RT095B | Additional accounts for revaluation | 4 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
66 | J_3RTRET | Lock table for update retired asset during TranspTaxCalc | 7 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
67 | TGLO_JP_IMPDEPR | Depreciation areas to Impairment data mapping | 4 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
TOPOverhead Cost Orders |
68 | AUAI | Settlement Amounts per Depreciation Area | 4 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
TOPProfit Center Accounting |
69 | GLPCA | EC-PCA: Actual Line Items | 24 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
70 | GLPCC | EC-PCA: Transaction Attributes | 7 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
71 | GLPCP | EC-PCA: Plan Line Items | 24 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
72 | GLPCT | EC-PCA: Totals Table | 23 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
73 | T8APP_GLPCM | EC-PCA: Plan Costs from Material Costing for Rep. Material | 25 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |
TOPStatistical Key Figures |
74 | COEPBR | CO Object: Valuated Line Item Settlement | 6 | AFABE | Real depreciation area | nvarchar | 2 | 0 | | |