RE: CO Data (Transaction Data)
Technical name: 0REFX_3
Technical Data
DataSource Type |
Transactional data (transaction data) |
|---|---|
Application Component |
|
Available as of OLTP Release |
SAP R/3 Enterprise Extension Set 2.0 |
Available as of Plug-In Release |
-- |
RemoteCube-Enabled |
Yes |
Use
The actual data of real estate objects is exported from the source system 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 |
SNKSL |
Service charge key |
VISCSU |
SNKSL |
SEMPSL |
Settlement unit |
VISCSU |
SEMPSL |
TPLNR |
Functional location |
IFLOT |
TPLNR |
AUFNR |
Order number |
AUFK |
AUFNR |
AUTYP |
Order category |
AUFK |
AUTYP |
POSID |
Work breakdown structure element (WBS element) |
PRPS |
POSID |
FISCVAR |
Fiscal year variant |
TKA01 |
LMONA |
FISCPER |
Fiscal year/period |
COSS/COSP |
GJAHR, PERBL |
KOKRS |
Controlling area |
TKA02 |
KOKRS |
LSTAR |
Activity type |
COSS/COSP |
OBJNR |
WRTTP |
Value type |
COSS/COSP |
WRTTP |
VTYPE |
Value type for reporting |
See Mapping the Value Type etc. |
|
VTDETAIL |
Details of value type |
See Mapping the Value Type etc. |
|
VTSTAT |
Statistical indicator for value type |
See Mapping the Value Type etc. |
|
VERSN |
Version |
See Mapping the Version and Transfer Price Valuation |
|
KSTAR |
Cost element |
COSS/COSP |
KSTAR |
SEKNZ |
Sender/receiver indicator |
See Mapping the Debit/Credit Indicator (0DB_CR_IND) |
|
RSPOBART |
Partner InfoObject (4 characters) |
COSS |
PAROB |
RSPAROBVAL |
Value of partner InfoObject |
COSS |
PAROB |
VALUTYP |
Valuation view |
See Mapping the Version and Transfer Price Valuation |
|
MEASTYPE |
Key figure category |
See Mapping the Value Type etc. |
|
SWG |
Amount |
COSS/COSP |
WKG*, WOF*, WTF* |
SMEG |
Consumption quantity |
COSS/COSP |
MEG* |
WAERS |
Currency key |
See Mapping the Currency Type and Currency Key |
|
CURTYPE |
Currency type |
See Mapping the Currency Type and Currency Key |
|
MEINH |
Unit of measurement |
COSS/COSP |
MEINH |
MEAS |
Measurement type |
VIBDMEAS |
MEAS |
MEASVALUE |
Measurement amount: Available |
VIBDMEAS |
MEASVALUE |
MEASUNIT |
Measurement unit |
VIBDMEAS |
MEASUNIT |
Delta Update
No delta update is supported for this DataSource.