工作生活与爱好

工作中的记录; 生活中的记忆; 业余爱好的记载。

2007-02-02

 

SAP BOM的读取逻辑

1 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

Comments: 发表评论



<< Home

Archives

1990年1月15日   2007年1月14日   2007年1月15日   2007年1月16日   2007年1月17日   2007年1月18日   2007年1月19日   2007年1月20日   2007年1月22日   2007年1月23日   2007年1月24日   2007年1月25日   2007年1月26日   2007年1月27日   2007年1月29日   2007年1月30日   2007年1月31日   2007年2月1日   2007年2月2日   2007年2月3日   2007年3月13日   2007年5月15日   2007年5月16日   2007年6月2日  

This page is powered by Blogger. Isn't yours?