topic Re: getting the customer description in Application Development and Automation Discussions

getting the customer description

Former Member — Mon, 03 Sep 2007 07:14:32 GMT

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

Former Member — Mon, 03 Sep 2007 07:19:45 GMT

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 — Mon, 03 Sep 2007 07:30:01 GMT

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 — Mon, 03 Sep 2007 07:34:47 GMT

Hi,

You take field NAME1,NAME2 in KNA1 table.

reward if helpful.

Former Member — Mon, 03 Sep 2007 07:38:10 GMT

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.