Skip to Content
Author's profile photo K Jogeswara Rao

ALV Report on Catalog Profile and Catalogs & Codes – (Infoset way)

Introduction:

After the exposure to many standard ALV reports for masterdata , it is seen that the clients or end-users expect similar reports for Catalog-Profiles, Code Groups and Codes, so that it will be easier to search for such available profiles which suit to their requirements and they can make use of the same, saving lot of time, effort and data duplication.

For big organizations, comprising of several units where SAP-PM is adopted, this requirement is very common.

We do not have such ready report/s provided by SAP.  At the same time, SAP has given good tools for Functional persons to generate reports on their own.

These are Quick viewer, and Infoset Queries.Present article is based on Infoset Query.

Let’s see what we are going to achieve in this article:


A report with selection screen like this

/wp-content/uploads/2013/07/untitled_248093.png

will generate a report like this: (list of all profiles related to ‘Motors’)

/wp-content/uploads/2013/07/output_247798.jpg


DO you find it is relevant and useful to you? Then here is how to make it !

Step 1. Create an Infoset as follows

– Create an infoset (Say ‘CATCODES’) using ‘SQ02′ Tcode. opting for Table-Join in the initial screen.

– In the Join  page Insert these tables as shown ( select left-outer-join for QPGR and QPCD tables join)

1.JPG

– Click Back,

– Select the required fields from tables (left) to the Field Groups in the right. (Drag & Drop) as shown here.

2'.jpg

In order to arrange the Calatogs in the sort order of B, C, 5, 2, A  in the ALV screen, a user defined field ‘SORT’ is being created in the following section.

For this click on the  ‘Extrastab on the application toolbar to have Extras window on the right.

Click on the ‘New’ icon and create ‘Additional Field‘ named ‘SORT

3.JPG

The specification of field ‘SORT‘ while creating

sort.JPG

Now, keep cursor on the ‘SORT’ field (Red Boxed area) and click on the ‘CODE‘ icon (Green box), and write the following code.

sort1.JPG

Save the code,

Making of ‘Selection screen’ of the report

Go to  ‘Selections’ tab (next to ‘Extras’ tab) and create the select-option.

Here we are creating the 2 selection fields shown in the 1st image of this document. i.e., Catalog Profile’ and ‘Created By’.

For this click on ‘New‘ icon in this tab and create two selection fields ‘CATPROF’ and ‘CRTDBY’ one after one as shown here.

4.JPG

/wp-content/uploads/2013/07/untitled1_248094.png

Now the ‘Selections’ tab will look like this.

sel.JPG

Save and Generate the Infoset.

This completes the job in Infoset creation (SQ02).

Come to initial screen of SQ02 and assign this infoset to your usergroup. (User group is created through SQ03)

Step 2. Create Infoset-Query through SQ01 as follows.

Create a Query (say ‘CATCODES’) using the infoset made above ‘CATCODES‘.

6.JPG

Click ‘Next’ arrow

Select all the 3 tables appearing here used in Infoset and click next.

sq011.JPG

Select the fields required for display in ALV.

sq012.JPG

Click on Basic List button and arrive at the following screen.

(If this screen does not appear go to ‘Settings’ menu, check the ‘Graphical Menu Painter’ option in the ‘Settings’ option)

sq013.JPG

The red box list shows the Field selections you need to appear in the output.

For column coloring you have to drag & Drop colors from tool box to the corresponding field as shown by the Red arrow on the right.

That’s all. Now You save the query and return to the initial screen. Execute and test.

To have a Tcode for the program you’ve just generated

In the SQ01 screen

/wp-content/uploads/2013/07/untitled1_248002.jpg

to get this result.

report.JPG

Copy this string (Report name), Run SE93 in Development Client and create a Z-Tcode with desired name using the above program name.

Transport the request to Production.

Now the report you’ve made is operated using the Tcode you’ve created.

To my end-users, this report was very much sought and proved very useful by them. They can now easily search the profiles available in the system (made by users in other shops)   for their similar equipments. This report has got many such uses.

