cancel
Showing results for 
Search instead for 
Did you mean: 

Grouping in list of items window to 7 levels

reno1
Active Participant
0 Kudos
43

Hi All,

"Grouping in list of items window to 7 levels ", is this possible ? if not, pls suggest a work around

Regards ,

Rohan

Accepted Solutions (0)

Answers (2)

Answers (2)

reno1
Active Participant
0 Kudos

I have given the Filter solution to the customer, but they say its not as friendly as Collapse and expand option (Groups) in List of Items Screen.

So have to open the thread again to all experts.

Suggest how to go about it.

Regards

Rohan S. Kamble

kvbalakumar
Active Contributor
0 Kudos

Hi Rohan,

Create a Formatted search in Item Code field with "Item Group" as input selection parameter.

For Ex:

Select T0.ItemCode, T0.ItemName from OITM T0 inner join OITB T1 T0.ItmsGrpCod = T1.ItmsGrpCod where T1.ItmsGrpNam = [%0]

Use this above query as FMS in the Item Code selection field.

regards,

Bala

reno1
Active Participant
0 Kudos

Thanks Bala,

But FMS will not work here.

Regards

Rohan S. Kamble

kvbalakumar
Active Contributor
0 Kudos

Hi Rohan,

If FMS won't help, no other go. Your work around (Filter) is the best one for this solution.

Regards,

Bala

reno1
Active Participant
0 Kudos

got a work around in the form of "filter list", grouping of 7 levels is not possible as per standard .