topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Thu, 06 Dec 2007 11:12:30 GMT

one select i.e

select single vbeln

from *vbfa

into *vbfa-vbeln

where vbelv = lk_likp-vbeln

and vbtyp_n = gc_8.

This is the select, i dont know *vbfa that to its not the table or any structure

but it doesnot showing any error and syntax errors also.

Former Member — Thu, 06 Dec 2007 11:16:04 GMT

Hi Pallavi,

Good!

thanks,

Sunil

Former Member — Thu, 06 Dec 2007 11:17:38 GMT

Hi Pallavi,

I tried this and it shows error "*vbfa-vbeln is unknown".

Regards,

Pankaj

Former Member — Thu, 06 Dec 2007 11:21:52 GMT

Hi,

It is generic select statement.....

thanks and regards

Rajib

former_member188827 — Thu, 06 Dec 2007 11:24:41 GMT

try da following code

tables:vbfa, *vbfa.

select single * from vbfa into *vbfa where vbeln = '1234'.

*vbfa-vbeln = '234'.

WRITE / *vbfa-vbeln.

former_member188827 — Thu, 06 Dec 2007 11:26:16 GMT

using *vbfa in tables statement declares a structure dat is identical to structure of vbfa...

plz reward points if dis helps

Former Member — Thu, 06 Dec 2007 11:28:25 GMT

Hi Pallavi,

I tried this and it shows error "*vbfa is unknown".If u give the complete code then we can suggest.

Regards,

Aditya.