取其中一条与有效日期结束(ANLB-BDATU)最近的,且在其后续时间的
SELECT SINGLE bukrs anln1 anln2 afabe
afasl afabg ndjar ndper
naprz schrw MIN( bdatu )
FROM anlb
INTO ws_anlb
WHERE bukrs = ws_anla-bukrs
AND anln1 = ws_anla-anln1
AND anln2 = ws_anla-anln2
AND afabe = p_afabe
AND afasl IN s_afasl
AND bdatu >= wlv_date
GROUP BY bukrs anln1 anln2 afasl
afabe afabg ndjar ndper
naprz schrw.