arron99

saper

  博客中心 :: 首页 :: 新随笔 :: 联系 :: 聚合  :: 登录 ::
  515 随笔 :: 0 文章 :: 235 评论 :: 0 Trackbacks
Cached @ 2025/4/26 17:36:18Control ASP.skins_cogitation_controls_blogstats_ascx
<2006年11月>
2930311234
567891011
12131415161718
19202122232425
262728293012
3456789

留言簿(2)

随笔档案

文章档案

搜索

最新评论

阅读排行榜

评论排行榜

Cached @ 2025/4/26 17:36:18Control ASP.skins_cogitation_controls_singlecolumn_ascx
 Search Material, Plant and Material Description.
Read the material number, plant and material description from join of MARA, MARC and MAKT using the following conditions:

Material Number (MARA-MATNR) in input material (select-options) and
Plant (MARC-WERKS) in input plant (select-options) and
Material type (MARA-MTART) in input material type (select-options).
Note: Proceeding to Step 2 or 3 or 4 depends on the input radio button for Production or Engineering or ALL BOM option.

2. Search for BOM – Engineering.
BOM link search from MAST -
Select material numbers and BOM link from MAST based on the material numbers selected above using the following conditions:
Material (MAST-MATNR) = Materials selected above and
Plant (MAST–WERKS) = As in input and
BOM usage (MAST-STLAN) = 2 (Engineering usage).
Read BOM Header and Item.
Read BOM Header details as per data mapping (Section 5.2) from table STKO using the
conditions:
BOM Number (STKO-STLNR) = BOM number got in previous step and
BOM alternative (STKO-STLAL) = BOM alternative got in previous step.

Read Item details as per data mapping from STOP using the conditions :
BOM number (STOP-STLNR) = STKO-STNLR.
Read BOM text from table STZU.

3. Search BOM – Production.
BOM link search from MAST -
Select material numbers and BOM link from MAST based on the material numbers selected above using the following conditions:
Material (MAST-MATNR) = Materials selected above and
Plant (MAST–WERKS) = As in input and
BOM usage (MAST-STLAN) = 1 (Production usage).

Read BOM Header and Item.
Read BOM Header details as per data mapping (Section 5.2) from table STKO using the
conditions:
BOM Number (STKO-STLNR) = BOM number got in previous step and
BOM alternative (STKO-STLAL) = BOM alternative got in previous step.

Read Item details as per data mapping (Section 5.2) from table STOP using the
conditions:
BOM number (STOP-STLNR) = STKO-STNLR.
Read BOM text from table STZU.

Search for Resource / Production Version (Production BOM’s only)

Read Production Version and Resource as per data mapping (Section 5.2) from table MKAL using the conditions:
Material number (MKAL–MATNR) = Material number from above selection (MAST) And
Plant (MKAL–WERKS) = Plant from above selection (MAST)
And
Alternative BOM (MKAL-STLAL) = Alternative BOM from above selection (MAST)
And
BOM Usage (MKAL-STLAN) = 1 (Production BOM).

Note:
1. If no production version exists for any of the BOM’s write such records at the bottom of the report under the heading “No Production Version Exists (Production BOM’s)”.
2. Sort the output on Plant, Usage and then on Material.
3. If multiple plants then the report will be displayed Plant wise.

• Header to be displayed for Production / Engineering BOM option.

4. Material BOM Comparison.
Search for BOM’s
BOM link search from MAST -
Select material numbers and BOM link from MAST based on the material numbers selected above using the following conditions:
Material (MAST-MATNR) = Materials selected above and
Plant (MAST–WERKS) = As in input.

Read BOM Header’s
Read BOM Header details as per data mapping (Section 5.2) from table STKO using the
conditions:
BOM Number (STKO-STLNR) = BOM number got in previous step and
BOM alternative (STKO-STLAL) = BOM alternative got in previous step.

Read Item details as per data mapping from STPO using the conditions:
BOM number (STPO-STLNR) = STKO-STNLR.

相关表列表:
MAST Material BOM
STKO BOM Header
STPO BOM Positions (detail)
MAPL Assignment fo Task Lists to Materials
PLKO Routing Group Header
PLSO Routing Group Sequence
PLPO Routing Group Operations
AFKO Production Order Header
AFPO Production Order Position (details)

可用函数
CSAP_MAT_BOM_READ

分享按钮发布于: 2006-11-22 10:30 arron99 阅读(771) 评论(0)  编辑 收藏

评论

标题
姓名
主页
内容 
  登录  使用高级评论  Top 订阅回复  取消订阅
[使用Ctrl+Enter键可以直接提交]