Skip to Content
Author's profile photo K Jogeswara Rao

Equipment vs Class Report

Objective:

To develop an ALV report showing Equipment and the Class assigned to it.

Please see the screen capture of a report showing Equipment vs Class assigned.

Capture4.JPG

Do we have such report in standard system? We didn’t get when we needed this years ago. Ours is still ECC6.0 with no EHPs.

We expected such information from standard reports like IH08, but same unavailable.

Then I have developed a Quick-view fulfilling this need and assigned a Tcode to it.

Are you also one among those who need this report? If yes go through this document. It is a simple method of developing this report in PRD server itself through SQVI.

Step1

Run SQVI Tcode.

Create a QuickView eg., Equip_Class,’

Give a Title ýou like e.g., Equipment vs Classification

Choose ‘Logical Database‘  in the Data Source.

Type ‘EQI‘ in the Logical Database field, and press Enter to continue.

(All this Means you are about to create a Quickview using Logical Database EQI.)

Capture.JPG

Step2

If you are in ‘Basis Mode’ click on this button to switch to ‘Layout Mode‘.

Captur_e.JPG

Now you’ll see the following.

Capture1.JPG

You need not have to do anything on the left side ‘Data Fields’ area.

See in the Right side ‘List fld. select.‘ tab.

Choose the fields you desire to have in the ALV output here. Select these from ‘Available fields’ (Right side list) and transfer to Left side.

In the above example, I have chosen 6 fieds as per my requirement.

Define your own Selection screen

Go to ‘Selection fields’ tab.

Here you’ll see 4 fields have been already given by the system (with Lock icons), which you can not remove.

But you can add your own fields for selection criteria.

In the example below, I have added 5 such fields (5 to 9).

Capture2.JPG


Step3

It is almost done now.

Save the work done so far by clicking on the Save button at the top of the QuickViewer screen..

Now click on Execute button to run this program.

b.JPG

The Selection-screen

Capture3.JPG

The output

Capture4.JPG

A report for Functional Location vs Class can also be made in exactly similar way by using Logical database TPI.

fl.JPG

Step4

We have done all this work in PRD server and have seen the realtime data in the output by executing the QuickView.

Instead of going to SQVI and executing this quickview from there everytime, you can give a Tcode to this work.

Get the Report Name.

In the SQVI initial screen, select your Quickview, click on Quickview at top left corner –> Additional Functions –> Display Report Name.

/wp-content/uploads/2013/09/tcode1_286388.jpg

You will be getting this pop-up displaying the Report name you’ve just made.

tcode2.JPG

Now to create a Tcode there are two options.

1. Ask your technical person to create a Tcode you desire with the program name shown above.

OR

2. Do it yourself in ABAP client through SE93 Tcode and transport it to PRD.

This applies to the other Quickview also (FL vs Class)

Conclusion

Most of the steps described here apply while dealing with Infoset Queries also (SQ02, SQ01).

SAP has provided many Logical Databases in the system, which often come to our rescue while working with Queries and when we do not get proper tables to fulfill our requirements.

This document has been made with beginners in mind. For members with SQVI experience, it is a simple communication to use Logical database EQI or TPI to make Technical object vs Classification Report.

——–o——–








Assigned tags

      22 Comments
      Comments are closed.
      Author's profile photo Srinu S
      Srinu S

      Hi,

      Very nicely explained. And useful document as well.

      thanks,

      Srinu.

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Thank you Srini !

      Author's profile photo RAKESH MANE
      RAKESH MANE

      good and best details for SQVi

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Thank you Mane !

      Author's profile photo Former Member
      Former Member

      Thanks for sharing 🙂

      Author's profile photo Dipak Joshi
      Dipak Joshi

      Good information on Reporting.

      Author's profile photo Kalyan Chakravarthi
      Kalyan Chakravarthi

      Another good document Sir....Thanks for sharing

      Author's profile photo Former Member
      Former Member

      the t-code creation part is an addition for my knowledge...thanks 🙂

      Author's profile photo Former Member
      Former Member

      Hi Sir,

      Found you and your so many docs during completing the missions. Great work sir

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Hi PM User,

      Such are the observations keep me work on these documents and post.

      Thank you very much.

      Author's profile photo Ravi Prakash
      Ravi Prakash

      Very usefull & knowledge sharing Jogeswara keep it up boss in 2014 also.

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Thank you very much Ravi 🙂

      Author's profile photo Lokesh Ojha
      Lokesh Ojha

      really nice documents again ....thanks

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Thank you Lokesh 🙂

      Author's profile photo Former Member
      Former Member

      Hi Sir,

      Very nice document . Thanks for sharing .

      Best regards,

      Nitin

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Thank you Nitin,

      Glad you've liked the post 🙂

      Regards

      KJogeswaraRao

      Author's profile photo swapnil rajane
      swapnil rajane

      Dear Sir,

      Once again thanks a lot....

      Regards.

      Swapnil

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Thank you swapnil again

      🙂

      Regards

      Author's profile photo Carlos Eduardo Araujo
      Carlos Eduardo Araujo

      Hi Jogeswara Rao Kavala

      Very useful. Hats off!

      Best Regards.

      Carlos Araújo

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      Hello Carlos,

      So nice of you to have communicated the usefulness you felt about the post. 🙂

      Thank you

      Best Regards

      KJogeswaraRao

      Author's profile photo Lokesh Ojha
      Lokesh Ojha

      Hi sir ,

      can we add characteristics values also in the same with the associated class.

      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K
      Blog Post Author

      You can try by using AUSP table and other related tables as discussed here: linking of Eqp no. & Char. values | SCN

      Also you go through this post:  ALV Report on Equipment vs Class vs Characteris... | SCN

      Comments are closed.