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: 

What & when to use this TABLES: *ZMTO02

Former Member
0 Kudos

Guys

What is this & when to use this type of declaration with * in table statement ...

TABLES: *ZMTO02 ?

Regards

Jaman

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi,

you can use this statement(TABLES: *ZMTO02) for declaring additional table work area ,whose data type is same as of structured data type of ZMTO02.

The additional table work area can be used like the normal table work area. This applies in particular to obsolete short forms(select,insert,delete,modify,update) of Open SQL statements

ex:

1)TABLES: scarr, *scarr.

SELECT SINGLE *

FROM scarr

WHERE carrid = 'LH'.

SELECT SINGLE *

FROM *scarr

WHERE carrid = 'UA'.

2)INSERT dbtab FROM *dbtab

3)UPDATE dbtab FROM *dbtab .

reward points if useful...

1 REPLY 1

Former Member
0 Kudos

Hi,

you can use this statement(TABLES: *ZMTO02) for declaring additional table work area ,whose data type is same as of structured data type of ZMTO02.

The additional table work area can be used like the normal table work area. This applies in particular to obsolete short forms(select,insert,delete,modify,update) of Open SQL statements

ex:

1)TABLES: scarr, *scarr.

SELECT SINGLE *

FROM scarr

WHERE carrid = 'LH'.

SELECT SINGLE *

FROM *scarr

WHERE carrid = 'UA'.

2)INSERT dbtab FROM *dbtab

3)UPDATE dbtab FROM *dbtab .

reward points if useful...