SAP TABLES | Real Estate Management(RE) SAP RE

VICN01 SAP Real Estate Contract: Contract Data Table and data







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

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP VICN01 Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Allowed

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories

==>View Table relationships


SAP VICN01 Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
.INCLUDEVICN01_HD1 1. Key Structure VICN01
MANDTMANDTCLNT3
*
Client
INTRENOVVINTRENOCHAR13 Internal Real Estate Master Data Code
.INCLUDEVICN01_FT Real Estate Contract: Contract Data
.INCLUDEVICN01_HD2 2. Key Structure VICN01
BUKRSBUKRSCHAR4 T001Company Code
RECNTYPESMVARTCHAR4 TIV26External Real Estate contract type
RECNNRRECNNRCHAR13 Real Estate Contract NumberALPHA
RECNDATRECNDATDATS8 Date of Contract Conclusion
RECNBEGRECNBEGDATS8 Date of contract start
RECNENDRECNENDDATS8 Date of contract end
RECNADJTSMVARCHAR1
*
Lease-Out Adjustment Type
RECNTXTRECNTXTCHAR80 Contract name
RECNDPORECNDPODATS8 Date of first posting
RECNOBJNRJ_OBJNRCHAR22
*
Object number
RECNNOTTYPESMVKUEARTCHAR1 Notice Type of Lease-Out
RECNNOTKEYSKUEKEYCHAR12 Notice rule
RECNNOTPERDKUZUDATS8 Contract Notice Per
RECNAUTHGRVVBERGRPCHAR40 Authorization group
RECNBUSAREAGSBERCHAR4 TGSBBusiness Area
RECNPRCTRPRCTRCHAR10 CEPCProfit CenterALPHA
RECNACCDETVALVVWERTN_ADCNCHAR10 TIVCN08Account determination key for account determination
RECNADMONTHVVJMABGRCHAR1 Accrual/deferral method
RECNDDUNNEDMADATDATS8 Last dunned on
RECNDCOMPLNTVVKLDATUMDATS8 Date of complaint
RECNDCOMPLRCVVKLAKTZEICHAR20 Complaint reference code
RECNJURISDICVVXGERSTDCHAR35 Jurisdiction
IMKEYIMKEYCHAR8 Internal Key for Real Estate ObjectIMKEY
.INCLUDERUSER Field String for Maintenance of User Data
RERFRERFCHAR12 Entered by
DERFDERFDATS8 First Entered on
TERFTERFTIMS6 Time of Initial Entry
REHERREHERCHAR10 Source of initial entry
RBEARRBEARCHAR12 Employee ID
DBEARDBEARDATS8 Last Edited on
TBEARTBEARTIMS6 Last Edited at
RBHERRBHERCHAR10 Editing Source
RECNUNITRECNUNITUNIT3 T006Area unitCUNIT
RECNKUNNRKUNNRCHAR10 KNA1Customer NumberALPHA


RECNLIFNRLIFNRCHAR10 LFA1Account Number of Vendor or CreditorALPHA
RECNTXJCDTXJCDCHAR15
*
Tax Jurisdiction
RECNCURRRECNWAERS_HCUKY5 TCURCCurrency key for local currency
RECNTLAWSMIETRCHAR5 TIV03Tenancy law
RECNCURR2RECNWAERS_DCUKY5 TCURCCurrency key for the display currency
RECNTXTOLDVVOSMIVECHAR20 Number of old contractALPHA
RECNDACTIVDAKTVDATS8 Contract activation
RECNNRCOLLECTRECNNRCOLLECTCHAR13 Number of Real Estate main contractALPHA
RECNKOSTLRECNKOSTLCHAR10
*
Cost center of internal contractALPHA
ZLSCHDZLSCHCHAR1
*
Payment Method
RECNPREDATARECNPREDATACHAR1 Flag: Predefined rates
SPARTNRBP_PARTNRCHAR10
*
Business Partner NumberALPHA
RECNNOTRECEIPTDEKUEADATS8 Receipt or issue date of notice
RECNNOTREASONRKUEGRUNUMC2 TIV39Reason for notice
RECNNOTINVREARABLGRUNUMC2 TIV41Reason for rejection
RECNJVSTOPTVVJVSTOPTCHAR1 Input tax opting (indicator)
RECNVSTSONDSVSTSONDCHAR1 TIV63Input tax opting reason
RECNMANSPMANSPCHAR1 T040SDunning block
RECNMABERMABERCHAR2 T047MDunning Area
RECNMAHNAMAHNACHAR4 T047ADunning Procedure
RECNMAHNS_DMAHNS_DNUMC1 Dunning level
RECNNOTCATSKUARCHAR1 Notice Type
RECNGFZLSCHRECNGFZLSCHCHAR1
*
Payment method for credit memos
RECNZLSPRDZLSPRCHAR1 T008Payment Block Key
RECNHBKIDHBKIDCHAR5 T012Short Key for a House Bank
RECNXBLNRRECNXBLNR1CHAR16 Note to payee
RECNDKUZUGVVDKUZUGDATS8 Date notice approved
RECNDKUABGVVDKUABGDATS8 Date notice rejected
RECNDWIKUVVDWIKUDATS8 Date of objection to notice
RECNDKUERCKDKUERCKDATS8 Date of withdrawal of notice
RECNDKREUEBVVDKREUEBDATS8 Date notice submitted to legal department
RECNDAKTKUVVDAKTKUDATS8 Activation date
RECNDSTKUVVDSTKUDATS8 Reversal date
RECNADJTTYPERECNADJTTYPECHAR1 Adjustment triggered by
RECNADJTRUECKRECNADJTRUECKCHAR1 Retroactive adjustment possible
RECNBUKRSCOLLECTRECNBUKRSCOLLECTCHAR4 T001Company code of main contract
RECNBASISAEZIFRECNBASISAEZIFINT25 Base: equivalence number distribution
RECNXCROSSRECNXCROSSCHAR1 Gross amount indicator
RECNMANDATRECNMANDATCHAR20 Mandate


