Start of Content Area

Query Real Estate: Costs and Revenues – Plan/Actual  Locate the document in its SAP Library structure

Technical name of the query: 0REFX_C03_Q0013

Based on InfoCube: 0REFX_C03

Use

This report provides plan/actual values and variances, and supports the real estate manager with reports on:

¡        Complete real estate portfolio

¡        Individual regional locations

¡        Individual real estate objects

NoteThis query is assigned to the Real Estate: Costs and Revenue – Plan/Actual workbook.

Filter

InfoObject

Description of InfoObject (or Restriction or Calculation Formula)

0COMP_CODE

Company code

0FISCVARNT

Fiscal year variant

0FISCYEAR

Fiscal year

0CURTYPE

Currency type

0REOBJECT_0REOBJTYPE

Object type

The real estate contract is excluded as a single value in selection by object type.

Free Characteristics

InfoObject

Description

0FISCPER3

Posting period

0REOBJECT_0REGION

Region

0REOBJECT_0COUNTRY

Country

0CO_AREA

Controlling area

0REOBJECT_0USAGETYPE

Usage type

0COSTELMNT

Cost element

0FUNCT_LOC

Functional location

0COORDER

Order number

0WBS_ELEMT

Work breakdown structure element (WBS element)

Variables Used

Variable

Description

0S_COCD

Company code (selection options, optional)

0P_FYEAR

Fiscal year (individual value entry, required)

0P_CURRT

Currency type (individual value entry, required)

0H_COEL

Cost element hierarchy

Rows

InfoObject

Description of InfoObject (or Restriction or Calculation Formula)

0REOBJECT_0RELOCAT

Regional location

0REOBJECT

Real estate object

Columns

InfoObject

Description of InfoObject (or Restriction or Calculation Formula)

 

Actual

 

Plan

 

Variance ('Actual' - 'Plan')

 

Variance % ('Variance' %A 'Actual')

 

 

End of Content Area