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..