query

[Former Member]

hello gurus,

i am using two tables EKKO EKPO FOR PRICE VARIANCE

suppose in a particular date there are five PO ARE created i have to fetch the latest PO from the data base in ascending order and i have to show the price variance also for the particular period .

but my problem is that i have to fetch data thru date wise not FROM -TO IT IS VICE -VERSA TO -FROM PLZ HELP ME OUT FROM THIS PROBLEM....

[Former Member]

hello gurus,

i am using two tables EKKO EKPO FOR PRICE VARIANCE

suppose in a particular date there are five PO ARE created i have to fetch the latest PO from the data base in ascending order and i have to show the price variance also for the particular period .

but my problem is that i have to fetch data thru date wise not FROM -TO IT IS VICE -VERSA TO -FROM PLZ HELP ME OUT FROM THIS PROBLEM....

[former_member404244]

Hi try like this

SELECT ebeln FROM ekko into it_ebeln WHERE date in s_date

ORDER BY ebeln DESCENDING.

Regards,

nagaraj

[Former Member]

This is a simple way to do it.

Retrieve the record according to the specified date and include the purch. doc. (EKKO-EBELN) in your selection

Then sort your itab descending. Out from the result in your itab, you can now do any processing as you wish.

[Former Member]

hi,

SELECT ebeln FROM ekko into it_ebeln WHERE date in s_date and sy-uzeit = p_time

ORDER BY ebeln DESCENDING.

if helpful reward some points.

with regards,

Suresh Aluri.