0CUSTOMER_ATTR extractor and e-mail field

[Former Member]

Hello experts,

I was pretty surprised to find out that standard BW extractor 0CUSTOMER_ATTR has no e-mail field in it. So my question is: do I have to enhance this extractor to get the e-mail field for the customer? If enhancement is required, what table/tables in ERP has e-mail data for customer?

Or is there another way this data is delivered to BW from ERP? Maybe there is another standard extractor I don't know about?

Best regards,

Vladislav

[Former Member · Accepted solution]

Hi,

Yes, the 0CUSTOMER_ATTR datsource needs to be enhanced to get the email address for the customers.

You can get the email address for customers by comparing table ADR6 and KNA1.

Below is the sample code you can use it dobuild your logic.

SELECT SINGLE ADR6~SMTP_ADDR

     INTO (<fs_biw_lfa1_s>-ZZSMTP_ADDR)

      FROM KNA1

      INNER JOIN ADR6 on KNA1~ADRNR = ADR6~ADDRNUMBER

       WHERE KNA1~KUNNR = <fs_biw_lfa1_s>-KUNNR

        AND KNA1~KTOKD in ('ZREP','ZINT').

Thanks,

Sathya

[Former Member]

Hi Vladislav,

You can enhance e-mail field from

ADR6 SAP Table - E-Mail Addresses (Business Address Services)

ADR6 - SMTP_ADDR field will contain e-mail address, get it by comparing KNA1 - ADRNR with ADR6 - ADDRNUMBER etc.

Hope answers your need - Kumar