Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Capturing "Actual Amounts" from previous years

Hi Experts,

We had earlier developed a report to produce a list of projects which can be changed from status TECO to CLSD. If the project cannot be closed then the corresponding reason for failure should be displayed.

Now the problem is that there were some direct costs which were booked under certain WBS elements. These elements were created in the previous year & haven't been settled in that year. Our present program isn't able to capture & display these costs in the current year. We have based our logic up on a join of table COBK with tables COEP, PROJ & PRPS. We are referring to the SAP standard TCODE s_alr_87013533 which is able to find the unsettled dollars (Actual amount) even from previous years. Anyone please help advise as to how we can even capture the actual amounts from previous years.



Our inner join statement is as shown below:

SELECT coep~objnr coep~wogbtr coep~megbtr coep~wrttp coep~kstar
         coep~owaer coep~vrgng coep~sgtxt coep~ebeln coep~ebelp
         coep~objnr_n1 coep~belnr coep~gjahr coep~perio
         cobk~blart cobk~refbn cobk~refbk cobk~refgj
    FROM coep INNER JOIN cobk ON cobk~kokrs = coep~kokrs AND
                                 cobk~belnr = coep~belnr
              INNER JOIN prps ON coep~objnr = prps~objnr
              INNER JOIN proj ON proj~pspnr = prps~psphi
    WHERE proj~pspnr  = wa_proj-pspnr   "project definition
      AND prps~pspnr  = wa_prps-pspnr   "WBS element
  AND prps~belkz =  c_x             "Account assignment
  AND coep~wogbtr <> 0              "amount
  AND coep~lednr = c_00             "Ledger (needed to hit index)
  AND coep~wrttp IN (c_04, c_11)    "actual value type - real & stat
  AND coep~beknz IN r_beknz.        "D/C Ind <> Settlement


based on the data provided -


Cost line 7143.28 71710000

Cost line 42874.74 73120000

Cost line 22752.77 73120000

TOTAL COST 72770.79

Settlement line 65627.51 81650000

Settlement line 7143.28 81650000

TOTAL SETL 72770.79

you should be able to set CLSD to this project as there is no unsettled value in the project

CJI3 report confirms that there is no outstanding settlement and hence project can be set to CLSD. This report shows all the line items against project

The report S_ALR_87013533 shows the actual cost incurred in the project, but not settlement. This does not mean that the project is unsettled.

see another report (project cost element report) - that might help you S_ALR_87013542

0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question