1. SAP Tutorial
  2. Real Estate Management

VICNCN SAP table for – Real Estate Contract

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

SAP VICNCN table

Table VICNCN technical data

TableVICNCN
Data storingReal Estate Contract
ModuleRE
Sub ModuleRE-FX-CN
SAP PackageRE_CN_CN
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

SAP VICNCN 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 VICNCN 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 : RE Contract: Key Fields
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • RECNNR : Contract Number
    Its data type is CHAR (Character String) with field length 13
  • .INCLUDE : RE Contract: Non-Key Fields
  • OBJNR : Object Number
    Its data type is CHAR (Character String) with field length 22
  • IMKEY : Internal Key of Real Estate Object (FI)
    Its data type is CHAR (Character String) with field length 8
  • 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
  • RECNTYPE : Contract Type
    Its data type is CHAR (Character String) with field length 4
  • RECNBEG : Date of contract start
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RECNENDABS : Term End Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RECNTXT : Contract name
    Its data type is CHAR (Character String) with field length 80
  • RECNDACTIV : Contract activation
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RECNTLAW : Tenancy law
    Its data type is CHAR (Character String) with field length 5
  • RECNTXTOLD : Number of old contract
    Its data type is CHAR (Character String) with field length 20
  • 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
  • RECNDAT : Date of Contract Conclusion
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RECN2DAT : Date of Second Signature
    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
  • RECNNOTPER : Contract Notice Per
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RECNNOTRECEIPT : Date of receipt of notice
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RECNNOTREASON : Reason for Notice
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • RECNDAKTKU : Notice: Date of Activation
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CFARCHIVEDTO : Date Up to Which the Cash Flow Is Archived
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CFLOCKEDTO : Date Until Which the Cash Flow Is Locked
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CFPOSTINGFROM : First Posting From
    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
  • TRANSPOSSFROM : Transfer of Possession: Start Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TRANSPOSSTO : Transfer of Possession: End Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • HASMULTIASSIGN : Multiple Assignment of Object to Group Allowed
    Its data type is CHAR (Character String) with field length 1
  • 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
  • .INCLU–AP : Country Specific Fields for Spain
  • .INCLUDE : Country-Specific Fields for Spain – Contract
  • SECDEPRELEVANT : Relevant to Security Deposit
    Its data type is CHAR (Character String) with field length 1
  • NOTADJSDCN : No Data Update in Security Deposit Contract
    Its data type is CHAR (Character String) with field length 1

    • VICNCN related tables

    • VICNCN : Real Estate Contract
    • TIVCNCCTADD : Attribute for Contract
    • TIVCNUSGCNTYPE : Allowed Usage Type per Contract Type
    • TIVCNCCTFMOD : Field Status per Contract Type

    VICNCN related transaction codes under SAP package RE_CN_CN

    • REGC0012 : Field Modification Criteria
    • REGC0006 : Screen Sequences
    • REGC0005 : Screens
    • REGC0007 : Events
    • RECNAR : Archive Real Estate Contracts
    • REGC0022 : Where-Used List: Structure
    • REGC0008 : GUI Standard Functions
    • REGC0106 : Assign object part –> Note ID
    • REGC0019 : Field Modifictn per Actvty (Control)
    • REGC0023 : Data Sets
    • REGC0102 : Authorization Types
    • REGC0107 : Where-used list: Views
    • RECNAA : Contract Type Field Modification
    • REGC0017 : External Applications
    • REGC0014 : Role Cat. Groupings
    • REGC0004 : Sections
    • REGC0103 : Field groups for authorization
    • REGC0104 : Screen configuration
    • RECNCHECK : Mass Check: Contracts
    • REGC0100 : GC: Field Modification per Activity

    Related References

    Related Tutorials

    VILMRG SAP table for – Real Estate Register – Entries

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

    TIVORSET SAP table for – General Settings for Real Estate Search

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

    VILMRGCHG SAP table for – Real Estate Register – Additions/Removals

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

    TIVCAARDEL SAP table for – Deletion of Real Estate Objects Without Archiving

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

    RECNAR SAP tcode for – Archive Real Estate Contracts

    RECNAR tcode in SAP RE (Flexible Real Estate Management in RE) module. This transaction code is used for Archive Real...

    TIVHOCP01 SAP table for – Real Estate Correspondenz: Zuordnung Formular zu KV

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

    VILMRGDTSRV SAP table for – Real Estate Register – Related Right – Servient Tenements

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

    «
    »