0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

找出某个Plant里面的成品

Posted at

使用到的表:
表 说明
MARC 物料主数据(按工厂层次),比如库存管理、采购、MRP参数是按工厂保存的。
MARA 物料主数据(全公司层次),比如物料的基本信息、物料类型(品目タイプ)在这里。

具体步骤:
第一步:在MARC中,找出A201工厂存在的所有物料。
到MARA中,**进一步筛选这些物料中,物料类型是ZIFG(制品)**的物料。

具体操作
1.在marc上筛选出plant=A201的物料,download下来。
image.png
下载下来的excel
image.png

第二步:用刚刚down下来的品目,在mara表中检索品目type=ZIFG(成品)的数据。
点击这个符号
image.png
在刚刚下载的excel中复制一整列
image.png
将这一整列粘贴在MARA的品目里,点击「データ転送」
image.png
现时点的检索条件(品目,品目type)
image.png
image.png
点击执行,最后检索出来的就是在Plant里面的成品。
image.png

0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?