Catalysis of the reaction: (R)-3-hydroxybehenoyl-CoA(4-) + NADP(3-) <=> 3-oxodocosanoyl-CoA + NADPH + H+.