Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
aDao_Zhang
Contributor
Contributor

Qlik Script Select SAPQUERY with Language selection

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

 

Labels (1)
0 Replies