topic query in Application Development and Automation Discussions

query

Former Member — Mon, 01 Oct 2007 09:12:46 GMT

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....

Re: query

former_member404244 — Mon, 01 Oct 2007 09:17:07 GMT

Hi try like this

SELECT ebeln FROM ekko into it_ebeln WHERE date in s_date

ORDER BY ebeln DESCENDING.

Regards,

nagaraj

Re: query

Former Member — Mon, 01 Oct 2007 09:17:33 GMT

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.

Re: query

Former Member — Mon, 01 Oct 2007 09:26:36 GMT

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.