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