kst001+kst002 = 材料成本 + 委外费用
kst006 = 标准人工
EXEC SQL .
select TRM,cm from (
SELECT
( (kst001+kst002) / LOSGR ) AS TRM,( kst006 / LOSGR )AS cm
from keph A
inner join keko B
on
A.MANDT = B.MANDT
AND A.BZOBJ = B.BZOBJ
AND A.KALNR = B.KALNR
AND A.KALKA = B.KALKA
AND A.KADKY = B.KADKY
AND A.TVERS = B.TVERS
AND A.BWVAR = B.BWVAR
AND A.KKZMA = B.KKZMA
where B.matnr = :IT_SHOW-ARTNR
and B.feh_sta = 'FR'
AND a.KKZST <> 'X'
order by A.kadky desc
) c
into :it_show-trm
,:it_show-cm
WHERE ROWNUM = 1
ENDEXEC.