Skip to Content
0
May 08, 2008 at 11:44 AM

REGARDING FETCHING OF PARTICULAR DATA

22 Views

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...