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 |