Skip to Content
0
Former Member
Dec 29, 2007 at 07:09 AM

Getting the MAX value in a field..

672 Views

hi,

SELECT

a~VBELN

a~POSNR

a~ARKTX

a~KWMENG

a~MEINS

a~NETPR

a~NETWR

b~CUMM_QUAN

b~PREVQUAN

b~RATE

b~PARTBILQUAN

b~PARTBILRATE

b~PROFINVNO

b~PROFINVDAT

b~INVNO

b~INVDAT

INTO CORRESPONDING FIELDS OF

TABLE T_BILLDETAIL

from VBAP as a

inner join

ZSD_CVL_PROF_DET as b on avbeln = bso_no

where avbeln = SAL and aposnr = bSO_Item and bversion = "Max value of b~version" .

how to get the Max value there i have mentioned...

Thank u..