Qlik Script Select SAPQUERY with Language selection

aDao_Zhang — Sat, 12 Mar 2022 11:47:21 GMT

I want to use select SAPQUERY to get data from SAP.

Below are my script, I want to select the description in language Afrikaans, looks like SAP expect a single letter for Language, if I use "a", I got nothing, I guess it was converted as upper case when query runs, it went to language Arabic instead of Afrikaans.

How can I modify my query to make it works as expected? thanks

Select SAPQUERY (QUERY (MATERIALTDESC), USERGROUP (DATA), WORKSPACE ( ), EXTERNAL_PRESENTATION (S),
OPTIONS (
(SELNAME LANG, KIND P, SIGN I, OPTION EQ, LOW a),
(SELNAME S_MATNR, KIND S, SIGN I, OPTION EQ, LOW MAT001)
));

Language	Language Specifications	Degree of Translation of Lang.	Lng ISO	Name of Language
a	S	0	AF	Afrikaans
D	S	1	DE	German
E	S	1	EN	English
A	L	0	AR	Arabic
S	S	2	ES	Spanish

topic Qlik Script Select SAPQUERY with Language selection in QlikView

Qlik Script Select SAPQUERY with Language selection