Start of Content Area

Query Contract Performance – Lease-In – Top N  Locate the document in its SAP Library structure

Technical name of the query: 0REFX_C03_Q0005

Based on InfoCube: 0REFX_C03

Use

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

Example: Only the fifteen contracts which generate the fewest costs (= top 15).

NoteThis query is assigned to the Contract Performance – Lease-In 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

0P_CURRT

Currency type

 

Top N parameter (&0P_TOPN&)

The top N parameter variable contains the condition (&0P_TOPN&).

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