Get Current Ticket status text of Solution Manager Text

Table Relationship Below

DATA: lv_stat               TYPE crm_j_status,
    lv_txt30              TYPE j_txt30,
    lv_stsma              TYPE j_stsma

SELECT SINGLE stat INTO lv_stat FROM crm_jest
 WHERE objnr = ls_orderadm_h-guid
 AND inact EQ space.

SELECT SINGLE stsma INTO lv_stsma FROM crm_jsto
WHERE objnr = ls_orderadm_h–guid.

SELECT SINGLE txt30 INTO lv_txt30 FROM tj30t
WHERE estat EQ lv_stat AND spras = SY–LANGU
AND stsma EQ lv_stsma.