RE: Cash Flow
Technical name: 0REFX_6
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 data from the source system for the cash flow of contracts and rental 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 |
CO object number |
|
OBJTYPE |
Object type |
Type group TBO01 (see pooled space RECA1) |
|
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 |
FISCVAR |
Fiscal year variant |
TKA01 |
LMONA |
FISCPER |
Fiscal year/period |
Calculated by subtracting DFAELL from VICDCF* |
|
DBERVON |
'Calculation from’ date' |
VICDCFPAY/VICDCFOBJ |
DBERVON |
DBERBIS |
'Calculation to’ date' |
VICDCFPAY/VICDCFOBJ |
DBERBIS |
DVALUT |
Calculation date |
VICDCFPAY/VICDCFOBJ |
DVALUT |
DFAELL |
Due date |
VICDCFPAY/VICDCFOBJ |
DFAELL |
DBPERIOD |
Period start date |
VICDCFPAY/VICDCFOBJ |
DBPERIOD |
DEPERIOD |
Period end date |
VICDCFPAY/VICDCFOBJ |
DEPERIOD |
TAXTYPE |
Tax type |
VICDCFPAY/VICDCFOBJ |
TAXTYPE |
TAXGROUP |
Tax group |
VICDCFPAY/VICDCFOBJ |
TAXGROUP |
TXJCD |
Tax jurisdiction code |
VICDCFPAY/VICDCFOBJ |
TXJCD |
PARTNER |
Business partner number |
VICDCFPAY |
PARTNER |
PARTNEROBJNR |
Object number |
VICDCFPAY |
PARTNEROBJNR |
KOKRS |
Controlling area |
VICDCFPAY |
PARTNEROBJNR |
KOSTL |
Cost Center |
VICDCFPAY |
PARTNEROBJNR |
AUFNR |
Order number |
VICDCFPAY |
PARTNEROBJNR |
POSID |
Work breakdown structure element (WBS element) |
VICDCFPAY |
PARTNEROBJNR |
CONDTYPE |
Condition type |
VICDCFPAY/VICDCFOBJ |
CONDTYPE |
POSTINGDATE |
Posting date |
VICDCFPAY/VICDCFOBJ |
POSTINGDATE |
DOCUMENTDATE |
Document date |
VICDCFPAY/VICDCFOBJ |
DOCUMENTDATE |
BOOK_FLOWTYPE |
Flow type |
VICDCFPAY/VICDCFOBJ |
BOOK_FLOWTYPE |
BOOK_REFFLOWREL |
Type of relationship between flow type and reference flow type |
VICDCFPAY/VICDCFOBJ |
BOOK_REFFLOWREL |
CCNETAMOUNT |
Net amount of cash flow item in condition currency |
VICDCFPAY/VICDCFOBJ |
CCNETAMOUNT |
CCGROSSAMOUNT |
Gross amount of cash flow item in condition currency |
VICDCFPAY/VICDCFOBJ |
CCGROSSAMOUNT |
CONDCURR |
Condition currency of the cash flow item |
VICDCFPAY/VICDCFOBJ |
CONDCURR |
Extractors
Extractor: REIS_CASHFLOW_TRAN_GET
Extraction structure: REIS_CASHFLOW_TRAN
Delta Update
No delta update is supported for this DataSource.