VIXCITIREDATA SAP table for – IRE master data

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

SAP VIXCITIREDATA table

Table VIXCITIREDATA technical data

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

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Key for IRE master data (VIXCITIREDATA)
    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
  • BILLDATE : IRE Date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : IRE data – data fields
  • CURRENCY : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • IRECALCTYPE : IRE Calculation Type ID
    Its data type is CHAR (Character String) with field length 2
  • RENTAL : IRE Monthly Rental Amount
    Its data type is CURR (Currency Field) with field length 15
  • RTAXAMOUNT : IRE Rental Taxable Amount
    Its data type is CURR (Currency Field) with field length 15
  • IREPERCENT : IRE Tax Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • REDPERCENT : IRE Reduction Percentage
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • IREAMOUNT : IRE Tax Amount
    Its data type is CURR (Currency Field) with field length 15
  • ISPAYB : IRE Pay Back Indicator
    Its data type is CHAR (Character String) with field length 1
  • IREPAYB : IRE Expenses Pay-Back
    Its data type is CURR (Currency Field) with field length 15
  • PERCENPAYB : IRE Pay-Back Percentage
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • XACCPOS : IRE Accounting position description
    Its data type is CHAR (Character String) with field length 60
  • ISACTIVE : IRE Record active for posting
    Its data type is CHAR (Character String) with field length 1
  • PSTDATE : Posting Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TCODE1 : IRE Tax Code
    Its data type is CHAR (Character String) with field length 4
  • TYEAR : IRE Status of Contract
    Its data type is CHAR (Character String) with field length 1
  • TCODE2 : IRE Tax Code
    Its data type is CHAR (Character String) with field length 4
  • TCODE3 : IRE Tax Code
    Its data type is CHAR (Character String) with field length 4
  • TYEARX : IRE Type of year handled as intermediate year
    Its data type is CHAR (Character String) with field length 1
  • IREOFFVALUE : Register Office Charges
    Its data type is CURR (Currency Field) with field length 15
  • REFDOCTYPE : Reference to Document Class
    Its data type is CHAR (Character String) with field length 5
  • REFDOCID : Reference Key of Document
    Its data type is CHAR (Character String) with field length 20
  • LOGSYSTEM : Logical System
    Its data type is CHAR (Character String) with field length 10
  • ISCANCELED : Indicator if the posting is canceled
    Its data type is CHAR (Character String) with field length 1
  • TERMMONTHS : IRE Period in months
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • .INCLUDE : Additional Tax Codes for IRE
  • TAXCODE2AMOUNT : Amount for IRE Tax Code 2
    Its data type is CURR (Currency Field) with field length 15
  • TAXCODE3AMOUNT : Amount for IRE Tax Code 3
    Its data type is CURR (Currency Field) with field length 15
  • ISPAYB_2 : IRE Pay Back Indicator
    Its data type is CHAR (Character String) with field length 1
  • ISPAYB_3 : IRE Pay Back Indicator
    Its data type is CHAR (Character String) with field length 1
  • ISPAYB_OFF_VALUE : IRE Pay Back Indicator
    Its data type is CHAR (Character String) with field length 1
  • ISSUMM_1 : Contributes to IRE Sum
    Its data type is CHAR (Character String) with field length 1
  • ISSUMM_2 : Contributes to IRE Sum
    Its data type is CHAR (Character String) with field length 1
  • ISSUMM_3 : Contributes to IRE Sum
    Its data type is CHAR (Character String) with field length 1
  • ISSUMM_OFF_VALUE : Contributes to IRE Sum
    Its data type is CHAR (Character String) with field length 1
  • IRERENTAXAMOUNT : IRE Total Tax Amount
    Its data type is CURR (Currency Field) with field length 15
  • PAYBACK1RATE : IRE Payback Percentage for Main Tax Code
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • PAYBACK2RATE : IRE Payback Percentage for Tax Code 2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • PAYBACK3RATE : IRE Payback Percentage for Tax Code 3
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • PAYBACKRRATE : IRE Payback Percentage for Reg. Office Value
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • TRANSFER : Transfer of Ownership
    Its data type is CHAR (Character String) with field length 1
  • OBJRENTALCODE : Rental Object Code
    Its data type is CHAR (Character String) with field length 2
  • ONETIMEDEDUCAM : Amount of One-Time Payment Deduction
    Its data type is CURR (Currency Field) with field length 13
  • ISONETIMEPYMNT : Indicator for one-time payment for IRE
    Its data type is CHAR (Character String) with field length 1
  • CFPAYGUID_PB1 : IRE Payback – Cashflow GUID for Taxcode 1
    Its data type is RAW (Byte string) with field length 16
  • CFPAYGUID_PB2 : IRE Payback – Cashflow GUID for Taxcode 2
    Its data type is RAW (Byte string) with field length 16
  • CFPAYGUID_PB3 : IRE Payback – Cashflow GUID for Taxcode 3
    Its data type is RAW (Byte string) with field length 16
  • CFPAYGUID_PB_RO : IRE Payback – Cashflow GUID for Reg. Off. Value
    Its data type is RAW (Byte string) with field length 16
  • .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