VILIC

ICI Historical Data | #masterdata | Component: Real Estate Management
Column Name Description
MANDT Client
INTRENO Internal Real Estate Master Data Code
ANFIS Fiscal Year
DTVAL Validity date
Column Name Description
πŸ’² Currency Key (WAERS):
ICVAL ICI value
RENBA Basic Cadastral revenue
RENCA Cadastral revenue
VAVEN Selling value for building areas
REDOM Domain revenue
VAIMM D-Building value
BASVL Basic value
BASIM Taxable amount
VEDET Possible detraction value
VLPRI First instalment value
DEPRI First instalment detractions
ACCON Down payment
VLSEC Second instalments value
DESEC Second instalment detractions
SALDO Balance
Column Name Description
Column Name Description
DTVAL Validity date
DTFIN End period date
DTPRI First payment deadline
DTSEC Second payment deadline
CPUDT Day On Which Accounting Document Was Entered
BLDAT Document Date in Document
Column Name Description
TPCAL Calculation type Show values
FLPRI Flag 1st instalment payment Show values
Column Name Description Domain name
BUKRS Company Code BUKRS
SWENR Business Entity Number SWENR
SMENR Number of Rental Unit SMENR
SGRNR Land Number for BE SGRNR
ORT01 Ort VVLICORT01
ZOCEN Census Area VVLIC2
ALCOM County rate DEC03_2
ESATT Name of the ICI collector DDTEXT
CCNRO C/C number CHAR010
COFCA Category coefficient DEC03_2
COFRE Regional Coefficient DEC03_2
COFRI Revaluation Coefficient DEC3_2
MEPOS Months of ownership NUMC02
PEPOS Percentage of ownership DEC03_2
MEESC Months of exclusion NUMC02
PEDET Detraction percentage DEC03_2
AUPER Raising percentage DEC03_2
USNAM User Name XUBNAME
Master Data Relations Join Conditions
Use grouping code
  • Use grouping code
  • Client
Category ID
Class ID
  • Class ID
  • Client
Currency Key
  • VILIC.MANDT == TCURC.MANDT
  • VILIC.WAERS == TCURC.WAERS