Probing the Carbon-Nitrogen Bonding in Heterocyclic Compounds with the N K-Shell Excitation Spectroscopy