Skip to Content
0

how to get language field in 2 character using open sql

Nov 24, 2017 at 09:30 AM

32

avatar image

I am getting spras from a x table using open sql in abap.

I am retrieving the value in 1 character like for 'EN' its 'E'.

I wanted to use new open sql feature to get value as EN, can we do that?

SQL
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Raymond Giuseppi
Nov 24, 2017 at 09:38 AM
0

You already could JOIN with table T002 Which sql expressions did you already try

e.g. loading T002 values fin an internal table and using this internal table in a host expression

SELECT FROM t002 
       FIELDS spras, laiso
       INTO TABLE @DATA(isocodes).

SELECT SINGLE
       FROM makt
       FIELDS '*' AS mark,
              @( isocodes[ spras = spras ]-laiso ) AS laiso
       WHERE matnr = @matnr
       INTO @DATA(result). 
Share
10 |10000 characters needed characters left characters exceeded