VICN01

Real Estate Contract: Contract Data | #masterdata | Component: Real Estate Management
Column Name Description
MANDT Client
INTRENO Internal Real Estate Master Data Code
Column Name Description
Column Name Description
Column Name Description
RECNDAT Date of Contract Conclusion
RECNBEG Date of contract start
RECNEND Date of contract end
RECNDPO Date of first posting
RECNNOTPER Contract Notice Per
RECNDDUNNED Date of Last Dunning Notice
RECNDCOMPLNT Date of complaint
DERF First Entered On
TERF Time of Creation
DBEAR Last Edited On
TBEAR Last Edited At
RECNDACTIV Contract activation
RECNNOTRECEIPT Receipt or issue date of notice
RECNDKUZUG Date notice approved
RECNDKUABG Date notice rejected
RECNDWIKU Date of objection to notice
RECNDKUERCK Date of withdrawal of notice
RECNDKREUEB Date notice submitted to legal department
RECNDAKTKU Activation date
RECNDSTKU Reversal date
RELSDAT2 null
RELSWIRTUEBG null
RELSNOTEARLY null
RECNENDABS Term End Date
RECN2DAT Date of Second Signature
CFARCHIVEDTO Date Up to Which the Cash Flow Is Archived
CFLOCKEDTO Date Until Which the Cash Flow Is Locked
BIVALIDFROM null
BIVALIDTO null
BIREPRTO null
BIREPRTOTIME null
Column Name Description
RECNNOTTYPE Notice Type of Lease-Out Show values
RECNADMONTH Accrual/deferral method Show values
RECNPREDATA Flag: Predefined rates Show values
RECNJVSTOPT Input tax opting (indicator) Show values
RECNNOTCAT Notice Type Show values
RECNADJTTYPE Adjustment triggered by Show values
RECNADJTRUECK Retroactive adjustment possible Show values
RECNXCROSS Gross amount indicator Show values
RECNMANDATTYP Role of Contract in Mandate Show values
RECNFLESR Activation of POR functions Show values
RECNKZEIGGKT Cash account control for owner Show values
CREATIONTYPE How the Object Was Created Show values
SRRELEVANT Indicator: Relevant to Sales Show values
BIRELEASE null Show values
Column Name Description Domain name
RECNNR Real Estate Contract Number RECNNR
RECNADJT Lease-Out Adjustment Type SMVAR
RECNTXT Contract Name XTEXT80
RECNOBJNR Object number J_OBJNR
RECNNOTKEY Notice rule SKUEKEY
RECNAUTHGR Authorization group VVBERGRP
RECNDCOMPLRC Complaint reference code CHAR20
RECNJURISDIC Jurisdiction TEXT35
IMKEY Internal Key for Real Estate Object IMKEY
RERF Entered By SYCHAR12
REHER Source of Initial Entry CHAR10
RBEAR Employee ID SYCHAR12
RBHER Editing Source CHAR10
RECNTXJCD Tax Jurisdiction TXJCD
RECNTXTOLD Number of old contract VVOSMIVE
RECNNRCOLLECT Number of Real Estate Main Contract RECNNR
RECNKOSTL Cost center of internal contract KOSTL
ZLSCH Payment Method ZLSCH
SPARTNR Business Partner Number BP_PARTNR
RECNMAHNS_D Dunning Level MAHNS
RECNGFZLSCH Payment method for credit memos ZLSCH
RECNXBLNR Note to payee XBLNR1
RECNBASISAEZIF Base: equivalence number distribution RECNAEZIF
RECNMANDAT Mandate CHAR20
RECNVATNROW Value-added tax of owner STCEG
RELSKASSENZ null CHAR30
RELSGRDNR null CHAR30
RELSAKTZ null TEXT35
RELSOWNER Business Partner Number BP_PARTNR
RELSROLETYP Business Partner Role Category BP_ROLETYP
RESPONSIBLE Person Responsible XUBNAME
USEREXCLUSIVE User with Exclusive Change Authorization XUBNAME
INDUSTRY Industry BU_INDSECTOR
FILENO null CHAR35
Master Data Relations | to Other Relations ↓ Join Conditions
null
  • ?
  • Client
null
  • ?
  • Client
null
Company Code
  • VICN01.MANDT == T001.MANDT
  • VICN01.BUKRS == T001.BUKRS
