problem with a *

[Former Member]

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

[Former Member]

Hi,

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

[Former Member]

Select *

implies, <b>select all the records from the database table.</b>

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

Regards,

Pavan P.

[Former Member]

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

REPORT ychatest.

TABLES : mara , <b>*mara.</b>

DATA : itab TYPE TABLE OF mara.

SELECT * FROM mara INTO TABLE itab

WHERE matnr = <b>*mara-matnr.</b>

[Former Member]

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

[Former Member]

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?

[Former Member]

<b>have you checked my solution,</b>

• 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..

[Former Member]

thanks a lot