SAP ABAP Table RECN_CONTRACT_X (Real Estate Contract and Additional Fields)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX-CN (Application Component) Real Estate Contract
     ⤷ RE_CN_CN (Package) RE: Contract

Basic Data

Table Category	INTTAB	Structure
Structure	RECN_CONTRACT_X	Table Relationship Diagram
Short Description	Real Estate Contract and Additional Fields

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Real Estate Contract
2	.INCLUDE	☐				0	0	Real Estate Contract
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
4	INTRENO	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
5	.INCLUDE	☐				0	0	RE Contract: Key Fields
6	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
7	RECNNR	☐	RECNNUMBER	RECNNUMBER	CHAR	13	0	Contract Number
8	.INCLUDE	☐				0	0	RE Contract: Non-Key Fields
9	OBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
10	IMKEY	☐	RECAIMKEY	IMKEY	CHAR	8	0	Internal Key of Real Estate Object (FI)
11	CREATIONTYPE	☐	RECACREATIONTYPE	RECACREATIONTYPE	CHAR	1	0	How the Object Was Created
12	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
13	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
14	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
15	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
16	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
17	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
18	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
19	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
20	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
21	RESPONSIBLE	☐	RECARESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	USR02
22	USEREXCLUSIVE	☐	RECAUSEREXCLUSIVE	XUBNAME	CHAR	12	0	User with Exclusive Change Authorization	USR02
23	AUTHGRP	☐	RECAAUTHGRP	RECAAUTHGRP	CHAR	40	0	Authorization Group
24	RECNTYPE	☐	RECNCONTRACTTYPE	SMVART	CHAR	4	0	Contract Type	TIV26
25	RECNBEG	☐	RECNCNBEG	RECADATE	DATS	8	0	Date of contract start
26	RECNENDABS	☐	RECNCNENDABS	RECADATEEND	DATS	8	0	Term End Date
27	RECNTXT	☐	RECNTXT	XTEXT80	CHAR	80	0	Contract name
28	RECNDACTIV	☐	DAKTV	DATUM	DATS	8	0	Contract activation
29	RECNTLAW	☐	SMIETR	SMIETR	CHAR	5	0	Tenancy law	TIV03
30	RECNTXTOLD	☐	VVOSMIVE	VVOSMIVE	CHAR	20	0	Number of old contract
31	RECNBUKRSCOLLECT	☐	RECNBUKRSCOLLECT	BUKRS	CHAR	4	0	Company code of main contract	T001
32	RECNNRCOLLECT	☐	RECNNUMBERCOLLECT	RECNNUMBER	CHAR	13	0	Number of Real Estate Main Contract
33	RECNCNCURR	☐	RECNWAERS_CN	WAERS	CUKY	5	0	Currency for Contract	*
34	INDUSTRY	☐	BU_IND_SECTOR	BU_INDSECTOR	CHAR	10	0	Industry	*
35	SRRELEVANT	☐	RECNSALESRENTRELEVANT	RECABOOL	CHAR	1	0	Relevant to Sales
36	DPTARGETTYPE	☐	RECNDPTYPE	RECNDPTYPE	CHAR	4	0	Security Deposit Type	TIVCNDPTYPE
37	RECNDAT	☐	RECNDAT	DDAT	DATS	8	0	Date of Contract Conclusion
38	RECN2DAT	☐	RECN2DAT	RECADATE	DATS	8	0	Date of Second Signature
39	RECNDPO	☐	RECDCFSTARTFROM	RECADATE	DATS	8	0	Cash Flow Generated Starting On
40	RECNEND1ST	☐	RECNCNEND1ST	RECADATE	DATS	8	0	Date of First Contract End
41	RECNNOTPER	☐	RECNNTPER	RECADATE	DATS	8	0	Contract Notice Per
42	RECNNOTRECEIPT	☐	RECNNTRECEIPT	RECADATE	DATS	8	0	Date of receipt of notice
43	RECNNOTREASON	☐	RECNNTREASON	RECNNTREASON	NUMC	2	0	Reason for Notice	TIVCNNTRE
44	RECNDAKTKU	☐	RECNNTACTIVATEDON	RECADATE	DATS	8	0	Notice: Date of Activation
45	CFARCHIVEDTO	☐	RECDCFARCHIVEDTO	RECADATE	DATS	8	0	Date Up to Which the Cash Flow Is Archived
46	CFLOCKEDTO	☐	RECDCFLOCKEDTO	RECADATE	DATS	8	0	Date Until Which the Cash Flow Is Locked
47	CFPOSTINGFROM	☐	RECDCFPOSTINGFROM	RECADATE	DATS	8	0	First Posting From
48	BENOCN	☐	RECNBENOCN	REBDBENO	CHAR	8	0	Business Entity That Belongs to Contract	*
49	TRANSPOSSFROM	☐	RECNTRANSPOSSFROM	RECADATEBEG	DATS	8	0	Transfer of Possession: Start Date
50	TRANSPOSSTO	☐	RECNTRANSPOSSTO	RECADATEEND	DATS	8	0	Transfer of Possession: End Date
51	HASMULTIASSIGN	☐	REBDHASMULTIASSIGN	RECABOOL	CHAR	1	0	Multiple Assignment of Object to Group Allowed
52	POSSDATEFROM	☐	REBDPOSSDATEFROM	RECADATE	DATS	8	0	Date From Which the Object Is Made Available for Use
53	POSSDATETO	☐	REBDPOSSDATETO	RECADATE	DATS	8	0	Date Up to Which the Object Is Used
54	.INCLUDE	☐				0	0
55	.INCLU--AP	☐				0	0	Country Specific Fields for Spain
56	.INCLUDE	☐				0	0	Country-Specific Fields for Spain - Contract
57	SECDEPRELEVANT	☐	REXCESCDREL	XFELD	CHAR	1	0	Relevant to Security Deposit
58	NOTADJSDCN	☐	REXCESCDNOTADJ	RECABOOL	CHAR	1	0	No Data Update in Security Deposit Contract
59	XRECNNRCOL	☐	RECNTXT	XTEXT80	CHAR	80	0	Contract name
60	XBUKRS	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
61	XRECNTYPE	☐	XMVARTM	XMBEZ	CHAR	30	0	Description of type of RE contract type
62	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
63	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
64	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
65	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
66	XTENANCYLAW	☐	XMIETR	XTEXT50	CHAR	50	0	Tenancy law long text
67	XCOLLECT	☐	RECNTXT	XTEXT80	CHAR	80	0	Contract name
68	XAUTHGRP	☐	RECAXAUTHGRP	RECAXLDESCRIPTION	CHAR	60	0	Description of Authorization Group
69	XINDUSTRY	☐	RECNINDUSTRY	TEXT20	CHAR	20	0	Industry Name
70	XTRANSPOSSPERIOD	☐	RECNXTRANSPOSSPERIOD	RECAXMDESCRIPTION	CHAR	30	0	Productive Holdings: Time Period

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RECN_CONTRACT_X	BUKRS	T001	BUKRS	KEY	1	CN
2	RECN_CONTRACT_X	DPTARGETTYPE	TIVCNDPTYPE	DPTYPE	REF	C	CN
3	RECN_CONTRACT_X	RECNBUKRSCOLLECT	T001	BUKRS
4	RECN_CONTRACT_X	RECNNOTREASON	TIVCNNTRE	NTREASON	REF	C	CN
5	RECN_CONTRACT_X	RECNTLAW	TIV03	SMIETR	KEY	1	CN
6	RECN_CONTRACT_X	RECNTYPE	TIV26	SMVART	KEY	1	CN
7	RECN_CONTRACT_X	RESPONSIBLE	USR02	BNAME	REF	1	CN
8	RECN_CONTRACT_X	USEREXCLUSIVE	USR02	BNAME	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C