2012 Jun 04 8:42 PM
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.
2012 Jun 04 8:48 PM
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
2012 Jun 04 8:48 PM
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
2012 Jun 06 8:06 AM