Skip to Content
avatar image
Former Member

Deleted Record in SOST

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 31, 2017 at 03:02 PM

    Hi

    the user can create own layout for sost and define filter for status.

    Best regards

    JozsefH

    Add comment
    10|10000 characters needed characters exceeded