topic Re: CUSTOMER GENERAL DATA FD03 in Application Development and Automation Discussions

CUSTOMER GENERAL DATA FD03

Former Member — Mon, 04 Sep 2006 14:02:33 GMT

Hi All ,

My requirment is to pull data for the

'E-MAIL ' field into the report using TC : FD03 , which is for customer general data . i would like to know which table-fields we can retrive this from....

Thxs,

vin

Re: CUSTOMER GENERAL DATA FD03

abdul_hakim — Mon, 04 Sep 2006 14:04:13 GMT

hi,

check the table <b>ADR6</b>.

Cheers,

Abdul Hakim

Re: CUSTOMER GENERAL DATA FD03

Former Member — Mon, 04 Sep 2006 14:08:08 GMT

I should be the table ADR6, so you need to read the table KNA1 using customer code (KUNNR) and so ADR6 where ADDRNUMBER = KNA1-ADRNR.

Max

Re: CUSTOMER GENERAL DATA FD03

Former Member — Mon, 04 Sep 2006 14:45:54 GMT

Hi,

I have pulled up the requored e-mail field but the problem is the ADR6-SMTP_ADDR field lenth is 241 which is taking too much space in the ALV may i know how to avoid this pls..

Thxs,

Vin.

Re: CUSTOMER GENERAL DATA FD03

abdul_hakim — Mon, 04 Sep 2006 15:29:52 GMT

while building the fieldcatalog you could restrict the field length to the required length.

Cheers,

Abdul Hakim