hi experts select statment

[Former Member]

select matnr netpr aedat from ekpo INTO table IT_EKPO where matnr = BOM-idnrk

for this 11 records are coming to internal table, for this i need latest date price,

how to take that .

can u guide me.

[Former Member]

select matnr netpr aedat from ekpo INTO table IT_EKPO where matnr = BOM-idnrk

for this 11 records are coming to internal table, for this i need latest date price,

how to take that .

can u guide me.

[Former Member]

Hi use this

select matnr netpr aedat

from ekpo

up to 1 rows

INTO table IT_EKPO

where matnr = BOM-idnrk

order by aedat decending.

Here u will get last price

Regards

Srimanta

[Former Member]

Hi,

Sort your internal table descending order..then read the internal table at index 1.

sort itab descending by aedat.

read table itab index 1.

Arunima

[Former Member]

Hi,

use like this:

select matnr netpr aedat upto 1 rows from ekpo INTO table IT_EKPO where matnr = BOM-idnrk

order by aedat descending.

[Former Member]

Hi,

You can do as below:

Once IT_EKPO is filled up with the data. Use the code below :

SORT IT_EKPO BY aedat.

READ TABLE IT_EKPO INDEX 1.

WRITE : IT_EKPO.

Thanks,

Sriram POnna.

[Former Member]

hi,

If you want latest date or hight price the you can write select statement

select matnr

max( netpr )

aedat from ekpo INTO ekpo where matnr = BOM-idnrk

this may solve your problem.

Thanks & regards