SAP Lease Accounting Tables

Are you looking for the right table related to SAP Lease Accounting 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 Lease Accounting (FI-LA) module.

Top 10 tables in Lease Accounting

TableDescription
TFILA_GF_001EProcesses for Changing Value ID Contents
TFILA_GF_003MVAssignment Value ID <-> Processing Method
TFILA_GF_005Specifications for One-Time Postings per Value ID
TFILA_GF_003MFor Later Use of Value IDs for Retrieval
TFILA_RE_TNRNumber Range per Company Code and Refinancing Type
TFILA_GF_003TValue IDs
TFILA_FA_001Process+Accounting Principle -> Transaction Type
TFILA_GF_000MMethods
TFILA_GF_007CFPayment Schedules
LAE_CRM_CONDSLease-Accounting-Relevant Conditions

List of tables in Lease Accounting

TableDescription
TFILA_GF_001EProcesses for Changing Value ID Contents
TFILA_GF_003MVAssignment Value ID <-> Processing Method
TFILA_GF_005Specifications for One-Time Postings per Value ID
TFILA_GF_003MFor Later Use of Value IDs for Retrieval
TFILA_RE_TNRNumber Range per Company Code and Refinancing Type
TFILA_GF_003TValue IDs
TFILA_FA_001Process+Accounting Principle -> Transaction Type
TFILA_GF_000MMethods
TFILA_GF_007CFPayment Schedules
LAE_CRM_CONDSLease-Accounting-Relevant Conditions
TFILA_GF_004Assignment Value ID -> Accrual Method
TFILA_GF_001CESpecifications for Change Processes
TFILA_RE_VALAssign Refinancing Category and Value Identifier
TFILA_FA_003Control of Useful Life Adjustment for Upgrades
TFILA_RE_CAT_CAssign Sales Tax Flag and Clearing Account to Refi. Categ.
LAE_CRM_BILLPLANPayment Schedule
TFILA_ACCRULEAccounting Principles for Classification in CRM
TFILA_GF_110TTexts of Check Sequences in Financing Classification
TFIOTP_001TDocument Group Characteristic Name
TFILA_GF_007Assignment Condition Type -> Value ID
TFILA_LC_006Option IDs
FIOTPOIOne-Time Postings: Items
TFILA_COMPONENTApplication Components of Accounting Engine
FILA_GF_ITEMVALSObject Data: Value IDs and their Values/Contents
FIEH_STATUSObject Status for Restart Exception Handling
FILA_RE_TR_ITranche Item: Selection Result for Refinancing
TFILA_GF_008GTName of Grouping Key
TFILA_EXPL_001Structure of Tree Controls in Leasing Explorer
FILA_MIG_RESTARTRestart Legacy Data Transfer for Lease Accounting
TFILA_GF_008Assignment of Company Code to Grouping Key
TFILA_GF_001STSubprocesses
TFILA_GF_001SSubprocesses
TFILA_ACCRULETAccounting Principles for CRM Classification -Texts
TFILA_GF_100Assignment of Derivations for Validations/Substitutions
TFILA_GF_003RBValues/Data Required by Method
TFILA_GF_000RReasons for Changes
TFILA_RE_EVENTAssign Refinancing Category and Process Type to Processes
TFILA_GF_007CFAPayment Schedule Definition
TFIOTP_002Account Determination Rule
TFILA_LC_001TClass Groups
TFILA_GF_020SAssign Value IDs for Determining Residual Value
FILA_GF_ITEMCHAHObject Data: Value ID Change Header Information
TFIOTP_003Posting Key for Document Grouping Characteristic
TFILA_GF_001ASYST: Allowed Change Events
TFILA_LC_002AKAssignment of Access Keys to Financing Classes
TFILA_GF_000MTMethod Texts
TFILA_GF_001Assignment Process -> Subprocess
TFILA_LDB_001Determination of Data Basis for Reports
FSL_STAT_CUST_TFSL: User Status Text for Item
TFILA_GF_003RValue IDs Referenced from Method
FSL_IDOTYPM_CUSTMapping Table for ID Object Type (AB) and ID Object Type(BP)
TFILA_GF_004CFAssignment of Payment Schedule for Accrual Postings
FILA_GF_ITEMPARMObject Data: Additional Information
LAE_CRM_CLASSContract Classification
FILA_RE_TR_HTranche Header: Selection Result for Refinancing
TFILA_GF_001MCAssignment- Subprocesses to User-Defined Processing Methods
TFILA_RE_CHGPRAssign Refinancing Categ. and Change Process to Cluster Type
TFIEH_GF_002Methods for Retrieval of Object Data
TFILA_LC_002TOSpecification Asset Values Copied for Following Business
TFILA_GF_001CControl Table for Value IDs to Be Changed or Added
TFILA_RE_CATDefine Refinancing Category
TFIOTP_002TDocument Group Characteristic Name
FILA_GF_ITEMDATAProcess Data
TFILA_GF_003CFAssignment of Value ID -> Payment Schedule for Calculation
TFILA_GF_006Assignment Company Code -> Accounting Principles
TFILA_RE_CATTText for Refinancing Category
LAE_CRM_LNKLink between LAE and CRM Contract Items
TFILA_GF_003Value IDs and their Determination
TFILA_GF_007CValue IDs to Be Included in Payment Schedule
TFILA_LC_003Assignmt of Value IDs to Fields of FILA_LCS_PARAM Structure
FILA_GF_ITEMDOCSAssignment of Process - FI/CO Document Numbers
FSL_STAT_CUSTFSL: User Status for Item
FILA_GF_PROCINFOObject Data: Processing Info for Process
TFIEH_GF_001Handling Methods
FILA_RE_LNKLink Between Leasing <-> Refinancing
TFILA_GF_009Assignment of Value IDs to Structure Field
TFILA_GF_020TFill New Residual Values in Conditions
TFILA_GF_021Controls Number of Processes
TFILAFM_IRCMAssignment of Acct Prin. to Interest Rate Calc. Methods
TFILA_FA_002Assignment Accounting Principle -> Depreciation Area
TFILA_GF_000Process Mapping for Processs from External Systems
TFILA_GF_007CFTPayment Schedule Names
TFILA_LDB_000Assignment of Value IDs to Fields of Logical DB
FILA_RE_PRGTText for Refinancing Program
TFILA_GF_000PTProcess Texts
FSLC_ACTIVE_INVFSL: Billing
TFILA_GF_008GGrouping Key
LAE_CRM_HEADERLAE: CRM Contract Header
TFILA_GF_000PProcesses
FILA_GF_ITEMLINKAssignment of Objects to Assets
FILA_MIG_SYNCSynchronization of CRM and LAE Legacy Data
TFILA_GF_000CPosting Periods Closed for Processes in LAE
TFILA_RE_TNRTText for Number Range per Refinancing Type and Company Code
TFILA_RE_RFFMapping for Payment Schedule Forfaiting
TFILA_LC_002TTexts for Financing Classes
FILA_RE_PRGRefinancing Program
TFILA_LC_006TOption Indicators: Names
TFILA_LC_001Class Groups
TFILA_GF_001MAssignment Subprocess -> Processing Methods
FIOTPOHOne-Time Postings: Header
FILA_GF_ITEMVALCObject Data: Changed Value IDs
TFILA_LC_002Financing Classes
LAE_CRM_PRODSProduct Information
TFILA_GF_009VMapping Table for Structure Fields in Value IDs
LAE_BILLING_DATPayment Schedule
LAE_BILLING_DATAPayment Schedule
TFILA_GF_011Option IDs
LAE_CRM_ITEMSLAE: Contract Items
TFILA_GF_111Check Steps in Financing Classification
TFILA_GF_009FAssignment of Field Transfer of Two Structures
TFILA_GF_110Check Sequences in Financing Classification
TFILA_GF_004BTAssignment of Value ID -> Accrual Method for Determ. Balance
TFILA_GF_003RMValues/Data Required by Method
TFIOTP_001Document Group Characteristic
TFILA_GF_000RTChange Reason Texts
TFILA_GF_011TOption IDs