Budget - Available budget below Threshold

Query Query: 0PU_MP03_Q0004

The aim of the queries is to display all funds where the available budget is smaller than the predefined threshold value. The query is used in the application Funds Management Visual Composer.

Structure

Filters
Object Type Name Technical Name Value Restriction / Calculation
Characteristic Characteristic Request ID 0REQUID

Variable current data (transactional InfoCube) (0S_RQTRA)

Characteristic Characteristic FM area 0FM_AREA

Characteristic Characteristic Fiscal year 0FISCYEAR

Variable current fiscal year (SAP-EXIT) (0FYEAR)

Characteristic Characteristic Posting period 0FISCPER3

Variable fiscal year period — max (interval, SAP exit) (0I_PMAX)

Characteristic Characteristic Fiscal year variant 0FISCVARNT

Calendar year, 4 special periods

Characteristic Characteristic Budget Category 0FM_BUCAT

Not assigned (#)

Characteristic Characteristic Version 0VERSION

Plan/Actual — Version (0)

Not assigned (#)

Free Characteristics
Object Type Name Technical Name
Characteristic Characteristic Funds center 0FUND_CTR
Characteristic Characteristic Commitment item 0CMMT_ITEM
Characteristic Characteristic Functional Area 0FUNC_AREA
Characteristic Characteristic Grant 0GRANT_NBR
Characteristic Characteristic Funded program 0PU_MEASURE
Rows
Object Type Name Technical Name Value Restriction / Calculation
Characteristic Characteristic Fund 0FUND

Columns
Object Type Name Technical Name Value Restriction / Calculation
Key Figure Key Figure Available budget / consumable budget in % 0MP51_RK003

Key Figure Key Figure Consumable budget (all periods) 0MP51_RK011

Key Figure Key Figure Consumed amount (until current period -1) 0MP51_RK012

Key Figure Key Figure Available budget (overall budget, current consumed amounts -1) 0MP51_CK002