topic Re: Report Painter Query (FI) in Application Development and Automation Discussions

Report Painter Query (FI)

Former Member — Thu, 21 Dec 2006 10:19:59 GMT

Can you suggest me a table for report painter where we have field mentioned below on the selection screen.

Controlling area

Reporting Year

Reporting Month

Comparison Year

Comparison Month

Chart of Accounts

Currency

Ledger

Cost Center

Functional Area

Re: Report Painter Query (FI)

Former Member — Thu, 21 Dec 2006 10:28:28 GMT

check : CSKS + CSKSD + CSKT

Re: Report Painter Query (FI)

Former Member — Thu, 21 Dec 2006 11:39:13 GMT

Hi Namit,

For Report Painter you must use existing Reporting Tables, the most likely candidate with the fields you want would be CCSS.

The selection screen entries are generated by assigning variables to various characteristics in the Reporting Library created from the table - you can define these yourself.

If you can find the fields you want on database tables in the Data Dictionary, and wish to find the Reporting Tables which are populated from those database tables, the information is stored in table T804E - a browse of this will show you the relationships between database and reporting tables.

Hope that helps - please award points if it does.

Best Regards

Robin