Skip to Content
0
Former Member
May 13, 2013 at 06:40 AM

plz solve my problem

163 Views

hi frnds

we need to develop a report on PO release time lines.

Internal table: t_cdpos(OBJECTID FNAME CHANGENR VALUE_NEW VALUE_OLD).

After select stmt, get these values.


Row OBJECTID FNAME CHANGENR VALUE_NEW VALUE_OLD 1 1000003 FRGZU 637324 XX X 2 1000003 FRGZU 637323 X 3 1000003 FRGZU 637322 XX 4 1000003 FRGZU 637302 XX X 5 1000003 FRGZU 637301 X 6 1000003 FRGZU 637300 XX 7 1000003 FRGZU 637299 XX X 8 1000003 FRGZU 637298 X XX 9 1000003 FRGZU 637224 XX 10 1000004 FRGZU 637223 X 11 1000004 FRGZU 637225 X 12 1000004 FRGZU 637226 X 13 1000004 FRGZU 637227 XX X 14 1000007 FRGZU 637236 X 15 1000007 FRGZU 637237 XX X 16 1000007 FRGZU 637238 XXX XX 17 1000007 FRGZU 637239 XX XXX 18 1000007 FRGZU 637240 XXX XX 19 1000007 FRGZU 637241 XXXX XXX

The no. of ‘X’ denotes the release against the levels of approvers found earlier. From this, the highest change doc num against each value of ‘X’, ‘XX’, ‘XXX’

i want to only for this below values.

Row OBJECTID FNAME CHANGENR VALUE_NEW VALUE_OLD 1 1000003 FRGZU 637324 XX X 2 1000003 FRGZU 637323 X 12 1000004 FRGZU 637226 X 13 1000004 FRGZU 637227 XX X 14 1000007 FRGZU 637236 X 15 1000007 FRGZU 637237 XX X 18 1000007 FRGZU 637240 XXX XX 19 1000007 FRGZU 637241 XXXX XXX

frnds how i can get the our requirement. any one plz help me that.