VIORPO SAP table for – Continuous Occupancy

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

SAP VIORPO table

Table VIORPO technical data

TableVIORPO
Data storingContinuous Occupancy
ModuleRE
Sub ModuleRE-FX-RS
SAP PackageRE_OR_PO
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Continuous Occupancy – Header Data – Key Fields
    Its a key field.
  • POGUID : GUID for Continuous Occupancy
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Continuous Occupancy – Header Data – Non-Key Fields
  • 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
  • OCCUPANTOBJNR : Assigned Object
    Its data type is CHAR (Character String) with field length 22
  • VALIDFROM : Occupancy Effective From
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALIDTO : Occupancy Effective To
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • OCCPOSITION : Desk Assignment of Occupant
    Its data type is CHAR (Character String) with field length 10
  • PLANRESP : Assignment Planner
    Its data type is CHAR (Character String) with field length 10
  • PLANRESPROLE : Role of Assignment Planner
    Its data type is CHAR (Character String) with field length 6
  • PLANIND : Actual Entry or Plan Entry
    Its data type is CHAR (Character String) with field length 1
  • PLANSTATUS : Status of Actual/Planned Occupancy
    Its data type is CHAR (Character String) with field length 1
  • PLANTYPE : Planning Type
    Its data type is CHAR (Character String) with field length 1
  • PLANENTRYTYPE : Type of Plan Entry (Internal)
    Its data type is CHAR (Character String) with field length 1
  • PLANIGNORE : Ignore Plan Entry
    Its data type is CHAR (Character String) with field length 1
  • ISPERIODMANUAL : Planned Occupancy Period Changed Manually
    Its data type is CHAR (Character String) with field length 1
  • MPID : Move Plan ID
    Its data type is CHAR (Character String) with field length 10
  • ACCTASSOBJNR : Account Assignment Object – Occupant/Host
    Its data type is CHAR (Character String) with field length 22
  • PRICEFACTOR : Price Multiplier
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • ISOCCEXT : External Reservation
    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
  • XPO : Comment for Continuous Occupancy
    Its data type is CHAR (Character String) with field length 100
  • OCCOBJEXT : ID of Assigned Object
    Its data type is CHAR (Character String) with field length 45
  • POSRCGUID : GUID of Source Entry
    Its data type is RAW (Byte string) with field length 16
  • PODESTGUID : GUID of Target Entry
    Its data type is RAW (Byte string) with field length 16
  • POPLANGUID : GUID for Reference Entry for Planning
    Its data type is RAW (Byte string) with field length 16
  • OCCQUOTENUM : Degree of Occupancy – Numerator
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 30
  • OCCQUOTEDENOM : Degree of Occupancy – Denominator
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 30
  • .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
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes