TFILA_LDB_000 SAP table for – Assignment of Value IDs to Fields of Logical DB

Here we would like to draw your attention to TFILA_LDB_000 table in SAP. As we know it is being mainly used with the SAP FI-LA (Lease Accounting in FI) component which is coming under FI module (Financial Accounting). TFILA_LDB_000 is a SAP standard transp table used for storing Assignment of Value IDs to Fields of Logical DB related data in SAP. It comes under the package FI_LA_BA.

SAP TFILA_LDB_000 table

Table TFILA_LDB_000 technical data

TableTFILA_LDB_000
Data storingAssignment of Value IDs to Fields of Logical DB
ModuleFI
Sub ModuleFI-LA
SAP PackageFI_LA_BA
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentEA-APPL
Table CategoryTRANSP

SAP TFILA_LDB_000 Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in TFILA_LDB_000 table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • COMPONENT : Application Component
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • LDBNAME : LDB name
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • LDBNODE : Logical node name
    Its a key field. Its data type is CHAR (Character String) with field length 14
  • LDBFIELD : Field Name in Structure of Node of Logical DB
    Its a key field. Its data type is CHAR (Character String) with field length 30
  • DBTAB : Table Name
    Its data type is CHAR (Character String) with field length 30
  • DBFIELD_PARAM : Logical DB: Database Field Parameter Name
    Its data type is CHAR (Character String) with field length 30
  • PARAM : Logical Database: Parameters
    Its data type is CHAR (Character String) with field length 30
  • DBFIELD_CONTENT : Logical Database: Field Name Contents Database
    Its data type is CHAR (Character String) with field length 30