1. SAP Tutorial
  2. Real Estate Management

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

    • VIORRS related tables

    • VIORRS : Reservation
    • TIVORRSOBJBO : Derivation of Reservation Object Type from Business Object
    • TIVORRSAREA : Reservation Area
    • TIVORRSOBJTYPET : Reservation Object Type (Text)
    • VIORRSCOST : Reservation – Costs
    • TIVORRSSET : Settings for Reservation
    • VIORRSCOSTREL : Relationship of Reservation to Costs
    • TIVORRSREVT : Cancellation Schema Texts
    • TIVORRSOBJTYPE : Reservation Object Type
    • VIORRSPARTLIST : Attendee List
    • TIVORRSREVRL : Rule for Calculating Cancellation Fees
    • TIVORSRVGRPT : Service Group (Texts)
    • VIORRECCOSTREL : Relationship of Recurring Reservation to Costs
    • TIVORSRVTYPE : Service type
    • TIVORRSREV : Cancellation Schema
    • TIVORSRVGRP : Service Group
    • TIVORPRICECODE : Price Code
    • TIVORPRICECODET : Price Code (Text)
    • TIVORRSTYPET : Reservation Type (Text)
    • TIVORRSAREASRV : Service Groups for Reservation

    VIORRS related transaction codes under SAP package RE_OR_RS

    • REORPDRES1 : Reservation Price: Derivation Rule
    • REORCOST : Costs of Reservation/Cont.Occupancy
    • REORRS : Edit Reservation
    • REORPDSRV1 : Service Price: Derivation Rule
    • REORSRVPROV : Services for Reservation
    • REORCOSTPOSTRSRV : Reversal of Reservations
    • REORRSIDINT : No. Range Maintenance: Reservation
    • REORCANCELRS : Reversal of Reservations
    • REISRSSRV : Services for Reservation
    • REORPDRES2 : Reservation Price: Derivation
    • REORSRVRECV : Services for Reservation
    • REORPDSRV2 : Price of Service: Derivation
    • REORCOSTPOSTRS : Posting of Reservations
    • REORDELEMPTYRS : Delete Empty Reservations
    • REORRSREC : Edit Recurring Reservation

    Related References

    Related Tutorials

    TIVORRSSET SAP table for – Settings for Reservation

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

    TIVORRSAREAT SAP table for – Reservation Area (Text)

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

    TIVORRSOBJTYPET SAP table for – Reservation Object Type (Text)

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

    TIVORRSTYPE SAP table for – Reservation Type

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

    TIVORRSAREA SAP table for – Reservation Area

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

    TIVORRSTYPET SAP table for – Reservation Type (Text)

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

    VIORRECCOSTREL SAP table for – Relationship of Recurring Reservation to Costs

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

    «
    »