SAP VIBDROOCC Occupancy History Table
Overview
VIBDROOCC is a standard SAP S/4HANA table that stores Occupancy History data. There are total 25 fields in the VIBDROOCC table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIBDROOCC belongs to Basic Data (RE-FX-BD) module and is located in the package RE: Occupancy (Occupancy History and Vacancy Reason) (RE_BD_OC).
In addition, following links provide an overview of foreign key relationships, if any, that link VIBDROOCC to other SAP tables and standard CDS views available based on VIBDROOCC table in S/4HANA 2020.
Techincal Settings of VIBDROOCC
Below are technical details of the table VIBDROOCC
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIBDROOCC Fields
The following table gives you an overview of the fields available in VIBDROOCC
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| ROOCCGUID | GUID That Makes Vacancy Record Unique | REBDROOCCGUID | RAW | 16 | |
| INTRENO | Internal Object Number for Rental Object (INTRENO) | REBDINTRENORO | CHAR | 13 | |
| OCCFROM | Start of Occupancy/Vacancy | REBDOCCFROM | DATS | 8 | |
| OBJNR | Object Number | RECAOBJNR | * | CHAR | 22 |
| OCCTO | End of Occupancy/Vacancy | REBDOCCTO | DATS | 8 | |
| VACREASON | Vacancy Reason | REBDVACREASON | TIVBDVACREAS | CHAR | 4 |
| ISVACANT | Is Rental Object Vacant During Period? | REBDISVACANT | CHAR | 1 | |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| SWENR | Business Entity Number | REBDBENO | * | CHAR | 8 |
| SMENR | Number of Rental Object | REBDRONO | CHAR | 8 | |
| ROTYPE | Rental Object Type | REBDROTYPE | CHAR | 2 | |
| USAGETYPE | Usage Type of Rental Object | REBDUSAGETYPE | TIV01 | NUMC | 4 |
| XMETXT | Rental Object Name | REBDXRO | CHAR | 60 | |
| PSNO | Number of Pooled Space of Rental Space | REBDPSNO | CHAR | 8 | |
| VACINFLRENTAL | How Does Vacancy Period Influence Subsequent Rental? | REBDVACINFLRENTAL | CHAR | 1 | |
| RNINFLRENTAL | Influence of Renewal Rule on Follow-On Processes | REBDRNINFLRENTAL | CHAR | 1 | |
| TERMNOVAC | Number of Posting Term to Be Used for Posting | REBDTMNOVAC | VITMTERM | CHAR | 4 |
| OCCCNBUKRS | Company Code of Occupancy Contract | REBDOCCCNBUKRS | T001 | CHAR | 4 |
| OCCRECNNR | Contract Number of Occupancy Contract | REBDOCCRECNNR | CHAR | 13 | |
| RESCNBUKRS | Company Code of Reserving Contract | REBDRESBUKRS | T001 | CHAR | 4 |
| RESRECNNR | Contract Number of Reserving Contract | REBDRESRECNNR | CHAR | 13 | |
| OFID | Contract Offer Number | REOROFID | CHAR | 13 | |
| RNNOTDATE | Notification By | RETMRNNOTDATE | DATS | 8 | |
| RNENDMAX | Latest Day on Which Contract Ends (All Options) | RETMRNENDMAX | DATS | 8 |
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 VIBDROOCC
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIBDROOCC | BUKRS | 1: CN | T001 |
| VIBDROOCC | OCCCNBUKRS | C: CN | T001 |
| VIBDROOCC | RESCNBUKRS | C: CN | T001 |
| VIBDROOCC | TERMNOVAC | C: CN | VITMTERM |
| VIBDROOCC | USAGETYPE | 1: CN | TIV01 |
| VIBDROOCC | VACREASON | 1: CN | TIVBDVACREAS |