Using Primary index

This is very simple select query to select data from MARA using Primary INDEX.

select matnr mtart
    from mara into TABLE it_mara
    where mtart = c_mat_type
      %_hints ORACLE 'index("MARA" "T")'.