Problem with searching for 'empty' emails with BAPI_BUPA_SEARCH

[Former Member]

Dear ABAP'ers.

I have got a small problem with BAPI_BUPA_SEARCH.

I Use this BAPI to search for Business Partners with the Email condition.

I put rhe Email to lv_email variable, it works ok.

    lv_email = ' '

    CALL FUNCTION 'BAPI_BUPA_SEARCH'
      EXPORTING
        email = lv_email
      TABLES
        searchresult = lt_searchresult   <= returns no BuPas
        return       = ls_bapiret2  .

But I need to have a possibility to search for such Business Partners who have got no email address. Unfortunatellu when I pass an empty lv_email to BAPI, it returns no Business Partners whilst such BuPas exist in database.

Is there some possibility to search for those BuPas who have got no email address assigned?

I will be thankful for help.

Regards,

P.

[former_member156446]

Can you query ADR6 table where SMTP_ADDR = space.

and pick the PERSNUMBER or ADDRNUMBER and pick the Patners related to that ..