Skip to Content
0
Former Member
Aug 16, 2007 at 05:48 PM

SAP Query - Selection to get only one record by date

50 Views

I am writing a query in which the infoset includes dates example would be material, plant, date, price. For a given material and plant, there will be multiple records in the infoset because the material can have a different price on a different date.

I want to choose the one record from the infoset that has a date closest to but less than or equal to a user entered date.

How do I do this.

Steven Engel