select Materal_number, UOM
from (
	select distinct 
		marm.[MATNR: (PK) Material Number] as Materal_number, 
		marm.[MEINH: (PK) Alternative Unit of Measure for Stockkeeping Unit] UOM,
		ROW_NUMBER() OVER(partition by marm.[MATNR: (PK) Material Number] order by 
			case 
				when  marm.[MEINH: (PK) Alternative Unit of Measure for Stockkeeping Unit] = 'B2' then 1
				when  marm.[MEINH: (PK) Alternative Unit of Measure for Stockkeeping Unit] = 'P2' then 2
				when  marm.[MEINH: (PK) Alternative Unit of Measure for Stockkeeping Unit] = 'B1' then 3
				when  marm.[MEINH: (PK) Alternative Unit of Measure for Stockkeeping Unit] = 'P1' then 4
			end
		) as Ord
	from LIB_F6P_RTP.bv.[MARM: Units of Measure for Material] marm
	where  [MANDT: (PK) Client] ='430'
		and marm.[MEINH: (PK) Alternative Unit of Measure for Stockkeeping Unit] IN ('B2', 'P2', 'B1', 'P1')
		and marm.[MATNR: (PK) Material Number] in   ('000000000081697825', '000000000081697872', '000000000081697875', '000000000081697878',
			'000000000081697944', '000000000081697946','000000000081698004', '000000000081698005', '000000000081718189', '000000000081718190', 
			'000000000081718191', '000000000081718192')
) as t
where Ord = 1