Get Material document in error (in COGI) with ABAP

To get material document in error, check table AFFW.

Example : Code used in COGI :

    SELECT * FROM affw                                    "#EC CI_BYPASS
             INTO TABLE affw_tab UP TO p_maxrow ROWS
             WHERE weblnr <> space
               AND wablnr = space
               AND ( inact = space OR
                     inact IS NULL )
               AND weblnr IN s_belnr
               AND werks  IN s_werks
               AND matnr  IN s_matnr
               AND lgort  IN s_lgort
               AND dispo  IN s_dispo
               AND fevor  IN s_fevor
               AND ps_psp_pnr IN psp_affw_range
               AND msgno <> space.	

Search tag: doc, document, article