VICNCN SAP (Real Estate Contract) Table details

Dictionary Type: Table
Description: Real Estate Contract




ABAP Code to SELECT data from VICNCN
Related tables to VICNCN
Access table VICNCN




Table field list including key, data, relationships and ABAP select examples

VICNCN is a standard SAP Table which is used to store Real Estate Contract data and is available within R/3 SAP systems depending on the version and release level.

The VICNCN table consists of various fields, each holding specific information or linking keys about Real Estate Contract data available in SAP. These include INTRENO (Internal Key of Real Estate Object), BUKRS (Company Code), RECNNR (Contract Number), OBJNR (Object Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP VICNCN table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
INTRENOInternal Key of Real Estate Object RECAINTRENOCHAR13RECAINTRENO
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
RECNNRContract Number RECNNUMBERCHAR13ALPHARECNNUMBERRECNNRRECNCN
OBJNRObject Number RECAOBJNRCHAR22Assigned to domainJ_OBJNRONR
IMKEYInternal Key of Real Estate Object (FI) RECAIMKEYCHAR8IMKEYIMKEYRECLFXCAIMKEY
CREATIONTYPEHow the Object Was Created RECACREATIONTYPECHAR1RECACREATIONTYPE
RERFEntered by RERFCHAR12SYCHAR12
DERFFirst Entered on DERFDATS8DATUM
TERFTime of Initial Entry TERFTIMS6TIMES
REHERSource of initial entry REHERCHAR10CHAR10
RBEAREmployee ID RBEARCHAR12SYCHAR12
DBEARLast Edited on DBEARDATS8DATUM
TBEARLast Edited at TBEARTIMS6TIMES
RBHEREditing Source RBHERCHAR10CHAR10
RESPONSIBLEPerson Responsible RECARESPONSIBLECHAR12USR02XUBNAMEUSER_COMP
USEREXCLUSIVEUser with Exclusive Change Authorization RECAUSEREXCLUSIVECHAR12USR02XUBNAMEUSER_COMP
AUTHGRPAuthorization Group RECAAUTHGRPCHAR40RECAAUTHGRP
RECNTYPEContract Type RECNCONTRACTTYPECHAR4TIV26SMVARTRECNTYPERECNCONTRACTTYPE
RECNBEGDate of contract start RECNCNBEGDATS8RECADATE
RECNENDABSTerm End Date RECNCNENDABSDATS8REDATRECADATEEND
RECNTXTContract name RECNTXTCHAR80XTEXT80
RECNDACTIVContract activation DAKTVDATS8DATUM
RECNTLAWTenancy law SMIETRCHAR5TIV03SMIETR
RECNTXTOLDNumber of old contract VVOSMIVECHAR20ALPHAVVOSMIVE
RECNBUKRSCOLLECTCompany code of main contract RECNBUKRSCOLLECTCHAR4T001BUKRS
RECNNRCOLLECTNumber of Real Estate Main Contract RECNNUMBERCOLLECTCHAR13ALPHARECNNUMBERRECNNR
RECNCNCURRCurrency for Contract RECNWAERS_CNCUKY5TCURCWAERSFWS
INDUSTRYIndustry BU_IND_SECTORCHAR10Assigned to domainBU_INDSECTOR
SRRELEVANTRelevant to Sales RECNSALESRENTRELEVANTCHAR1RECABOOL
DPTARGETTYPESecurity Deposit Type RECNDPTYPECHAR4TIVCNDPTYPEALPHARECNDPTYPE
RECNDATDate of Contract Conclusion RECNDATDATS8DDAT
RECN2DATDate of Second Signature RECN2DATDATS8RECADATE
RECNDPOCash Flow Generated Starting On RECDCFSTARTFROMDATS8RECADATE
RECNEND1STDate of First Contract End RECNCNEND1STDATS8RECADATE
RECNNOTPERContract Notice Per RECNNTPERDATS8RECADATE
RECNNOTRECEIPTDate of receipt of notice RECNNTRECEIPTDATS8RECADATE
RECNNOTREASONReason for Notice RECNNTREASONNUMC2TIVCNNTRERECNNTREASONRECNNTREASON
RECNDAKTKUNotice: Date of Activation RECNNTACTIVATEDONDATS8RECADATE
CFARCHIVEDTODate Up to Which the Cash Flow Is Archived RECDCFARCHIVEDTODATS8RECADATE
CFLOCKEDTODate Until Which the Cash Flow Is Locked RECDCFLOCKEDTODATS8RECADATE
CFPOSTINGFROMFirst Posting From RECDCFPOSTINGFROMDATS8RECADATE
BENOCNSite That Belongs to Contract RECNBENOCNCHAR8Assigned to domainSWENRREBDBENOREBDBENO
TRANSPOSSFROMTransfer of Possession: Start Date RECNTRANSPOSSFROMDATS8RECADATEBEG
TRANSPOSSTOTransfer of Possession: End Date RECNTRANSPOSSTODATS8REDATRECADATEEND
HASMULTIASSIGNMultiple Assignment of Object to Group Allowed REBDHASMULTIASSIGNCHAR1RECABOOL
POSSDATEFROMDate From Which the Object Is Made Available for Use REBDPOSSDATEFROMDATS8RECADATE
POSSDATETODate Up to Which the Object Is Used REBDPOSSDATETODATS8RECADATE
.INCLU--AP 0
SECDEPRELEVANTRelevant to Security Deposit REXCESCDRELCHAR1XFELD
NOTADJSDCNNo Data Update in Security Deposit Contract REXCESCDNOTADJCHAR1RECABOOL
.INCLU--AP 0
REYCMAJORCNCAM Major Contract REYCMAJORCNCHAR13ALPHARECNNUMBER
REYCDEDUCTMEASDeduct Major Tenant Space in Den. when Calc. Subtenant Share REYCDEDUCTMEASCHAR1RECABOOL
REYCMAJORTNTMajor Tenant Contribution Indicator REYCMAJORTNTCHAR1RECABOOL
REYCISSUECREDITIssue Credit REYCISSUECREDITCHAR1REYCISSUECREDIT
REYCPOSDATERELPossession Date Relevant REYCPOSDATERELCHAR1RECABOOL

Key field Non-key field



How do I retrieve data from SAP table VICNCN using ABAP code

The following ABAP code Example will allow you to do a basic selection on VICNCN to SELECT all data from the table
DATA: WA_VICNCN TYPE VICNCN.

SELECT SINGLE *
FROM VICNCN
INTO CORRESPONDING FIELDS OF WA_VICNCN
WHERE...

How to access SAP table VICNCN

Within an ECC or HANA version of SAP you can also view further information about VICNCN and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!