topic Re: *table name mean in Application Development and Automation Discussions

*table name mean

Former Member — Fri, 28 Dec 2007 05:22:16 GMT

SELECT SINGLE * FROM STXH INTO *STXH

WHERE TDOBJECT = TEXTS-DESTOBJECT

AND TDNAME = TEXTS-DESTNAME

AND TDID = TEXTS-DESTID

AND TDSPRAS = TEXTS-DESTLANG.

please help on code *stxh means

Re: *table name mean

Former Member — Fri, 28 Dec 2007 05:28:52 GMT

Hi,

*STXH means that its a work area. one record is getting stored in *STXH.

regards,

Santosh Thorat

Re: *table name mean

former_member386202 — Fri, 28 Dec 2007 05:31:08 GMT

Hi,

Its a Internal Table name

Regards,

Prashant

Re: *table name mean

Former Member — Fri, 28 Dec 2007 05:32:58 GMT

hi anil,

SELECT SINGLE * FROM STXH INTO *STXH

The above statement describes that --> selecting all the records of a particular row depending upon the where condition and these values are stored in all the tables which contain tha table names as *stxh.

For eg... let there are two tables abcSTXH and xyzSTXH

So, as said earlier all the data selected from the STXH table are stored in these two tables

abcSTXH and xyzSTXH. (here abc & xyz are replaced for *).

Reward if helpful.

Thank you,

Regards.

Re: *table name mean

Former Member — Fri, 28 Dec 2007 05:39:25 GMT

Hi,

We know that whenever TABLES statement is used, it creates a workarea for the given table.

In the same way, if we want to create one more workarea for the same table using Tables statement, we can create by using *.

Check this sample code.

TABLES : MARA,

*MARA.

SELECT-OPTIONS : S_MATNR FOR *MARA-MATNR.

SELECT *

FROM MARA

INTO *MARA

WHERE MATNR EQ '000000000000000080'.

WRITE 😕 *MARA-MATNR.

ENDSELECT.

Regards

Sailaja.