topic Open SQL for ABAP and MS SQL equivalent code. in Application Development and Automation Discussions

Open SQL for ABAP and MS SQL equivalent code.

Former Member — Mon, 04 Jun 2012 19:42:35 GMT

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 — Mon, 04 Jun 2012 19:48:53 GMT

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 — Wed, 06 Jun 2012 07:06:54 GMT

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