SAP table RECN_CONTRACT_X (Real Estate Contract and Additional Fields)

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 * MANDT
INTRENO Internal Key of Real Estate Object CHAR 13 0 RECAINTRENO
BUKRS Company Code CHAR 4 0 T001 BUKRS
RECNNR Contract Number CHAR 13 0 RECNNUMBER
OBJNR Object Number CHAR 22 0 * RECAOBJNR
IMKEY Internal Key of Real Estate Object (FI) CHAR 8 0 RECAIMKEY
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
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
RESPONSIBLE Person Responsible CHAR 12 0 USR02 RECARESPONSIBLE
USEREXCLUSIVE User with Exclusive Change Authorization CHAR 12 0 USR02 RECAUSEREXCLUSIVE
AUTHGRP Authorization Group CHAR 40 0 RECAAUTHGRP
RECNTYPE Contract Type CHAR 4 0 TIV26 RECNCONTRACTTYPE
RECNBEG Date of contract start DATS 8 0 RECNCNBEG
RECNENDABS Term End Date DATS 8 0 RECNCNENDABS
RECNTXT Contract Name CHAR 80 0 RECNTXT
RECNDACTIV Contract activation DATS 8 0 DAKTV
RECNTLAW Tenancy law CHAR 5 0 TIV03 SMIETR
RECNTXTOLD Number of old contract CHAR 20 0 VVOSMIVE
RECNBUKRSCOLLECT Company Code of Main Contract CHAR 4 0 T001 RECNBUKRSCOLLECT
RECNNRCOLLECT Number of Real Estate Main Contract CHAR 13 0 RECNNUMBERCOLLECT
RECNCNCURR Currency for Contract CUKY 5 0 RECNWAERS_CN
INDUSTRY Industry CHAR 10 0 * BU_IND_SECTOR
SRRELEVANT Indicator: Relevant to Sales CHAR 1 0 RECNSALESRENTRELEVANT
DPTARGETTYPE Security Deposit Type CHAR 4 0 TIVCNDPTYPE RECNDPTYPE
RECNDAT Date of Contract Conclusion DATS 8 0 RECNDAT
RECN2DAT Date of Second Signature DATS 8 0 RECN2DAT
RECNDPO Cash Flow Generated Starting On DATS 8 0 RECDCFSTARTFROM
RECNEND1ST Date of First Contract End DATS 8 0 RECNCNEND1ST
RECNNOTPER Contract Notice Per DATS 8 0 RECNNTPER
RECNNOTRECEIPT Date of receipt of notice DATS 8 0 RECNNTRECEIPT
RECNNOTREASON Reason for Notice NUMC 2 0 TIVCNNTRE RECNNTREASON
RECNDAKTKU Notice: Date of Activation DATS 8 0 RECNNTACTIVATEDON
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
CFPOSTINGFROM First Posting From DATS 8 0 RECDCFPOSTINGFROM
BENOCN Business Entity That Belongs to Contract CHAR 8 0 * RECNBENOCN
TRANSPOSSFROM Transfer of Possession: Start Date DATS 8 0 RECNTRANSPOSSFROM
TRANSPOSSTO Transfer of Possession: End Date DATS 8 0 RECNTRANSPOSSTO
HASMULTIASSIGN Multiple Assignment of Object to Group Allowed CHAR 1 0 REBDHASMULTIASSIGN
POSSDATEFROM Date From Which the Object Is Made Available for Use DATS 8 0 REBDPOSSDATEFROM
POSSDATETO Date Up to Which the Object Is Used DATS 8 0 REBDPOSSDATETO
RELEVANTEVAL Valuation Relevance CHAR 10 0 RECNRELEVANTEVAL
DUMMY_REC_PS Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY
SECDEPRELEVANT Relevant to Security Deposit CHAR 1 0 REXCESCDREL
NOTADJSDCN No Data Update in Security Deposit Contract CHAR 1 0 REXCESCDNOTADJ
XRECNNRCOL Contract Name CHAR 80 0 RECNTXT
XBUKRS Name of Company Code or Company CHAR 25 0 BUTXT
XRECNTYPE Description of type of RE contract type CHAR 30 0 XMVARTM
GSBER Business Area CHAR 4 0 GSBER
PRCTR Profit Center CHAR 10 0 PRCTR
KOSTL Cost Center CHAR 10 0 KOSTL
AUFNR Order Number CHAR 12 0 AUFNR
XTENANCYLAW Tenancy law long text CHAR 50 0 XMIETR
XCOLLECT Contract Name CHAR 80 0 RECNTXT
XAUTHGRP Description of Authorization Group CHAR 60 0 RECAXAUTHGRP
XINDUSTRY Industry Name CHAR 20 0 RECNINDUSTRY
XTRANSPOSSPERIOD Productive Holdings: Time Period CHAR 30 0 RECNXTRANSPOSSPERIOD
PSPNR WBS Element NUMC 8 0 PS_POSNR
XRELEVANTEVAL Description for Valuation Relevance CHAR 60 0 RECNXRELEVANTEVAL
KOSTLX Name of Cost Center CHAR 40 0 KOSTLX
AUFNRX Name of Order CHAR 40 0 AUFNRX
PSPNRX Name of Order CHAR 40 0 PSPNRX

RECN_CONTRACT_X foreign key relationships

Table Field Check Table Check Field
0 RECN_CONTRACT_X BUKRS T001 Company Codes BUKRS
1 RECN_CONTRACT_X DPTARGETTYPE TIVCNDPTYPE Security Deposit Type DPTYPE
0 RECN_CONTRACT_X RECNBUKRSCOLLECT T001 Company Codes BUKRS
1 RECN_CONTRACT_X RECNNOTREASON TIVCNNTRE Reason for Notice MANDT
1 RECN_CONTRACT_X RECNNOTREASON TIVCNNTRE Reason for Notice NTREASON
0 RECN_CONTRACT_X RECNTLAW TIV03 Country-specific tenancy law MANDT
1 RECN_CONTRACT_X RECNTYPE TIV26 Real Estate Contract Type (Entities) MANDT
1 RECN_CONTRACT_X RECNTYPE TIV26 Real Estate Contract Type (Entities) SMVART
0 RECN_CONTRACT_X RESPONSIBLE USR02 Logon Data (Kernel-Side Use) BNAME
1 RECN_CONTRACT_X USEREXCLUSIVE USR02 Logon Data (Kernel-Side Use) BNAME