I have created a report that looks in the table SOST, graps the records with an error code and reports them via email to the end-user. They want to be able to remove the record using SOST the t-code and have it not show up in the report. I haven't figured a way to filter it out of the select return. Any help would be appreciated.
SELECT od~objnam od~objdes st~msgv4 st~sndart st~stat_date st~stat_time
INTO TABLE it_sost
FROM sost AS st
INNER JOIN sood AS od ON (
od~objtp = st~objtp
AND od~objyr = st~objyr
AND od~objno = st~objno )
WHERE st~msgty ='E'
AND ( st~stat_date Eq lv_email_date AND st~stat_time GE s_time-low ) or st~stat_date = sy-datum
GROUP BY st~stat_date st~stat_time od~objnam od~objdes st~sndart st~msgv4.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.