topic Re: *t001 in select statement in Application Development and Automation Discussions

*t001 in select statement

Former Member — Tue, 22 Aug 2006 10:01:22 GMT

hi,

select * from *t001 into itab..

what is the purpose of using *t001...

Re: *t001 in select statement

Former Member — Tue, 22 Aug 2006 10:08:08 GMT

Hi,

I think it should be

select Single * from t001 into *t001.

*t001 indicates a temp workarea. Many SAP program uses this way to store data during the program execution.

I dont think the other way as you have mentioned exists.

Cheers

Re: *t001 in select statement

Former Member — Tue, 22 Aug 2006 10:08:41 GMT

its means that u fetch value from the copy of table t001(image of table).

this type of coding was used in old version.

Re: *t001 in select statement

Former Member — Tue, 22 Aug 2006 10:10:17 GMT

Hai Sumi,

*T001 can be used as a <b>workarea</b>. In standard SAP programs, you can see similar work areas which is mainly used for screen texts.

Re: *t001 in select statement

Former Member — Tue, 22 Aug 2006 10:11:48 GMT

hi Sumi,

*t001 is a <b>workarea</b>..

Re: *t001 in select statement

Former Member — Tue, 22 Aug 2006 10:12:46 GMT

FROM *T001 has the same effect as FROM T001 when it is a select on single table as in :

SELECT * from *T001.

But when there is a join on 2 or more tables, you are selecting fields from different tables and writing them inot an internal table which contains all the fields selected.

In this case, the fields are written to the target area from left to right in the order in which the tables appear in the FROM clause, according to the structure of each table work area.

For more detailed explanation, hit F1 on FROM keyword in your ABAP program and read help with regards to JOIN statement.

Re: *t001 in select statement

Former Member — Tue, 22 Aug 2006 10:15:15 GMT

Hi,

In this case the data from table T001 is made available using the table workarea. The select has the same effect as the normal select statement while processing.

Regards,

Re: *t001 in select statement

Former Member — Tue, 22 Aug 2006 10:22:04 GMT

If it is a workarea then how to get records from this workarea

Re: *t001 in select statement

Laxmana_Appana_ — Tue, 22 Aug 2006 10:35:41 GMT

Hi,

it is a work area , you can get only one record with select statement .you can't get multiple records.

check this link for more details:

Regards

Appana

Re: *t001 in select statement

vimal_kumar4 — Tue, 22 Aug 2006 10:40:46 GMT

Hi,

I tried like this.

Report y_test.

tables: *t001.

select single * from t001 into *t001.

write: *t001-bukrs,

*t001-butxt.

Regards

Vimal Kumar