SAP VIORRS Reservation Table
Overview
VIORRS is a standard SAP S/4HANA table that stores Reservation data. There are total 38 fields in the VIORRS table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIORRS belongs to Room Reservations and Seating Arrangements (RE-FX-RS) module and is located in the package RE: Reservation (RE_OR_RS).
In addition, following links provide an overview of foreign key relationships, if any, that link VIORRS to other SAP tables and standard CDS views available based on VIORRS table in S/4HANA 2020.
Techincal Settings of VIORRS
Below are technical details of the table VIORRS
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIORRS Fields
The following table gives you an overview of the fields available in VIORRS
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| RSGUID | GUID for Reservation | REORRSGUID | RAW | 16 | |
| RSIDEXT | External ID for Reservation | REORRSIDEXT | CHAR | 45 | |
| OBJNROO | Object Number | RECAOBJNR | * | CHAR | 22 |
| OCCUPANT | Occupant | REOROCCUPANT | BUT000 | CHAR | 10 |
| OCCUPANTROLE | Role of Occupant | REOROCCUPANTROLE | * | CHAR | 6 |
| VALIDFROM | Reserved From | REORRSVALIDFROM | DEC | 15 | |
| VALIDTO | Reserved To | REORRSVALIDTO | DEC | 15 | |
| RSOBJTYPE | Reservation Object Type | REORRSOBJTYPE | TIVORRSOBJTYPE | CHAR | 2 |
| RSTYPE | Reservation Type | REORRSTYPE | TIVORRSTYPE | CHAR | 2 |
| RSRECGUID | GUID for Recurring Reservation | REORRSRECGUID | VIORRSREC | RAW | 16 |
| RECVALIDFROM | Reserved From (As Per Recurring Appointment) | REORRSRECVALIDFROM | DEC | 15 | |
| RECVALIDTO | Reserved To (As Per Recurring Appointment) | REORRSRECVALIDTO | DEC | 15 | |
| STATEIND | Single Appointment Status | REORRSSTATEIND | CHAR | 1 | |
| ISREVERSED | Reservation Canceled | REORISREVERSED | CHAR | 1 | |
| ISOCCEXT | External Reservation | REORRSISOCCEXT | CHAR | 1 | |
| SETTLETYPE | Billing Type | REORSETTLETYPE | CHAR | 1 | |
| OBJNRCN | Outline Agreement | REOROBJNRCN | * | CHAR | 22 |
| XRS | Description of Reservation | REORXRS | CHAR | 60 | |
| EXTINVREC | Bill-To Party | REOREXTINVREC | * | CHAR | 10 |
| RSRESPONSIBLE | Reservation Requester | REORRSRESPONSIBLE | * | CHAR | 10 |
| RSRESPROLE | Business Partner: Role | REBPROLE | * | CHAR | 6 |
| NUMPARTICIPANTS | Number of Attendees | REORNUMPARTICIPANTS | INT4 | 10 | |
| PARTICIPLISTGUID | GUID for List of Attendees | REORPARTICIPLISTGUID | RAW | 16 | |
| RERF | Entered By | RERF | CHAR | 12 | |
| DERF | First Entered On | DERF | DATS | 8 | |
| TERF | Time of Creation | TERF | TIMS | 6 | |
| REHER | Source of Initial Entry | REHER | CHAR | 10 | |
| RBEAR | Employee ID | RBEAR | CHAR | 12 | |
| DBEAR | Last Edited On | DBEAR | DATS | 8 | |
| TBEAR | Last Edited At | TBEAR | TIMS | 6 | |
| RBHER | Editing Source | RBHER | CHAR | 10 | |
| TZONE | Time Zone | TZNZONE | TTZZ | CHAR | 6 |
| FDELETE | Deletion Indicator for Archiving | RECAARDELETEIND | CHAR | 1 | |
| RESPONSIBLEUSER | Reservation Requester (User) | REORRESPONSIBLEUSER | * | CHAR | 12 |
| OCCUPANTUSER | Occupant (User) | REOROCCUPANTUSER | * | CHAR | 12 |
| EXTINVRECROLE | Role of Invoice Recipient | REORINVRECROLE | * | CHAR | 6 |
| INVRECADDRTYPE | Address Type | REBPADDRTYPE | * | CHAR | 10 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VIORRS
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIORRS | OCCUPANT | : | BUT000 |
| VIORRS | RSOBJTYPE | : | TIVORRSOBJTYPE |
| VIORRS | RSRECGUID | : | VIORRSREC |
| VIORRS | RSRESPONSIBLE | : | * |
| VIORRS | RSTYPE | : | TIVORRSTYPE |
| VIORRS | TZONE | : | TTZZ |