Skip to Content
0
Former Member
Dec 07, 2006 at 04:18 PM

get list with max no

111 Views

hi all,

I want to get max changenr from cdhdr for each and every object id . if i write for all entries iam getting an error . how can i get the list with max change number for each and every material?

SELECT * FROM CDPOS INTO TABLE T_CDPOS FOR ALL

ENTRIES IN T_ZWPBPH WHERE OBJECTCLAS ='MATERIAL'

AND OBJECTID = T_ZWPBPH-PBPINO AND FNAME = 'SPART'.

SELECT * FROM CDHDR INTO TABLE T_CDHDR FOR ALL

ENTRIES IN T_CDPOS WHERE OBJECTCLAS ='MATERIAL' AND

OBJECTID = T_CDPOS-OBJECTID AND CHANGENR = T_CDPOS-CHANGENR => this statement

Message was edited by:

priya katragadda