Real Estate (Actual) (Contracts) 
DataSource Transactional Data: 0DF_IS_DFS_54
This DataSource allows you to access actual data about real estate from the source system.
Technical Data
Application Component | ISDFPS BW Business Content (IS-DFS-BW) |
|---|---|
Available as of Release | SAP Defense Forces & Public Security 6.10 |
Shipment | NW 2004s BI Content Add-On 3 |
Content Versions | There are no content versions. |
RemoteCube-Capable | No |
Delta-Capable | No |
Extraction from Archives | No |
Verifiable | No |
Data Modeling
Fields in the Extract Structure | Description of the Field in the Extract Structure | Table of Origin | Field in the Table of Origin |
|---|---|---|---|
FORCE_ID |
Object ID |
/ISDFPS/FORCNID |
OBJID |
DF_CONTING |
Contingent Key |
HRP1985 |
CON_ID |
DF_OPERATN |
Object ID |
HRP1985 |
OPERATION_ID |
RECNNR |
Contract Number |
VICNCN |
RECNNR |
SWENR |
Business Entity Number |
VIBDBE |
SWENR |
SMENR |
Rental Object Number |
VIBDRO |
SMENR |
SGENR |
Building Number |
VIBDBU |
SGENR |
SGRNR |
Land Number |
VIBDPR |
SGRNR |
FIXFITCHARACT |
Fixtures and Fittings Characteristic |
VIBDCHARACT |
FIXFITCHARACT |
MEASTYPE |
Measurement Type |
VIBDMEAS |
MEAS |
BUKRS |
Company Code |
VICNCN |
BUKRS |
IVSTAT1 |
"Planned" Status |
/ISDFPS/FORCN |
STATUS |
IVSTAT2 |
"Requested" Status |
/ISDFPS/FORCN |
STATUS |
IVSTAT3 |
"Approved" Status |
/ISDFPS/FORCN |
STATUS |
IVSTAT4 |
"Rejected" Status |
/ISDFPS/FORCN |
STATUS |
IVSTAT5 |
"Active" Status |
/ISDFPS/FORCN |
STATUS |
IVSTAT6 |
'Obsolete' Status |
/ISDFPS/FORCN |
STATUS |
BEGDA |
Start Date |
berechnet |
|
ENDDA |
End Date |
berechnet |
|
MEAS_CAPA |
Measurement Amount: Capacity |
VIBDMEAS |
MEASVALUECMPL |
MEAS_VALUE |
Measurement Amount: Available |
VIBDMEAS |
MEASVALUE |
MEAS_UNIT |
Measurement Unit |
VIBDMEAS |
MEASUNIT |
MAX_NO_PERS |
Maximum Number of Persons |
momentan nicht belegt |
Extractor Logic
Description of the Key Figures:
The extractor provides the following key figures:
MEAS_CAPA: Measurement Amount: Capacity of a Measurement
MEAS_VALUE: Measurement Amount: Available Size of a Measurement
MAX_NO_PERSR: Maximum Number of Persons [not yet reserved]
Extraction Logic:
Real estate contracts and assigned objects are selected from table VIBDOBJASS using the /ISDFPS/V_BI_REA view. Possible object types of the assigned objects and their master data tables are:
Business Entities (VIBDBE)
Buildings (VIBDBU)
Lands (VIBDPR)
Rental Objects (VIBDRO)
Master data in the respective database tables is imported into internal "LT_<...>" tables for all of the assigned objects, and the internal keys of all the objects are saved in internal "LT_<…>_MEAS" tables.
Using the internal keys in the "LT_<...>_MEAS" tables, measurements (from table VIBDMEAS) and fixtures and fittings (from table VIBDCHARACT) are selected for the respective objects.
Using the /ISDFPS/V_BI_RCF view, the linked HR data and contract status (from tables /ISDFPS/FORCN and /ISDFPS/FORCNID) are selected and transferred to the internal LT_HR_DATA table for all relevant real estate contracts.
This data is converted to another internal table (LT_HR_STAT_PROV) in function module /ISDFPS/BI_EXT_PRO_RE_CN_DISS. This table contains a matrix of check fields for the possible connection status of each data record, instead of individual records that each have one status.
This internal LT_HR_STAT_PROV table is processed in a LOOP to create data records of the result structure (sorted by object types, that is, business unit and so on). Here is it necessary to use the PROVIDE function to map the different time intervals that occur (validity of the real estate contracts/objects/HR connection) to joint time intervals.
Finally, possible duplicates that arise from PROVIDE are deleted.