Application Development and Automation 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: 
Read only

*table name mean

Former Member
0 Likes
791

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
Read only

Former Member
0 Likes
745

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
Read only

Former Member
0 Likes
745

Hi,

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

regards,

Santosh Thorat

Read only

former_member386202
Active Contributor
0 Likes
745

Hi,

Its a Internal Table name

Regards,

Prashant

Read only

Former Member
0 Likes
746

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.

Read only

Former Member
0 Likes
745

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.