topic Re: problem with a * in Application Development and Automation Discussions

problem with a *

Former Member — Wed, 04 Jul 2007 13:10:45 GMT

Hallo,

does anbody know what following "*"-construct may mean?

SELECT * FROM tableA INTO itag

WHERE kokrs = *zckstsapmzb21-kokrs

AND lstar = *zckstsapmzb21-lstar...

Is the * an element of the operator?

Thx,

Marcel

Re: problem with a *

Former Member — Wed, 04 Jul 2007 13:12:46 GMT

Hi,

when u r specifying SELECT * FROM tableA , u r selecting all the fields from that particular table.

Re: problem with a *

Former Member — Wed, 04 Jul 2007 13:13:51 GMT

Select *

implies, select all the records from the database table.

However we shouldn't have any '*' operator in the where condition.

Regards,

Pavan P.

Re: problem with a *

Former Member — Wed, 04 Jul 2007 13:14:12 GMT

in front of table corresponds to work area, chk this code

REPORT ychatest.

TABLES : mara , *mara.

DATA : itab TYPE TABLE OF mara.

SELECT * FROM mara INTO TABLE itab

WHERE matnr = *mara-matnr.

Re: problem with a *

Former Member — Wed, 04 Jul 2007 13:21:13 GMT

SELECT * FROM tableA INTO itag   ->  "  * points all fields in the table
WHERE kokrs = *zckstsapmzb21-kokrs   " but  here *  is  not valid operator
AND lstar = *zckstsapmzb21-lstar...

reward points if it is usefull

Girish

Re: problem with a *

Former Member — Wed, 04 Jul 2007 13:37:35 GMT

thx,

i mean the * at the front of a table/variable etc. Not the * in the selct clause.

we have some programs with such * and they are correct. syntax-check is okay.

anybody an idea?

Re: problem with a *

Former Member — Wed, 04 Jul 2007 13:44:47 GMT

have you checked my solution,

in front of a struture represents a structure(Work area) in old versions , it is obsolete now..

so they are checking the value from that work area..

Re: problem with a *

Former Member — Wed, 04 Jul 2007 13:56:41 GMT

thanks a lot