The making of this report here has been demonstrated using ‘Standard Client ‘option in the SQ02 (Environment –> Query Areas), so that no transport needs to be done during creation or modifications. However as explained, the Z-Tcode has to be created in Workbench Dev Client, once.

Also, it is aimed through this document, the beginners in the Infoset query area to be benefited without referring to other detailed documents on SQ03, SQ02, SQ01.

Hoping it is useful to many.

Jogeswara Rao K

Assigned tags

      29 Comments
      Comments are closed.
      Author's profile photo Former Member
      Former Member

      Thanks for sharing another useful document.

      Author's profile photo Ravindra Devarapalli
      Ravindra Devarapalli

      Hi,

      I tried this document. When i am generating the infoset. error getting SORT not defined . Can you please tell why this error is getting . When i am defining SORT as data type system giving one more error already exist.

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

      It is difficult without screen-shots to judge what is happening.

      You may do one thing.

      1.Try giving some other name to 'SORT'. say 'SORT1;

      2.If this too is giving problems, then Ignore the 'SORT' part of the document.

      (This is only to bring the ALV in a particular order. ie., B,C,5,2 and A.)

      You'll be able to complete the exercise.

      Then you try to add SORT part and investigate what's happening.

      Jogeswara Rao K

      Author's profile photo Ramesh .
      Ramesh .

      Good Presentation... Thanks for sharing.

      Author's profile photo giuseppe caselli
      giuseppe caselli

      Tahnks for sharing this query.

      It is very useful.

      Giu

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

      Thank you giuseppe for recognition,

      -Jogeswara Rao K

      Author's profile photo swapnil rajane
      swapnil rajane

      Hi Jogeswara,

      No words....

      Excellent work.I will definately try it and let you know.

      Thanks once again...

      Regards.

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

      Thanks again Swapnil, Am sure you'll do it.

      -Jogeswara Rao K

      Author's profile photo Gary Bracegirdle
      Gary Bracegirdle

      Hi Jogeswara,

      One of our clients uses an Excel spreadsheet - I created this Query and they are happy that its online and now inside SAP.

      Thanks

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

      Hi  Gary,

      That gives a great satisfaction. I am sure you'll agree that this document deserves some acclaim (some rating / like) from your side.

      Jogeswara Rao K

      Author's profile photo Former Member
      Former Member

      Hi Jogeswara,

      Wonderful document i will try and let u know

      Thanks a lot

      Author's profile photo Srinu S
      Srinu S

      Helpful document. thanks for sharing. 🙂

      Author's profile photo Rajen Patel
      Rajen Patel

      Very helpful post

      Author's profile photo Kalyan Chakravarthi
      Kalyan Chakravarthi

      Dear Jogeswara Rao garu,

      Good document...thanks for sharing.

      Best Regards

      Kalyan

      Author's profile photo Former Member
      Former Member

      hi all,

      good day to all.

      i am new here, can anyone give me a standard list of catalog profile? our company is about to start the SAP this coming year.

      object, fault codes, causes, tasks and activities is all i need so please i need help out there.

      Thanks,

      Marcos

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

      Hello Marcos,

      Present posts or threads are not the right places for posting your Queries. Please post your query as a new Discussion, by clicking on Create --> Discussion as shown in th picture below.

      /wp-content/uploads/2014/12/untitled1_599450.jpg

      Author's profile photo Former Member
      Former Member

      Very usefull, thank you !!!

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

      Thank you Nicolas for your time and review 🙂

      KJogeswaraRao

      Author's profile photo Former Member
      Former Member

      thank you so much.. this query made my life easy.. though i have some issue.

      i cant group the profile. How to group and get the report layout as same as in your screen shot.

      Once again thank you so much..

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

      Thank you.

      Please explain what is meant by grouping of Catalog Profile. If it is how understand then, you export this report as excel file and do your sorting exercise.

      Author's profile photo Former Member
      Former Member

      Nice and helpfull document

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

      Thank you Niranjan 🙂

      Comments are closed.