FAAASSETID SAP table for – Assignment Table – Asset Key to Asset GUID

Here we would like to draw your attention to FAAASSETID table in SAP. As we know it is being mainly used with the SAP FI-AA (Asset Accounting in FI) component which is coming under FI module (Financial Accounting). FAAASSETID is a SAP standard transp table used for storing Assignment Table – Asset Key to Asset GUID related data in SAP. It comes under the package FAA_DB.

SAP FAAASSETID table

Table FAAASSETID technical data

TableFAAASSETID
Data storingAssignment Table – Asset Key to Asset GUID
ModuleFI
Sub ModuleFI-AA-AA
SAP PackageFAA_DB
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

SAP FAAASSETID 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 FAAASSETID table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • ASSET_ID : GUID That Uniquely Identifies an Asset
    Its a key field. Its data type is CHAR (Character String) with field length 32
  • .INCLUDE : Key Fields for an Asset ID
  • .INCLUDE : Key Fields for Identifying Main Asset Number
  • ORGUNIT : Leading Organizational Unit for Asset Accounting
    Its data type is CHAR (Character String) with field length 4
  • ASSET : Main Asset Number
    Its data type is CHAR (Character String) with field length 12
  • SUBNUMBER : Asset Subnumber
    Its data type is CHAR (Character String) with field length 4