on 06-27-2007 7:59 AM
Dear Friends,
Please suggest how can we pass a variable working with Native SQL using a Select statement?
Regards,
Alok.
You can achieve this by typing ":" before the name of the ABAP variable likewise:
EXEC SQL.
SELECT ERNAM INTO :LV_ERNAM FROM MARA WHERE MATNR = :P_MATNR
ENDEXEC.
Where LV_ERNAME is a local variable which will recieve the data from the query and P_MATNR is a parameter which holds the material number before the query is executed.
Hope it helps,
Alex
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.