SAP ABAP Table REHORECNFLDS (Mandatsverwaltung: Arbeits- und Dynprofelder Vertrag)
Hierarchy
☛
EA-FIN (Software Component) EA-FIN
⤷ RE-FX (Application Component) Flexible Real Estate Management
⤷ RE_MI_HO (Package) RE: Migration WEG (Data Dictionary only)
⤷ RE-FX (Application Component) Flexible Real Estate Management
⤷ RE_MI_HO (Package) RE: Migration WEG (Data Dictionary only)
Basic Data
Table Category | INTTAB | Structure |
Structure | REHORECNFLDS | Table Relationship Diagram |
Short Description | Mandatsverwaltung: Arbeits- und Dynprofelder Vertrag |
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 | 1. Key Structure VICN01 | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
3 | INTRENO | VVINTRENO | VVINTRENO | CHAR | 13 | 0 | Internal Real Estate Master Data Code | ||
4 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
5 | RECNNR | REHORECNNR | RECNNR | CHAR | 13 | 0 | Mandatsverwaltung: Vertrag | ||
6 | RECNTYPE | REHORECNTYPE | SMVART | CHAR | 4 | 0 | Mandatsverwaltung: Vertragsart | * | |
7 | RECNDAT | RECNDAT | DDAT | DATS | 8 | 0 | Date of Contract Conclusion | ||
8 | RECNBEG | RECNBEG | DDAT | DATS | 8 | 0 | Date of contract start | ||
9 | RECNEND | RECNEND | DDAT | DATS | 8 | 0 | Date of contract end | ||
10 | RECNADJT | SMVAR | SMVAR | CHAR | 1 | 0 | Lease-Out Adjustment Type | * | |
11 | RECNTXT | RECNTXT | XTEXT80 | CHAR | 80 | 0 | Contract name | ||
12 | RECNDPO | RECNDPO | DDAT | DATS | 8 | 0 | Date of first posting | ||
13 | RECNOBJNR | J_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object number | * | |
14 | RECNNOTTYPE | SMVKUEART | SMVKUEART | CHAR | 1 | 0 | Notice Type of Lease-Out | ||
15 | RECNNOTKEY | SKUEKEY | SKUEKEY | CHAR | 12 | 0 | Notice rule | ||
16 | RECNNOTPER | DKUZU | DDAT | DATS | 8 | 0 | Contract Notice Per | ||
17 | RECNAUTHGR | VVBERGRP | VVBERGRP | CHAR | 40 | 0 | Authorization group | ||
18 | RECNBUSAREA | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
19 | RECNPRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
20 | RECNACCDETVAL | VVWERTN_ADCN | VVWERTN_ADCN | CHAR | 10 | 0 | Account determination key for account determination | * | |
21 | RECNADMONTH | VVJMABGR | JFLAGG | CHAR | 1 | 0 | Accrual/deferral method | ||
22 | RECNDDUNNED | MADAT | DATUM | DATS | 8 | 0 | Date of Last Dunning Notice | ||
23 | RECNDCOMPLNT | VVKLDATUM | DATUM | DATS | 8 | 0 | Date of complaint | ||
24 | RECNDCOMPLRC | VVKLAKTZEI | CHAR20 | CHAR | 20 | 0 | Complaint reference code | ||
25 | RECNJURISDIC | VVXGERSTD | TEXT35 | CHAR | 35 | 0 | Jurisdiction | ||
26 | IMKEY | IMKEY | IMKEY | CHAR | 8 | 0 | Internal Key for Real Estate Object | ||
27 | .INCLUDE | 0 | 0 | Field String for Maintenance of User Data | |||||
28 | RERF | RERF | SYCHAR12 | CHAR | 12 | 0 | Entered by | ||
29 | DERF | DERF | DATUM | DATS | 8 | 0 | First Entered on | ||
30 | TERF | TERF | TIMES | TIMS | 6 | 0 | Time of Initial Entry | ||
31 | REHER | REHER | CHAR10 | CHAR | 10 | 0 | Source of initial entry | ||
32 | RBEAR | RBEAR | SYCHAR12 | CHAR | 12 | 0 | Employee ID | ||
33 | DBEAR | DBEAR | DATUM | DATS | 8 | 0 | Last Edited on | ||
34 | TBEAR | TBEAR | TIMES | TIMS | 6 | 0 | Last Edited at | ||
35 | RBHER | RBHER | CHAR10 | CHAR | 10 | 0 | Editing Source | ||
36 | RECNUNIT | RECNUNIT | MEINS | UNIT | 3 | 0 | Area unit | * | |
37 | RECNKUNNR | KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | * | |
38 | RECNLIFNR | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | * | |
39 | RECNTXJCD | TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | * | |
40 | RECNCURR | RECNWAERS_H | WAERS | CUKY | 5 | 0 | Currency key for local currency | * | |
41 | RECNTLAW | SMIETR | SMIETR | CHAR | 5 | 0 | Tenancy law | * | |
42 | RECNCURR2 | RECNWAERS_D | WAERS | CUKY | 5 | 0 | Currency key for the display currency | * | |
43 | RECNTXTOLD | VVOSMIVE | VVOSMIVE | CHAR | 20 | 0 | Number of old contract | ||
44 | RECNDACTIV | DAKTV | DATUM | DATS | 8 | 0 | Contract activation | ||
45 | RECNNRCOLLECT | RECNNRCOLLECT | RECNNR | CHAR | 13 | 0 | Number of Real Estate main contract | ||
46 | RECNKOSTL | RECNKOSTL | KOSTL | CHAR | 10 | 0 | Cost center of internal contract | * | |
47 | ZLSCH | DZLSCH | ZLSCH | CHAR | 1 | 0 | Payment method | * | |
48 | RECNPREDATA | RECNPREDATA | XFELD | CHAR | 1 | 0 | Flag: Predefined rates | ||
49 | SPARTNR | BP_PARTNR | BP_PARTNR | CHAR | 10 | 0 | Business Partner Number | * | |
50 | RECNNOTRECEIPT | DEKUEA | DDAT | DATS | 8 | 0 | Receipt or issue date of notice | ||
51 | RECNNOTREASON | RKUEGRU | RKUEGRU | NUMC | 2 | 0 | Reason for notice | * | |
52 | RECNNOTINVREA | RABLGRU | RABLGRU | NUMC | 2 | 0 | Reason for rejection | * | |
53 | RECNJVSTOPT | VVJVSTOPT | JANE | CHAR | 1 | 0 | Input tax opting (indicator) | ||
54 | RECNVSTSOND | SVSTSOND | SVSTSOND | CHAR | 1 | 0 | Input tax opting reason | * | |
55 | RECNMANSP | MANSP | MANSP | CHAR | 1 | 0 | Dunning block | * | |
56 | RECNMABER | MABER | MABER | CHAR | 2 | 0 | Dunning Area | * | |
57 | RECNMAHNA | MAHNA | MAHNA | CHAR | 4 | 0 | Dunning Procedure | * | |
58 | RECNMAHNS_D | MAHNS_D | MAHNS | NUMC | 1 | 0 | Dunning Level | ||
59 | RECNNOTCAT | SKUAR | SKUAR | CHAR | 1 | 0 | Notice Type | ||
60 | RECNGFZLSCH | RECNGFZLSCH | ZLSCH | CHAR | 1 | 0 | Payment method for credit memos | * | |
61 | RECNZLSPR | DZLSPR | ZAHLS | CHAR | 1 | 0 | Payment Block Key | * | |
62 | RECNHBKID | HBKID | HBKID | CHAR | 5 | 0 | Short key for a house bank | * | |
63 | RECNXBLNR | RECNXBLNR1 | XBLNR1 | CHAR | 16 | 0 | Note to payee | ||
64 | RECNDKUZUG | VVDKUZUG | DDAT | DATS | 8 | 0 | Date notice approved | ||
65 | RECNDKUABG | VVDKUABG | DDAT | DATS | 8 | 0 | Date notice rejected | ||
66 | RECNDWIKU | VVDWIKU | DDAT | DATS | 8 | 0 | Date of objection to notice | ||
67 | RECNDKUERCK | DKUERCK | DATUM | DATS | 8 | 0 | Date of withdrawal of notice | ||
68 | RECNDKREUEB | VVDKREUEB | DDAT | DATS | 8 | 0 | Date notice submitted to legal department | ||
69 | RECNDAKTKU | VVDAKTKU | DDAT | DATS | 8 | 0 | Activation date | ||
70 | RECNDSTKU | VVDSTKU | DDAT | DATS | 8 | 0 | Reversal date | ||
71 | RECNADJTTYPE | RECNADJTTYPE | RECNADJTTYPE | CHAR | 1 | 0 | Adjustment triggered by | ||
72 | RECNADJTRUECK | RECNADJTRUECK | XFELD | CHAR | 1 | 0 | Retroactive adjustment possible | ||
73 | RECNBUKRSCOLLECT | RECNBUKRSCOLLECT | BUKRS | CHAR | 4 | 0 | Company code of main contract | * | |
74 | RECNBASISAEZIF | RECNBASISAEZIF | RECNAEZIF | INT2 | 5 | 0 | Base: equivalence number distribution | ||
75 | RECNXCROSS | RECNXCROSS | XFELD | CHAR | 1 | 0 | Gross amount indicator | ||
76 | RECNMANDAT | RECNMANDAT | CHAR20 | CHAR | 20 | 0 | Mandate | ||
77 | RECNMANDATTYP | RECNMANDATTYP | RECNMANDATTYP | NUMC | 1 | 0 | Role of Contract in Mandate | ||
78 | RECNFLESR | VVKZESR | JANE | CHAR | 1 | 0 | Activation of POR functions | ||
79 | RECNESRNROW | VVESRNR_EIG | NUM9 | NUMC | 9 | 0 | POR participant number of owner | ||
80 | RECNESRCUIDOW | VVESRKUID_EIG | CHAR15 | CHAR | 15 | 0 | POR customer identification number | ||
81 | RECNVATNROW | VVMWSTNR_EIG | STCEG | CHAR | 20 | 0 | Value-added tax of owner | ||
82 | RECNBUKRSGKT | VVBUKRS_GKT | BUKRS | CHAR | 4 | 0 | Object and account CoCd | * | |
83 | RECNKZEIGGKT | VVKZEIGGKT | VVKZEIGGKT | CHAR | 1 | 0 | Cash account control for owner | ||
84 | RECNTYPETXT | XMVARTM | XMBEZ | CHAR | 30 | 0 | Description of type of RE contract type | ||
85 | BUKRSTXT | BUTXT | TEXT25 | CHAR | 25 | 0 | Name of Company Code or Company | ||
86 | RECNTERM | VVNLAUFZ | NUMC4 | NUMC | 4 | 0 | Contract term in months | ||
87 | BUT_NOTICE | ICON_TEXT | SYCHAR132 | CHAR | 132 | 0 | Carrier field for icons | ||
88 | BUT_RESUBMIS | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
89 | RECNDSUBMIS | RECNDSUBMIS | DDAT | DATS | 8 | 0 | Resubmission date | ||
90 | RECNTSUBMIS | RECNTSUBMIS | XTEXT50 | CHAR | 50 | 0 | Resubmission name | ||
91 | RECNTSUBMISOK | RECNTSUBMISOK | JANE | CHAR | 1 | 0 | Resubmission carried out? | ||
92 | BUT_AUTHGRP | ICON_TEXT | SYCHAR132 | CHAR | 132 | 0 | Carrier field for icons | ||
93 | RECNPRCTRTXT | RECNPRCTTXT | TEXT20 | CHAR | 20 | 0 | Name of profit center | ||
94 | RECNBUSAREATXT | GTEXT | TEXT30 | CHAR | 30 | 0 | Business area description | ||
95 | COUNT_WE | VVAWE | DEC6 | DEC | 6 | 0 | No. of business entities | ||
96 | COUNT_GR | VVAGR | DEC6 | DEC | 6 | 0 | No. of properties | ||
97 | COUNT_GB | VVAGE | DEC6 | DEC | 6 | 0 | No. of buildings | ||
98 | COUNT_ME | VVAME | DEC6 | DEC | 6 | 0 | Number of rental units | ||
99 | COUNT_MV | VVAMV | VVDEC6 | DEC | 6 | 0 | No. of lease-outs | ||
100 | BUT_INSERT_LINE | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
101 | BUT_DELETE_LINE | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
102 | BUT_DETAIL | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
103 | BUT_DELETE | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
104 | BUT_INSERT | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
105 | DFAELL | DFAELL | DATUM | DATS | 8 | 0 | Due date | ||
106 | DFAELL2 | DFAELL | DATUM | DATS | 8 | 0 | Due date | ||
107 | BUT_FIN_OLD | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
108 | BUT_FIN_NEW | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
109 | BUT_EXPAND | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
110 | BUT_COLLAPSE | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
111 | BUT_UNDO | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
112 | BUT_NOTE_EDIT | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
113 | BUT_NOTE_SEND | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
114 | BUT_ADJT | ICON_TEXT | SYCHAR132 | CHAR | 132 | 0 | Carrier field for icons | ||
115 | JDIVANP | VVJDIVANP | XFELD | CHAR | 1 | 0 | Do several adjustment types exist? | ||
116 | RECNADJTTXT | XMVANARTM | XMBEZ | CHAR | 30 | 0 | Description of LO adjustment type | ||
117 | RECNNRCOLTXT | RECNTXT | XTEXT80 | CHAR | 80 | 0 | Contract name | ||
118 | BUT_NRCOLLECT | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
119 | RECNKUNNRTXT | RECNADRLINE | RECNADRLINE | CHAR | 80 | 0 | Address line | ||
120 | RECNLIFNRTXT | RECNADRLINE | RECNADRLINE | CHAR | 80 | 0 | Address line | ||
121 | RECNKUNNRLIFNRTXT | RECNADRLINE | RECNADRLINE | CHAR | 80 | 0 | Address line | ||
122 | BUT_SUPPORT | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
123 | BUT_ANPASS | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
124 | BUT_STAFFEL | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
125 | BUT_SUM_KOND | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
126 | BUT_EXPAND1 | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
127 | BUT_COLLAPSE1 | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
128 | BUT_HISTORY | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
129 | OBJECTTXT1 | VVOBJTXT | XLBEZ | CHAR | 60 | 0 | Text for Real Estate object | ||
130 | OBJECTTXT2 | RECNADRLINE | RECNADRLINE | CHAR | 80 | 0 | Address line | ||
131 | BUT_EXPAND2 | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
132 | BUT_COLLAPSE2 | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
133 | DAT_VERTEIL_BEG | DGULTAB | DDAT | DATS | 8 | 0 | Date from when assignment is valid | ||
134 | DAT_VERTEIL_END | DGULTBIS | DDAT | DATS | 8 | 0 | Date up to when the assignment is valid | ||
135 | BUT_INSERT_LINE1 | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
136 | BUT_DELETE_LINE1 | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
137 | BUT_VERTEIL_DATE | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
138 | BUT_VERTEIL_COPY | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
139 | BUT_VERTEIL_DEL | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
140 | BUT_VERTEIL_NEW | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
141 | BUT_VERTEIL_LIST | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
142 | BUT_VERTEIL_SIMU | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
143 | KOSTLTEXT | KLTXT | TEXT40 | CHAR | 40 | 0 | Description | ||
144 | KOKRS | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | * | |
145 | KOKRSTEXT | BEZEI | TEXT25 | CHAR | 25 | 0 | Name of the controlling area | ||
146 | VBUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
147 | VRECNNR | RECNNR | RECNNR | CHAR | 13 | 0 | Real Estate Contract Number | ||
148 | CHECK_1 | VVJFELD | XFELD | CHAR | 1 | 0 | Checkbox | ||
149 | CHECK_2 | VVJFELD | XFELD | CHAR | 1 | 0 | Checkbox | ||
150 | CHECK_3 | VVJFELD | XFELD | CHAR | 1 | 0 | Checkbox | ||
151 | CHECK_4 | VVJFELD | XFELD | CHAR | 1 | 0 | Checkbox | ||
152 | CHECK_5 | VVJFELD | XFELD | CHAR | 1 | 0 | Checkbox | ||
153 | CHECK_6 | VVJFELD | XFELD | CHAR | 1 | 0 | Checkbox | ||
154 | CHECK_7 | VVJFELD | XFELD | CHAR | 1 | 0 | Checkbox | ||
155 | CHECK_8 | VVJFELD | XFELD | CHAR | 1 | 0 | Checkbox | ||
156 | CHECK_9 | VVJFELD | XFELD | CHAR | 1 | 0 | Checkbox | ||
157 | CHECK_10 | VVJFELD | XFELD | CHAR | 1 | 0 | Checkbox | ||
158 | ZLSCHTEXT | TEXT1_042Z | TEXT30 | CHAR | 30 | 0 | Name of Payment Method in Language of the Country | ||
159 | CHECK_USE_PREDATA | VVJFELD | XFELD | CHAR | 1 | 0 | Checkbox | ||
160 | RECNUNITTXT | MSEHL | TEXT30 | CHAR | 30 | 0 | Unit of Measurement Text (Maximum 30 Characters) | ||
161 | BUT_LEGENDE | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
162 | SPARTNRTXT | RECNADRLINE | RECNADRLINE | CHAR | 80 | 0 | Address line | ||
163 | DKGSTZL | VVDKGSTZL | DATUM | DATS | 8 | 0 | Date of (calculated) notice | ||
164 | RECNNOTREASONTXT | XKKUEGRU | XKBEZ | CHAR | 15 | 0 | Notice reason short name | ||
165 | GFZLSCHTEXT | TEXT1_042Z | TEXT30 | CHAR | 30 | 0 | Name of Payment Method in Language of the Country | ||
166 | RECNZLSPRTXT | TEXTL_008 | TEXT20 | CHAR | 20 | 0 | Explanation of the Reason for Payment Block | ||
167 | RECNHBKIDTXT | FIBL_TXT50 | TEXT50 | CHAR | 50 | 0 | Description | ||
168 | BUT_NOTICE_ACT | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
169 | BUT_NOTICE_DEACT | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
170 | RECNMABERTXT | TEXT1 | TEXT50 | CHAR | 50 | 0 | Text | ||
171 | BUT_SEL_ALL | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
172 | BUT_UNSEL_ALL | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
173 | BUT_GEN_VERTEIL | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
174 | RECNNR_SHOW | RECNNR | RECNNR | CHAR | 13 | 0 | Real Estate Contract Number | ||
175 | BUT_DO_VORBELEG | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
176 | BUT_PARTNER | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
177 | BUT_PARTNER_Z | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
178 | BUT_PARTNER_A | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
179 | BUT_PARTNER_L | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
180 | BUT_PARTNER_T | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
181 | BUT_PARTNER_H | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID | ||
182 | BUT_DELETE_LINE2 | VVMSGID | CHAR02 | CHAR | 2 | 0 | Message ID |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | REHORECNFLDS | BUKRS | T001 | BUKRS |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 230 |