`
Jack Wu
  • 浏览: 867197 次
  • 来自: ...
社区版块
存档分类
最新评论

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

来自:https://www.sdn.sap.com/irj/sdn/thread?forumID=50&threadID=75996



分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics