
取数逻辑
SELECT stprs INTO lv_lplpr
FROM keko
JOIN ckmlcr ON ckmlcr~kalnr = keko~kalnr AND ckmlcr~bdatj = keko~bdatj AND ckmlcr~poper = keko~poper
WHERE keko~matnr = im_ekpo-matnr AND keko~werks = im_ekpo-werks AND ckmlcr~curtp = 10 AND stprs > 0 AND keko~bwvar = 'Z01' AND keko~klvar = 'ZPC1'
======================================================================================
以上法定
SELECT stprs INTO lv_lplpr
FROM keko
JOIN ckmlcr ON ckmlcr~kalnr = keko~kalnr AND ckmlcr~bdatj = keko~bdatj AND ckmlcr~poper = keko~poper
WHERE keko~matnr = im_ekpo-matnr AND keko~werks = im_ekko-lifnr AND ckmlcr~curtp = 31 AND stprs > 0 AND keko~bwvar = 'Z01' AND keko~klvar = 'ZPC2'
=======================================================================================
以上集团
10是法定 31是集团评估

567

被折叠的 条评论
为什么被折叠?



