topic *ekpo in Application Development and Automation Discussions

*ekpo

Former Member — Fri, 22 Feb 2008 04:19:29 GMT

HI,

I had seen some of the standard abap that the table name had *, like *ekpo. What is the meaning? What is the difference between with * and without * ?

Re: *ekpo

Former Member — Fri, 22 Feb 2008 04:23:29 GMT

hi,

Where u had seen ? .. i didnt see any of those like *ekpo..

if i type *ekpo in SE11 means it search for tables has patterns like '--ekpo' only..

Re: *ekpo

Former Member — Fri, 22 Feb 2008 04:23:31 GMT

Hi,

SAP follows some naming conventions to store the old value and the new value. * is one of it.

field (*) wil have the old value and the other will have the new value.

Regards,

Niyaz

Edited by: Niyaz Ahamed on Feb 22, 2008 9:54 AM

Re: *ekpo

Former Member — Fri, 22 Feb 2008 04:30:04 GMT

*TABLES table_wa

This statement declares an additional table work area *table_wa, whose data type, like that of normal TABLES statements of flat, structured data type table_wa, is copied from the ABAP Dictionary.

The additional table work area can be used like the normal table work area. This applies in particular to obsolete short forms of Open SQL statements.

Declaration of a normal and additional table work area and its use in obsolete short forms of the SELECT statement.

TABLES: scarr, *scarr.

SELECT SINGLE *

FROM scarr

WHERE carrid = 'LH'.

SELECT SINGLE *

FROM *scarr

WHERE carrid = 'UA'.

Thanks

Vijay

PLZ reward points if helpful

Re: *ekpo

Former Member — Fri, 22 Feb 2008 05:48:43 GMT

Hi,

It just lets you use the table a second time. For example:

select single * from ekpo where ebeln = '12345' and ebelp = '1'.

select single * from *ekpo where ebeln = '67890' and ebelp = '1'.

You now have two separate records, one in ekpo and one in *ekpo.

Another way to do this is to simply use the 'into' argument in the 'select' statement to read the second ekpo record into some other field. The '*' format can be confusing, I think it may be left over from earlier releases, like 2.2.

EKPO is database table and *EKPO is internal table.

Once you select into EKPO, you can use it the same way as *EKPO.

Reward Points if found helpfull..

Cheers,

Chandra Sekhar.