How to add copy or save function to EHS report

[Former Member]

I am new to EH&S. Currently we have already a customized report ZEHSBOS that can display the bill of specifications for one material at a time, but it doesn't have copy or save to spreadsheet function. If we want to copy or download the entire structure of material, what needed to fix it? Thanks a lot.

[christoph_bergemann]

Dear Zhifeng

normally you would develop an output variant to do the job. You would start by using a hit list of REAL_SUBs. You can download/display then easily material data, specification data (liek composition) etc.

This is in most case a "more" user friendly option and output variant can be developed by your own and made available to the user by customizing etc.. By the way: SAP is providing very useful output variants regarding your topic/ Please refer to EHS docu.

Coming back to your question:

"but it doesn't have copy or save to spreadsheet function"

Save: normally you integrate the "SAP ALV" functionality . With recent SAP releases you can "open" EXCEl "within" SAP and you need not to make first the download (even if EXCEL ist started immedately by SAP).

Refer to: http://de.wikipedia.org/wiki/SAP_List_Viewer

http://help.sap.com/printdocu/core/Print46c/de/data/pdf/BCSRVALV/BCSRVALV.pdf

or newer SAP documentation

May be: http://wiki.sdn.sap.com/wiki/display/ABAP/OBJECT+ORIENTED+ALV+Guide

could be of interest too.

As you are "still" using "Z Report": you can solve the topic as well by using "WebDynpro" technique: now SAP is providing a lot of solutions in this direction

Regarding your "copy" topic: which "type" of copy you are thinking of?? or is "download" you interest?

With best regards

C.B.

PS: in daily work user would like to select "property" to download composition or get information regarding usage etc.

Output Variantes like "EXCEL" etc. are really suitable and using this example you can do the job by your own.

[Former Member]

Thank you Christoph!

I can't read German, and would appreciate if you can send me same contents in English.

And could you please elaborate more on "WebDynpro" technique as we might still use the "Z report".  we want copy like ctrl + y does, but this is unavailable in the z report. It's better if we can download it.  I will read thru ur post and let you know of any question.

[Former Member]

I tried 1st solution as suggested, it can give a list for a specific material level by level, but I can't get a snapshot of the whole chain at one time as the Z report did. Any suggestion? Thanks.

[christoph_bergemann]

Dear Zhifeng

sorry. I provided the link to the german documentation of the ALV.

Please use:

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCSRVALV/BCSRVALV.pdf

instead

YOu should read cross first this:

http://help.sap.com/erp2005_ehp_06/helpdata/en/c1/eda0f591ec12408b25e7a1b369ca45/frameset.htm

And then navigate:

Basic Data and Tools (EHS-BD) =>

Specification Information System (EHS-BD-SIS) =>

"Displaying Specification Data" and then check

"Displaying Properties" or

"Displaying Compositions and Ingredients"

Please check these output variants how they fulfill your demand.

Now coming back to your demand:

a.) to use EH&S you need either a specification number or a material number; then you can use transaction CG02 and then you are bale to use one of the above mentioned output variants to do the job (or by preparing a customer specific output variant)

b.) actually it is not possible to use directly a list of material numbers to generate the so call "hitlist" and then to use one of the output variants

In any case: ALV and the functionality assigned to it is "quite old" and the EXCEL download option can be generated with "few lines of code" (please refer to SAP documentation; you will find many examples in internet how to do the job)

Coming back to the topic of WebDynpro: I mentioned it only WebDynpro because of the fact that you prepare similar UIs in which you can generate an EXCEL download. Actually EH&S is designed to use SAP "classic" not using WebDynpro. Only recent enlargements of EH&S are provided by SAP using WebDynpro techniques.

Regarding yor topic:

"I tried 1st solution as suggested, it can give a list for a specific material level by level, but I can't get a snapshot of the whole chain at one time as the Z report did."

I can not help directly because I don't understand what you have now realized/developped and what is missing there.

ALV and other SAP techniques provide useful techniques to displays "results" "different"; as hierarchy tree etc.

Hopefully these hints will help you.

With best regards

C.B.

[Former Member]

Thank you a lot! The component output variant from CG02 is what users need. Instead of displaying in SAP, can it be downloaded to Excel? Does it must be done by user exit?

[christoph_bergemann]

Dear Zhifeng

the existing output variants are delivered in the SAP standard. You should not change them. Therefore prepare a "copy" and play around with them. In doing so you could use ALV functionality. In this case EXCEL download functionality is available without further programming.

Any output variant is defined in customizing (refer to the "user exit" part). You can add your own custom developped variant by using customizing entry,. In doing so you will never have problems with releases (upgrade, updates) as SAP must support this feature in future release.

Main benefit of using an output variant is: it is completely integrated in the main transaction cg02. You can maintain ata (insert, update delele) then use at once the output variant without starting a further modus/session etc.

With best regards

C.B.