SAP Table VIXCITICIDATA - ICI master data

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
INTRENO X RECAINTRENO CHAR 3 13 0 Internal Key of Real Estate Object
DATEFROM X RECADATEFROM DATS 16 8 0 Date: Valid From
CURRENCY WAERS CUKY 24 5 0 TCURC Currency Key
DATETO RECADATETO DATS 29 8 0 Date: Valid To
ICIAMOUNT REXCITICIAMOUNT CURR 37 15 2 ICI City Tax Amount
POSTALCODE AD_PSTCD1 CHAR 45 10 0 City postal code
CITY AD_CITY1 CHAR 55 40 0 City
ICIRATE REXCITICIRATE CHAR 95 1 0 ICI city rate
ISMANUALRATE REXCITISMANUALRATE CHAR 98 1 0 Manually entered ICI rate differs from automatic. det. rate
ICICOLLECTOR REXCITICICOLLECTOR CHAR 99 60 0 Name of the ICI collector
ACCNO REXCITACCNO CHAR 159 1 0 Account number
CATID REXCITCATID CHAR 169 1 0 Cadastral Category ID
CATCOEFF REXCITCATCOEFF DEC 173 5 2 Category coefficient
CALCTYPE REXCITCALCTYPE CHAR 176 1 0 Calculation Type
AOVALUE REXCITAOVALUE CURR 178 15 2 Value of Architectural Object
BASEAMOUNT REXCITBASEAMOUNT CURR 186 15 2 Base amount
TAXBASE REXCITICITAXBASE CURR 194 15 2 Taxable Amount
MONOWN REXCITMONOWN CHAR 202 1 0 Period of ownership
PERCOWN REXCITPERCOWN DEC 204 5 2 Ownership Percentage
MONEXCL REXCITMONEXCL CHAR 207 1 0 Months of exclusion
DETRAMOUNT REXCITDETRAMOUNT CURR 209 15 2 Detraction Amount
DETRACTPREC REXCITDETRACTPREC DEC 217 5 2 Detraction Percentage
RAISPERC REXCITRAISPERC DEC 220 5 2 Percentage Increase
ISANNUALPAY REXCITISANNUALPAY CHAR 223 1 0 One Annual Payment (Without Down Payment)
DATPRI REXCITDATPRI DATS 224 8 0 Due Date of First Installment (Down Payment)
INSTPRIPAID REXCITINSTPRIPAID CHAR 232 1 0 First Installment (downpayment) Paid
DOWNPAYMENT REXCITDOWNPAYM CURR 233 15 2 Down payment
DATSEC REXCITDATSEC DATS 241 8 0 Due Date of Second Installment Payment
BALANCE REXCITBALANCE CURR 249 15 2 Balance
ISACTIVEICI REXCITISACTIVEICI CHAR 257 1 0 ICI record locked for recalculation
ASSIGINTRENO REXCITASSIGINTRENO CHAR 258 13 0 Assigned real estate object
ASSIGOBJNR RECAOBJNR CHAR 271 22 0 ONR00 Object Number
BUKRS BUKRS CHAR 293 4 0 T001 Company Code
IS_EXEMPT REXCITISEXEMPT CHAR 297 1 0 Exemption Status
IS_UNINHABIT REXCITISUNINHABIT CHAR 298 1 0 Uninhabitable Building
IS_HISTORIC REXCITHISTORIC CHAR 299 1 0 Historical Object
RERF RERF CHAR 300 12 0 Entered by
DERF DERF DATS 312 8 0 First Entered on
TERF TERF TIMS 320 6 0 Time of Initial Entry
REHER REHER CHAR 326 10 0 Source of initial entry
RBEAR RBEAR CHAR 336 12 0 Employee ID
DBEAR DBEAR DATS 348 8 0 Last Edited on
TBEAR TBEAR TIMS 356 6 0 Last Edited at
RBHER RBHER CHAR 362 10 0 Editing Source