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

PCA Report

Friends,

I have to develop a PCA report using the Report Writer / Report Painter. The report has 13 columns. The 13th column is the sum of the first 12 columns. The data coming into the first 12 columns should be dynamic. For e.g. if the period selected on the selection screen is 8, then the first 8 columns (Jan - Aug) should give the actual data and the balance 4 columns (Sep to Dec) should give the plan data. Similarly, if the period selected on the selection screen is 6, then the first 6 columns (Jan - Jun) should give the actual data and the balance 6 columns (Jul - Dec) should give the plan data.

Please advise on how I should proceed, because I am stuck on how to get the columns to fetch the data in a dynamic way.

Thanks & Regards,

Sameer S. Gupte

Cell: +91 9323274801

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Nov 25, 2006 at 02:04 AM

    You can have budget and plan for all columns and then the total or the total of the

    columns that u selected, to meet ur requirement is difficult cause it depends on

    the previous row if its actual or not, try to use a variable, one column would

    have both record type 0 and 3 so theres no logic that it follow

    . i guess you will need an ABAP report for this

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 24, 2006 at 01:39 PM

    Hi,

    Good afternoon and greetings,

    Please go through the following link and it may be of some help for you

    http://help.sap.com/saphelp_erp2004/helpdata/en/27/06e23954d9035de10000000a114084/frameset.htm

    Please reward points if found useful

    Thanking you

    With kindest regards

    Ramesh Padmanabhan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 04:01 PM

    The PCA report that was required could not be developed using Report Writer. We dcided to develop the report using ABAP.

    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.