1. SAP Tutorial
  2. Real Estate Management

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

    • VIORRR related tables

    • TIVORINFLOWFROM : Source of Prospect
    • TIVORINFLOWREAST : Reason for Search (Text)
    • TIVORINFLOWFROMT : Source of Prospect (Text)
    • TIVOREDITINDT : Processing Indicator (Text)
    • TIVORMEAS : Measurements for RE Search Request Type
    • TIVORDISTLOC : District Location
    • TIVORINFLOWWAY : Source of Inquiry
    • TIVORAECPERSONT : Person Group for Accom. Entitlement Certificate (Texts)
    • VIORRRBE : Business Entities for RE Search Request
    • TIVORDISTLOCT : District Location (Text)
    • TIVORAECPRIOT : Priority for Accommodation Entitlement Certificate
    • TIVOREDITSTAT : Processing Status
    • TIVORRRTYPET : RE Search Request Type (Text)
    • TIVORPRESELECT : Preselection Indicator
    • TIVORAECINFOT : Additional Info for Accom. Entitlement Certificate (Texts)
    • TIVORINFLOWREAS : Reason for Search
    • TIVORCHARACT : Fixt./Fittings Characteristic for Real Estate Search
    • TIVORAECPERSON : Person Group for Accommodation Entitlement Certificate
    • TIVORTRANSPCONN : Transport Connections
    • TIVOREDITIND : Processing Indicator

    VIORRR related transaction codes under SAP package RE_OR_RR

    • REORRR0106 : RR: Assignmt Object Part –> MemoID
    • REORRR0006 : RR: Screen Sequences
    • REORRRARE : Display RE Search Requests (Archive)
    • REORRR0018 : RR: Activities
    • REORRR0008 : RR: CUA Standard Functions
    • REORRR0016 : RR: Tables
    • REORRR0012 : RR: Field Modification Criteria
    • REORRR0103 : RR: Field Groups for Authorization
    • REORRR0011 : RR: Assignment Screen Fld->DB Field
    • REORRR0017 : RR: External Applications
    • REORRR0009 : RR: CUA Additional Functions
    • REORRRCHECK : Mass Check: RE Search Requests
    • REORRR0007 : RR: Events
    • REORRR0002 : RR: Field Groups
    • REORRR : Edit RE Search Request
    • REORRR0022 : RR: Where-Used List: Structure
    • REORRR0004 : RR: Sections
    • REORRR0019 : RR: Field Mod. per Activity (Control
    • REORRR0001 : RR: Applications
    • REORRR0003 : RR: Views

    Related References

    Related Tutorials

    TIVORCOND SAP table for – Conditions for RE Search Request Type

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

    TIVAR08 SAP table for – RE: REsearch – Preassignment For Offer Object/Rental Request

    TIVAR08 table in SAP RE (Rental in RE) module. This table is used for storing data of RE: REsearch -...

    VIAR04 SAP table for – RE: REsearch – Rental Request – Offer

    VIAR04 table in SAP RE (Rental in RE) module. This table is used for storing data of RE: REsearch -...

    VILMNAVAL SAP table for – Notice of Assessment: Annual Values

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

    VISCS_SU_RO SAP table for – Sum of All Costs and Measurement Amounts for a Rental Object

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

    VIOROO SAP table for – Offered Object

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

    VISRTMSBRP SAP table for – Assignment of a Reporting Rule to a Sales Rule

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

    «
    »