Security Deposit Type
  • Security Deposit Type
  • Client
null
Account determination key for account determination
  • Account determination key for account determination
  • Client
Company Code of Main Contract
  • VICN01.MANDT == T001.MANDT
  • VICN01.RECNBUKRSCOLLECT == T001.BUKRS
Company Code Check
  • VICN01.MANDT == T001.MANDT
  • VICN01.RECNBUKRSGKT == T001.BUKRS
Business Area
  • VICN01.MANDT == TGSB.MANDT
  • VICN01.RECNBUSAREA == TGSB.GSBER
Currency for Contract
  • VICN01.MANDT == TCURC.MANDT
  • VICN01.RECNCNCURR == TCURC.WAERS
Currency key for local currency
  • VICN01.MANDT == TCURC.MANDT
  • VICN01.RECNCURR == TCURC.WAERS
Currency key for the display currency
  • VICN01.MANDT == TCURC.MANDT
  • VICN01.RECNCURR2 == TCURC.WAERS
Short Key for a House Bank
  • Short Key for a House Bank
  • Company Code
  • VICN01.MANDT == T012.MANDT
  • VICN01.RECNHBKID == T012.HBKID
  • VICN01.BUKRS == T012.BUKRS
Customer Number
  • VICN01.MANDT == KNA1.MANDT
  • VICN01.RECNKUNNR == KNA1.KUNNR
Account Number of Supplier
  • VICN01.MANDT == LFA1.MANDT
  • VICN01.RECNLIFNR == LFA1.LIFNR
Dunning Area
  • Dunning Area
  • Company Code
  • VICN01.MANDT == T047M.MANDT
  • VICN01.RECNMABER == T047M.MABER
  • VICN01.BUKRS == T047M.BUKRS
Dunning Procedure
  • VICN01.MANDT == T047A.MANDT
  • VICN01.RECNMAHNA == T047A.MAHNA
Dunning: Blocking Reason
  • VICN01.MANDT == T040S.MANDT
  • VICN01.RECNMANSP == T040S.MANSP
Reason for rejection
  • Reason for rejection
  • Client
  • VICN01.RECNNOTINVREA == TIV41.RABLGRU
  • VICN01.MANDT == TIV41.MANDT
Reason for notice
  • Reason for notice
  • Client
  • VICN01.RECNNOTREASON == TIV39.RKUEGRU
  • VICN01.MANDT == TIV39.MANDT
Profit Center
  • ?
  • ?
  • Profit Center
  • VICN01.MANDT == CEPC.MANDT
  • VICN01.[column in domain "DATBI"] == CEPC.DATBI
  • VICN01.[column in domain "KOKRS"] == CEPC.KOKRS
  • VICN01.RECNPRCTR == CEPC.PRCTR
Tenancy law
  • VICN01.MANDT == TIV03.MANDT
  • VICN01.RECNTLAW == TIV03.SMIETR
External Real Estate Contract Type
  • VICN01.MANDT == TIV26.MANDT
  • VICN01.RECNTYPE == TIV26.SMVART
Area unit
  • VICN01.MANDT == T006.MANDT
  • VICN01.RECNUNIT == T006.MSEHI
Input tax opting reason
  • Input tax opting reason
  • Client
  • VICN01.RECNVSTSOND == TIV63.SVSTSOND
  • VICN01.MANDT == TIV63.MANDT
Payment Block Key
  • Payment Block Key
  • Client
  • VICN01.RECNZLSPR == T008.ZAHLS
  • VICN01.MANDT == T008.MANDT
null
  • ?
  • Client
  • ?
Other Relations | to Master Data Relations ↑ Join Conditions
POR customer identification number
  • POR participant number of owner
  • Company Code
  • POR customer identification number
  • Client
  • VICN01.RECNESRNROW == TIV9I.TEILN
  • VICN01.BUKRS == TIV9I.BUKRS
  • VICN01.RECNESRCUIDOW == TIV9I.KUNID
  • VICN01.MANDT == TIV9I.MANDT
POR owner no.
  • POR participant number of owner
  • Company Code
  • POR customer identification number
  • Client
  • VICN01.RECNESRNROW == TIV9I.TEILN
  • VICN01.BUKRS == TIV9I.BUKRS
  • VICN01.RECNESRCUIDOW == TIV9I.KUNID
  • VICN01.MANDT == TIV9I.MANDT