Menu

SAP Table VICN01

Real Estate Contract: Contract Data

The table VICN01 (Real Estate Contract: Contract Data) is a standard table in SAP ERP. It belongs to the package FVVICN.

Technical Information

Table VICN01
Short Text Real Estate Contract: Contract Data
Package FVVICN
Table Type Transparent Table

Fields for Table VICN01

Field Name Key Description Data Element Type Length Check Table
MANDT Client MANDT CLNT 3 *
INTRENO Internal Real Estate Master Data Code VVINTRENO CHAR 13
BUKRS Company Code BUKRS CHAR 4 T001
RECNTYPE External Real Estate contract type SMVART CHAR 4 TIV26
RECNNR Real Estate Contract Number RECNNR CHAR 13
RECNDAT Date of Contract Conclusion RECNDAT DATS 8
RECNBEG Date of contract start RECNBEG DATS 8
RECNEND Date of contract end RECNEND DATS 8
RECNADJT Lease-Out Adjustment Type SMVAR CHAR 1 *
RECNTXT Contract name RECNTXT CHAR 80
RECNDPO Date of first posting RECNDPO DATS 8
RECNOBJNR Object number J_OBJNR CHAR 22 *
RECNNOTTYPE Notice Type of Lease-Out SMVKUEART CHAR 1
RECNNOTKEY Notice rule SKUEKEY CHAR 12
RECNNOTPER Contract Notice Per DKUZU DATS 8
RECNAUTHGR Authorization group VVBERGRP CHAR 40
RECNBUSAREA Business Area GSBER CHAR 4 TGSB
RECNPRCTR Profit Center PRCTR CHAR 10 CEPC
RECNACCDETVAL Account determination key for account determination VVWERTN_ADCN CHAR 10 TIVCN08
RECNADMONTH Accrual/deferral method VVJMABGR CHAR 1
RECNDDUNNED Last dunned on MADAT DATS 8
RECNDCOMPLNT Date of complaint VVKLDATUM DATS 8
RECNDCOMPLRC Complaint reference code VVKLAKTZEI CHAR 20
RECNJURISDIC Jurisdiction VVXGERSTD CHAR 35
IMKEY Internal Key for Real Estate Object IMKEY CHAR 8
RERF Entered by RERF CHAR 12
DERF First Entered on DERF DATS 8
TERF Time of Initial Entry TERF TIMS 6
REHER Source of initial entry REHER CHAR 10
RBEAR Employee ID RBEAR CHAR 12
DBEAR Last Edited on DBEAR DATS 8
TBEAR Last Edited at TBEAR TIMS 6
RBHER Editing Source RBHER CHAR 10
RECNUNIT Area unit RECNUNIT UNIT 3 T006
RECNLIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 LFA1
RECNTXJCD Tax Jurisdiction TXJCD CHAR 15 *
RECNCURR Currency key for local currency RECNWAERS_H CUKY 5 TCURC
RECNTLAW Tenancy law SMIETR CHAR 5 TIV03
RECNCURR2 Currency key for the display currency RECNWAERS_D CUKY 5 TCURC
RECNTXTOLD Number of old contract VVOSMIVE CHAR 20
RECNDACTIV Contract activation DAKTV DATS 8
RECNNRCOLLECT Number of Real Estate main contract RECNNRCOLLECT CHAR 13
RECNKOSTL Cost center of internal contract RECNKOSTL CHAR 10 *
ZLSCH Payment Method DZLSCH CHAR 1 *
RECNPREDATA Flag: Predefined rates RECNPREDATA CHAR 1
SPARTNR Business Partner Number BP_PARTNR CHAR 10 *
RECNNOTRECEIPT Receipt or issue date of notice DEKUEA DATS 8
RECNNOTREASON Reason for notice RKUEGRU NUMC 2 TIV39
RECNNOTINVREA Reason for rejection RABLGRU NUMC 2 TIV41
RECNJVSTOPT Input tax opting (indicator) VVJVSTOPT CHAR 1
RECNVSTSOND Input tax opting reason SVSTSOND CHAR 1 TIV63
RECNMANSP Dunning block MANSP CHAR 1 T040S
RECNMABER Dunning Area MABER CHAR 2 T047M
RECNMAHNA Dunning Procedure MAHNA CHAR 4 T047A
RECNMAHNS_D Dunning level MAHNS_D NUMC 1
RECNNOTCAT Notice Type SKUAR CHAR 1
RECNGFZLSCH Payment method for credit memos RECNGFZLSCH CHAR 1 *
RECNZLSPR Payment Block Key DZLSPR CHAR 1 T008
RECNHBKID Short Key for a House Bank HBKID CHAR 5 T012
RECNXBLNR Note to payee RECNXBLNR1 CHAR 16
RECNDKUZUG Date notice approved VVDKUZUG DATS 8
RECNDKUABG Date notice rejected VVDKUABG DATS 8
RECNDWIKU Date of objection to notice VVDWIKU DATS 8
RECNDKUERCK Date of withdrawal of notice DKUERCK DATS 8
RECNDKREUEB Date notice submitted to legal department VVDKREUEB DATS 8
RECNDAKTKU Activation date VVDAKTKU DATS 8
RECNDSTKU Reversal date VVDSTKU DATS 8
RECNADJTTYPE Adjustment triggered by RECNADJTTYPE CHAR 1
RECNADJTRUECK Retroactive adjustment possible RECNADJTRUECK CHAR 1
RECNBUKRSCOLLECT Company code of main contract RECNBUKRSCOLLECT CHAR 4 T001
RECNBASISAEZIF Base: equivalence number distribution RECNBASISAEZIF INT2 5
RECNXCROSS Gross amount indicator RECNXCROSS CHAR 1
RECNMANDAT Mandate RECNMANDAT CHAR 20
RECNMANDATTYP Role of Contract in Mandate RECNMANDATTYP NUMC 1
RECNFLESR Activation of POR functions VVKZESR CHAR 1
RECNESRNROW POR participant number of owner VVESRNR_EIG NUMC 9 TIV9I
RECNESRCUIDOW POR customer identification number VVESRKUID_EIG CHAR 15 TIV9I
RECNVATNROW Value-added tax of owner VVMWSTNR_EIG CHAR 20
RECNBUKRSGKT Object and account CoCd VVBUKRS_GKT CHAR 4 T001
RECNKZEIGGKT Cash account control for owner VVKZEIGGKT CHAR 1
RELSKASSENZ Kassenzeichen/Hebebuch-Nr. RELSKASSENZ CHAR 30
RELSGRDNR Grundstücksnummer im Abgabenbescheid RELSGRDNR CHAR 30
RELSSUBTYPE Untervertragsart (Liegenschaftsvertrag) RELSSUBTYPE CHAR 4 TIVLSCNSTYPE
RELSAKTZ Aktenzeichen RELSAKTZ CHAR 35
RELSDAT2 Datum Vertragsbestätigung RELSDAT2 DATS 8
RELSWIRTUEBG Wirtschaftlicher Übergang RELSWIRTUEBG DATS 8
RELSNOTEARLY Frühestmögliche Kündigung RELSNOTEARLY DATS 8
RELSOWNER Business Partner Number BP_PARTNR CHAR 10 *
RELSROLETYP Business Partner Role Category BP_ROLETYP CHAR 4 *
CREATIONTYPE How the Object Was Created RECACREATIONTYPE CHAR 1
RECNCNCURR Currency for Contract RECNWAERS_CN CUKY 5 TCURC
RECNENDABS Term End Date RECNCNENDABS DATS 8
RECN2DAT Date of Second Signature RECN2DAT DATS 8
RESPONSIBLE Person Responsible RECARESPONSIBLE CHAR 12 *
USEREXCLUSIVE User with Exclusive Change Authorization RECAUSEREXCLUSIVE CHAR 12 *
SRRELEVANT Relevant to Sales RECNSALESRENTRELEVANT CHAR 1
CFARCHIVEDTO Date Up to Which the Cash Flow Is Archived RECDCFARCHIVEDTO DATS 8
CFLOCKEDTO Date Until Which the Cash Flow Is Locked RECDCFLOCKEDTO DATS 8
INDUSTRY Industry BU_IND_SECTOR CHAR 10 *
DPTARGETTYPE Security Deposit Type RECNDPTYPE CHAR 4 TIVCNDPTYPE
BIRELEASE Ausschreibung freigegeben (Kennzeichen) RELUBIRELEASE CHAR 1
BIVALIDFROM Ausschreibung gültig von RELUBIVALIDFROM DATS 8
BIVALIDTO Ausschreibung gültig bis RELUBIVALIDTO DATS 8
BIREPRTO Ausschreibung befristet bis RELUBIREPRTO DATS 8
BIREPRTOTIME Uhrzeit, bis zu der die Ausschreibung befristet ist RELUBIREPRTOTIME TIMS 6
BIRECAT Liegenschaftskategorie RELUBIRECAT CHAR 2 TIVLUBIRECAT
PUBLICTYPE Art der Veröffentlichung RELUPUBLICTYPE CHAR 2 TIVLUPUBLICTYPE
FILENO Aktenzeichen RELUFILENO CHAR 35
BIPURPOSE Zweck der Ausschreibung RELUBIPURPOSE CHAR 2 TIVLUBIPURPOSE
BIPRICING Preisfindung RELUBIPRICING CHAR 2 TIVLUBIPRICING