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?.