RE: Conditions (Transaction
Data)
Technical name: 0REFX_1
Technical Data
DataSource Type |
Transactional data (transaction data) |
Application Component |
Flexible Real Estate Management (RE-FX) ® Information System (RE-FX-IS) |
Available as of OLTP Release |
SAP R/3 Enterprise Extension Set 2.0 |
Available as of Plug-In Release |
-- |
RemoteCube-Enabled |
Yes |
Use
The texts from the source system for the conditions of real estate objects are exported to the Business Information Warehouse from this DataSource.
Origin Fields for the Extraction Structure
Field in the Extraction Structure |
Description of the Field in the Extraction Structure |
Origin Table |
Field in the Origin Table |
OBJNR |
Object number |
Object number of the real estate object |
|
OBJTYPE |
Object type |
Object type (see pooled space object type) |
|
OBJNRDIST |
Object number |
VICDCOND |
OBJNRDIST |
OBJTYPEDIST |
Object type |
VICDCOND |
OBJNRDIST(2) |
BUKRS |
Company code |
VI* |
BUKRS |
SWENR |
Business entity number |
VIBDBE |
SWENR |
SGENR |
Building number |
VIBDBU |
SGENR |
SGRNR |
Property number |
VIBDBR |
SGRNR |
SMENR |
Rental object number |
VIBDRO |
SMENR |
RECNNR |
Contract number |
VICNCN |
RECNNR |
CONDTYPE |
Condition type |
VICDCOND |
CONDTYPE |
CONDPURPOSEEXT |
Conditions – external purpose |
VICDCOND |
CONDPURPOSEEXT |
VALUEVALIDFROM |
Date starting on which the condition is valid |
VICDCONDCALC |
VALUVALIDFROM |
VALUEVALIDTO |
Date up to which the condition is valid |
VICDCONDCALC |
VALUEVALIDTO |
CONDVALUE |
Currency amount of condition item |
VICDCONDCALC |
CONDVALUE |
CONDCURR |
Currency of the condition item |
VICDCONDCALC |
CONDCURR |
UNITPRICE |
Unit price, independent of currency |
VICDCOND |
UNITPRICE |
FREQUENCY |
Number of frequency units in period |
VITMRH |
FREQUENCY |
FREQUENCYUNIT |
Frequency unit |
VITMRH |
RFREQUENCYUNIT |
CALCRULE |
Calculation formula |
VICDCOND |
CALCRULE |
TAXVALUE |
Tax amount of condition item |
VICDCONDCALC |
TAXVALUE |
CONDVALUEMONTH |
Currency amount of condition item per month |
Calculated using CONDVALUE and FREQUENCY |
|
TAXVALUEMONTH |
Tax amount of condition item per month |
Calculated using TAXVALUE and FREQUENCY |
|
CONDVALUEDAY |
Currency amount of condition item per day |
Calculated using CONDVALUE and FREQUENCY |
|
TAXVALUEDAY |
Tax amount of condition item per day |
Calculated using TAXVALUE and FREQUENCY |
|
Delta Update
No delta update is supported for this DataSource.