VIORRR SAP table for – Rental Request

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

SAP VIORRR table

Table VIORRR technical data

TableVIORRR
Data storingRental Request
ModuleRE
Sub ModuleRE-FX-OR
SAP PackageRE_OR_RR
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • INTRENO : Internal Key of Real Estate Object
    Its a key field. Its data type is CHAR (Character String) with field length 13
  • .INCLUDE : RE Search Request: Key Fields
  • RRID : RE Search Request Number
    Its data type is CHAR (Character String) with field length 20
  • .INCLUDE : RE Search Request: Non-Key Fields
  • OBJNR : Object Number
    Its data type is CHAR (Character String) with field length 22
  • CREATIONTYPE : How the Object Was Created
    Its data type is CHAR (Character String) with field length 1
  • .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
  • AUTHGRP : Authorization Group
    Its data type is CHAR (Character String) with field length 40
  • RRCNBEG : Requested Contract Start Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RRCNEND : Requested Contract End Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RRCNBEGLATER : Later Contract Start Date Possible
    Its data type is CHAR (Character String) with field length 1
  • RRTYPE : Type of RE Search Request
    Its data type is CHAR (Character String) with field length 2
  • ACQUISTYPE : Lease/Buy
    Its data type is CHAR (Character String) with field length 2
  • XRR : Text for RE Search Request
    Its data type is CHAR (Character String) with field length 255
  • SEARCHTERM : Text Search
    Its data type is CHAR (Character String) with field length 45
  • .INCLU-01 : Maximum Amount for Condition Group
  • CDVALUETO01 : Maximum Condition Amount
    Its data type is CURR (Currency Field) with field length 15
  • CDVALUETOL01 : Maximum Condition Amount Including Tolerance Limit
    Its data type is CURR (Currency Field) with field length 15
  • CDCURR01 : Currency of condition item
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • .INCLU-02 : Maximum Amount for Condition Group
  • CDVALUETO02 : Maximum Condition Amount
    Its data type is CURR (Currency Field) with field length 15
  • CDVALUETOL02 : Maximum Condition Amount Including Tolerance Limit
    Its data type is CURR (Currency Field) with field length 15
  • CDCURR02 : Currency of condition item
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • .INCLU-03 : Maximum Amount for Condition Group
  • CDVALUETO03 : Maximum Condition Amount
    Its data type is CURR (Currency Field) with field length 15
  • CDVALUETOL03 : Maximum Condition Amount Including Tolerance Limit
    Its data type is CURR (Currency Field) with field length 15
  • CDCURR03 : Currency of condition item
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • .INCLU-04 : Maximum Amount for Condition Group
  • CDVALUETO04 : Maximum Condition Amount
    Its data type is CURR (Currency Field) with field length 15
  • CDVALUETOL04 : Maximum Condition Amount Including Tolerance Limit
    Its data type is CURR (Currency Field) with field length 15
  • CDCURR04 : Currency of condition item
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • .INCLU-01 : Size Restrictions for Measurement Type
  • MSVALUEFROM01 : Minimum Measurement
    Its data type is QUAN (Quantity field) with field length 17
  • MSVALUETO01 : Maximum Measurement
    Its data type is QUAN (Quantity field) with field length 17
  • MSVALUETOLFROM01 : Minimum Measurement Including Tolerance Limit
    Its data type is QUAN (Quantity field) with field length 17
  • MSVALUETOLTO01 : Maximum Measurement Including Tolerance
    Its data type is QUAN (Quantity field) with field length 17
  • MSUNIT01 : Measurement Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • .INCLU-02 : Size Restrictions for Measurement Type
  • MSVALUEFROM02 : Minimum Measurement
    Its data type is QUAN (Quantity field) with field length 17
  • MSVALUETO02 : Maximum Measurement
    Its data type is QUAN (Quantity field) with field length 17
  • MSVALUETOLFROM02 : Minimum Measurement Including Tolerance Limit
    Its data type is QUAN (Quantity field) with field length 17
  • MSVALUETOLTO02 : Maximum Measurement Including Tolerance
    Its data type is QUAN (Quantity field) with field length 17
  • MSUNIT02 : Measurement Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • .INCLU-03 : Size Restrictions for Measurement Type
  • MSVALUEFROM03 : Minimum Measurement
    Its data type is QUAN (Quantity field) with field length 17
  • MSVALUETO03 : Maximum Measurement
    Its data type is QUAN (Quantity field) with field length 17
  • MSVALUETOLFROM03 : Minimum Measurement Including Tolerance Limit
    Its data type is QUAN (Quantity field) with field length 17
  • MSVALUETOLTO03 : Maximum Measurement Including Tolerance
    Its data type is QUAN (Quantity field) with field length 17
  • MSUNIT03 : Measurement Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • .INCLU-04 : Size Restrictions for Measurement Type
  • MSVALUEFROM04 : Minimum Measurement
    Its data type is QUAN (Quantity field) with field length 17
  • MSVALUETO04 : Maximum Measurement
    Its data type is QUAN (Quantity field) with field length 17
  • MSVALUETOLFROM04 : Minimum Measurement Including Tolerance Limit
    Its data type is QUAN (Quantity field) with field length 17
  • MSVALUETOLTO04 : Maximum Measurement Including Tolerance
    Its data type is QUAN (Quantity field) with field length 17
  • MSUNIT04 : Measurement Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • RRFLOORSTR : Floor
    Its data type is CHAR (Character String) with field length 255
  • RRREGLOCSTR : Regional Location
    Its data type is CHAR (Character String) with field length 255
  • RRLOCATIONSTR : Location
    Its data type is CHAR (Character String) with field length 255
  • RRLOCATIONNESTR : Location
    Its data type is CHAR (Character String) with field length 255
  • RRDISTLOCSTR : District Location
    Its data type is CHAR (Character String) with field length 255
  • RRTRANSPCONNSTR : Transport Connections
    Its data type is CHAR (Character String) with field length 255
  • BUILDAGEFROM : Building Age From
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BUILDAGETO : Building Age To
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RRCHARACTSTR : Fixtures and Fittings Characteristic String
    Its data type is CHAR (Character String) with field length 80
  • .INCLUDE : Address for Real Estate Search
  • COUNTRY : Country Key
    Its data type is CHAR (Character String) with field length 3
  • REGION : Region (State, Province, County)
    Its data type is CHAR (Character String) with field length 3
  • POST_CODE1 : City postal code
    Its data type is CHAR (Character String) with field length 10
  • CITY1 : City
    Its data type is CHAR (Character String) with field length 40
  • CITY2 : District
    Its data type is CHAR (Character String) with field length 40
  • STREET : Street
    Its data type is CHAR (Character String) with field length 60
  • HOUSE_NUM1 : House Number
    Its data type is CHAR (Character String) with field length 10
  • NEIGHBORHOODSTR : Neighborhood
    Its data type is CHAR (Character String) with field length 255
  • EDITINDICATOR : Processing Indicator for RE Search Request
    Its data type is CHAR (Character String) with field length 2
  • EDITSTATUS : Processing Status for RE Search Request
    Its data type is CHAR (Character String) with field length 2
  • PRESELECTION : Preselection Indicator for RE Search Request
    Its data type is CHAR (Character String) with field length 2
  • INFLOWFROM : Source of Prospect
    Its data type is CHAR (Character String) with field length 2
  • INFLOWREASON : Reason for Search
    Its data type is CHAR (Character String) with field length 2
  • INFLOWWAY : Source of Inquiry
    Its data type is CHAR (Character String) with field length 2
  • RRSEARCHPART : Participation in Search
    Its data type is CHAR (Character String) with field length 1
  • AECEXISTS : Accommodation Entitlement Certificate Exists
    Its data type is CHAR (Character String) with field length 1
  • AECCLASSSTR : AEC Level String
    Its data type is CHAR (Character String) with field length 60
  • AECDATEOFISSUE : Issue Date of Accommodation Entitlement Certificate
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AECVALIDTO : Accommodation Entitlement Certificate Valid To
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AECPRIORITY : Priority for Accommodation Entitlement Certificate
    Its data type is CHAR (Character String) with field length 4
  • AECPERSONGROUP : Person Group for Accommodation Entitlement Certificate
    Its data type is CHAR (Character String) with field length 4
  • AECINFO : Additional Info for Accommodation Entitlement Certificate
    Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes