SAP table RECNFLDS (Real Estate Contract: Work Fields and Screen Fields)

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 * MANDT
INTRENO Internal Real Estate Master Data Code CHAR 13 0 VVINTRENO
BUKRS Company Code CHAR 4 0 T001 BUKRS
RECNTYPE External Real Estate Contract Type CHAR 4 0 TIV26 SMVART
RECNNR Real Estate Contract Number CHAR 13 0 RECNNR
RECNDAT Date of Contract Conclusion DATS 8 0 RECNDAT
RECNBEG Date of contract start DATS 8 0 RECNBEG
RECNEND Date of contract end DATS 8 0 RECNEND
RECNADJT Lease-Out Adjustment Type CHAR 1 0 * SMVAR
RECNTXT Contract Name CHAR 80 0 RECNTXT
RECNDPO Date of first posting DATS 8 0 RECNDPO
RECNOBJNR Object number CHAR 22 0 * J_OBJNR
RECNNOTTYPE Notice Type of Lease-Out CHAR 1 0 SMVKUEART
No period of notice
1 Period reg.
2 Deadline reg.
3 free period reg.
4 free deadline reg.
RECNNOTKEY Notice rule CHAR 12 0 SKUEKEY
RECNNOTPER Contract Notice Per DATS 8 0 DKUZU
RECNAUTHGR Authorization group CHAR 40 0 VVBERGRP
RECNBUSAREA Business Area CHAR 4 0 TGSB GSBER
RECNPRCTR Profit Center CHAR 10 0 CEPC PRCTR
RECNACCDETVAL Account determination key for account determination CHAR 10 0 TIVCN08 VVWERTN_ADCN
RECNADMONTH Accrual/deferral method CHAR 1 0 VVJMABGR
RECNDDUNNED Date of Last Dunning Notice DATS 8 0 MADAT
RECNDCOMPLNT Date of complaint DATS 8 0 VVKLDATUM
RECNDCOMPLRC Complaint reference code CHAR 20 0 VVKLAKTZEI
RECNJURISDIC Jurisdiction CHAR 35 0 VVXGERSTD
IMKEY Internal Key for Real Estate Object CHAR 8 0 IMKEY
RERF Entered By CHAR 12 0 RERF
DERF First Entered On DATS 8 0 DERF
TERF Time of Creation TIMS 6 0 TERF
REHER Source of Initial Entry CHAR 10 0 REHER
RBEAR Employee ID CHAR 12 0 RBEAR
DBEAR Last Edited On DATS 8 0 DBEAR
TBEAR Last Edited At TIMS 6 0 TBEAR
RBHER Editing Source CHAR 10 0 RBHER
RECNUNIT Area unit UNIT 3 0 T006 RECNUNIT
RECNKUNNR Customer Number CHAR 10 0 KNA1 KUNNR
RECNLIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
RECNTXJCD Tax Jurisdiction CHAR 15 0 * TXJCD
RECNCURR Currency key for local currency CUKY 5 0 TCURC RECNWAERS_H
RECNTLAW Tenancy law CHAR 5 0 TIV03 SMIETR
RECNCURR2 Currency key for the display currency CUKY 5 0 TCURC RECNWAERS_D
RECNTXTOLD Number of old contract CHAR 20 0 VVOSMIVE
RECNDACTIV Contract activation DATS 8 0 DAKTV
RECNNRCOLLECT Number of Real Estate Main Contract CHAR 13 0 RECNNRCOLLECT
RECNKOSTL Cost center of internal contract CHAR 10 0 * RECNKOSTL
ZLSCH Payment Method CHAR 1 0 * DZLSCH
RECNPREDATA Flag: Predefined rates CHAR 1 0 RECNPREDATA
SPARTNR Business Partner Number CHAR 10 0 * BP_PARTNR
RECNNOTRECEIPT Receipt or issue date of notice DATS 8 0 DEKUEA
RECNNOTREASON Reason for notice NUMC 2 0 TIV39 RKUEGRU
RECNNOTINVREA Reason for rejection NUMC 2 0 TIV41 RABLGRU
RECNJVSTOPT Input tax opting (indicator) CHAR 1 0 VVJVSTOPT
RECNVSTSOND Input tax opting reason CHAR 1 0 TIV63 SVSTSOND
RECNMANSP Dunning Block CHAR 1 0 T040S MANSP
RECNMABER Dunning Area CHAR 2 0 T047M MABER
RECNMAHNA Dunning Procedure CHAR 4 0 T047A MAHNA
RECNMAHNS_D Dunning Level NUMC 1 0 MAHNS_D
RECNNOTCAT Notice Type CHAR 1 0 SKUAR
1 Tenant-side
2 Landlord-side
RECNGFZLSCH Payment method for credit memos CHAR 1 0 * RECNGFZLSCH
RECNZLSPR Payment Block Key CHAR 1 0 T008 DZLSPR
RECNHBKID Short Key for a House Bank CHAR 5 0 T012 HBKID
RECNXBLNR Note to payee CHAR 16 0 RECNXBLNR1
RECNDKUZUG Date notice approved DATS 8 0 VVDKUZUG
RECNDKUABG Date notice rejected DATS 8 0 VVDKUABG
RECNDWIKU Date of objection to notice DATS 8 0 VVDWIKU
RECNDKUERCK Date of withdrawal of notice DATS 8 0 DKUERCK
RECNDKREUEB Date notice submitted to legal department DATS 8 0 VVDKREUEB
RECNDAKTKU Activation date DATS 8 0 VVDAKTKU
RECNDSTKU Reversal date DATS 8 0 VVDSTKU
RECNADJTTYPE Adjustment triggered by CHAR 1 0 RECNADJTTYPE
Tenant
1 Landlord
RECNADJTRUECK Retroactive adjustment possible CHAR 1 0 RECNADJTRUECK
RECNBUKRSCOLLECT Company Code of Main Contract CHAR 4 0 T001 RECNBUKRSCOLLECT
RECNBASISAEZIF Base: equivalence number distribution INT2 5 0 RECNBASISAEZIF
RECNXCROSS Gross amount indicator CHAR 1 0 RECNXCROSS
RECNMANDAT Mandate CHAR 20 0 RECNMANDAT
RECNMANDATTYP Role of Contract in Mandate NUMC 1 0 RECNMANDATTYP
0 No Mandate Contract
1 Object Mandate (Simple Mandate)
5 Condominium Owners Association (COA)
6 Condominium Managemement (Separate Ownership)
9 Assessment Contract
RECNFLESR Activation of POR functions CHAR 1 0 VVKZESR
RECNESRNROW POR participant number of owner NUMC 9 0 TIV9I VVESRNR_EIG
RECNESRCUIDOW POR customer identification number CHAR 15 0 TIV9I VVESRKUID_EIG
RECNVATNROW Value-added tax of owner CHAR 20 0 VVMWSTNR_EIG
RECNBUKRSGKT Object and account CoCd CHAR 4 0 T001 VVBUKRS_GKT
RECNKZEIGGKT Cash account control for owner CHAR 1 0 VVKZEIGGKT
No control is active
1 No owner account - Administrator has pool account
2 No owner account - Objects have pool account
3 Owner account with automatic payment (incoming/outgoing)
4 Owner account with automatic payment (incoming)
5 Owner account with automatic payment (outgoing)
6 Owner account without automatic payment
RELSKASSENZ CHAR 30 0 RELSKASSENZ
RELSGRDNR CHAR 30 0 RELSGRDNR
RELSSUBTYPE CHAR 4 0 TIVLSCNSTYPE RELSSUBTYPE
RELSAKTZ CHAR 35 0 RELSAKTZ
RELSDAT2 DATS 8 0 RELSDAT2
RELSWIRTUEBG DATS 8 0 RELSWIRTUEBG
RELSNOTEARLY DATS 8 0 RELSNOTEARLY
RELSOWNER Business Partner Number CHAR 10 0 * BP_PARTNR
RELSROLETYP Business Partner Role Category CHAR 4 0 * BP_ROLETYP
CREATIONTYPE How the Object Was Created CHAR 1 0 RECACREATIONTYPE
Object created in Classic RE
1 Object created in Classic RE or migrated from other system
2 Object created in Flexible Real Estate Management
RECNCNCURR Currency for Contract CUKY 5 0 TCURC RECNWAERS_CN
RECNENDABS Term End Date DATS 8 0 RECNCNENDABS
RECN2DAT Date of Second Signature DATS 8 0 RECN2DAT
RESPONSIBLE Person Responsible CHAR 12 0 RECARESPONSIBLE
USEREXCLUSIVE User with Exclusive Change Authorization CHAR 12 0 RECAUSEREXCLUSIVE
SRRELEVANT Indicator: Relevant to Sales CHAR 1 0 RECNSALESRENTRELEVANT
CFARCHIVEDTO Date Up to Which the Cash Flow Is Archived DATS 8 0 RECDCFARCHIVEDTO
CFLOCKEDTO Date Until Which the Cash Flow Is Locked DATS 8 0 RECDCFLOCKEDTO
INDUSTRY Industry CHAR 10 0 * BU_IND_SECTOR
DPTARGETTYPE Security Deposit Type CHAR 4 0 TIVCNDPTYPE RECNDPTYPE
BIRELEASE CHAR 1 0 RELUBIRELEASE
BIVALIDFROM DATS 8 0 RELUBIVALIDFROM
BIVALIDTO DATS 8 0 RELUBIVALIDTO
BIREPRTO DATS 8 0 RELUBIREPRTO
BIREPRTOTIME TIMS 6 0 RELUBIREPRTOTIME
BIRECAT CHAR 2 0 TIVLUBIRECAT RELUBIRECAT
PUBLICTYPE CHAR 2 0 TIVLUPUBLICTYPE RELUPUBLICTYPE
FILENO CHAR 35 0 RELUFILENO
BIPURPOSE CHAR 2 0 TIVLUBIPURPOSE RELUBIPURPOSE
BIPRICING CHAR 2 0 TIVLUBIPRICING RELUBIPRICING
RECNTYPETXT Description of type of RE contract type CHAR 30 0 XMVARTM
BUKRSTXT Name of Company Code or Company CHAR 25 0 BUTXT
RECNTERM Contract term in months NUMC 4 0 VVNLAUFZ
BUT_NOTICE Carrier field for icons CHAR 132 0 ICON_TEXT
BUT_RESUBMIS Message ID CHAR 2 0 VVMSGID
RECNDSUBMIS Resubmission date DATS 8 0 RECNDSUBMIS
RECNTSUBMIS Resubmission name CHAR 50 0 RECNTSUBMIS
RECNTSUBMISOK Resubmission carried out? CHAR 1 0 RECNTSUBMISOK
BUT_AUTHGRP Carrier field for icons CHAR 132 0 ICON_TEXT
RECNPRCTRTXT Name of profit center CHAR 20 0 RECNPRCTTXT
RECNBUSAREATXT Business area description CHAR 30 0 GTEXT
COUNT_WE No. of business entities DEC 6 0 VVAWE
COUNT_GR No. of properties DEC 6 0 VVAGR
COUNT_GB No. of buildings DEC 6 0 VVAGE
COUNT_ME Number of rental units DEC 6 0 VVAME
COUNT_MV No. of lease-outs DEC 6 0 VVAMV
BUT_INSERT_LINE Message ID CHAR 2 0 VVMSGID
BUT_DELETE_LINE Message ID CHAR 2 0 VVMSGID
BUT_DETAIL Message ID CHAR 2 0 VVMSGID
BUT_DELETE Message ID CHAR 2 0 VVMSGID
BUT_INSERT Message ID CHAR 2 0 VVMSGID
DFAELL Due date DATS 8 0 DFAELL
DFAELL2 Due date DATS 8 0 DFAELL
BUT_FIN_OLD Message ID CHAR 2 0 VVMSGID
BUT_FIN_NEW Message ID CHAR 2 0 VVMSGID
BUT_EXPAND Message ID CHAR 2 0 VVMSGID
BUT_COLLAPSE Message ID CHAR 2 0 VVMSGID
BUT_UNDO Message ID CHAR 2 0 VVMSGID
BUT_NOTE_EDIT Message ID CHAR 2 0 VVMSGID
BUT_NOTE_SEND Message ID CHAR 2 0 VVMSGID
BUT_ADJT Carrier field for icons CHAR 132 0 ICON_TEXT
JDIVANP Do several adjustment types exist? CHAR 1 0 VVJDIVANP
RECNADJTTXT Description of LO adjustment type CHAR 30 0 XMVANARTM
RECNNRCOLTXT Contract Name CHAR 80 0 RECNTXT
BUT_NRCOLLECT Message ID CHAR 2 0 VVMSGID
RECNKUNNRTXT Address line CHAR 80 0 RECNADRLINE
RECNLIFNRTXT Address line CHAR 80 0 RECNADRLINE
RECNKUNNRLIFNRTXT Address line CHAR 80 0 RECNADRLINE
BUT_SUPPORT Message ID CHAR 2 0 VVMSGID
BUT_ANPASS Message ID CHAR 2 0 VVMSGID
BUT_STAFFEL Message ID CHAR 2 0 VVMSGID
BUT_SUM_KOND Message ID CHAR 2 0 VVMSGID
BUT_EXPAND1 Message ID CHAR 2 0 VVMSGID
BUT_COLLAPSE1 Message ID CHAR 2 0 VVMSGID
BUT_HISTORY Message ID CHAR 2 0 VVMSGID
OBJECTTXT1 Text for Real Estate object CHAR 60 0 VVOBJTXT
OBJECTTXT2 Address line CHAR 80 0 RECNADRLINE
BUT_EXPAND2 Message ID CHAR 2 0 VVMSGID
BUT_COLLAPSE2 Message ID CHAR 2 0 VVMSGID
DAT_VERTEIL_BEG Date from when assignment is valid DATS 8 0 DGULTAB
DAT_VERTEIL_END Date up to when the assignment is valid DATS 8 0 DGULTBIS
BUT_INSERT_LINE1 Message ID CHAR 2 0 VVMSGID
BUT_DELETE_LINE1 Message ID CHAR 2 0 VVMSGID
BUT_VERTEIL_DATE Message ID CHAR 2 0 VVMSGID
BUT_VERTEIL_COPY Message ID CHAR 2 0 VVMSGID
BUT_VERTEIL_DEL Message ID CHAR 2 0 VVMSGID
BUT_VERTEIL_NEW Message ID CHAR 2 0 VVMSGID
BUT_VERTEIL_LIST Message ID CHAR 2 0 VVMSGID
BUT_VERTEIL_SIMU Message ID CHAR 2 0 VVMSGID
KOSTLTEXT Description CHAR 40 0 KLTXT
KOKRS Controlling Area CHAR 4 0 KOKRS
KOKRSTEXT Name of the controlling area CHAR 25 0 BEZEI
VBUKRS Company Code CHAR 4 0 BUKRS
VRECNNR Real Estate Contract Number CHAR 13 0 RECNNR
CHECK_1 Checkbox CHAR 1 0 VVJFELD
CHECK_2 Checkbox CHAR 1 0 VVJFELD
CHECK_3 Checkbox CHAR 1 0 VVJFELD
CHECK_4 Checkbox CHAR 1 0 VVJFELD
CHECK_5 Checkbox CHAR 1 0 VVJFELD
CHECK_6 Checkbox CHAR 1 0 VVJFELD
CHECK_7 Checkbox CHAR 1 0 VVJFELD
CHECK_8 Checkbox CHAR 1 0 VVJFELD
CHECK_9 Checkbox CHAR 1 0 VVJFELD
CHECK_10 Checkbox CHAR 1 0 VVJFELD
ZLSCHTEXT Name of Payment Method in Language of the Country/Region CHAR 30 0 TEXT1_042Z
CHECK_USE_PREDATA Checkbox CHAR 1 0 VVJFELD
RECNUNITTXT Unit of Measurement Text (Maximum 30 Characters) CHAR 30 0 MSEHL
BUT_LEGENDE Message ID CHAR 2 0 VVMSGID
SPARTNRTXT Address line CHAR 80 0 RECNADRLINE
DKGSTZL Date of (calculated) notice DATS 8 0 VVDKGSTZL
RECNNOTREASONTXT Notice reason short name CHAR 15 0 XKKUEGRU
GFZLSCHTEXT Name of Payment Method in Language of the Country/Region CHAR 30 0 TEXT1_042Z
RECNZLSPRTXT Explanation of the Reason for Payment Block CHAR 20 0 TEXTL_008
RECNHBKIDTXT Description CHAR 50 0 FIBL_TXT50
BUT_NOTICE_ACT Message ID CHAR 2 0 VVMSGID
BUT_NOTICE_DEACT Message ID CHAR 2 0 VVMSGID
RECNMABERTXT Text CHAR 50 0 TEXT1
BUT_SEL_ALL Message ID CHAR 2 0 VVMSGID
BUT_UNSEL_ALL Message ID CHAR 2 0 VVMSGID
BUT_GEN_VERTEIL Message ID CHAR 2 0 VVMSGID
RECNNR_SHOW Real Estate Contract Number CHAR 13 0 RECNNR
BUT_DO_VORBELEG Message ID CHAR 2 0 VVMSGID
BUT_PARTNER Message ID CHAR 2 0 VVMSGID
BUT_PARTNER_Z Message ID CHAR 2 0 VVMSGID
BUT_PARTNER_A Message ID CHAR 2 0 VVMSGID
BUT_PARTNER_L Message ID CHAR 2 0 VVMSGID
BUT_PARTNER_T Message ID CHAR 2 0 VVMSGID
BUT_PARTNER_H Message ID CHAR 2 0 VVMSGID
BUT_DELETE_LINE2 Message ID CHAR 2 0 VVMSGID
ADR_REF_SPARTNR Address ID CHAR 10 0 BP_ADR_REF

