Start of Content Area

Query Contract Performance – Lease-Out – Bottom N  Locate the document in its SAP Library structure

Technical name of the query: 0REFX_C03_Q0004

Based on InfoCube: 0REFX_C03

Use

This report supplies information on costs and revenues for lease-outs. The real estate manager can limit the number of contracts displayed to a specified number.

Example: Only the fifteen contracts which brought the least rent revenue (= bottom 15).

NoteThis query is assigned to the Contract Performance – Lease-Out workbook.

Filter

InfoObject

Description of InfoObject (or Restriction or Calculation Formula)

0FISCVARNT

Fiscal year variant

0FISCYEAR

Fiscal year

0CURTYPE

Currency type

0REOBJECT_0REOBJTYPE

Object type

0VTYPE

Value type

0REOBJECT_0CONTRTYPE

Contract type

Free Characteristics

InfoObject

Description

0CO_AREA

Controlling area

0REOBJECT_0RELOCAT

Regional location

0COSTELMNT

Cost element

0REOBJECT_0REGION

Region

0REOBJECT_0COUNTRY

Country

Variables Used

Variable

Description

0P_FYEAR

Fiscal year (individual value entry, required)

0P_CURRT

Currency type (individual value entry, required)

 

Bottom N parameters (&0P_BOTN&)

The bottom N parameter variable contains the condition (&0P_BOTN&).

Rows

InfoObject

Description of InfoObject (or Restriction or Calculation Formula)

0COMP_CODE

Company code

0REOBJECT

Real estate object

0REOBJECT_0CONTRPART1

Contract: 1st business partner

Columns

InfoObject

Description of InfoObject (or Restriction or Calculation Formula)

0FISCPER3

Posting period

0AMOUNT

Amount

 

 

End of Content Area