Skip to Content
0
Oct 23, 2005 at 03:04 PM

CUSTOMER DATA WITH DIFFERENT SPRAS

744 Views

Hi,

i´ve got the following SELECT statement:

SELECT SINGLE aname1 aort01 astras apstlz

atelf1 astcd1 c~bezei

INTO (wa_devolucion-name1, wa_devolucion-ort01,

wa_devolucion-stras, wa_devolucion-pstlz,

wa_devolucion-telf1, wa_devolucion-stcd1,

wa_devolucion-provi)

FROM kna1 AS a

INNER JOIN t005 AS b

ON bland1 = aland1

AND bspras = aspras

INNER JOIN t005u AS c

ON cspras = aspras

AND cland1 = aland1

AND cbland = aregio

WHERE a~kunnr = v_kunnr

AND c~spras = v_spras

AND c~land1 = v_land1

AND c~bland = v_regio.

The problem is that for certain customer the value in t005-spras is different from the value in kna1 and t005u.

How can i solve this problem?.