Project and Portfolio Management Practitioners Forum
cancel

Query to get total planned cost/actual cost for each buget line

Highlighted
Phanishwar
Honored Contributor.

Query to get total planned cost/actual cost for each buget line

Hi,

For a project there is requirement to pull total planned and actual cost per/individual buget line for both labor and non labor . I am wondering if it can be pull directly. is there any api by ppm to pull the same.

I need the sql for list portlet.

Thanks ALL for you immense support till now!!.

Thanks,
Phani
2 REPLIES
Phanishwar
Honored Contributor.

Re: Query to get total planned cost/actual cost for each buget line

see the doc attached
Phanishwar
Honored Contributor.

Re: Query to get total planned cost/actual cost for each buget line

I think i got it.

SELECT
sum( c.PLAN_VALUE_BSE),
sum( c.ACTUAL_VALUE_BSE)
FROM kcst_currency_cells c, kcst_budget_line_cells b
WHERE c.CURRENCY_CELL_ID = b.CURRENCY_CELL_ID
and budget_line_id=35280.

I thought it's not direct.