RECNMANDATTYPRECNMANDATTYPNUMC1 Role of Contract in Mandate
RECNFLESRVVKZESRCHAR1 Activation of POR functions
RECNESRNROWVVESRNR_EIGNUMC9 TIV9IPOR participant number of owner
RECNESRCUIDOWVVESRKUID_EIGCHAR15 TIV9IPOR customer identification number
RECNVATNROWVVMWSTNR_EIGCHAR20 Value-added tax of owner
RECNBUKRSGKTVVBUKRS_GKTCHAR4 T001Object and account CoCd
RECNKZEIGGKTVVKZEIGGKTCHAR1 Cash account control for owner
.APPENDRELSVICN01 LUM: Vertragserweiterungen
RELSKASSENZRELSKASSENZCHAR30 Kassenzeichen/Hebebuch-Nr.
RELSGRDNRRELSGRDNRCHAR30 Grundstücksnummer im Abgabenbescheid
RELSSUBTYPERELSSUBTYPECHAR4 TIVLSCNSTYPEUntervertragsart (Liegenschaftsvertrag)
RELSAKTZRELSAKTZCHAR35 Aktenzeichen
RELSDAT2RELSDAT2DATS8 Datum Vertragsbestätigung
RELSWIRTUEBGRELSWIRTUEBGDATS8 Wirtschaftlicher Übergang
RELSNOTEARLYRELSNOTEARLYDATS8 Frühestmögliche Kündigung
RELSOWNERBP_PARTNRCHAR10
*
Business Partner NumberALPHA
RELSROLETYPBP_ROLETYPCHAR4
*
Business Partner Role Category
.APPENDVICN01_APP OBSOLETE: RE Contract: Append Fields
.INCLUDERECN_CONTRACT_APP OBSOLETE: RE Contract: Append Fields
CREATIONTYPERECACREATIONTYPECHAR1 How the Object Was Created
RECNCNCURRRECNWAERS_CNCUKY5 TCURCCurrency for Contract
RECNENDABSRECNCNENDABSDATS8 Term End DateREDAT
RECN2DATRECN2DATDATS8 Date of Second Signature
RESPONSIBLERECARESPONSIBLECHAR12
*
Person Responsible
USEREXCLUSIVERECAUSEREXCLUSIVECHAR12
*
User with Exclusive Change Authorization
SRRELEVANTRECNSALESRENTRELEVANTCHAR1 Relevant to Sales
CFARCHIVEDTORECDCFARCHIVEDTODATS8 Date Up to Which the Cash Flow Is Archived
CFLOCKEDTORECDCFLOCKEDTODATS8 Date Until Which the Cash Flow Is Locked
INDUSTRYBU_IND_SECTORCHAR10
*
Industry
DPTARGETTYPERECNDPTYPECHAR4 TIVCNDPTYPESecurity Deposit TypeALPHA
.APPENDVICN01_APPRELUBI LUM: Ausschreibung
BIRELEASERELUBIRELEASECHAR1 Ausschreibung freigegeben (Kennzeichen)
BIVALIDFROMRELUBIVALIDFROMDATS8 Ausschreibung gültig von
BIVALIDTORELUBIVALIDTODATS8 Ausschreibung gültig bis
BIREPRTORELUBIREPRTODATS8 Ausschreibung befristet bis
BIREPRTOTIMERELUBIREPRTOTIMETIMS6 Uhrzeit, bis zu der die Ausschreibung befristet ist
BIRECATRELUBIRECATCHAR2 TIVLUBIRECATLiegenschaftskategorie
PUBLICTYPERELUPUBLICTYPECHAR2 TIVLUPUBLICTYPEArt der Veröffentlichung
FILENORELUFILENOCHAR35 Aktenzeichen

BIPURPOSERELUBIPURPOSECHAR2 TIVLUBIPURPOSEZweck der Ausschreibung
BIPRICINGRELUBIPRICINGCHAR2 TIVLUBIPRICINGPreisfindung



Key field
Non-key field

VICN01 relationships with other tables


RECONTRACT_KEY-Root Node: Key Fields of LDB RECONTRACT
     VICN01-Real Estate Contract: Contract Data
          RFVILSP-Dummy Node: Time Dependence
          VZGPO-Partner/Role Object Relationship
          VIOB01-Business Entities
               VIOB02-Property Master Data
               VIOB03-Real Estate Building Master
               VIMI01-Rental Unit - Master Data
                    VIMIMV-Lease-Out
          VIOBOV-Assignment Table for RE to Standard Objects
          VICN03-Real Estate Contract: Posting Distribution
          VIKOKO-Real Estate Condition Header
               VZZKOPO-Condition Items Table
          VIMIUH-Sales-Based Rental Agreement: Contracted Sales
               VIMIUI-Sales-Based Grading Lease-Out Items
          VIMI54-Real Estate: Time-dependent Adjustment Data
          VIMI55-Index Data for Lease-Out (Time-Dependent)