Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

*table name mean

anil_kumar98
Participant
0 Kudos
92

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos
46

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.

4 REPLIES 4

Former Member
0 Kudos
46

Hi,

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

regards,

Santosh Thorat

former_member386202
Active Contributor
0 Kudos
46

Hi,

Its a Internal Table name

Regards,

Prashant

Former Member
0 Kudos
47

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.

Former Member
0 Kudos
46

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.