*t001 in select statement

[Former Member]

hi,

select * from *t001 into itab..

what is the purpose of using *t001...

[Former Member]

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

VJ

[Former Member]

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

this type of coding was used in old version.

[Former Member]

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.

[Former Member]

hi Sumi,

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

[Former Member]

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.

[Former Member]

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,

HR

[Former Member]

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

[laxmanakumar_appana]

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

[vimal_kumar4]

Hi,

I tried like this.

Report y_test.

tables: *t001.

select single * from t001 into *t001.

write: *t001-bukrs,

*t001-butxt.

Regards

Vimal Kumar