Skip to Content
author's profile photo Former Member
Former Member

actual cost from coep table not comming properly for wbs

Hello All,

I develop a z report for wbs detail as similar to s_alr_87013558, i m gatting the correct actual value for some wbs ,and not correct for some,

M selecting wtgbtr from COEP by passing -prps-objnr,lednr = '00' and wrttp = ' 4',beknz =''s'.

my problem is in a same project the actual value is comming correct for few wbs and its behave different for another 1.my my dev system the actual value is not present in rpsco table also. if a check the table menually for correct value i need to pass -prps-objnr,lednr = '00' and wrttp = ' 4',vrgng-'coin'.

Please help me in selecting the actual value ,may b m not passing the correct value in where condition.

where condition prps-objnr,lednr = '00' and wrttp = ' 4',beknz =''s'.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • Posted on Apr 29, 2013 at 04:56 AM

    Check in RPSCO master table for project accounting info and compare with COEP table.

    Regards,

    Sanjeev

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 25, 2013 at 05:20 AM

    Not good idea to have Z report. Build a report painter which is more simple and reliable.

    If not possible, then use the table COSS and COSP rather than COEP.

    Regards,

    Mahendra

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 25, 2013 at 05:39 AM

    Hi,

    This is due to the inconsistency in the budget commitment tables.

    So try to run the belo wmentione correction programmes:

    RKACOR04 : Adjustments Between Line Items and Total Records ( Act Cost+ Commitment )

    RAKNBU01 : Transfer Purchase Requisitions and Purchase Order Commitments.

    followed by CJEN and CJBN .

    So this will help you , to update & line up the missed data in COEP table for accurate cost of the project / wbs

    Please reward , If its helpful to you.

    Regards,

    vrkumar

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 25, 2013 at 07:03 AM

    Hello Mahendra and VR,

    my client wnat a z simple report for this purpose,i know developing a report in report painter is bit eassy ,then developing a custo z one,as m a tech consultent i have less idea about report painter,so please help me and guide me to develope a report painter for this purpose,i study different document for report painter ,but still not comfortable in report painter,help me if u have some idea,.i resolve the issue by passing beknz = 'A',lendr ='00' and objnr ''

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Also try pass your conditions in table COSS and COSP.

      About report painter, you cna get guidance from FICO consultant if any in your team. It is not possible to guide you completely from this forum.

      Regards,

      Mahendra

  • author's profile photo Former Member
    Former Member
    Posted on Apr 29, 2013 at 02:42 PM

    Hi sam,

    Try This,

    In PRPS table PASS your WBS Element and get the OBJNR number .

    Pass that OBJNR number in COSP table along with Valuation Type will be '4' and BELTP value should be 1. Get the SUM of values.

    Now again go to AFVC table pass the WBS Element get the OBJNR number. Pass this number in COEP table with valuation type will be '4'. based upon your business process pass the business transaction type will be " COIN", now sum up this and above one you will get the exact result.

    Revert to me if you have any query.

    Regds

    Srikumar. S

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Srikumar,

      i m passing beknz = 'A',lendr ='00' and objnr '' to coep table ,for now in dev the value are coming correct,lets wait for the user testing ,its working fine as i test almost 35 cases hope 4 the best and thanks for the replay 2 all vary soon i ll close this thread as closed if my selection is work ,if any problem come i ll definitly ask u people and also after uat i ll share all the detail about the selection😊

      Thanks,

      Sam

  • author's profile photo Former Member
    Former Member
    Posted on Jan 23, 2014 at 07:16 AM

    Hello All,

    How to capture the commitment value of PR ,in my zreport the value is populating after po but if only PR exit no commitment value

    may b rpsco wrttp with 21 help me suggest some ideas.

    Thanks,

    sam

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.