SAP Table VILIC - ICI Historical Data

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
INTRENO X VVINTRENO CHAR 3 13 0 Internal Real Estate Master Data Code
ANFIS X GJAHR NUMC 16 4 0 Fiscal Year
DTVAL X VVLICDTVAL DATS 20 8 0 Validity date
BUKRS BUKRS CHAR 28 4 0 T001 Company Code
SWENR SWENR CHAR 32 8 0 VIOB01 Business Entity Number
SMENR SMENR CHAR 40 8 0 VIMI01 Number of Rental Unit
SGRNR SGRNR CHAR 48 8 0 Land Number for BE
WAERS WAERS CUKY 56 5 0 TCURC Currency Key
DTFIN VVLICDTFIN DATS 61 8 0 End period date
ICVAL VVLICICVAL CURR 69 13 2 ICI value
ORT01 VVLICORT01 CHAR 76 35 0 Ort
ZOCEN VVLICZOCEN CHAR 111 2 0 Census Area
ALCOM VVLICALCOM DEC 113 5 2 County rate
ESATT VVLICESATT CHAR 116 60 0 Name of the ICI collector
CCNRO VVLICCCNRO CHAR 176 10 0 TN21Z1 C/C number
IDCAT VVLICIDCAT CHAR 186 4 0 TIVLICTG Category ID
COFCA VVLICCOFCA DEC 190 5 2 Category coefficient
IDCLA VVLICIDCLA CHAR 193 2 0 Class ID
COFRE VVLICCOFRE DEC 195 5 2 Regional Coefficient
COFRI VVLICCOFRI DEC 198 5 2 Revaluation Coefficient
TPCAL VVLICTPCAL CHAR 201 2 0 Calculation type
CORUS VVLICCORUS CHAR 203 2 0 Use grouping code
RENBA VVLICRENBA CURR 205 13 2 Basic Cadastral revenue
RENCA VVLICRENCA CURR 212 13 2 Cadastral revenue
VAVEN VVLICVAVEN CURR 219 13 2 Selling value for building areas
REDOM VVLICREDOM CURR 226 13 2 Domain revenue
VAIMM VVLICVAIMM CURR 233 13 2 D-Building value
BASVL VVLICBASVL CURR 240 13 2 Basic value
BASIM VVLICBASIM CURR 247 13 2 Taxable amount
MEPOS VVLICMEPOS NUMC 254 2 0 Months of ownership
PEPOS VVLICPEPOS DEC 256 5 2 Percentage of ownership
MEESC VVLICMEESC NUMC 259 2 0 Months of exclusion
VEDET VVLICVEDET CURR 261 13 2 Possible detraction value
PEDET VVLICPEDET DEC 268 5 2 Detraction percentage
AUPER VVLICAUPER DEC 271 5 2 Raising percentage
DTPRI VVLICDTPRI DATS 274 8 0 First payment deadline
VLPRI VVLICVLPRI CURR 282 13 2 First instalment value
DEPRI VVLICDEPRI CURR 289 13 2 First instalment detractions
FLPRI VVLICFLPRI CHAR 296 1 0 Flag 1st instalment payment
ACCON VVLICACCON CURR 297 13 2 Down payment
DTSEC VVLICDTSEC DATS 304 8 0 Second payment deadline
VLSEC VVLICVLSEC CURR 312 13 2 Second instalments value
DESEC VVLICDESEC CURR 319 13 2 Second instalment detractions
SALDO VVLICSALDO CURR 326 13 2 Balance
CPUDT CPUDT DATS 333 8 0 Day On Which Accounting Document Was Entered
USNAM USNAM CHAR 341 12 0 USR02 User name
BLDAT BLDAT DATS 353 8 0 Document Date in Document