VIORRS SAP table for – Reservation

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

SAP VIORRS table

Table VIORRS technical data

TableVIORRS
Data storingReservation
ModuleRE
Sub ModuleRE-FX-RS
SAP PackageRE_OR_RS
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • RSGUID : GUID for Reservation
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Reservation: Non-Key Fields
  • RSIDEXT : External ID for Reservation
    Its data type is CHAR (Character String) with field length 45
  • OBJNROO : Object Number
    Its data type is CHAR (Character String) with field length 22
  • OCCUPANT : Occupant
    Its data type is CHAR (Character String) with field length 10
  • OCCUPANTROLE : Role of Occupant
    Its data type is CHAR (Character String) with field length 6
  • VALIDFROM : Reserved From
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • VALIDTO : Reserved To
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • RSOBJTYPE : Reservation Object Type
    Its data type is CHAR (Character String) with field length 2
  • RSTYPE : Reservation Type
    Its data type is CHAR (Character String) with field length 2
  • RSRECGUID : GUID for Recurring Reservation
    Its data type is RAW (Byte string) with field length 16
  • RECVALIDFROM : Reserved From (As Per Recurring Appointment)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • RECVALIDTO : Reserved To (As Per Recurring Appointment)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • STATEIND : Single Appointment Status
    Its data type is CHAR (Character String) with field length 1
  • ISREVERSED : Reservation Canceled
    Its data type is CHAR (Character String) with field length 1
  • ISOCCEXT : External Reservation
    Its data type is CHAR (Character String) with field length 1
  • SETTLETYPE : Billing Type
    Its data type is CHAR (Character String) with field length 1
  • OBJNRCN : Outline Agreement
    Its data type is CHAR (Character String) with field length 22
  • XRS : Description of Reservation
    Its data type is CHAR (Character String) with field length 60
  • EXTINVREC : Bill-To Party
    Its data type is CHAR (Character String) with field length 10
  • RSRESPONSIBLE : Reservation Requester
    Its data type is CHAR (Character String) with field length 10
  • RSRESPROLE : Business Partner: Role
    Its data type is CHAR (Character String) with field length 6
  • NUMPARTICIPANTS : Number of Attendees
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • PARTICIPLISTGUID : GUID for List of Attendees
    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
  • TZONE : Time Zone
    Its data type is CHAR (Character String) with field length 6
  • FDELETE : Deletion Indicator for Archiving
    Its data type is CHAR (Character String) with field length 1
  • RESPONSIBLEUSER : Reservation Requester (User)
    Its data type is CHAR (Character String) with field length 12
  • OCCUPANTUSER : Occupant (User)
    Its data type is CHAR (Character String) with field length 12