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: 

current version of document

Former Member

‎04-26-2007 10:49 AM

0 Kudos

hi all,

i have document number for which i have doc typ, doc vesion, docu par

i have doc type 2 character

doc version is in ranage p1, p2,......p9 then 00, 01, 02,.....99

docu part 000, 001,....999.

here i have to bring latest version.

i have to print doc type, doc num, version, part.

to bring latest i have to check for particular doc type i have to check docu part 000,

001,...999 which is the higest i have to pick and at the same time i have check for vesion which start from p1 ,...p9, 00....99 i have to pick the highest.

see here document number will be same for all .

with regards

1 REPLY 1

Former Member

‎04-26-2007 11:02 AM

0 Kudos

Hi..

if it is from dbtable..

select * from dbtab into itab.

sort itab desccending by version.

read the first record which is ur required record.