1. SAP Tutorial
  2. Real Estate Management

VIXCITICIDATA SAP table for – ICI master data

Here we would like to draw your attention to VIXCITICIDATA 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). VIXCITICIDATA is a SAP standard transp table used for storing ICI master data related data in SAP. It comes under the package RE_XC_RA_IT.

SAP VIXCITICIDATA table

Table VIXCITICIDATA technical data

TableVIXCITICIDATA
Data storingICI master data
ModuleRE
Sub ModuleRE-FX
SAP PackageRE_XC_RA_IT
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Key for ICI master data (VIXCITICIDATA)
    Its a key field.
  • INTRENO : Internal Key of Real Estate Object
    Its a key field. Its data type is CHAR (Character String) with field length 13
  • DATEFROM : Date: Valid From
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : ICI Data – data fields
  • CURRENCY : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • DATETO : Date: Valid To
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ICIAMOUNT : ICI/IMU Tax Amount
    Its data type is CURR (Currency Field) with field length 15
  • POSTALCODE : City postal code
    Its data type is CHAR (Character String) with field length 10
  • CITY : City
    Its data type is CHAR (Character String) with field length 40
  • ICIRATE : ICI/IMU Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • ISMANUALRATE : Manually entered ICI/IMU rate differs from auto. det. rate
    Its data type is CHAR (Character String) with field length 1
  • ICICOLLECTOR : Name of the Tax Collector
    Its data type is CHAR (Character String) with field length 60
  • ACCNO : Account number
    Its data type is CHAR (Character String) with field length 10
  • CATID : Cadastral Category ID
    Its data type is CHAR (Character String) with field length 4
  • CATCOEFF : Category Coefficient
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • CALCTYPE : Calculation Type
    Its data type is CHAR (Character String) with field length 2
  • AOVALUE : Value of Architectural Object
    Its data type is CURR (Currency Field) with field length 15
  • BASEAMOUNT : Base amount
    Its data type is CURR (Currency Field) with field length 15
  • TAXBASE : Taxable Amount
    Its data type is CURR (Currency Field) with field length 15
  • MONOWN : Period of ownership
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • PERCOWN : Ownership Percentage
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • MONEXCL : Months of exclusion
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • DETRAMOUNT : Detraction Amount
    Its data type is CURR (Currency Field) with field length 15
  • DETRACTPREC : Detraction Percentage
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • RAISPERC : Percentage Increase
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • ISANNUALPAY : One Annual Payment (Without Down Payment)
    Its data type is CHAR (Character String) with field length 1
  • DATPRI : Due Date of First Installment (Down Payment)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • INSTPRIPAID : First Installment (downpayment) Paid
    Its data type is CHAR (Character String) with field length 1
  • DOWNPAYMENT : Down Payment
    Its data type is CURR (Currency Field) with field length 15
  • DATSEC : Due Date of Second Installment Payment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BALANCE : Balance
    Its data type is CURR (Currency Field) with field length 15
  • ISACTIVEICI : ICI/IMU Record Locked for Recalculation
    Its data type is CHAR (Character String) with field length 1
  • ASSIGINTRENO : Assigned real estate object
    Its data type is CHAR (Character String) with field length 13
  • ASSIGOBJNR : Object Number
    Its data type is CHAR (Character String) with field length 22
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • IS_EXEMPT : Exemption Status
    Its data type is CHAR (Character String) with field length 1
  • IS_UNINHABIT : Uninhabitable Building
    Its data type is CHAR (Character String) with field length 1
  • IS_HISTORIC : Historical Object
    Its data type is CHAR (Character String) with field length 1
  • COUNTRYRATE : IMU Country Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • CITYRATE : IMU City Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • DOWNPAYMENTCITY : Down Payment to City
    Its data type is CURR (Currency Field) with field length 15
  • DOWNPAYMENTCNTRY : Down Payment to Country
    Its data type is CURR (Currency Field) with field length 15
  • BALANCECITY : Balance to City
    Its data type is CURR (Currency Field) with field length 15
  • BALANCECOUNTRY : Balance to Country
    Its data type is CURR (Currency Field) with field length 15
  • CITYAMOUNT : ICI/IMU City Tax Amount
    Its data type is CURR (Currency Field) with field length 15
  • COUNTRYAMOUNT : ICI/IMU Country Tax Amount
    Its data type is CURR (Currency Field) with field length 15
  • REDUCTION : Reduction ID
    Its data type is CHAR (Character String) with field length 2
  • .INCLUDE : Field String for Maintenance of User Data
  • RERF : Entered by
    Its data type is CHAR (Character String) with field length 12
  • DERF : First Entered on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TERF : Time of Initial Entry
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • REHER : Source of initial entry
    Its data type is CHAR (Character String) with field length 10
  • RBEAR : Employee ID
    Its data type is CHAR (Character String) with field length 12
  • DBEAR : Last Edited on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TBEAR : Last Edited at
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • RBHER : Editing Source
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes

    • VIXCITICIDATA related tables

    • VIXCITCDCHACTTYT : Cadastral Changes Act Type Description
    • TIVXCITCADMSR : Define the editable measurements
    • TIVXCITIRETCOBJR : Assign Tax Codes for Objects of Rentals
    • TIVXCITIREFT : Mapping of IRE Status to Contract-Flow type-Taxcode
    • TIVXCITIBPARA : IB Stamp tax parameter
    • TIVXCITICIRATE : ICI City rate
    • TIVXCITIRECALCPA : IRE Calculation parameters
    • TIVXCITCADCATT : ICI cadastral category description
    • TIVXCITCADCITY : City code
    • VIXCITIREOFDAT : IRE Office Data
    • TIVXCITCALCTYPE : ICI calculation type
    • TIVXCITIRECALCP : IRE calculation type
    • VIXCITCADRO : Temporary rental object data
    • TIVXCITREDUCT : Reduced rate
    • TIVXCITSDINT : Settings of Italian Security Deposit Interest Calculation
    • TIVXCITCADCPY : Cadastral Data to Transfer
    • TIVXCITIREOBJRET : IRE Object of Rental Description
    • TIVXCITIREOF : IRE Register Office Data
    • TIVXCITIRECFPB : Create Cash-flow or One-time posting for IRE Payback?
    • TIVXCITCALCTYPET : ICI calculation type description

    VIXCITICIDATA related transaction codes under SAP package RE_XC_RA_IT

    • REXCITICI : ICI Cockpit
    • REXCITICIFORM : ICI Reporting Tool
    • REXCITIRE : IRE Cockpit
    • REXCITCAD : Cadastral Object Splitting/Merging
    • REXCITPROCID : Number range maintenance: REXCIT

    Related References

    Related Tutorials

    TIVXCITPAYINST SAP table for – ICI Payment instalment

    TIVXCITPAYINST table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VIXCITICIDBUD SAP table for – ICI parameter for D-Building

    VIXCITICIDBUD table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    TIVXCITICIPARAM SAP table for – ICI/IMU City parameter

    TIVXCITICIPARAM table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VIXCITIREDATA SAP table for – IRE master data

    VIXCITIREDATA table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    TIVXCITCALCTYPE SAP table for – ICI calculation type

    TIVXCITCALCTYPE table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    TIVXCITICIFORM SAP table for – ICI Form Settings

    TIVXCITICIFORM table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    TIVXCITCADCAT SAP table for – ICI cadastral category

    TIVXCITCADCAT table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    «
    »