SELECT r~ZZID r~ZZCOMPANY_CODE r~ZZCOST_CENTER r~ZZSR_NUMBER r~ZZDATE r~ZZSERVICE_TYPE r~ZZRQSTTS r~CREA_USER r~CREA_TIME r~CHNG_USER r~CHNG_TIME r~ZZASSIGNED_TO l1~ZZDESC as ZZSERVICE_DESC l2~ZZDESC as ZZSTATUS_DESC T~BUTXT as ZZCOMPANY_NAME
  INTO CORRESPONDING FIELDS OF TABLE req
  FROM ZFI_DISPOSAL_REQ as r
  LEFT JOIN ZFI_LOOKUP as l1 ON  l1~ZZLKUPID = r~ZZSERVICE_TYPE
  LEFT JOIN ZFI_LOOKUP as l2 ON  l2~ZZLKUPID = r~ZZRQSTTS
  LEFT JOIN T001 as T ON  T~BUKRS = r~ZZCOMPANY_CODE
  WHERE ( r~ZZCOMPANY_CODE in ZZCOMPANY_CODE )
   and   ( r~ZZCOST_CENTER in ZZCOST_CENTER )
   and   ( r~ZZSR_NUMBER in ZZSR_NUMBER )
   and   ( r~ZZDATE in ZZDATE )
   and   ( r~ZZSERVICE_TYPE in ZZSERVICE_TYPE )
   and   ( r~ZZRQSTTS in ZZRQSTTS )
   and   ( r~ZZASSIGNED_TO = i_fa_specialist ).