Open SQL for ABAP and MS SQL equivalent code.

[Former Member]

can somebody please give open sql for ABAP and MS SQL equivalent code for the following code snippet.

EXEC SQL.

SELECT *

INTO :zglhrmm_trans_v

FROM zglhrmm_trans_v

WHERE trans_num = :trans_num

AND UPPER(in_val_01) = :zinVAL01

ENDEXEC.

Points will be rewarded .

Thanks.

[venkateswaran_k]

You have to have an internal table defined say IT_ZGLHRMM_TRANS

DATA  : IT_ZGLHRMM_TRANS TYPE zglhrmm_trans_v

DATA   lv_zinVAL01, lv_trans_num ......

SELECT *

    FROM zglhrmm_trans_v

    INTO CORRESPONDING FIELDS OF TABLE IT_ZGLHRMM_TRANS

    WHERE

    trans_num = lv_trans_num

   AND UPPER(in_val_01) = lv_zinVAL01

Regards,

Venkat

[Former Member]

Thanks Venkat. I appreciate your response. It helped me fix the code.