Application Development and Automation 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
Showing results for 
Search instead for 
Did you mean: 
Read only

current version of document

Former Member
0 Likes
343

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
Read only

Former Member
0 Likes
317

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.