2008 Feb 22 4:19 AM
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 * ?
2008 Feb 22 5:48 AM
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.
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 * ?
2008 Feb 22 4:23 AM
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..
2008 Feb 22 4:23 AM
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
2008 Feb 22 4:30 AM
Hi
*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
2008 Feb 22 5:48 AM
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.
| User | Count |
|---|---|
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |