cancel
Showing results for 
Search instead for 
Did you mean: 

Staff Budget / Actual Variance report

Former Member
0 Kudos

Hi,

What is 'Staff Budget / Actual Variance report'.

Is there any Business Content Reports avaliable for this purpose.

Please provide me information on Which Data Target 9Technical Name) i can do this report.

Thanks

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

This InfoCube contains all costs and quantities on WBS elements (plan and actual using delta extraction, commitment, budget, accruals) that were transferred from the source system(s).

You can also use this InfoCube to access your own fields. For more information, see Customer-Defined Fields.

For background information on the concept of InfoCubes, see InfoCubes in Controlling.

Higher-Level Objects

Queries

The following queries can access this InfoCube:

· 0WBS_C11_Q0001: WBS Element (Detail): Plan/Actual

· 0WBS_C11_Q0002: WBS Elements (List): Budget/Actual/Commitment

· 0WBS_C11_Q0003: WBS Elements (List): Overall Planning/Actual/Commitment

· 0WBS_C11_Q0301: PSM: WBS Element (Detail): Plan/Actual

· 0WBS_C11_Q0002: PSM: WBS Elements (List): Budget/Actual/Commitment

Notes on Query Definition

If you attempt to sum across different valuation views and currency types, your query results will be incorrect. Summing across different values of these characteristics does not provide useful information.

InfoSources

· 0CO_OM_WBS_1: WBS Elements: Costs

· 0CO_OM_WBS_2: WBS Elements: Budget

· 0CO_OM_WBS_3: WBS Elements: Overall Plan

· 0CO_OM_WBS_6: WBS Elements: Actual Costs Using Delta Extraction

Characteristics

InfoObject

Description

0WBS_ELEMT

PSP element

0COSTELMNT

Cost element

0CO_AREA

Controlling area

0CURTYPE

Currency type

0PIOBJSV

Partner object type

0PIOVALUE

Partner object

0METYPE

Key figure category

0VERSION

Version

0VTDETAIL

Details of value type

0VTYPE

Value type for reporting

0DB_CR_IND

Sender/receiver indicator

0VALUATION

Valuation view

0VTSTAT

Statistics indicator for value type

0FM_AREA

FM area

0FUND

Fund

0FUNC_AREA

Functional area

0GRANT_NBR

Grant

0PFUND

Partner fund

0PFUNC_AREA

Partner functional area

0PGRANT_NBR

Partner grant

Navigation Attributes

The following navigation attributes have been activated. This is a sample selection. You are free to activate additional attributes, or deactivate attributes to improve performance.

InfoObject

Description

0WBS_ELEMT__0CO_AREA

Controlling area

0WBS_ELEMT__0PROFIT_CTR

Profit center

Time Characteristics

InfoObject

Description

0FISCPER

Fiscal year/period

0FISCVARNT

Fiscal year variant

0FISCPER3

Posting period

0FISCYEAR

Fiscal year

· The characteristics fiscal year (0FISCYEAR) and posting period (0FISCPER3) are filled by the fiscal year period field (0FISCPER) in the InfoSource.

· The characteristics and the cost element are not filled for overall budgets or overall plan values. The posting period and the cost element characteristic are not filled for annual budgets or annual plan values. This provides values with the format 000.YYYY (where YYYY is the fiscal year), particularly for the 0FISCPER characteristic.

Key Figures

InfoObject

Description

0AMOUNT

Amount

0QUANTITY

Consumption quantity

Restricted Key Figures

The restricted key figures are divided into several groups.

The basic key figures cannot be used without restricting some of the characteristics. For this reason you should use only the supplied restricted key figures in queries you have defined yourself, or analyze the supplied restricted key figures and modify them to suit your requirements.

InfoObject

Restriction

“Costs” Group

Data for all restricted key figures of the group

Key figure category = 1000 (costs and associated quantities)

Valuation view = 0 (legal valuation)

Version = 0 (current variant)

Key figure = 0AMOUNT (amount)

0WBS_C11_RK0002 Actual costs

Sender/receiver = S (debit posting or receiver debit)

Value type = 10 (actual)

0WBS_C11_RK0001 Planned costs

Sender/receiver = S (debit posting or receiver debit)

Value type = 20 (plan)

0WBS_C11_RK0006 Settled costs

Sender/receiver = H (credit posting or sender debit)

Value type = 10 (actual)

0WBS_C11_RK0003 Commitments

Sender/receiver = S (debit posting or receiver debit)

Value type = 40 (commitment)

0WBS_C11_RK0004 Budget (per fiscal year)

Value type = 50 (budget)

0WBS_C11_RK0005 overall planning (per fiscal year)

Value type = 20 (plan)

“Revenues” Group

Data for all restricted key figures of the group

Sender/receiver = H (credit posting or sender debit)

