SAP查询当前期间初始库存数量

1.SAP查询当前期间初始库存数量

SELECT lhd~matnr AS matnr  lpp~bdatj AS bdatj  lpp~poper AS poper
       lhd~bwkey AS bwkey  lpp~abkumo AS abkumo
  FROM ckmlpp AS lpp
 INNER JOIN ckmlhd AS lhd
    ON lpp~kalnr = lhd~kalnr
 WHERE lhd~matnr = '000000001000000006' AND lpp~bdatj = '2022'
   AND lpp~poper = '7' AND bwkey = '8200'

 

2.SAP查询当前期间初始库存数量大于0的物料清单

SELECT lhd~matnr AS matnr  lpp~bdatj AS bdatj  lpp~poper AS poper
       lhd~vbeln AS vbeln  lhd~posnr AS posnr  lhd~bwkey AS bwkey
       lpp~abkumo AS abkumo
  FROM ckmlpp AS lpp
 INNER JOIN ckmlhd AS lhd
    ON lpp~kalnr = lhd~kalnr
 WHERE lpp~bdatj = '2022' AND lpp~poper = '7'
   AND bwkey = '8200' AND lpp~abkumo > 0