Concerning the new Canopy 900 MHz gear, I understand that LMR - 400 is used from the AP to the omni- antenna but what type of cable is used between the SM and the connectorized antenna?

A 16" LMR-195, which is attached to the radio from the factory, is the only certified cable for both the AP/SM to antenna connections. At this time there are three certified directional antennas and the details for these are listed below:

Maxrad Model # Z1681, flat panel with 10 dBi gain
Mars Model # MA-IS91-T2, flat panel with10 dBi gain
MTI Model #MT-2630003/N, flat panel with 10 dBi gain