SELECT * FROM ZBCVT_PRD_PRC_HI AS pp INNER JOIN zbcvt_product AS p ON pp~product_id = p~product_id
    INTO CORRESPONDING FIELDS OF TABLE it_products
    WHERE pp~history_date = ( SELECT MAX( history_date ) FROM ZBCVT_PRD_PRC_HI WHERE product_id = p~product_id ).