Doubt on an query.

[Former Member]

Hello Gurus,

I was going through SAPScript driver program RFKORD10_TE and found a query as follows:

Can someone tell me as what is the meaning of following, I mean what does *t001 in following query ?

select single * from t001 into *t001

where bukrs = havico-bukrs.

[Former Member]

I beleive its header area... i mean it's workarea

[RichHeilman]

That's right. *t001 is a work area. The older way of creating or declaring a work area is to use the * in front of the table name.

Tables:  t001,
        *t001.

The newer way of doing this is.....

data: wa_t001 type t001.

You still will find this type of coding in older programs. Just remember that it is no different than a regular work area and it takes is structure from the table name .

Regards,

Rich Heilman

[laxmanakumar_appana]

Hi,

select single * from t001 into *t001

where bukrs = havico-bukrs.

*t001 : system will create the work area for the table t001.

now , selected single row contents will be stored to t001 table work area.

after this select , you can use the selected table contents like

(t001-fieldname ) returns the contents of the selected column value.

Regards

Laxman