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