SAP Table VICN01 - Real Estate Contract: Contract Data

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
INTRENO X VVINTRENO CHAR 3 13 0 Internal Real Estate Master Data Code
BUKRS BUKRS CHAR 16 4 0 T001 Company Code
RECNTYPE SMVART CHAR 20 4 0 TIV26 External Real Estate contract type
RECNNR RECNNR CHAR 24 13 0 Real Estate Contract Number
RECNDAT RECNDAT DATS 37 8 0 Date of Contract Conclusion
RECNBEG RECNBEG DATS 45 8 0 Date of contract start
RECNEND RECNEND DATS 53 8 0 Date of contract end
RECNADJT SMVAR CHAR 61 1 0 TIV27 Lease-Out Adjustment Type
RECNTXT RECNTXT CHAR 62 80 0 Contract name
RECNDPO RECNDPO DATS 142 8 0 Date of first posting
RECNOBJNR J_OBJNR CHAR 150 22 0 ONR00 Object number
RECNNOTTYPE SMVKUEART CHAR 172 1 0 Notice Type of Lease-Out
RECNNOTKEY SKUEKEY CHAR 173 12 0 Notice rule
RECNNOTPER DKUZU DATS 185 8 0 Contract Notice Per
RECNAUTHGR VVBERGRP CHAR 193 40 0 Authorization group
RECNBUSAREA GSBER CHAR 233 4 0 TGSB Business Area
RECNPRCTR PRCTR CHAR 237 10 0 Profit Center
RECNACCDETVAL VVWERTN_ADCN CHAR 247 10 0 TIVCN08 Account determination key for account determination
RECNADMONTH VVJMABGR CHAR 257 1 0 Accrual/deferral method
RECNDDUNNED MADAT DATS 258 8 0 Date of Last Dunning Notice
RECNDCOMPLNT VVKLDATUM DATS 266 8 0 Date of complaint
RECNDCOMPLRC VVKLAKTZEI CHAR 274 20 0 Complaint reference code
RECNJURISDIC VVXGERSTD CHAR 294 35 0 Jurisdiction
IMKEY IMKEY CHAR 329 8 0 Internal Key for Real Estate Object
RERF RERF CHAR 337 12 0 Entered by
DERF DERF DATS 349 8 0 First Entered on
TERF TERF TIMS 357 6 0 Time of Initial Entry
REHER REHER CHAR 363 10 0 Source of initial entry
RBEAR RBEAR CHAR 373 12 0 Employee ID
DBEAR DBEAR DATS 385 8 0 Last Edited on
TBEAR TBEAR TIMS 393 6 0 Last Edited at
RBHER RBHER CHAR 399 10 0 Editing Source
RECNUNIT RECNUNIT UNIT 409 3 0 T006 Area unit
RECNKUNNR KUNNR CHAR 412 10 0 KNA1 Customer Number
RECNLIFNR LIFNR CHAR 422 10 0 LFA1 Account Number of Vendor or Creditor
RECNTXJCD TXJCD CHAR 432 15 0 TTXJ Tax Jurisdiction
RECNCURR RECNWAERS_H CUKY 447 5 0 TCURC Currency key for local currency
RECNTLAW SMIETR CHAR 452 5 0 TIV03 Tenancy law
RECNCURR2 RECNWAERS_D CUKY 457 5 0 TCURC Currency key for the display currency
RECNTXTOLD VVOSMIVE CHAR 462 20 0 Number of old contract
RECNDACTIV DAKTV DATS 482 8 0 Contract activation
RECNNRCOLLECT RECNNRCOLLECT CHAR 490 13 0 Number of Real Estate main contract
RECNKOSTL RECNKOSTL CHAR 503 10 0 Cost center of internal contract
ZLSCH DZLSCH CHAR 513 1 0 T042E Payment Method
RECNPREDATA RECNPREDATA CHAR 514 1 0 Flag: Predefined rates
SPARTNR BP_PARTNR CHAR 515 10 0 Business Partner Number
RECNNOTRECEIPT DEKUEA DATS 525 8 0 Receipt or issue date of notice
RECNNOTREASON RKUEGRU NUMC 533 2 0 Reason for notice
RECNNOTINVREA RABLGRU NUMC 535 2 0 Reason for rejection
RECNJVSTOPT VVJVSTOPT CHAR 537 1 0 Input tax opting (indicator)
RECNVSTSOND SVSTSOND CHAR 538 1 0 TIV63 Input tax opting reason
RECNMANSP MANSP CHAR 539 1 0 T040S Dunning Block
RECNMABER MABER CHAR 540 2 0 T047M Dunning Area
RECNMAHNA MAHNA CHAR 542 4 0 Dunning Procedure
RECNMAHNS_D MAHNS_D NUMC 546 1 0 Dunning Level
RECNNOTCAT SKUAR CHAR 547 1 0 Notice Type
RECNGFZLSCH RECNGFZLSCH CHAR 548 1 0 T042E Payment method for credit memos
RECNZLSPR DZLSPR CHAR 549 1 0 Payment Block Key
RECNHBKID HBKID CHAR 550 5 0 T012 Short Key for a House Bank
RECNXBLNR RECNXBLNR1 CHAR 555 16 0 Note to payee
RECNDKUZUG VVDKUZUG DATS 571 8 0 Date notice approved
RECNDKUABG VVDKUABG DATS 579 8 0 Date notice rejected
RECNDWIKU VVDWIKU DATS 587 8 0 Date of objection to notice
RECNDKUERCK DKUERCK DATS 595 8 0 Date of withdrawal of notice
RECNDKREUEB VVDKREUEB DATS 603 8 0 Date notice submitted to legal department
RECNDAKTKU VVDAKTKU DATS 611 8 0 Activation date
RECNDSTKU VVDSTKU DATS 619 8 0 Reversal date
RECNADJTTYPE RECNADJTTYPE CHAR 627 1 0 Adjustment triggered by
RECNADJTRUECK RECNADJTRUECK CHAR 628 1 0 Retroactive adjustment possible
RECNBUKRSCOLLECT RECNBUKRSCOLLECT CHAR 629 4 0 T001 Company code of main contract
RECNBASISAEZIF RECNBASISAEZIF INT2 634 5 0 Base: equivalence number distribution
RECNXCROSS RECNXCROSS CHAR 636 1 0 Gross amount indicator
RECNMANDAT RECNMANDAT CHAR 637 20 0 Mandate
RECNMANDATTYP RECNMANDATTYP NUMC 657 1 0 Role of Contract in Mandate
RECNFLESR VVKZESR CHAR 658 1 0 Activation of POR functions
RECNESRNROW VVESRNR_EIG NUMC 659 9 0 POR participant number of owner
RECNESRCUIDOW VVESRKUID_EIG CHAR 668 15 0 POR customer identification number
RECNVATNROW VVMWSTNR_EIG CHAR 683 20 0 Value-added tax of owner
RECNBUKRSGKT VVBUKRS_GKT CHAR 703 4 0 T001 Object and account CoCd
RECNKZEIGGKT VVKZEIGGKT CHAR 707 1 0 Cash account control for owner
RELSKASSENZ RELSKASSENZ CHAR 708 30 0
RELSGRDNR RELSGRDNR CHAR 738 30 0
RELSSUBTYPE RELSSUBTYPE CHAR 768 4 0 TIVLSCNSTYPE
RELSAKTZ RELSAKTZ CHAR 772 35 0
RELSDAT2 RELSDAT2 DATS 807 8 0
RELSWIRTUEBG RELSWIRTUEBG DATS 815 8 0
RELSNOTEARLY RELSNOTEARLY DATS 823 8 0
RELSOWNER BP_PARTNR CHAR 831 10 0 Business Partner Number
RELSROLETYP BP_ROLETYP CHAR 841 4 0 TPZ3 Business Partner Role Category
CREATIONTYPE RECACREATIONTYPE CHAR 845 1 0 How the Object Was Created
RECNCNCURR RECNWAERS_CN CUKY 846 5 0 TCURC Currency for Contract
RECNENDABS RECNCNENDABS DATS 851 8 0 Term End Date
RECN2DAT RECN2DAT DATS 859 8 0 Date of Second Signature
RESPONSIBLE RECARESPONSIBLE CHAR 867 12 0 USR02 Person Responsible
USEREXCLUSIVE RECAUSEREXCLUSIVE CHAR 879 12 0 USR02 User with Exclusive Change Authorization
SRRELEVANT RECNSALESRENTRELEVANT CHAR 891 1 0 Relevant to Sales
CFARCHIVEDTO RECDCFARCHIVEDTO DATS 892 8 0 Date Up to Which the Cash Flow Is Archived
CFLOCKEDTO RECDCFLOCKEDTO DATS 900 8 0 Date Until Which the Cash Flow Is Locked
INDUSTRY BU_IND_SECTOR CHAR 908 10 0 Industry
DPTARGETTYPE RECNDPTYPE CHAR 918 4 0 TIVCNDPTYPE Security Deposit Type
BIRELEASE RELUBIRELEASE CHAR 922 1 0
BIVALIDFROM RELUBIVALIDFROM DATS 923 8 0
BIVALIDTO RELUBIVALIDTO DATS 931 8 0
BIREPRTO RELUBIREPRTO DATS 939 8 0
BIREPRTOTIME RELUBIREPRTOTIME TIMS 947 6 0
BIRECAT RELUBIRECAT CHAR 953 2 0
PUBLICTYPE RELUPUBLICTYPE CHAR 955 2 0
FILENO RELUFILENO CHAR 957 35 0
BIPURPOSE RELUBIPURPOSE CHAR 992 2 0
BIPRICING RELUBIPRICING CHAR 994 2 0

1548018DMS document links to REFX lost
734981RE-FX upgrade from 470x200 to ERP 2004 or a subsequent relea
1003934RFVICNTAX01 for using user fields
690900User-defined real estate master data fields as of 470x200
632104User-defined fields real estate contract RE-FX 470x110
548173General contract: Display user-defined fields
453273Periodic posting: fill POR data