Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
Showing results for 
Search instead for 
Did you mean: 

fetch the record based on older ERDAT field

Former Member
0 Kudos

Hi ,

In KNA1 table select query could get many records, in that i need to fetch the record with older ERDAT field.

please can you help me achieve this?



Moderator message: very basic, please search for information and try this yourself first.

Message was edited by: Thomas Zloch


Active Contributor
0 Kudos

hi Kannan,

In where part of select you can add restriction for ERDAT or sort internal table by Ascending ERDAT and then dispaly or  in final dispaly screeen if it is ALV yoy can sort by ERDAT