Skip to Content
0
Former Member
Apr 24, 2009 at 09:38 AM

How to get value for location for each material?

39 Views

I have a data for the material-location into internal table t_matloc like...

Material	Location	STATUS
GLASS_01	IND-1001	A
GLASS_01	IND-1002	A
GLASS_01	IND-1003
GLASS_01	BRN-9999

GLASS_02	IND-1001	A
GLASS_02	IND-1002	

GLASS_03	IND-1001	
GLASS_03	BRN-9999

GLASS_04	IND-1001	
GLASS_04	IND-1002	
GLASS_04	IND-1003	A
GLASS_04	BRN-9999

GLASS_05	IND-1001	
GLASS_05	IND-1002	
GLASS_05	IND-1003
GLASS_05	BRN-9999	A

GLASS_06	IND-1001	
GLASS_06	IND-1002	
GLASS_06	IND-1003
GLASS_06	BRN-9999	A

I want to check for particular material, if other than location 'BRN-9999' has status = 'A', Put 'BRN-9999' has status = 'A'.

At least one location other than 'BRN-9999' has status = 'A', Put staus = 'A' for the 'BRN-9999'.

How can I do this?

Regards,

RH