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.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Abap Query on most Latest Posting Date in G/L Account

Former Member

‎2007 Mar 21 5:53 AM

0 Kudos
139

Dear All

This is the new request that has come from the client. What they want to see is the G/L account and the most recent Posting Date. For eg Lets say that 220000 has 3 line items

1000 in march 06

2000 in april 06

3000 in may 06

End user wants to see Balance as 6000 and the most recent Posting date as may 06. If i Pull Accounting Doc # and Posting Date it will give me all the details and date which i dont really want. How do i do it ?

Please help me

Thanks

Sameer

1 REPLY 1

Former Member

‎2007 Mar 21 6:29 AM

0 Kudos
62

Hi,

what we can do is that get all the line items for a G/L account in an internal table. Sort it descending by date. Pick the first row's date and then simply sum up the quantities.

Hope this helps.

Regards,

Himanshu.