Aggr w.r.t to particular selection

[rahulsud007]

Dear Experts,

I am stuck in a issue where I need material controller of the selected plant in a single row.

For eg if we select a plant ch51 and a material code JL232604 in the below example.

I need to have a coloumn as Material Cont having the respective Material Control for the plant CH51 which is PF2 as shown in the output image and everything else as in the figure.

Kindly share your inputs.

Thanks in advance. !

[swuehl]

Maybe like attached?

[rahulsud007]

The output I need as shown in the outputimage

[swuehl]

My solution looks like

Mat Cond	Material Code	Material Desc.	U/R Stock	Quality Stock	Value	Plant	CH01	CH51	WA01	WA02
PF2	JL232604	COVER SEAT LOCK ASSY	2571	0	5167.71		MOV	MOV	NM	MOV

What's the issue with that table?

edit: Ah, I see, the attachment didn't make it

[rahulsud007]

Hi.

Thanks for your reply. But when we clear selection the Mat Cond field goes blank, over here I need values of respective MRP Controller for the selected Plant with respect to its material.

[rahulsud007]

... only when a particular plant is selected.

[swuehl]

Maybe like attached?