getting the customer description

[Former Member]

I have 2 table a005 and kna1. I have to get the customer description of the customer number.

[Former Member]

I have 2 table a005 and kna1. I have to get the customer description of the customer number.

[Former Member]

Hi rhymmeanne

KNB1 Customer master(Company Code)

KNB5 Customer master (Dunning Data)

KNVP Customer master Partner Function

KNVV Customer master Sales data

KNVD Customer master Record Sales Request Form

Regards

Wiboon

[Former Member]

Hi,

For a given customer number, you will get the description and general details in KNA1 only..

The field is KNA1-NAME1, KNA1-NAME2.... KNA1-NAME4..

Thanks and Best Regards,

Vikas Bittera.

[Former Member]

Hi,

You take field NAME1,NAME2 in KNA1 table.

reward if helpful.

[Former Member]

I have to get the material description in table kna1. please help me when i select.

im using these statement but no data retrieve when debug.

select a~kunnr

k~name1

k~spras

into table t_kna1

from a005 as a

inner join kna1 as k ON a_{kunnr eq k}kunnr

where k~spras eq sy-langu

and a~kunnr eq s_kunnr.