Skip to Content

how to get language field in 2 character using open sql

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 24, 2017 at 09:38 AM

    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). 
    
    Add comment
    10|10000 characters needed characters exceeded