RECNFLDS foreign key relationships

Table Field Check Table Check Field
0 RECNFLDS BIPRICING TIVLUBIPRICING BIPRICING
1 RECNFLDS BIPURPOSE TIVLUBIPURPOSE BIPURPOSE
0 RECNFLDS BIRECAT TIVLUBIRECAT BIRECAT
1 RECNFLDS BUKRS T001 Company Codes BUKRS
0 RECNFLDS DPTARGETTYPE TIVCNDPTYPE Security Deposit Type DPTYPE
1 RECNFLDS PUBLICTYPE TIVLUPUBLICTYPE PUBLICTYPE
0 RECNFLDS RECNACCDETVAL TIVCN08 Account Determination Key 2 for General Contract AcctDet. KOEIGR
1 RECNFLDS RECNBUKRSCOLLECT T001 Company Codes BUKRS
0 RECNFLDS RECNBUKRSGKT T001 Company Codes BUKRS
1 RECNFLDS RECNBUSAREA TGSB Business Areas MANDT
1 RECNFLDS RECNBUSAREA TGSB Business Areas GSBER
0 RECNFLDS RECNCNCURR TCURC Currency Codes MANDT
0 RECNFLDS RECNCNCURR TCURC Currency Codes WAERS
1 RECNFLDS RECNCURR TCURC Currency Codes MANDT
1 RECNFLDS RECNCURR TCURC Currency Codes WAERS
0 RECNFLDS RECNCURR2 TCURC Currency Codes MANDT
0 RECNFLDS RECNCURR2 TCURC Currency Codes WAERS
1 RECNFLDS RECNESRCUIDOW TIV9I RE: Owner POR Data (Switzerland) MANDT
1 RECNFLDS RECNESRCUIDOW TIV9I RE: Owner POR Data (Switzerland) BUKRS
0 RECNFLDS RECNESRNROW TIV9I RE: Owner POR Data (Switzerland) MANDT
0 RECNFLDS RECNESRNROW TIV9I RE: Owner POR Data (Switzerland) BUKRS
1 RECNFLDS RECNHBKID T012 House Banks BUKRS
0 RECNFLDS RECNKUNNR KNA1 General Data in Customer Master MANDT
0 RECNFLDS RECNKUNNR KNA1 General Data in Customer Master KUNNR
1 RECNFLDS RECNLIFNR LFA1 Supplier Master (General Section) MANDT
1 RECNFLDS RECNLIFNR LFA1 Supplier Master (General Section) LIFNR
0 RECNFLDS RECNMABER T047M Dunning areas MANDT
0 RECNFLDS RECNMABER T047M Dunning areas BUKRS
1 RECNFLDS RECNMAHNA T047A Account Level Dunning Control MANDT
0 RECNFLDS RECNNOTINVREA TIV41 Lease-out notice rejection reason RABLGRU
1 RECNFLDS RECNNOTREASON TIV39 Reason for notice RKUEGRU
0 RECNFLDS RECNPRCTR CEPC Profit Center Master Data Table PRCTR
0 RECNFLDS RECNPRCTR CEPC Profit Center Master Data Table DATBI
0 RECNFLDS RECNPRCTR CEPC Profit Center Master Data Table KOKRS
1 RECNFLDS RECNTLAW TIV03 Country-specific tenancy law MANDT
0 RECNFLDS RECNTYPE TIV26 Real Estate Contract Type (Entities) MANDT
0 RECNFLDS RECNTYPE TIV26 Real Estate Contract Type (Entities) SMVART
1 RECNFLDS RECNUNIT T006 Units of Measurement MANDT
0 RECNFLDS RECNVSTSOND TIV63 Reasons for input tax option MANDT
1 RECNFLDS RECNZLSPR T008 Blocking Reasons for Automatic Payment Transcations MANDT
1 RECNFLDS RECNZLSPR T008 Blocking Reasons for Automatic Payment Transcations ZAHLS
0 RECNFLDS RELSSUBTYPE TIVLSCNSTYPE MANDT
0 RECNFLDS RELSSUBTYPE TIVLSCNSTYPE RELSSUBTYPE