-----Original Message-----
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 <DD table ref> ( if this is a table and not another Eval structure.)
Enter the DD table "GLPCA". And click the check mark.
Then click <Characteristics> and mark all the characteristic fields you want to report on, (if
you right click
you can <select all>), then <copy + close> <copy>.
Do the same for <Key figures>
Then generate the Eval structure <back> <yes> or <Evaluation structure> <Generate>

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 Books
SAP Certification, Interview Questions, Functional, Basis Administration and ABAP Programming Reference Books

SAP FICO Tips
SAP FI/CO Tips and Financial Accounting/Controlling

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com