on 12-11-2013 12:48 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
13 | |
13 | |
11 | |
11 | |
7 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.