SAP VIORRSREC Recurring Reservation Table
Overview
VIORRSREC is a standard SAP S/4HANA table that stores Recurring Reservation data. There are total 35 fields in the VIORRSREC table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIORRSREC 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 VIORRSREC to other SAP tables and standard CDS views available based on VIORRSREC table in S/4HANA 2020.
Techincal Settings of VIORRSREC
Below are technical details of the table VIORRSREC
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIORRSREC Fields
The following table gives you an overview of the fields available in VIORRSREC
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| RSRECGUID | GUID for Recurring Reservation | REORRSRECGUID | RAW | 16 | |
| OCCUPANT | Occupant | REOROCCUPANT | BUT000 | CHAR | 10 |
| OCCUPANTROLE | Role of Occupant | REOROCCUPANTROLE | * | CHAR | 6 |
| OBJNROO | Object Number | RECAOBJNR | * | CHAR | 22 |
| RECURNO | Recurrence Rule | RECARECURNO | NUMC | 10 | |
| RSOBJTYPE | Reservation Object Type | REORRSOBJTYPE | TIVORRSOBJTYPE | CHAR | 2 |
| RSTYPE | Reservation Type | REORRSTYPE | TIVORRSTYPE | CHAR | 2 |
| ACCTASSOBJNR | Account Assignment Object for Object | REORACCTASSOBJNR | * | CHAR | 22 |
| STANDARDPRICE | Price per Unit for Object | REORSTDPRICE | CURR | 15 | |
| PRICECURRKEY | Currency | REORCURRKEY | * | CUKY | 5 |
| PRICEUNIT | Unit for Unit Price | REORPRICEUNIT | * | UNIT | 3 |
| ISREVERSED | Reservation Canceled | REORISREVERSED | CHAR | 1 | |
| ISOCCEXT | External Reservation | REORRSISOCCEXT | CHAR | 1 | |
| XRSREC | Description of Recurring Reservation | REORXRSREC | CHAR | 60 | |
| EXTINVREC | Bill-To Party | REOREXTINVREC | * | CHAR | 10 |
| RSRESPONSIBLE | Reservation Requester | REORRSRESPONSIBLE | BUT000 | 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 | |
| VALIDFROM | Start of a Recurring Appointment | RECARECURVALIDFROM | DATS | 8 | |
| VALIDTO | End of a Recurring Appointment | RECARECURVALIDTO | DATS | 8 | |
| OBJNRCN | Outline Agreement | REOROBJNRCN | * | CHAR | 22 |
| SETTLETYPE | Billing Type | REORSETTLETYPE | CHAR | 1 | |
| RESPONSIBLEUSER | Reservation Requester (User) | REORRESPONSIBLEUSER | * | CHAR | 12 |
| OCCUPANTUSER | Occupant (User) | REOROCCUPANTUSER | * | CHAR | 12 |
| FDELETE | Deletion Indicator for Archiving | RECAARDELETEIND | CHAR | 1 |
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 VIORRSREC
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIORRSREC | OCCUPANT | : | BUT000 |
| VIORRSREC | RSOBJTYPE | : | TIVORRSOBJTYPE |
| VIORRSREC | RSRESPONSIBLE | : | BUT000 |
| VIORRSREC | RSTYPE | : | TIVORRSTYPE |