VIXCESIBIDATA SAP table for – IBI master data

Here we would like to draw your attention to VIXCESIBIDATA table in SAP. As we know it is being mainly used with the SAP FI-LOC (Localization in FI) component which is coming under FI module (Financial Accounting). VIXCESIBIDATA is a SAP standard transp table used for storing IBI master data related data in SAP. It comes under the package GLO_REFX_ES_RA.

SAP VIXCESIBIDATA table

Table VIXCESIBIDATA technical data

TableVIXCESIBIDATA
Data storingIBI master data
ModuleFI
Sub ModuleFI-LOC
SAP PackageGLO_REFX_ES_RA
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Key for IBI master data (VIXCESIBIDATA)
    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 : IBI Data – data fields
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • 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
  • IBIAMOUNT : Property Tax Amount
    Its data type is CURR (Currency Field) with field length 15
  • IBICALCAMOUNT : Calculated Property Tax Amount
    Its data type is CURR (Currency Field) with field length 15
  • CITY : Municipality Code
    Its data type is CHAR (Character String) with field length 5
  • IBIRATE : Property Tax Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • ISMANUALAMOUNT : Tax Amount Entered Manually
    Its data type is CHAR (Character String) with field length 1
  • VPT : Tax Base Amount
    Its data type is CURR (Currency Field) with field length 15
  • TAXCATID : Property Tax Category
    Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : Discharge
  • DISCHRGID : Tax Discount Code
    Its data type is CHAR (Character String) with field length 4
  • DISCHRGAMNT : Discount Amount
    Its data type is CURR (Currency Field) with field length 15
  • DSCNTAPPL : Applicable Tax Discount Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • .INCLUDE : Surcharge
  • SURCHRGID : Surcharge Code
    Its data type is CHAR (Character String) with field length 4
  • SURCHRGFROM : Valid From Date of Surcharge Calculation
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SURCHRGAMNT : Surcharge Amount
    Its data type is CURR (Currency Field) with field length 15
  • .INCLUDE : IBI Installments
  • INSTDATE1 : Due Date of Installment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • INSTAMOUNT1 : Amount of Installment
    Its data type is CURR (Currency Field) with field length 15
  • INSTDATE2 : Due Date of Installment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • INSTAMOUNT2 : Amount of Installment
    Its data type is CURR (Currency Field) with field length 15
  • INSTDATE3 : Due Date of Installment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • INSTAMOUNT3 : Amount of Installment
    Its data type is CURR (Currency Field) with field length 15
  • INSTDATE4 : Due Date of Installment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • INSTAMOUNT4 : Amount of Installment
    Its data type is CURR (Currency Field) with field length 15
  • INSTDATE5 : Due Date of Installment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • INSTAMOUNT5 : Amount of Installment
    Its data type is CURR (Currency Field) with field length 15
  • INSTDATE6 : Due Date of Installment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • INSTAMOUNT6 : Amount of Installment
    Its data type is CURR (Currency Field) with field length 15
  • INSTDATE7 : Due Date of Installment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • INSTAMOUNT7 : Amount of Installment
    Its data type is CURR (Currency Field) with field length 15
  • INSTDATE8 : Due Date of Installment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • INSTAMOUNT8 : Amount of Installment
    Its data type is CURR (Currency Field) with field length 15
  • INSTDATE9 : Due Date of Installment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • INSTAMOUNT9 : Amount of Installment
    Its data type is CURR (Currency Field) with field length 15
  • INSTDATE10 : Due Date of Installment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • INSTAMOUNT10 : Amount of Installment
    Its data type is CURR (Currency Field) with field length 15
  • INSTDATE11 : Due Date of Installment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • INSTAMOUNT11 : Amount of Installment
    Its data type is CURR (Currency Field) with field length 15
  • INSTDATE12 : Due Date of Installment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • INSTAMOUNT12 : Amount of Installment
    Its data type is CURR (Currency Field) with field length 15
  • ISRECORDLOCKED : IBI Record Locked for Recalculation
    Its data type is CHAR (Character String) with field length 1
  • ACCTASSIGOBJNR : Account Assignment Object Number
    Its data type is CHAR (Character String) with field length 22
  • LIABLE_TAX : Liable Property Tax Amount
    Its data type is CURR (Currency Field) with field length 15
  • AWKEY1 : Reference Key
    Its data type is CHAR (Character String) with field length 20
  • AWTYP1 : Reference procedure
    Its data type is CHAR (Character String) with field length 5
  • AWKEY2 : Reference Key
    Its data type is CHAR (Character String) with field length 20
  • AWTYP2 : Reference procedure
    Its data type is CHAR (Character String) with field length 5
  • AWKEY3 : Reference Key
    Its data type is CHAR (Character String) with field length 20
  • AWTYP3 : Reference procedure
    Its data type is CHAR (Character String) with field length 5
  • AWKEY4 : Reference Key
    Its data type is CHAR (Character String) with field length 20
  • AWTYP4 : Reference procedure
    Its data type is CHAR (Character String) with field length 5
  • AWKEY5 : Reference Key
    Its data type is CHAR (Character String) with field length 20
  • AWTYP5 : Reference procedure
    Its data type is CHAR (Character String) with field length 5
  • AWKEY6 : Reference Key
    Its data type is CHAR (Character String) with field length 20
  • AWTYP6 : Reference procedure
    Its data type is CHAR (Character String) with field length 5
  • AWKEY7 : Reference Key
    Its data type is CHAR (Character String) with field length 20
  • AWTYP7 : Reference procedure
    Its data type is CHAR (Character String) with field length 5
  • AWKEY8 : Reference Key
    Its data type is CHAR (Character String) with field length 20
  • AWTYP8 : Reference procedure
    Its data type is CHAR (Character String) with field length 5
  • AWKEY9 : Reference Key
    Its data type is CHAR (Character String) with field length 20
  • AWTYP9 : Reference procedure
    Its data type is CHAR (Character String) with field length 5
  • AWKEY10 : Reference Key
    Its data type is CHAR (Character String) with field length 20
  • AWTYP10 : Reference procedure
    Its data type is CHAR (Character String) with field length 5
  • AWKEY11 : Reference Key
    Its data type is CHAR (Character String) with field length 20
  • AWTYP11 : Reference procedure
    Its data type is CHAR (Character String) with field length 5
  • AWKEY12 : Reference Key
    Its data type is CHAR (Character String) with field length 20
  • AWTYP12 : Reference procedure
    Its data type is CHAR (Character String) with field length 5
  • PARTNER : Business Partner Number
    Its data type is CHAR (Character String) with field length 10
  • .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