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

最新推荐文章于 2025-03-17 21:25:55 发布

原创最新推荐文章于 2025-03-17 21:25:55 发布 · 1.6k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#大数据

SAP 专栏收录该内容

4 篇文章

订阅专栏

这两段SQL查询用于获取SAP系统中特定期间（2022年）初始库存数量的详细信息，包括物料编号、日期、操作类型和库存金额等。第二段进一步筛选出库存数量大于0的物料清单。

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