topic Re: Doubt on an query. in Application Development and Automation Discussions

Doubt on an query.

Former Member — Fri, 07 Jul 2006 20:24:57 GMT

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.

Re: Doubt on an query.

Former Member — Fri, 07 Jul 2006 20:26:45 GMT

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

Re: Doubt on an query.

Laxmana_Appana_ — Fri, 07 Jul 2006 20:29:44 GMT

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

Re: Doubt on an query.

RichHeilman — Fri, 07 Jul 2006 20:29:58 GMT

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