SHARE
TWEET

Untitled

a guest Oct 12th, 2017 59 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT * FROM ZBCVT_PRD_PRC_HI AS pp INNER JOIN zbcvt_product AS p ON pp~product_id = p~product_id
  2.     INTO CORRESPONDING FIELDS OF TABLE it_products
  3.     WHERE pp~history_date = ( SELECT MAX( history_date ) FROM ZBCVT_PRD_PRC_HI WHERE product_id = p~product_id ).
RAW Paste Data
Top