| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNV_40305_ANKP | Backup of ANKP from prior to the conversion | 4 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
2 | CNV_40305_ANKP_B | Backup of ANKP from prior to the conversion | 4 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
3 | J_3RFDEPB_CHART | Depreciation bonus: Chart of depreciation level | 2 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
4 | T089T | Text table for T089 (appreciations) | 3 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
5 | T093F | Check rules dep. calc. (not used!) | 2 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
6 | T093S | Value Field Names for Depreciation Areas | 3 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
7 | TABWB | Transaction types AuC (no longer used) | 2 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
8 | TABWI | Allowed asset classes per transaction type group | 2 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
9 | TGLO_JP_IMP | Depreciation areas to Impairment data mapping | 3 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
TOPActual CostingMaterial Ledger |
10 | FCML_FIAACO | Control Table Transfer of Depreciation to CO | 2 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
TOPAddress ManagementBusiness Address |
11 | T005 | Countries | 56 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
TOPAsset Accounting |
12 | IDCN_GA_DEP | Parameters for Asset Depreciation (Golden Audit) | 2 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
13 | T093_MAP_ACC | Mapping Table for Alternative Company Codes | 7 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
TOPBasic Functions |
14 | ANGB | Asset catalog deprec. area | 2 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
15 | ANKB | Asset class: depreciation area | 3 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
16 | ANKL | Generation table for generating asset classes from accounts | 3 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
17 | ANKLAYP | Asset class: Assignment of tab layouts | 3 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
18 | ANKP | Asset classes: Fld Cont Dpndnt on Chart of Depreciation | 3 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
19 | T082AVIEWB | View Authorization for Depreciation Areas | 3 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
20 | T085 | Investment support measures | 2 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
21 | T085P | Investment support: Default and check table | 2 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
22 | T085S | Description of individual investment support measures | 3 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
23 | T085Z | Capital investment grants with time-dependent percentages | 2 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
24 | T089 | One-Time Revaluation on Key Date | 2 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
25 | T090C | External depreciation keys | 2 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
26 | T090NA | Depreciation Keys | 2 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
27 | T090NAT | Names of Depreciation Keys | 3 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
28 | T090NAZ | Depreciation Keys - Method Assignment | 2 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
29 | T090ND | Declining-Balance Method | 2 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
30 | T090NDT | Name for Declining-Balance Method | 3 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
31 | T090NP | Period Control Method | 2 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
32 | T090NPT | Name of Period Control Method | 3 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
33 | T090NS | Multilevel Method | 2 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
34 | T090NSG | Multi-Level Method - Start of Validity | 2 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
35 | T090NSK | Multilevel Method | 2 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
36 | T090NST | Name of Multi-Level Methods | 3 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
37 | T090T | Names For External Depreciation Keys | 3 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
38 | T093 | Real and derived depreciation areas | 2 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
39 | T093A | Real depreciation area | 2 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
40 | T093C | Company codes in Asset Accounting | 8 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
41 | T093T | Names for real and derived depreciation areas | 3 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
42 | T096 | Chart of depreciation | 2 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
43 | T096T | Chart of depreciation texts | 3 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
44 | TABWA | Transaction types/dep. areas | 2 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
45 | TABWU | Special Treatment of Retirements | 2 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
TOPCost Object |
46 | TKKAJ | Text Table for Results Analysis Versions | 3 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
47 | TKKAL | Entity Table for RA Versions for Assets Under Construction | 2 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
TOPHandling of Inflation |
48 | J_1AAT089 | Revaluation area assignment | 2 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
TOPInformation System |
49 | GLOFAAJPT093 | FI-AA: Japan / Additional attribute for Depreciation Areas | 2 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
TOPInterest |
50 | TPI02 | Interest Calculation Profile and Interest Indicator | 10 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
51 | T8JHF | Fields to transport from sending to new receiving asset | 2 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
TOPLand Use Management |
52 | TIVLMPLDPRAREA | LUM-Relevant Depreciation Areas | 2 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
TOPLease Accounting |
53 | TFILA_FA_002 | Assignment Accounting Principle -> Depreciation Area | 3 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
TOPLocal Currency Changeover |
54 | EWUAFAPL | EMU: Currencies for the participating investment supports | 3 | AFAPL | Chart of depreciation for the asset | nvarchar | 4 | 0 | | |
TOPLocalization |
55 | IDIN_FIAA_TAX | Tax Area for Asset Blocks | 2 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
56 | J_3RF_WW_AREA | Depreciation area for Working wear | 2 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
57 | J_3RMONTHACTIV | Monthly depreciation flags for depreciation areas | 2 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
58 | J_3RNEGPAFABE | Permit Negative Posting for Depr. Area and Chart of Depr. | 2 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
59 | TGLO_JP_IMPDEPR | Depreciation areas to Impairment data mapping | 3 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
TOPNet Worth Tax |
60 | IDFIAA_JP_TAX1 | Japanese Tax Report - Areas and Transaction Types | 2 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |
TOPRegulatory reporting for insurance companies |
61 | TISSR_STOCK_FIAA | Vermögenskennz. zu Bewertungsbereich FI-AA zuordnen | 5 | AFAPL | Bewertungsplan für die Anlagenbewertung | nvarchar | 4 | 0 | | |
TOPTreasury |
62 | TZ27 | Allocation: Valuation area for internal stock indicator | 3 | AFAPL | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | | |