1. Home
  2. Resources
  3. SAP Tables
  4. RECN_CONTRACT - Real Estate Contract

SAP Table RECN_CONTRACT

Real Estate Contract

RECN_CONTRACT (Real Estate Contract) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link RECN_CONTRACT to other SAP tables.

RECN_CONTRACT table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
INTRENO Internal Key of Real Estate Object RECAINTRENO CHAR 13 0
BUKRS Company Code BUKRS T001 CHAR 4 0
RECNNR Contract Number RECNNUMBER CHAR 13 0
OBJNR Object Number RECAOBJNR CHAR 22 0
IMKEY Internal Key of Real Estate Object (FI) RECAIMKEY CHAR 8 0
CREATIONTYPE How the Object Was Created RECACREATIONTYPE CHAR 1 0
NULL 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 RERF CHAR 12 0
DERF First Entered on DERF DATS 8 0
TERF Time of Initial Entry TERF TIMS 6 0
REHER Source of initial entry REHER CHAR 10 0
RBEAR Employee ID RBEAR CHAR 12 0
DBEAR Last Edited on DBEAR DATS 8 0
TBEAR Last Edited at TBEAR TIMS 6 0
RBHER Editing Source RBHER CHAR 10 0
RESPONSIBLE Person Responsible RECARESPONSIBLE USR02 CHAR 12 0
USEREXCLUSIVE User with Exclusive Change Authorization RECAUSEREXCLUSIVE USR02 CHAR 12 0
AUTHGRP Authorization Group RECAAUTHGRP CHAR 40 0
RECNTYPE Contract Type RECNCONTRACTTYPE TIV26 CHAR 4 0
RECNBEG Date of contract start RECNCNBEG DATS 8 0
RECNENDABS Term End Date RECNCNENDABS DATS 8 0
RECNTXT Contract name RECNTXT CHAR 80 0
RECNDACTIV Contract activation DAKTV DATS 8 0
RECNTLAW Tenancy law SMIETR TIV03 CHAR 5 0
RECNTXTOLD Number of old contract VVOSMIVE CHAR 20 0
RECNBUKRSCOLLECT Company code of main contract RECNBUKRSCOLLECT T001 CHAR 4 0
RECNNRCOLLECT Number of Real Estate Main Contract RECNNUMBERCOLLECT CHAR 13 0
RECNCNCURR Currency for Contract RECNWAERS_CN TCURC CUKY 5 0
INDUSTRY Industry BU_IND_SECTOR CHAR 10 0
SRRELEVANT Relevant to Sales RECNSALESRENTRELEVANT CHAR 1 0
X Yes
NULL No
DPTARGETTYPE Security Deposit Type RECNDPTYPE TIVCNDPTYPE CHAR 4 0
RECNDAT Date of Contract Conclusion RECNDAT DATS 8 0
RECN2DAT Date of Second Signature RECN2DAT DATS 8 0
RECNDPO Cash Flow Generated Starting On RECDCFSTARTFROM DATS 8 0
RECNEND1ST Date of First Contract End RECNCNEND1ST DATS 8 0
RECNNOTPER Contract Notice Per RECNNTPER DATS 8 0
RECNNOTRECEIPT Date of receipt of notice RECNNTRECEIPT DATS 8 0
RECNNOTREASON Reason for Notice RECNNTREASON TIVCNNTRE NUMC 2 0
RECNDAKTKU Notice: Date of Activation RECNNTACTIVATEDON DATS 8 0
CFARCHIVEDTO Date Up to Which the Cash Flow Is Archived RECDCFARCHIVEDTO DATS 8 0
CFLOCKEDTO Date Until Which the Cash Flow Is Locked RECDCFLOCKEDTO DATS 8 0
CFPOSTINGFROM First Posting From RECDCFPOSTINGFROM DATS 8 0
BENOCN Site That Belongs to Contract RECNBENOCN CHAR 8 0
TRANSPOSSFROM Transfer of Possession: Start Date RECNTRANSPOSSFROM DATS 8 0
TRANSPOSSTO Transfer of Possession: End Date RECNTRANSPOSSTO DATS 8 0
HASMULTIASSIGN Multiple Assignment of Object to Group Allowed REBDHASMULTIASSIGN CHAR 1 0
X Yes
NULL No
POSSDATEFROM Date From Which the Object Is Made Available for Use REBDPOSSDATEFROM DATS 8 0
POSSDATETO Date Up to Which the Object Is Used REBDPOSSDATETO DATS 8 0
SECDEPRELEVANT Relevant to Security Deposit REXCESCDREL CHAR 1 0
X Yes
NULL No
NOTADJSDCN No Data Update in Security Deposit Contract REXCESCDNOTADJ CHAR 1 0
X Yes
NULL No
REYCMAJORCN CAM Major Contract REYCMAJORCN CHAR 13 0
REYCDEDUCTMEAS Deduct Major Tenant Space in Den. when Calc. Subtenant Share REYCDEDUCTMEAS CHAR 1 0
X Yes
NULL No
REYCMAJORTNT Major Tenant Contribution Indicator REYCMAJORTNT CHAR 1 0
X Yes
NULL No
REYCISSUECREDIT Issue Credit REYCISSUECREDIT CHAR 1 0
N No cedit
F Issue credit at final settlement
A Issue credit at all settlement
REYCPOSDATEREL Possession Date Relevant REYCPOSDATEREL CHAR 1 0
X Yes
NULL No

