1. SAP Tutorial
  2. Real Estate Management

VIOROO SAP table for – Offered Object

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

SAP VIOROO table

Table VIOROO technical data

TableVIOROO
Data storingOffered Object
ModuleRE
Sub ModuleRE-FX-OR
SAP PackageRE_OR_OO
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • INTRENO : Internal Key of Real Estate Object
    Its a key field. Its data type is CHAR (Character String) with field length 13
  • .INCLUDE : Offered Object: Key Fields
  • OOID : Offered Object Number
    Its data type is CHAR (Character String) with field length 20
  • .INCLUDE : Offered Object: Non-Key Fields
  • OBJNR : Object Number
    Its data type is CHAR (Character String) with field length 22
  • CREATIONTYPE : How the Object Was Created
    Its data type is CHAR (Character String) with field length 1
  • .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
  • RESPONSIBLE : Person Responsible
    Its data type is CHAR (Character String) with field length 12
  • USEREXCLUSIVE : User with Exclusive Change Authorization
    Its data type is CHAR (Character String) with field length 12
  • AUTHGRP : Authorization Group
    Its data type is CHAR (Character String) with field length 40
  • OOBEG : Available From
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • OOEND : Available To
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • MEAS : Measurement Type
    Its data type is CHAR (Character String) with field length 4
  • USAGETYPE : Usage Type of Rental Object
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • RSOBJTYPE : Reservation Object Type
    Its data type is CHAR (Character String) with field length 2
  • RSAREA : Reservation Area
    Its data type is CHAR (Character String) with field length 10
  • ACQUISTYPE : Lease/Buy
    Its data type is CHAR (Character String) with field length 2
  • XOO : Text for Offered Object
    Its data type is CHAR (Character String) with field length 255
  • OOIDEXT : External ID of Reservation Object
    Its data type is CHAR (Character String) with field length 45
  • OBJTYPEREF : Object Type
    Its data type is CHAR (Character String) with field length 2
  • OBJNRREF : Object Number
    Its data type is CHAR (Character String) with field length 22
  • OODATAFROM : Offer Data Valid From
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • OODATATO : Offer Data Valid To
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • OORESFROM : Offer Reserved From
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • OORESTO : Offered Object Reserved To
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • BENO : Business Entity Number
    Its data type is CHAR (Character String) with field length 8
  • BUNO : Number of Building
    Its data type is CHAR (Character String) with field length 8
  • PRNO : Number of Land
    Its data type is CHAR (Character String) with field length 8
  • RONO : Number of Rental Object
    Its data type is CHAR (Character String) with field length 8
  • OFID : Contract Offer Number
    Its data type is CHAR (Character String) with field length 13
  • .INCLU-01 : Amount for Condition Group
  • CDVALUE01 : Condition Amount
    Its data type is CURR (Currency Field) with field length 15
  • CDCURR01 : Currency of condition item
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • .INCLU-02 : Amount for Condition Group
  • CDVALUE02 : Condition Amount
    Its data type is CURR (Currency Field) with field length 15
  • CDCURR02 : Currency of condition item
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • .INCLU-03 : Amount for Condition Group
  • CDVALUE03 : Condition Amount
    Its data type is CURR (Currency Field) with field length 15
  • CDCURR03 : Currency of condition item
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • .INCLU-04 : Amount for Condition Group
  • CDVALUE04 : Condition Amount
    Its data type is CURR (Currency Field) with field length 15
  • CDCURR04 : Currency of condition item
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • .INCLU-01 : Measurement Amount
  • MSVALUE01 : Measurement Amount
    Its data type is QUAN (Quantity field) with field length 17
  • MSUNIT01 : Measurement Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • .INCLU-02 : Measurement Amount
  • MSVALUE02 : Measurement Amount
    Its data type is QUAN (Quantity field) with field length 17
  • MSUNIT02 : Measurement Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • .INCLU-03 : Measurement Amount
  • MSVALUE03 : Measurement Amount
    Its data type is QUAN (Quantity field) with field length 17
  • MSUNIT03 : Measurement Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • .INCLU-04 : Measurement Amount
  • MSVALUE04 : Measurement Amount
    Its data type is QUAN (Quantity field) with field length 17
  • MSUNIT04 : Measurement Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • FLOOR : Floor
    Its data type is CHAR (Character String) with field length 2
  • SSTDORT : Regional location
    Its data type is CHAR (Character String) with field length 10
  • SLAGEWE : Business entity location number
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • SOBJLAGE : Indicator: District Location of Object
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • TRANSPCONN : Transport Connections of Business Entity
    Its data type is CHAR (Character String) with field length 1
  • BUILDYEAR : ConstYr
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RRCHARACTSTR : Fixtures and Fittings Characteristic String
    Its data type is CHAR (Character String) with field length 80
  • .INCLUDE : Address for Real Estate Search
  • COUNTRY : Country Key
    Its data type is CHAR (Character String) with field length 3
  • REGION : Region (State, Province, County)
    Its data type is CHAR (Character String) with field length 3
  • POST_CODE1 : City postal code
    Its data type is CHAR (Character String) with field length 10
  • CITY1 : City
    Its data type is CHAR (Character String) with field length 40
  • CITY2 : District
    Its data type is CHAR (Character String) with field length 40
  • STREET : Street
    Its data type is CHAR (Character String) with field length 60
  • HOUSE_NUM1 : House Number
    Its data type is CHAR (Character String) with field length 10
  • NEIGHBORH1 : Neighborhood
    Its data type is CHAR (Character String) with field length 30
  • NEIGHBORH2 : Neighborhood
    Its data type is CHAR (Character String) with field length 30
  • NEIGHBORH3 : Neighborhood
    Its data type is CHAR (Character String) with field length 30
  • AECNEEDED : Accommodation Entitlement Certificate Required
    Its data type is CHAR (Character String) with field length 1
  • AECCLASSSTR : AEC Level String
    Its data type is CHAR (Character String) with field length 60
  • OBJNRCN : Outline Agreement
    Its data type is CHAR (Character String) with field length 22
  • ACCDETKEY : Account Determination Value
    Its data type is CHAR (Character String) with field length 10
  • RESPOBJNRDEF : Responsible Account Assignment Object (Default)
    Its data type is CHAR (Character String) with field length 22
  • RESPOBJNR1 : Responsible Account Assignment Object
    Its data type is CHAR (Character String) with field length 22
  • RESPOBJNR2 : Responsible Account Assignment Object
    Its data type is CHAR (Character String) with field length 22
  • RESPOBJNR3 : Responsible Account Assignment Object
    Its data type is CHAR (Character String) with field length 22
  • RESPOBJNR4 : Responsible Account Assignment Object
    Its data type is CHAR (Character String) with field length 22
  • PRICECODE1 : Price Code
    Its data type is CHAR (Character String) with field length 10
  • PRICECODE2 : Price Code
    Its data type is CHAR (Character String) with field length 10
  • PRICECODE3 : Price Code
    Its data type is CHAR (Character String) with field length 10
  • PRICECODE4 : Price Code
    Its data type is CHAR (Character String) with field length 10
  • LOCKEDFROM : Start of Lock Period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LOCKEDTO : End of Lock Period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LOCKREASON : Lock Reason
    Its data type is CHAR (Character String) with field length 4
  • XLOCKREASONEXT : Other Lock Reason
    Its data type is CHAR (Character String) with field length 100
  • BILLEDTO : Date Up to Which Postings Were Made
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • NTPER : Contract Notice Per
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • NTREQUESTON : Tenant’s notice request date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BILLFROM : First Posting From
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes

    • VIOROO related tables

    • TIVOROBJSTATRST : Reason for Status (Text)
    • TIVOROOUPDATE : Control Data Update Offered Object
    • VIOROBJSTATUS : Search Status
    • TIVOROBJSTATRS : Reason for Status
    • TIVOROBJSTATUS : Search Status
    • TIVOROBJSTATUST : Search Status (Text)
    • TIVORRRTYPEMTC : Usage Types for RE Search Request Type
    • TIVORLOCKRS : Lock Reasons for Reservation Objects
    • VIOROO : Offered Object
    • TIVORLOCKRST : Lock Reasons for Reservation Objects – Texts

    VIOROO related transaction codes under SAP package RE_OR_OO

    • REOROO0103 : OO: Field Groups for Authorization
    • REOROO0007 : OO: Events
    • REOROO0006 : OO: Screen Sequences
    • REOROO0106 : OO: Assignment Obj. Part–> Memo ID
    • REOROO0003 : OO: Views
    • REOROO0100 : OO: Field Modification per Activity
    • REOROO0017 : OO: External Applications
    • REOROO0104 : OO: Screen Configuration
    • REOROO0004 : OO: Sections
    • REOROO0102 : OO: Authorization Types
    • REOROO0016 : OO: Tables
    • REOROOAR : Archive Offered Objects
    • REOROO0011 : OO: Assignment Screen Fld->DB Field
    • REOROOID : Number Range Maintenance: REOROO
    • REOROO0012 : OO: Field Modification Criteria
    • REOROO0019 : OO: Field Mod. per Activity (Control
    • REOROO : Edit Offered Object
    • REOROO0005 : OO: Screens
    • REOROO0107 : OO: Where-Used List: Views
    • REOROOCREATE : Creation of Offered Objects

    Related References

    Related Tutorials

    TIVOROOUPDATE SAP table for – Control Data Update Offered Object

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

    REOROO SAP tcode for – Edit Offered Object

    REOROO tcode in SAP RE (Flexible Real Estate Management in RE) module. This transaction code is used for Edit Offered...

    VIBDOBJRELPART SAP table for – Object Relationship A/U Object <-> A/U Object: Percent

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

    REISOO SAP tcode for – Info System: Offered Object

    REISOO tcode in SAP RE (Flexible Real Estate Management in RE) module. This transaction code is used for Info System:...

    VIBDOBJASS SAP table for – Object Assignment

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

    VISCS_SU_RO SAP table for – Sum of All Costs and Measurement Amounts for a Rental Object

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

    VIBDOBJREL SAP table for – Object Relationship A/U Object <-> A/U Object

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

    «
    »