VIXCITICIDATA

ICI master data | #transactional | Component: Flexible Real Estate Management
Column Name Description
MANDT FK Client
INTRENO FK Internal Key of Real Estate Object
DATEFROM Date: Valid From
Column Name Description
💲 Currency Key (CURRENCY):
ICIAMOUNT ICI/IMU Tax Amount
AOVALUE Value of Architectural Object
BASEAMOUNT Base amount
TAXBASE Taxable Amount
DETRAMOUNT Detraction Amount
DOWNPAYMENT Down Payment
BALANCE Balance
DOWNPAYMENTCITY Down Payment to City
DOWNPAYMENTCNTRY Down Payment to Country/Region
BALANCECITY Balance to City
BALANCECOUNTRY Balance to Country/Region
CITYAMOUNT ICI/IMU City Tax Amount
COUNTRYAMOUNT ICI/IMU Country Tax Amount
Column Name Description
Column Name Description
DATEFROM Date: Valid From
DATETO Date: Valid To
DATPRI Due Date of First Installment (Down Payment)
DATSEC Due Date of Second Installment Payment
DERF First Entered On
TERF Time of Creation
DBEAR Last Edited On
TBEAR Last Edited At
Column Name Description
ISMANUALRATE Manually Entered Tax Rate Differs Show values
CATCOEFF Category Coefficient Show values
PERCOWN Ownership Percentage Show values
DETRACTPREC Detraction Percentage Show values
RAISPERC Percentage Increase Show values
ISANNUALPAY One Annual Payment (Without Down Payment) Show values
INSTPRIPAID First Installment (Down Payment) Paid Show values
ISACTIVEICI ICI/IMU/TASI Record Locked for Recalculation Show values
IS_EXEMPT Exemption Status Show values
IS_UNINHABIT Uninhabitable Building Show values
IS_HISTORIC Historical Object Show values
NOIMUCALC No IMU Calculation Show values
Column Name Description Domain name
ICIRATE ICI/IMU Rate
ICICOLLECTOR Name of the Tax Collector RECAXLDESCRIPTION
ACCNO Account number
MONOWN Period of ownership
MONEXCL Months of exclusion
ASSIGINTRENO Assigned real estate object RECAINTRENO
ASSIGOBJNR Object Number J_OBJNR
COUNTRYRATE IMU Country/Region Rate
CITYRATE IMU City Rate
RERF Entered By SYCHAR12
REHER Source of Initial Entry CHAR10
RBEAR Employee ID SYCHAR12
RBHER Editing Source CHAR10
Master Data Relations | to Other Relations ↓ Join Conditions
Company Code
  • VIXCITICIDATA.MANDT == T001.MANDT
  • VIXCITICIDATA.BUKRS == T001.BUKRS
Currency Key
  • VIXCITICIDATA.MANDT == TCURC.MANDT
  • VIXCITICIDATA.CURRENCY == TCURC.WAERS
Internal Key of Real Estate Object
  • VIXCITICIDATA.MANDT == VIBDAO.MANDT
  • VIXCITICIDATA.INTRENO == VIBDAO.INTRENO
Client VIXCITICIDATA.MANDT == T000.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
City
Reduction ID