VIFANLA SAP table for – LUM: Flurstück – Zugeordnete Anlagenstammsätze

Here we would like to draw your attention to VIFANLA table in SAP. As we know it is being mainly used with the SAP RE-FX (Flexible Real Estate Management in RE) component which is coming under RE module (Real Estate Management). VIFANLA is a SAP standard transp table used for storing LUM: Flurstück – Zugeordnete Anlagenstammsätze related data in SAP. It comes under the package RE_MI_LU.

SAP VIFANLA table

Table VIFANLA technical data

TableVIFANLA
Data storingLUM: Flurstück – Zugeordnete Anlagenstammsätze
ModuleRE
Sub ModuleRE-FX
SAP PackageRE_MI_LU
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • INTRENO : Internal Real Estate Master Data Code
    Its a key field. Its data type is CHAR (Character String) with field length 13
  • PARTID : Flurstück: Identifikation zur Eigentümertabelle
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • SWENR : Business Entity Number
    Its a key field. Its data type is CHAR (Character String) with field length 8
  • ANLN1 : Main Asset Number
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • ANLN2 : Asset Subnumber
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • GUELTIG_VON : Datum gültig ab
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • GUELTIG_BIS : Datum gültig bis
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FLAECHE : Fläche intern
    Its data type is QUAN (Quantity field) with field length 14
  • EINHEIT : Area unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • KANSW_HR : Cumulative acquisition and production costs
    Its data type is CURR (Currency Field) with field length 13
  • KANSW_SB : Cumulative acquisition and production costs
    Its data type is CURR (Currency Field) with field length 13
  • KANSW_KO : Cumulative acquisition and production costs
    Its data type is CURR (Currency Field) with field length 13
  • KANSW_S1 : Cumulative acquisition and production costs
    Its data type is CURR (Currency Field) with field length 13
  • KANSW_S2 : Cumulative acquisition and production costs
    Its data type is CURR (Currency Field) with field length 13
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • KENNZEICHEN : Kennzeichen A=Anlagenstammsatz / F=Anl-Werte aus Fremdsystem
    Its data type is CHAR (Character String) with field length 1