HI EXPERTS,
In below int table i have somany plants and corresponding dates data, now i want to filter only one plant and corresponding max date , can any body suggest what is solution to proceed..
i cant use max (datum) as it is in for all entries.
ELECT datum werks INTO TABLE lt_maxdate FROM zuxg_ser_opbal
FOR ALL ENTRIES IN lt_exgrp WHERE exgrp = lt_exgrp-j_1iexcgrp
AND werks = lt_exgrp-j_1iwerks
AND register = 'STP2SER'
AND datum LE wrk_end.
SORT lt_maxdate BY werks ASCENDING datum.
thank you...