1. SAP Tutorial
  2. Real Estate Management

VIXCITCADAO SAP table for – Temporary architectural object data

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

SAP VIXCITCADAO table

Table VIXCITCADAO technical data

TableVIXCITCADAO
Data storingTemporary architectural object data
ModuleRE
Sub ModuleRE-FX
SAP PackageRE_XC_RA_IT
Delivery ClassL – Table for storing temporary data
ComponentEA-FIN
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Key for Cadaster temporary data of AO merging/splitting (VIX
    Its a key field.
  • PROCESSID : ID of Splitting/Merging Process
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 8
  • KEY_DATE : Date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ORIG_INTRENO : Internal Key of Real Estate Object
    Its a key field. Its data type is CHAR (Character String) with field length 13
  • NEW_INTRENO : Internal Key of Real Estate Object
    Its a key field. Its data type is CHAR (Character String) with field length 13
  • .INCLUDE : Architectural Object: Key
  • AOID : Identification of Architectural Object
    Its data type is CHAR (Character String) with field length 30
  • .INCLUDE : Architectural object
  • CADOPERATION : Process Type with Architectural Object
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Architectural Object: Header
  • AOTYPE : Architectural Object Type
    Its data type is CHAR (Character String) with field length 4
  • AONR : Number of Architectural Object
    Its data type is CHAR (Character String) with field length 13
  • VALIDFROM : Date: Object Valid From
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALIDTO : Date: Object Valid To
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PARTSEPARATOR : AOID Code: Separator
    Its data type is CHAR (Character String) with field length 10
  • PARTAOID : AOID Code
    Its data type is CHAR (Character String) with field length 30
  • XAO : Name of Architectural Object
    Its data type is CHAR (Character String) with field length 60
  • AOFUNCTION : Function of Architectural Object
    Its data type is CHAR (Character String) with field length 4
  • USAGECOMMON : Common Usage
    Its data type is CHAR (Character String) with field length 1
  • OBJNR : Object Number
    Its data type is CHAR (Character String) with field length 22
  • AUTHGRP : Authorization Group
    Its data type is CHAR (Character String) with field length 40
  • .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
  • RESPONSIBLE : Person Responsible
    Its data type is CHAR (Character String) with field length 12
  • USEREXCLUSIVE : User with Exclusive Change Authorization
    Its data type is CHAR (Character String) with field length 12
  • LASTRENO : Date of last redecoration
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • MEASSTRC : Measurement Structure
    Its data type is CHAR (Character String) with field length 4
  • DOORPLT : Short description
    Its data type is CHAR (Character String) with field length 15
  • .INCLUDE : Architectural Object: Attributes of Business Entity
  • SINSTBEZ : Maintenance district
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • SVERKEHR : Transport Connections of Business Entity
    Its data type is CHAR (Character String) with field length 1
  • SLAGEWE : Business entity location number
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • SOBJLAGE : Indicator: District Location of Object
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • .INCLUDE : Architectural Object: Attributes of Property
  • RGRNART : Usage Type of Property According to Land Use Map
    Its data type is CHAR (Character String) with field length 2
  • RBEPLAN : Development plan
    Its data type is CHAR (Character String) with field length 30
  • DBEPLAN : Date of development plan
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RNBPLAN : Usage type according to development plan
    Its data type is CHAR (Character String) with field length 4
  • XNUTZGRU : Current usage of property
    Its data type is CHAR (Character String) with field length 30
  • SUNUTZA : Main usage type
    Its data type is CHAR (Character String) with field length 8
  • JUNUTZA : Indicator: Predominant usage type ‘ ‘-ANLKL, ‘X’-TIV36
    Its data type is CHAR (Character String) with field length 1
  • NZGRZ : Permitted Usage: Site Occupancy Index
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • NZGFZ : Permitted Usage: Floor Area Ratio
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • NZBMZ : Permitted Usage: Construction Dimension Number
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • NTGRZ : Actual Usage: Site Occupancy Index
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • NTGFZ : Actual Usage: Floor Area Ratio
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • NTBMZ : Actual Usage: Construction Dimension Number
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • SGRART : Property type
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • SGRQAL : Property: Quality of location
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • SGRFRM : Property ground type
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • SGRGZS : Overall condition of property
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • JERBBAU : Heritable building right indicator
    Its data type is CHAR (Character String) with field length 1
  • ZULBAUH : Allowed Building Height (as Integer)
  • .INCLUDE : Architectural Object: Attributes of Building
  • RGEBART : Type of building
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • RGEBZUST : General condition of building
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • YBAUJAHR : ConstYr
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • JNURJAHR : Indicator: Only regard construction date in terms of years
    Its data type is CHAR (Character String) with field length 1
  • YMODERN : Year of modernization
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • YAUFBAU : Year of reconstruction
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DBAUBEGI : Construction start date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DBAUVOR : Date of planning inquiry
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DVORBES : Date of prior notice
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DANTBAU : Application for building permit
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DBAUGENE : Building permit
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • XBAUGENE : Note on building permit
    Its data type is CHAR (Character String) with field length 30
  • DFERTIG : Completion
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DSCHLUSS : Final Inspection
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DBEZUGSF : Ready for occupancy
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RDAZUST : Dummy: No Longer Used
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • RFAZUST : Dummy: No Longer Used
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • JDENKMAL : Protection of Historical Sites
    Its data type is CHAR (Character String) with field length 1
  • DFRDVON : Public funding from
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DFRDBIS : Public funding to
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BANZGE : Number of floors
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • AUGESCH : Number of basements
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 2
  • SSTCKBIS : Uppermost Floor of a Building
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • SLIFTBIS : Elevator to Floor in Building
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • NSTCKLFT : Number of highest floor reached by elevator
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • .INCLUDE : Cadastral Master Data – data fields
  • CITYCODE : City Code
    Its data type is CHAR (Character String) with field length 4
  • ADMINDIVISION : Administrative Division
    Its data type is CHAR (Character String) with field length 10
  • CENSUSDIVISION : Census Division
    Its data type is CHAR (Character String) with field length 10
  • CITYDIVISION : City Division
    Its data type is CHAR (Character String) with field length 10
  • SHEET : Sheet
    Its data type is CHAR (Character String) with field length 10
  • PARCEL : Parcel
    Its data type is CHAR (Character String) with field length 10
  • QUALITY : Quality
    Its data type is CHAR (Character String) with field length 25
  • DENOMINATOR : Denominator
    Its data type is CHAR (Character String) with field length 10
  • SUBALTERN : Subordinate
    Its data type is CHAR (Character String) with field length 10
  • CLASS : Class of Buildings
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • UIUOBJNR : Object Number
    Its data type is CHAR (Character String) with field length 22
  • UIUINTRENO : Intreno of U.I.U
    Its data type is CHAR (Character String) with field length 13
  • ORIGAOID : Original AO’s AOID
    Its data type is CHAR (Character String) with field length 30
  • DERIVAOID : Derivate AO’s AOID
    Its data type is CHAR (Character String) with field length 30
  • .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

    • VIXCITCADAO related tables

    • VIXCITCADMSR : Temporary measurement data
    • TIVXCITCADCITY : City code
    • TIVXCITIRECALCPA : IRE Calculation parameters
    • VIXCITCADAO : Temporary architectural object data
    • TIVXCITCADMSR : Define the editable measurements
    • TIVXCITCALCDBUD : ICI Calculation coefficient for D-Building
    • TIVXCITSDINT : Settings of Italian Security Deposit Interest Calculation
    • TIVXCITIREVA : IRE Variables
    • TIVXCITF24PYMNT : F24 Payment Data
    • TIVXCITREDUCT : Reduced rate
    • TIVRATAXBOLLOT : Steuergruppe (Text)
    • VIXCITIREOFDAT : IRE Office Data
    • TIVXCITICIRATE : ICI City rate
    • TIVXCITICIPARAM : ICI/IMU City parameter
    • VIXCITCADRO : Temporary rental object data
    • VIXCITICIDATA : ICI master data
    • TIVXCITCALCTYPE : ICI calculation type
    • TIVXCITPAYINST : ICI Payment instalment
    • TIVXCITCADCPY : Cadastral Data to Transfer
    • TIVXCITCADCAT : ICI cadastral category

    VIXCITCADAO related transaction codes under SAP package RE_XC_RA_IT

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

    Related References

    Related Tutorials

    VIXCITCADRO SAP table for – Temporary rental object data

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

    VIBDAO SAP table for – Architectural Object

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

    VIXCITICIDATA SAP table for – ICI master data

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

    TIVXCITAOTYPE SAP table for – Assign object type to architectural object type

    TIVXCITAOTYPE 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...

    TIVBDAROBJTYPE SAP table for – Architectural Object Type

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

    VIBDNODE SAP table for – Higher-Level Architectural Object

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

    «
    »