Skip to Content
0
Former Member
Dec 03, 2008 at 05:30 AM

Select Statement Doubt

48 Views

Moderator message: Please use meaningful subject in future

Hi,

I've a requirement that I need to get a record from EREV table for a Purchase Requisition no. based on Latest Version No. (REVNO. ) at a single shot.

I hav used the following code but i dint get desired values.

Select EDOKN

FGNAM

FGDAT

REVNO

from EREV into ls_erev

where edokn eq p_edokn and

revno eq (select Max(revno) from erev)).

Any body pl help me.

-Rajiv

Edited by: Vaddepati on Dec 3, 2008 11:01 AM

Edited by: Matt on Dec 3, 2008 10:03 AM