Report Painter,Relationship between Report Groups and Reports

Subject: Report Painter,Relationship between Report Groups and Reports

Dear Report painter gurus,

What is the relationship between Report Groups and the
Reports assigned to them ? My problem is that, when I leave EMPTY
characteristics in one Report, I cannot Execute ALL other reports
assigned to the same Report Group as the First Report (the report with
the empty characteristics)

So it seems that whatever mistakes I make in one report, affects
ALL the other reports within the same Report Group. Can someone verify
this for me ?

Thanks in advance !

-----Reply Message-----
Subject: RE: Report Painter,Relationship between Report Groups and Reports

I have found that by far the safest way to proceed is to have a one to one
relation ship between a report group and a report. otherwise all sorts of
strange things start to happen.

Cheersy cheers

Report Painter, changing the tables assigned to libraries

Subject: Report Painter, changing the tables assigned to libraries

Dear Report Painter folks,

If I assign the wrong table to a Library, how
do I correct this mistake ?

Regds,

-----Reply Message-----
Subject: RE: Report Painter, changing the tables assigned to libraries

If you just created the Library and assigned an existing table to it, you
can delete the Library using Report Writer, and start over.

-----End of Message-----

Library for Report Painter/Writer

Subject: Library for Report Painter/Writer

Hi Sappers
I just have one question regarding Report Writer/Painter
Is it possible to create new library based on whatever table we want which
is not SAP installed. For exmaple, in PCA, there is standard library
8A2 which si based on GLPCT. Is it possible to create new library based on
table say GLPCA? If so, what's menu path to add table in Library?
I am on 3.1H.

TIA

-----Reply Message-----
Subject: RE: Library for Report Painter/Writer

As consultants always say:
"Do you really want to create reports on table GLPCA?".
All the information is in GLPCT and in addition performance with reporting
on GLPCA would probably be very bad.

I wanted to get period information form PCA. And it looks like GLPCT does
not give records per period (period field is 16 or other value) but only the
cumulative values per period are stored in specific fields. So i thought I
needed a report on GLPCA, but I use libraries based on GLPTC to get the
information from GLPCA. Apparently by selecting periods (RPMAX) in reports,
SAP will show all the GLPCA records for that period, but it will get it from
the summary record in GLPCT. Don't ask me how, but it works.

hope this helps.

Regards,

-----Reply Message-----
Subject: RE: Library for Report Painter/Writer

You should be able to make a dd table available to Report Painter / Writer if you can create an
Evaluation structure for the table.

To create an Eval structure In Logistics:
Tran MCS7 - Create evaluation Structure.
(Path: Logistics >Sales & Distribution >Sales Info System >Flexible Analysis >Evaluation
Structure >Create)

You could name the Eval Structure "ZFGLPCA", (must begin with "ZF").
Then click

( if this is a table and not another Eval structure.)
Enter the DD table "GLPCA". And click the check mark.
Then click and mark all the characteristic fields you want to report on, (if
you right click
you can ), then .
Do the same for
Then generate the Eval structure or

After you created the Eval structure, you can create a library with this Eval structure (table) in it.

GLPCA worked for me. We are on 3.1H P47

Good Luck

-----Reply Message-----
Subject: RE: Library for Report Painter/Writer

The 'tables' that are available for use in Report Painter/Writer are stored in
client-independent table T804A. As far as I know, there is no customizing transaction for this table (at least not in
3.1H).

Please note that the "tables" defined here are not necessarily physical tables; they can also
be 'logical' tables which contain several physical tables, as defined in table T804E (also
client-independent). In your example, the table delivered for PCA report Library 8A2, 'GLPCT' is actually defined in
table T804E to include data from physical tables GLPCT, GLPCA, and GLPCP.

You actually define the Library using transaction GR21/GR22. I have never actually customized a
table definition for use in Report Painter/Writer; but it can be done through tables T804A/T804E.

-----End of Message-----

sap fico Report Painter, How to reverse +/- signs

Subject: Report Painter, How to reverse +/- signs

Dear Report Painter gurus,

I am trying to reverse the +/- signs in my P/L statement, which I
created using Report Painter. Could someone please help me out ?

Regds,

-----Reply Message-----
Subject: Report Painter, How to reverse +/- signs

Try using the Absolute value in your formula as follows:

Ex: (X003 / ABS X002)) * 100, or whatever variables you need to use.

I find that this usually reverses the appropriate signs.

In the report, there is also formatting available that will reverse the
signs.
Do: In Report Writer: Change report screen, (transaction GRR2),
Formatting-->Row-->reverse signs.

However, this will reverse all signs in the statement. You may not want
that.

Try both to see what happens.

Hope this helps.

-----End of Message-----