SAP Basic Functions Tables
Are you looking for the right table related to SAP Basic Functions Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Basic Functions (FI-AA-AA) module.
Top 10 tables in Basic Functions
| Table | Description |
|---|---|
| SMFIAA | Spec. FI-AA Data in Monitor (see Schedman_specific_fiaa) |
| T094A | Index series for replacement values |
| T093S | Value Field Names for Depreciation Areas |
| T090NSK | Multilevel Method |
| T093_BSN_FUNC | ERP Business Function for FI-AA |
| T093N | Number assignment alloc. AA |
| T091T | Names for Cut-Off Value Keys |
| TA1M | Line Item Schema |
| T093H | Assignment of FI-AA Line Item Schema |
| TFAA_PC_S | Subprocesses |
List of tables in Basic Functions
| Table | Description |
|---|---|
| SMFIAA | Spec. FI-AA Data in Monitor (see Schedman_specific_fiaa) |
| T094A | Index series for replacement values |
| T093S | Value Field Names for Depreciation Areas |
| T090NSK | Multilevel Method |
| T093_BSN_FUNC | ERP Business Function for FI-AA |
| T093N | Number assignment alloc. AA |
| T091T | Names for Cut-Off Value Keys |
| TA1M | Line Item Schema |
| T093H | Assignment of FI-AA Line Item Schema |
| TFAA_PC_S | Subprocesses |
| T094 | Index Figures for Replacement Values |
| T095P | Reconcil.accts. derived dep. areas |
| T094T | Index series names |
| TABWP | Entity table for asset history sheet versions |
| T090NA | Depreciation Keys |
| T093V | Validation for Asset Management / Company Code |
| T097T | Description of the Property Indicator |
| T093G | Cross-System Depreciation Areas |
| T090S | Names For Internal Calculation Keys |
| TABWD_VIT | Text Table for Table TABWD_VID |
| T093B_RSL | Company Code-Related Depreciation Area Specifications |
| T090NST | Name of Multi-Level Methods |
| TABWO | Names for the asset history sheet versions |
| TFAA_PC_PT | Process Names |
| T093GT | Texts for Cross-System Depreciation Areas |
| TA1MT | Text Table for Line Item Schema |
| T090NH_METH | Maximum Amount Method |
| TABA | Depreciation posting documents |
| T094P | Index Figures for Replacement Values |
| T099U | Insurance Companies Description |
| T093Y | Shortened fiscal year |
| T090NAT | Names of Depreciation Keys |
| T090NPT | Name of Period Control Method |
| TABWD | Default transaction types for FI-AA posting transactions |
| ANEA | Asset Line Items for Proportional Values |
| ANEK | Document Header Asset Posting |
| TABW | Asset transaction types |
| ANKB | Asset class: depreciation area |
| TAAPM1 | Assignment for Field Link between FI-AA and PM |
| FAAT_MD_VAL_TDD | Fixed Asset Master: Time Dependent Data for Valuation |
| FAAC_ACCTASN1C | Account Assignment Settings in AA for Company Code |
| T094S | Names for Index Classes |
| T099T | Description of Insurance Types |
| TABWU | Special Treatment of Retirements |
| FAAI_FIELD1P | Technical Fields and Position |
| TABWT | Asset transaction types texts |
| TABWI | Allowed asset classes per transaction type group |
| T093U | Options for asset legacy data transfer |
| FAAC_ACCTASN0 | Settings for Account Assignment Objects in Asset Accounting |
| T090 | Depreciation calculation keys |
| ANLH | Main asset number |
| T085Z | Capital investment grants with time-dependent percentages |
| T094C | Index Class |
| FAAT_MD_VAL | Fixed Asset Master: Valuation |
| T095T | Name for account groups |
| T087J | Text |
| T090NHT | Name for Maximum Amount Method |
| T082AVIEW0T | Text Tables for Asset Views |
| T090W | Short Texts for Depreciation Trace |
| T087U | Asset group number / asset group |
| T090M | Table for maximum depreciation amounts |
| T087L | Text table for reasons for environmental investments |
| TA1TV | Asset Transfer Variant |
| FAAT_CMP_DA | FAA Company Code: Depreciation Area Settings |
| TCREP | CATT-Test Reporting - Check of logical databases |
| T099 | Insurance types |
| ANKA | Asset classes: general data |
| T087I | Reason for investment |
| FAAT_CMP | Fixed Asset Company Code |
| T087T | Description of Evaluation Groups |
| TABWG | Transaction type groups |
| ANLA | Asset Master Record Segment |
| ANKL | Generation table for generating asset classes from accounts |
| T085P | Investment support: Default and check table |
| TFAA_PC_STEP | Process Steps (Entity Table) |
| T090NAZ | Depreciation Keys - Method Assignment |
| FAAC_VALVIEW0 | Valuation Views: Definition |
| T093T | Names for real and derived depreciation areas |
| T082AVIEW2 | View Authorization for Asset Depreciation Area Fields |
| FAAT_CMP_LDT | FAA Company Code: Legacy Data Transfer Settings |
| T093A | Real depreciation area |
| TABBR | Rules for determining asset value date |
| TABWV | Default transaction types |
| FAAD_MD_VAL_YDDA | I_ASSETTP I_ASSETYEAROPENINGVALNATTRIBTP |
| T099V | Insurance Tariff Description |
| TA1TVT | Asset Transfer Variant |
| TABWA | Transaction types/dep. areas |
| ANLB | Depreciation terms |
| FAAC_CMP0 | AA specific settings for company code |
| ANLQ | Period values from dep. posting run per posting level |
| T082H | Field string name: Asset master data maintenance |
| TFAA_PC_STEPT | Process Steps (Text Table) |
| FAAT_MD | Fixed Asset Master: Time Independent Data |
| ANLV | Insurance data |
| T090L | Unit-of-production method of depreciation |
| T090V | Name for period control in transactions |
| T093SB | Substitution for Asset Management / Company Code |
| TABWM | Asgnmt. hist. sheet (sub)groups to asset history sheet item |
| FAAD_MD_VAL_TDD | I_ASSETTP I_ASSETTIMEBASEDVALUATIONTP |
| FAAC_ACLS1A | Asset Class: Default Settings for Valuation View |
| T090MIG | FI-AA: Calculation Methods Were Migrated |
| T094B | Allowed base years per index series |
| TFAA_PC_PS | Assignment Process -> Subprocess |
| T090NS | Multilevel Method |
| TABWN | Item Titles in the Asset History Sheet |
| T082AVIEW1 | View Authorization for Asset Master Data Fields |
| FAAD_MD_ROOT | I_ASSETTP I_ASSETTP |
| FAAC_AP0 | FI-AA: Accounting Principle Settings |
| ANGT | Asset catalog text table |
| T091S | Text for translation methods |
| ANLBZA | Time-Dependent Depreciation Terms |
| TABWB | Transaction types AuC (no longer used) |
| TABWD_FTC | Fields Used for Table Controls on Asset Postings |
| T093C | Company codes in Asset Accounting |
| T093C_RSL | Default Values for Depreciation Key in Company Code |
| FAAT_MD_ROOT | Fixed Asset Master: Root Segment |
| T097 | Property indicator |
| T095B | G/L accounts value adjustment |
| T090NP | Period Control Method |
| TABVA | Variants for determining asset value date |
| T082AVIEWB | View Authorization for Depreciation Areas |
| T082F | Field groups asset data |
| T098T | Description of the reasons for manual property values |
| T089T | Text table for T089 (appreciations) |
| ANKV | Asset classes: insurance types |
| FAAD_MD_VAL | I_ASSETTP I_ASSETVALUATIONTP |
| FAAC_ACLS1C | Asset Class: Default Settings for Company Code |
| T082G | Field strings for screen selection asset master data. |
| T092T | Description of the Property Classification Key |
| FAAT_CMP_LEDGER | FAA Company Code: Ledger Settings |
| T083S | Leasing types-Description |
| T092 | Property classification key |
| ANKAZ | Asset class: extension for technical fields |
| T090I | Depreciation simulation (Reporting) |
| TABVO | Determine asset value date in Asset Accounting transactions |
| FAAI_FIELD0 | Layout Fields |
| FAAC_ACCTASN1A | Account Assignment Settings in AA for accounting principle |
| FAAC_ACLS0_T | Description of Asset Class |
| T087V | Text table asset group number / asset group |
| ANLC | Asset Value Fields |
| FAAC_ACCTDET1V | Account Determination for Depreciation Areas |
| ANEP | Asset Line Items |
| T093 | Real and derived depreciation areas |
| T087G | Evaluation group 8 places |
| FAAC_VALVIEW1A | Assignment Valuation View to Accounting Principle |
| T090NH | Maximum Amount Method |
| T087 | Evaluation groups |
| FAAC_ACLS0 | Asset Class: General Settings |
| T086T | Names for Reporting Sort Versions |
| T095A | Account allocation |
| FAAC_ACLS2CY | Asset Class: Assignment of Tab Layout for company code |
| FAAC_LAYOUT0 | Master Data Layout |
| ANLU | Asset Master Record: User Fields |
| T087K | Reason for investment protecting the environment |
| T093F | Check rules dep. calc. (not used!) |
| FAAC_VALVIEW0_T | Description of Valuation Views |
| T095_ACI | Technical Clearing Account for Integrated Asset Acquisition |
| FAAT_MD_VAL_YDDA | Fixed Asset Master: Year-Dependent Attributes for Valuation |
| FAAC_T093_EMU | Emulation of parallel currency depr. area |
| T095 | Balance sheet accounts for depreciation areas |
| T090NDT | Name for Declining-Balance Method |
| ANLBZW | Asset-specific base values |
| TAAPM2 | Link from FI-AA to PM: Assignment of Fields |
| TFAA_PC_P_STEP | Assignment of Processes -> Process Steps |
| T098 | Basis manual property evaluation |
| T093R | Control Table for Archiving in Asset Accounting |
| FAAC_CMP_DA0_T | Description of Depreciation Area |
| T082A | Field string asset master record maintenance |
| T085 | Investment support measures |
| T087S | Test table for evaluation group 8 places |
| FAAI_SLALIT1M | Allowed Slalittype Movcat Combinations |
| ANLX | Asset Master Record Segment |
| T090A | Period control dep. calculation |
| FAAI_SLALIT0 | Slalittype Metadata |
| FAAC_ACCTASN0_T | Texts for Account Assignment Objects in AA |
| T096 | Chart of depreciation |
| T085S | Description of individual investment support measures |
| TFAA_PC_ST | Subprocess Names |
| T082L | Summary of logical field groups |
| TAAPM1T | Assignment for Field Link between FI-AA and PM |
| T093D | Control dep. posting |
| T090NR | Base Method |
| T096T | Chart of depreciation texts |
| FAAC_LAYOUT0_T | Master Data Layout Text |
| FAAC_CMP_DA0 | Assign Depr. Area to company code |
| T080A | Structure definition work list suffix |
| T090R | Period control rules for transactions |
| T082AVIEWTRANSG | Assignment of Transaction Group to Asset View |
| T099B | Insurance premiums |
| ANKT | Asset classes: Description |
| T082B | Field groups assets definition |
| FAAC_LAYOUT1F | Master Data Layout |
| T090U | Texts on depreciation simulation versions |
| T083L | Leasing types |
| T083T | Description of leasing cycle |
| T090Z | Period control for transactions |
| T082I | Create takeover rules from transfer for master data |
| T097JP | FI-AA: Percentage rates for property valuation Japan |
| FAAC_AMOUNT0 | FIAA: Amount Specification |
| FAAT_MD_LD | Fixed Asset Master: Ledger |
| T090Y | Weighting of depreciation periods |
| ANLT | Asset Texts |
| T084 | Incorrect assets |
| T093B | Company code-related depreciation area specifications |
| T091C | Translation methods for Asset Accounting |
| T091P | Cut-off val. percent. rates |
| TA1MZ | Line Item Schema |
| FAAD_MD_TDD | I_ASSETTP I_ASSETASSIGNMENTTP |
| TABWK | Trans. types for posting prop. values and depreciation |
| FAAC_VALVIEW2AS | Specify source valuation view for calculated valuation view |
| T082J | Create takeover rules from transfer for master data: areas |
| T090NSG | Multi-Level Method - Start of Validity |
| ANEV | Asset downpymt settlement |
| T082M | Description for logical field groups |
| T090C | External depreciation keys |
| T091 | Cut-off value key |
| TABBT | Names of the rules for determining the asset value date |
| T090P | Dep. calc. key percentage records |
| ANLZ | Time-Dependent Asset Allocations |
| T089 | One-Time Revaluation on Key Date |
| T086 | Sort version Reporting |
| ANKP | Asset classes: Fld Cont Dpndnt on Chart of Depreciation |
| T082T | Names For Field Groups |
| FAAC_ACCTDET0_T | Description of account determination |
| ANKLAY | Asset class: Assignment of tab layouts |
| TABVAT | Names of variants for determining asset value date |
| T082S | Dynpro control of the views |
| T090T | Names For External Depreciation Keys |
| T090NRT | Base Method |
| FAAD_MD_LD | I_ASSETTP I_ASSETLEDGERTP |
| T090ND | Declining-Balance Method |
| TFAA_PC_SM | Assignment of Subprocess to Processing Methods/Modules |
| TABWH | Name for asset transaction type groups |
| T099A | Insurance companies |
| TFAA_PC_P | Processes |
| T095C | FI-AA Standard Account Determination |
| ANLP | Asset Periodic Values |
| ANLW | Insurable values (year dependent) |
| FAAT_MD_TDD | Fixed Asset Master: Time Dependent Data |
| T082AVIEW0 | Entity Table for Asset Views |
| TABWD_VID | Entity Table for Table TABWD |
| FAAC_ACCTDET0 | Definition of Account Determination |
| TABAS | Logging of periodic posting runs in FI-AA |
| FAAASSETID | Assignment Table - Asset Key to Asset GUID |
| T082 | Field group authorization assets |
| ANKLAYP | Asset class: Assignment of tab layouts |
| FAAI_FIELD0_T | Texts for Layout Fields |
| T082E | Description asset views |
| TA1TVB | Determination of the Asset Transfer Method |