RECN_CONTRACT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
RECN_CONTRACT BUKRS SYST MANDT T001 Company Codes MANDT
RECN_CONTRACT BUKRS RECN_CONTRACT BUKRS T001 Company Codes BUKRS
RECN_CONTRACT DPTARGETTYPE SYST MANDT TIVCNDPTYPE Security Deposit Type MANDT
RECN_CONTRACT DPTARGETTYPE RECN_CONTRACT DPTARGETTYPE TIVCNDPTYPE Security Deposit Type DPTYPE
RECN_CONTRACT RECNBUKRSCOLLECT RECN_CONTRACT RECNBUKRSCOLLECT T001 Company Codes BUKRS
RECN_CONTRACT RECNBUKRSCOLLECT SYST MANDT T001 Company Codes MANDT
RECN_CONTRACT RECNCNCURR SYST MANDT TCURC Currency Codes MANDT
RECN_CONTRACT RECNCNCURR RECN_CONTRACT RECNCNCURR TCURC Currency Codes WAERS
RECN_CONTRACT RECNNOTREASON SYST MANDT TIVCNNTRE Reason for Notice MANDT
RECN_CONTRACT RECNNOTREASON RECN_CONTRACT RECNNOTREASON TIVCNNTRE Reason for Notice NTREASON
RECN_CONTRACT RECNTLAW SYST MANDT TIV03 Country-specific tenancy law MANDT
RECN_CONTRACT RECNTLAW RECN_CONTRACT RECNTLAW TIV03 Country-specific tenancy law SMIETR
RECN_CONTRACT RECNTYPE SYST MANDT TIV26 Real Estate Contract Type (Entities) MANDT
RECN_CONTRACT RECNTYPE RECN_CONTRACT RECNTYPE TIV26 Real Estate Contract Type (Entities) SMVART
RECN_CONTRACT RESPONSIBLE SYST MANDT USR02 Logon Data (Kernel-Side Use) MANDT
RECN_CONTRACT RESPONSIBLE RECN_CONTRACT RESPONSIBLE USR02 Logon Data (Kernel-Side Use) BNAME
RECN_CONTRACT USEREXCLUSIVE SYST MANDT USR02 Logon Data (Kernel-Side Use) MANDT
RECN_CONTRACT USEREXCLUSIVE RECN_CONTRACT USEREXCLUSIVE USR02 Logon Data (Kernel-Side Use) BNAME