VIOROF SAP table for – Contract Offer

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

SAP VIOROF table

Table VIOROF technical data

TableVIOROF
Data storingContract Offer
ModuleRE
Sub ModuleRE-FX-OR
SAP PackageRE_OR_OF
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

SAP VIOROF 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 VIOROF 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 : Contract Offer: Key Fields
  • OFID : Contract Offer Number
    Its data type is CHAR (Character String) with field length 13
  • .INCLUDE : Contract Offer: 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
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • RECNTYPE : Contract Type
    Its data type is CHAR (Character String) with field length 4
  • OFCNBEG : Date of contract start
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • OFCNENDABS : Term End Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • XOF : Name of Contract Offer
    Its data type is CHAR (Character String) with field length 60
  • OFREJDATE : Rejection of Contract Offer
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RECNNR : Contract Number
    Its data type is CHAR (Character String) with field length 13
  • RECNTLAW : Tenancy law
    Its data type is CHAR (Character String) with field length 5
  • RECNBUKRSCOLLECT : Company code of main contract
    Its data type is CHAR (Character String) with field length 4
  • RECNNRCOLLECT : Number of Real Estate Main Contract
    Its data type is CHAR (Character String) with field length 13
  • RECNCNCURR : Currency for Contract
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • INDUSTRY : Industry
    Its data type is CHAR (Character String) with field length 10
  • SRRELEVANT : Relevant to Sales
    Its data type is CHAR (Character String) with field length 1
  • DPTARGETTYPE : Security Deposit Type
    Its data type is CHAR (Character String) with field length 4
  • OFRESTO : Contract Offer Reserved To
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RECNDAT : Date of Contract Conclusion
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RECNDPO : Cash Flow Generated Starting On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RECNEND1ST : Date of First Contract End
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BENOCN : Business Entity That Belongs to Contract
    Its data type is CHAR (Character String) with field length 8
  • POSSDATEFROM : Date From Which the Object Is Made Available for Use
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • POSSDATETO : Date Up to Which the Object Is Used
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes