Occupancy (View by Period)

DataSource Transactional Data: 0REFX_14

The data on occupancy viewed by period is exported from the source system to Business Intelligence from this DataSource. You have to enter limits (from and to values) for the CALMONTH field. The system generates data records for the time period you specify.

The following values are possible for the OCCUP field:

1 — Vacancy
2 — No Vacancy
3 — Intended for Rent
4 — Reserved

The value 3 — Intended for Rent is assigned during a time period when the rental object is included in an occupancy contract that is not yet active.

The value 4 — Reserved is assigned during a time period when the rental object is reserved by a contract due to renewal options.

Technical Data

Application Component	Master data of Flexible Real Estate Management (0REFX-IO)
Available as of Release	SAP Enhancement Package 4 for SAP ERP 6.0
Shipment	SAP NetWeaver 7.0 BI Content Add-On 4
Content Versions	ECC 604
RemoteCube-Capable	Yes
Delta-Capable	No
Extraction from Archives	No
Verifiable	No

Data Modeling

Fields of Origin for the Extract Structure
Fields in the Extract Structure	Description of the Field in the Extract Structure	Table of Origin	Field in the Table of Origin
OBJNR	Object number	VIBDROOCC	OBJNR
OBJTYPE	Object type		*³
BUKRS	Company code	VIBDROOCC	BUKRS
SWENR	Business entity number	VIBDROOCC	SWENR
SGENR	Building number	VIBDROOCC	SGENR
SGRNR	Land number	VIBDROOCC	SGRNR
SMENR	Rental object number	VIBDROOCC	SMENR
MEAS	Measurement type		*³
DAYS_OCC	No. of days in period		*³
DAYS_TOT	No. of days in period		*³
OCCUP	Vacancy of real estate object		*³
VACREASON	Reason for vacancy	VIBDROOCC	VACREASON
RECNBUKRS	Company code	VIBDROOCC	OCCCNBUKRS
RECNNR	Contract number	VIBDROOCC	OCCRECNNR

Extractor Logic

Information on the Field in the Origin Table:

*³ — The values are determined by the extractor.