Key figure category = 1001 (costs and associated quantities)

Valuation view = 0 (legal valuation)

Version = 0 (current variant)

Key figure = 0QUANTITY (quantity)

0WBS_C11_RK0008 Actual revenue

Value type = 10 (actual)

0WBS_C11_RK0007 Planned revenue

Value type = 20 (plan)

“Quantities” Group

Data for all restricted key figures of the group

Sender/receiver = S (debit posting or receiver debit)

Key figure category = 1000 (costs and associated quantities)

Valuation view = 0 (legal valuation)

Version = 0 (current variant)

Key figure = 0QUANTITY (quantity)

0WBS_C11_RK0021 Actual consumption quantity

Value type = 10 (actual)

0WBS_C11_RK0022 Plan consumption quantity

Value type = 20 (plan)

“WIP” Group

Data for all restricted key figures of the group

Sender/receiver = S (debit posting or receiver debit)

Key figure category = 1410 (inventory (WIP))

Valuation view = 0 (legal valuation), version = results analysis version

Value type = 80 (results analysis)

Key figure = 0AMOUNT (amount)

0WBS_C11_RK0011 WIP: Revenue in excess of billings

Detail for value type = 10

0WBS_C11_RK0009 WIP: Work in process

Detail for value type = 1, 2

0WBS_C11_RK0010 WIP: Cannot be activated

Detail for value type = 3

“Results” Group

Data for all restricted key figures of the group

Sender/receiver = S (debit posting or receiver debit)

Key figure category = 1400 (accrual calculation)

Valuation view = 0 (legal valuation)

Version = accrual version

Value type = 80 (results analysis)

Key figure = 0QUANTITY (quantity)

0WBS_C11_RK0018 Revenue affecting net income

Detail for value type = 12

0WBS_C11_RK0014 Cost of sales

Detail for value type = 3, 4

0WBS_C11_RK0015 Cost of sales (cannot be capitalized)

Detail for value type = 5

0WBS_C11_RK0017 Realized loss

Detail for value type = 11

0WBS_C11_RK0012 Reserves for imminent losses

Detail for value type = 1

0WBS_C11_RK0013 Reserves for imminent losses - inclusion cannot be capitalized

Detail for value type = 2

0WBS_C11_RK0016 Loss

Detail for value type = 10

“Reserves” Group

Data for all restricted key figures of the group

Sender/receiver = S (debit posting or receiver debit)

Key figure category = 1420 (reserves)

Valuation view = 0 (legal valuation), version = results analysis version

Value type = 80 (results analysis)

Key figure = 0AMOUNT (amount)

0WBS_C11_RK0019 Reserve: unrealized costs

Detail for value type = 1, 2

0WBS_C11_RK0020 Reserve: unrealized costs, not capitalized

Detail for value type = 3

Units

InfoObject

Description

0CURRENCY

Currency key

0UNIT

Unit of measure

Hareesh

Former Member
0 Kudos

Hi Haresh,

Thanks for the detailed Information.

Could you please let me know the Technical Name of INfocube i need to use for my report requirment

Former Member
0 Kudos

Hi,

Cube technical name-0PM_C01

Assign points if helpful

Hareesh

Former Member
0 Kudos

Hi Hareesh,

Thanks for the info provided.

I am confused again.

You mentioned the Cube Name - 0PM_C01

But for this cube is loaded with data using 0PM_OM_OPA_1: Maintenance orders: Costs and allocation Info source.

But in you earlier posting you mentioned that i need to use

InfoSources

· 0CO_OM_WBS_1: WBS Elements: Costs

· 0CO_OM_WBS_2: WBS Elements: Budget

· 0CO_OM_WBS_3: WBS Elements: Overall Plan

· 0CO_OM_WBS_6: WBS Elements: Actual Costs Using Delta Extraction

to achieve my requirment

Staff Budget / Actual Variance report

Our BW Reporting requirement is to compare the 'Cost Centre' Budgeting & Payroll Information.

In finance Budgeting will be done on Cost centre basis and to compare the Budget on Cost Centre with that of Payroll Data (Actual).

As i am new to BW please advise me on how to proceed further

Thanks

Former Member
0 Kudos

Hi,

I think 0PCA_C01 (not sure)

Hareesh

Former Member
0 Kudos

Hi,

Can u explain ur requirement clearly hwta u want to show in the report so that depending on ur requirement related datsrcs & cube is selected

Former Member
0 Kudos

Hi,

Thanks for the help.

Staff Budget / Actual Variance report

Our BW Reporting requirement is to compare the 'Cost Centre' Budgeting & Payroll Information.

In finance Budgeting will be done on Cost centre basis and to compare the Budget on Cost Centre with that of Payroll Data (Actual).

Thanks

Former Member
0 Kudos

Hi

Could anyone update me on this please

Thanks