1. Home
  2. Resources
  3. SAP Tables
  4. RECN_CONTRACT_X - Real Estate Contract and Additional Fields

SAP Table RECN_CONTRACT_X

Real Estate Contract and Additional Fields

RECN_CONTRACT_X (Real Estate Contract and Additional Fields) 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_X to other SAP tables.

Source: RECN_CONTRACT_X (Real Estate Contract and Additional Fields)

RECN_CONTRACT_X 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 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
XRECNNRCOL Contract name RECNTXT CHAR 80 0
XBUKRS Name of Company Code or Company BUTXT CHAR 25 0
XRECNTYPE Description of type of RE contract type XMVARTM CHAR 30 0
GSBER Business Area GSBER CHAR 4 0
PRCTR Profit Center PRCTR CHAR 10 0
KOSTL Cost Center KOSTL CHAR 10 0
AUFNR Order Number AUFNR CHAR 12 0
XTENANCYLAW Tenancy law long text XMIETR CHAR 50 0
XCOLLECT Contract name RECNTXT CHAR 80 0
XAUTHGRP Description of Authorization Group RECAXAUTHGRP CHAR 60 0
XINDUSTRY Industry Name RECNINDUSTRY CHAR 20 0
XTRANSPOSSPERIOD Productive Holdings: Time Period RECNXTRANSPOSSPERIOD CHAR 30 0

RECN_CONTRACT_X foreign key relationships

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