1. Home
  2. Resources
  3. SAP Tables
  4. VICNCN - Real Estate Contract

SAP Table VICNCN

Real Estate Contract

VICNCN (Real Estate Contract) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link VICNCN to other SAP tables.

VICNCN table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
INTRENO Internal Key of Real Estate Object RECAINTRENO CHAR 13 0
BUKRS Company Code BUKRS T001 CHAR 4 0
RECNNR Contract Number RECNNUMBER CHAR 13 0
OBJNR Object Number RECAOBJNR CHAR 22 0
IMKEY Internal Key of Real Estate Object (FI) RECAIMKEY CHAR 8 0
CREATIONTYPE How the Object Was Created RECACREATIONTYPE CHAR 1 0
NULL Object created in Classic RE
1 Object created in Classic RE or migrated from other system
2 Object created in Flexible Real Estate Management
RERF Entered by RERF CHAR 12 0
DERF First Entered on DERF DATS 8 0
TERF Time of Initial Entry TERF TIMS 6 0
REHER Source of initial entry REHER CHAR 10 0
RBEAR Employee ID RBEAR CHAR 12 0
DBEAR Last Edited on DBEAR DATS 8 0
TBEAR Last Edited at TBEAR TIMS 6 0
RBHER Editing Source RBHER CHAR 10 0
RESPONSIBLE Person Responsible RECARESPONSIBLE USR02 CHAR 12 0
USEREXCLUSIVE User with Exclusive Change Authorization RECAUSEREXCLUSIVE USR02 CHAR 12 0
AUTHGRP Authorization Group RECAAUTHGRP CHAR 40 0
RECNTYPE Contract Type RECNCONTRACTTYPE TIV26 CHAR 4 0
RECNBEG Date of contract start RECNCNBEG DATS 8 0
RECNENDABS Term End Date RECNCNENDABS DATS 8 0
RECNTXT Contract name RECNTXT CHAR 80 0
RECNDACTIV Contract activation DAKTV DATS 8 0
RECNTLAW Tenancy law SMIETR TIV03 CHAR 5 0
RECNTXTOLD Number of old contract VVOSMIVE CHAR 20 0
RECNBUKRSCOLLECT Company code of main contract RECNBUKRSCOLLECT T001 CHAR 4 0
RECNNRCOLLECT Number of Real Estate Main Contract RECNNUMBERCOLLECT CHAR 13 0
RECNCNCURR Currency for Contract RECNWAERS_CN TCURC CUKY 5 0
INDUSTRY Industry BU_IND_SECTOR CHAR 10 0
SRRELEVANT Relevant to Sales RECNSALESRENTRELEVANT CHAR 1 0
X Yes
NULL No
DPTARGETTYPE Security Deposit Type RECNDPTYPE TIVCNDPTYPE CHAR 4 0
RECNDAT Date of Contract Conclusion RECNDAT DATS 8 0
RECN2DAT Date of Second Signature RECN2DAT DATS 8 0
RECNDPO Cash Flow Generated Starting On RECDCFSTARTFROM DATS 8 0
RECNEND1ST Date of First Contract End RECNCNEND1ST DATS 8 0
RECNNOTPER Contract Notice Per RECNNTPER DATS 8 0
RECNNOTRECEIPT Date of receipt of notice RECNNTRECEIPT DATS 8 0
RECNNOTREASON Reason for Notice RECNNTREASON TIVCNNTRE NUMC 2 0
RECNDAKTKU Notice: Date of Activation RECNNTACTIVATEDON DATS 8 0
CFARCHIVEDTO Date Up to Which the Cash Flow Is Archived RECDCFARCHIVEDTO DATS 8 0
CFLOCKEDTO Date Until Which the Cash Flow Is Locked RECDCFLOCKEDTO DATS 8 0
CFPOSTINGFROM First Posting From RECDCFPOSTINGFROM DATS 8 0
BENOCN Site That Belongs to Contract RECNBENOCN CHAR 8 0
TRANSPOSSFROM Transfer of Possession: Start Date RECNTRANSPOSSFROM DATS 8 0
TRANSPOSSTO Transfer of Possession: End Date RECNTRANSPOSSTO DATS 8 0
HASMULTIASSIGN Multiple Assignment of Object to Group Allowed REBDHASMULTIASSIGN CHAR 1 0
X Yes
NULL No
POSSDATEFROM Date From Which the Object Is Made Available for Use REBDPOSSDATEFROM DATS 8 0
POSSDATETO Date Up to Which the Object Is Used REBDPOSSDATETO DATS 8 0
SECDEPRELEVANT Relevant to Security Deposit REXCESCDREL CHAR 1 0
X Yes
NULL No
NOTADJSDCN No Data Update in Security Deposit Contract REXCESCDNOTADJ CHAR 1 0
X Yes
NULL No
REYCMAJORCN CAM Major Contract REYCMAJORCN CHAR 13 0
REYCDEDUCTMEAS Deduct Major Tenant Space in Den. when Calc. Subtenant Share REYCDEDUCTMEAS CHAR 1 0
X Yes
NULL No
REYCMAJORTNT Major Tenant Contribution Indicator REYCMAJORTNT CHAR 1 0
X Yes
NULL No
REYCISSUECREDIT Issue Credit REYCISSUECREDIT CHAR 1 0
N No cedit
F Issue credit at final settlement
A Issue credit at all settlement
REYCPOSDATEREL Possession Date Relevant REYCPOSDATEREL CHAR 1 0
X Yes
NULL No

VICNCN foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VICNCN BUKRS SYST MANDT T001 Company Codes MANDT
VICNCN BUKRS VICNCN BUKRS T001 Company Codes BUKRS
VICNCN DPTARGETTYPE SYST MANDT TIVCNDPTYPE Security Deposit Type MANDT
VICNCN DPTARGETTYPE VICNCN DPTARGETTYPE TIVCNDPTYPE Security Deposit Type DPTYPE
VICNCN RECNBUKRSCOLLECT SYST MANDT T001 Company Codes MANDT
VICNCN RECNBUKRSCOLLECT VICNCN RECNBUKRSCOLLECT T001 Company Codes BUKRS
VICNCN RECNCNCURR SYST MANDT TCURC Currency Codes MANDT
VICNCN RECNCNCURR VICNCN RECNCNCURR TCURC Currency Codes WAERS
VICNCN RECNNOTREASON SYST MANDT TIVCNNTRE Reason for Notice MANDT
VICNCN RECNNOTREASON VICNCN RECNNOTREASON TIVCNNTRE Reason for Notice NTREASON
VICNCN RECNTLAW VICNCN RECNTLAW TIV03 Country-specific tenancy law SMIETR
VICNCN RECNTLAW SYST MANDT TIV03 Country-specific tenancy law MANDT
VICNCN RECNTYPE SYST MANDT TIV26 Real Estate Contract Type (Entities) MANDT
VICNCN RECNTYPE VICNCN RECNTYPE TIV26 Real Estate Contract Type (Entities) SMVART
VICNCN RESPONSIBLE SYST MANDT USR02 Logon Data (Kernel-Side Use) MANDT
VICNCN RESPONSIBLE VICNCN RESPONSIBLE USR02 Logon Data (Kernel-Side Use) BNAME
VICNCN USEREXCLUSIVE SYST MANDT USR02 Logon Data (Kernel-Side Use) MANDT
VICNCN USEREXCLUSIVE VICNCN USEREXCLUSIVE USR02 Logon Data (Kernel-Side Use) BNAME