topic Re: Report Painter in Application Development and Automation Discussions

Report Painter

Former Member — Wed, 08 Feb 2006 16:36:28 GMT

Hi All,

I have a standard report and it uses a structure to pull the data for the report. I need to create a custom report which uses the same structure, selection screen but a different layout. Could any of u plz advice, if its doable in report painter or just plain abap program?? Also I am interested to know how the report painter stores the actual report?? as ABAP program?? Please help..urgent..

Thank you

Message was edited by: Thilothama v

Re: Report Painter

Former Member — Wed, 08 Feb 2006 16:48:12 GMT

Hi,

check the SAP help ..

http://help.sap.com/saphelp_47x200/helpdata/en/66/bc7d2543c211d182b30000e829fbfe/content.htm

regards

vijay

Re: Report Painter

Former Member — Wed, 08 Feb 2006 16:52:50 GMT

Thanks for the link. I already started reading it, but I want to know if someone has done this? or is it doable??

Re: Report Painter

former_member181966 — Wed, 08 Feb 2006 16:53:12 GMT

I had made couple of SD reports in report painter 4 year ago .. as far as process is concern you have create library , but it deals with information structure which start with s0* , after defining information structure in library it take to select the fields and display them on your out put . information structure have the statistical data most of the time . As i worked on information structure , so31,32,33 .....

I t creates ABAP program like ABAP query creates in background . if you execute Customer Over due analysis or in Co02 cost analysis report or MC* ( MM stock reports ) those are in report painter .

Hope this’ll give you some guide line ...

Thanks

Re: Report Painter

Former Member — Wed, 08 Feb 2006 19:27:04 GMT

Yes, its doable..

SUMBIT <SOURCE PROG> USING SELECTION-SCREEN <scr no> EXPORTING LIST TO MEMORY AND RETURN.

This statement execute the given selection screen<scr no> and later program<source prog>. Output is written to ABAP memory.

Using function LIST_FROM_MEMORY you read the output and format accordingly.

Re: Report Painter

Former Member — Wed, 08 Feb 2006 21:18:05 GMT

The source program?? Do I give the source Program generated out of Report execution? If the report is Report Painter report, Report group has set of programs generated for the report. Do I have to give these abap programs?

Also in the meanwhile, I was trying to generate a new report in report painter. I couldnt see all the characteristics that the Library has while creating a row. Could you please help?

Are Characterics not like Column names that has to be pulled from the structure or table??? Why am I not seeing all the column names of the tables in the list???

Message was edited by: Thilothama v

Re: Report Painter

Former Member — Thu, 09 Feb 2006 16:38:38 GMT

Venkat,

Using your code, will I be able to get all the data that the report generated in the memory? including the variation options I see on the left side of the report???

Re: Report Painter

former_member181966 — Thu, 09 Feb 2006 16:46:17 GMT

As far as I know about report painter, It create a report in background..Like when you make ABAP query (SQ01, 02, 03 ) .. It will create a report. You cant modify the report . You have to get OSS id in order to do that. if you’re ready do it then you can pass it to Memory and can achieve your goal ...

I think it will give you some hint. I wish I could have authorization to use report painter on my this project so I can help you out practically.

Thanks

Re: Report Painter

Former Member — Thu, 09 Feb 2006 17:21:39 GMT

How do I see where the Variation is coming from?? In the left side of the report, I could see the variation object...how do i see it??

Anyone with PS report experience - could you help me???

Re: Report Painter

former_member181966 — Thu, 09 Feb 2006 17:29:24 GMT

Please see these steps , it`ll help you ...

http://www.thespot4sap.com/Articles/Code_CostCentreReport.asp

Thanks

Re: Report Painter

Former Member — Thu, 09 Feb 2006 19:08:46 GMT

Saquib,

I really appreciate all the hints you are providing me..I dont know couple of things like

Where the variation objects for the report are coming from, when i open the variations - fiscal year, period values etc are present not what i see in the report in the left side..Also how do we link a report to a DB profile??

Thanks for all the help..

Re: Report Painter

Former Member — Sun, 12 Feb 2006 10:01:35 GMT

Dear Thilothama_v,

The variation objects are coming from the sets.

For example, when you read the report 'Cost Centers: Actual/Plan/Variance'(T-code : S_ALR_87013611), you can find the characteristic 'Cost Center' is set as a 'set variable'. So the cost center in the report left side are coming from the cost center group that you input.

Best regards.

Lewis Hwang

Re: Report Painter

Former Member — Wed, 15 Feb 2006 20:55:54 GMT

Lewis,

Can I include Project, WBS Element, Network Activity in the report results? in the cost element reports? I want to make the report 6ppp-001(Tcode: S_ALR_87013549) to display variation information on the report layout in the right side...Could you please help me how I can do this????

Is there any other forum I can get some help on this?? I tried in SAP fans...but no one has answered...any inputs???

Thanks

Thilothama

Message was edited by: Thilothama v