Hello KP,
Your second statement doesn't seem to me a Native SQL statement!! It's just another (lesser used) way of writing the first statement.
For example -
data itab type table of spfli.
and
data : itab type table of spfli.
are both equivalent statements. However, I'm sure that you agree that the colon operator is generally used whn multiple statements need to be <i>chained</i> together.
For example -
data : itab1 type table of spfli,
itab2 type table of sflight.
This is certainly the more preferred way of declaring data.
Similarly, in your case, you could actually have written something like -
data vs_vbelv type vbelv.
data vb_vbelv type vbelv.
data cvbfa type table of vbfa.
select *
appending table cvbfa
from vbfa
where vbelv = : vs_vbelv ,
vb_vbelv .
The SELECT statement above would otherwise have to be written as -
select *
appending table cvbfa
from vbfa
where vbelv = vs_vbelv.
select *
appending table cvbfa
from vbfa
where vbelv = vb_vbelv .
So instead of writing two different select statements, you write only one of them.
Hope that clears the doubt you had.
Regards,
Anand Mandalika.
Bluesky