Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

how to find out the customer name

Former Member
0 Kudos

I m making a report for qm I need the customer name against the KUNNR field I have tried to find the customer name but i didnt plz anyone can tell me where can i find the customer name and address.

thanks

10 REPLIES 10

Former Member
0 Kudos

customer address can find in table ADRC table..

Former Member
0 Kudos

Hi,

Customer name is in KNA1 filed NAME1

ADDRESS : table ADRC

filed ADRNR is the common field

Regards

Krishna

peter_ruiz2
Active Contributor
0 Kudos

Hi Sunny,

Customer Name is in the KNA1 Table and Customer Address is in the ADRC Table. You may use this as reference.

Customer Name = KNA1-NAME1

Customer Address:

City = ADRC-CITY1

District = ADRC-CITY2

City Postal Code = ADRC-POST_CODE1

Street = ADRC-STREET

House Number = ADRC-HOUSE_NUM1

Country Key = ADRC-COUNTRY

Region = ADRC-REGION

you may reach the customer's address by linking the fieds KNA1-ADRNR and ADRC-ADDRNUMBER

Regards,

Peter

Former Member
0 Kudos

Hello ,

You can find Customer address from table ADRC and customer name from KNA1.

Regards

Sathish

Former Member
0 Kudos

Hi ,

You may use the FM "RPL_CUSTOMER_NAME_GET"

CALL FUNCTION 'RPL_CUSTOMER_NAME_GET'

EXPORTING

pi_kunnr = <KUNNR>

IMPORTING

PE_NAME1 = <CUSTOMER NAME>.

Hope this will help you.

Regards,

Smart Varghese

Former Member
0 Kudos

Hi,

Try like this.

Select single * from kna1 into wa_kna1 where kunnr = '0001012'

if not wa_kna1-adrnumber is initial.

CALL FUNCTION 'ADDR_SELECT_ADRC_SINGLE'

EXPORTING

addrnumber = wa_kna1-adrnumber

TABLES

et_adrc = it_adrc

  • EXCEPTIONS

  • ADDRESS_NOT_EXIST = 1

  • PARAMETER_ERROR = 2

  • INTERNAL_ERROR = 3

  • OTHERS = 4

.

IF sy-subrc <> 0.

  • MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

  • WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

endif.

Former Member
0 Kudos

Hi,

Pass the value of Kunnr to KNA1 and retrieve the value for ADRNR.

Then send this value as an importing parameter to the function module.

ADDRESS_GET_DATA . This will retreive both personal and Company data for the corresponding Customer.

Hope this will help you.

Regards,

Venkat.

former_member195383
Active Contributor
0 Kudos

get name1 and name2 from KNA1, based on the KUNNR.

Concatenate both, to get the cutomer name.

former_member333737
Active Participant
0 Kudos

Hi,

You will find it in,

customer name is in KNA1 filed NAME1
address : table ADRC

filed ADRNR is the common field

Regards,

Nikhil.

Former Member
0 Kudos

hi

1) Table : KNA1 (General Data in Customer Master)

Fields :

KUNNR : Customer No

NAME1 : Customer Name

2) Table : ADRC (Customer Address)

Regards