Skip to Content
author's profile photo Former Member
Former Member

0CUSTOMER_ATTR extractor and e-mail field

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 11, 2013 at 01:36 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 11, 2013 at 01:36 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.