Customer Master Data.

[Former Member]

Hi,

I have to retrieve customer master data from table KNA1 for all the customers from the system who have not been marked for deletion. Though this can be done using select statement, I wanted to know if this was possible using any function module.

Is there any function module available for the above scenario?

Also I have to get the contact person email(field SMTP_ADDR) from table ADR6 for a customer. I am not able to find a link between KNA1 and ADR6. Could you please help me to retrieve the data?

Thanks,

Sandeep.

[Former Member]

Done

[former_member585060]

Get the Addressnumber ADRNR from KNA1,

with that ADRNR number, get the Email address from

ADR6 table SMTP_ADDR comparing

KNA1-ADRNR = ADR6-ADDRNUMBER.

Regards

Bala Krishna

[former_member181995]

KNA1-ADRNR = ADR6-ADDRNUMBER

Blocking is depend on your requirement of business we may block in several ways like

KNA1-AUFSD-Central order block for customer
*01	Overall block*
*02	All free of charge*
*03	Test block*
*04	Check Terms of Pymt*
*05	Check Terms of Dlv*
*08	Check Credit Memo*
*09	Check Debit Memo*
*99	test (e)*
KNA1-FAKSD - Central billing block for customer
LIFSD-Central delivery block for the customer
KNA1-SPERR-Central posting block
KNA1-SPERZ-Payment Block
KNA1-CASSD-Central sales block for customer

depending on that condition you may write your select query.

and the values are depending on type of order block.

[former_member195383]

HI,

You can link ADR06 and KNA1 through the field ADDRNUMBER of ADR06 and ADRNR of KNA1