BOM 展开

一. SAP BOM读取逻辑

1.查找Material,Plant,Material Desc Table:MARA,MARC,MAKT

MARA-MATNR MARC-WERKS MARA-MTART（Material type）

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. Table:MAST

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 from table STKO。

BOM Number (STKO-STLNR) = BOM number got in previous step and

BOM alternative (STKO-STLAL) = BOM alternative got in previous step.

Read BOM Item details from STOP.

BOM number (STOP-STLNR) = STKO-STNLR.

Read BOM text from table STZU.

3. Search BOM – Production. Table:MAST

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 from table STKO。

BOM Number (STKO-STLNR) = BOM number got in previous step and

BOM alternative (STKO-STLAL) = BOM alternative got in previous step.

Read BOM Item details from STOP.

BOM number (STOP-STLNR) = STKO-STNLR.

Read BOM text from table STZU.

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

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. MAST

Material (MAST-MATNR) = Materials selected above and

Plant (MAST–WERKS) = As in input.

● Read BOM Header and Item

Read BOM Header from tableSTKO。

BOM Number (STKO-STLNR) = BOM number got in previous step and

BOM alternative (STKO-STLAL) = BOM alternative got in previous step.

Read BOM Item details fromSTOP.

BOM number (STOP-STLNR) = STKO-STNLR.

二、BOM逆向和正向查询

1.顺查BOM（CS12）

CALL FUNCTION 'CS_BOM_EXPL_MAT_V2'

EXPORTING

capid = pm_capid “应用程序一般为PP01

datuv = pm_datuv “通常为系统的当前日期

mtnrv = pm_mtnrv “要展开BOM的物料

mehrs = 'X' “ x表示多层展开﹐space表示只展开第一层

werks = pm_werks “通常为1000

IMPORTING

topmat = selpool

dstst = dstst_flg

TABLES

stb = stb “展开的BOM存放在该内表

matcat = matcat “下面含有元件的物料存放在该内表

2.逆查BOM

DATA: IT_WULTB LIKE STPOV OCCURS 0 WITH HEADER LINE,

IT_EQUICAT LIKE CSCEQUI OCCURS 0 WITH HEADER LINE,

IT_KNDCAT LIKE CSCKND OCCURS 0 WITH HEADER LINE,

IT_MATCAT LIKE CSCMAT OCCURS 0 WITH HEADER LINE,

IT_STDCAT LIKE CSCSTD OCCURS 0 WITH HEADER LINE,

IT_TPLCAT LIKE CSCTPL OCCURS 0 WITH HEADER LINE,

IT_PRJCAT LIKE CSCPRJ OCCURS 0 WITH HEADER LINE.

CLEAR:IT_WULTB,IT_WULTB[].

CALL FUNCTION 'CS_WHERE_USED_MAT'

EXPORTING

DATUB = SY-DATUM

DATUV = SY-DATUM

MATNR = P_C_MATNR

* POSTP = ' '

* RETCODE_ONLY = ' '

* STLAN = ' '

MCLMT = '00000000'

WERKS = S2_WERKS

* IMPORTING

* TOPMAT =

TABLES

WULTB = IT_WULTB

EQUICAT = IT_EQUICAT

KNDCAT = IT_KNDCAT

MATCAT = IT_MATCAT

STDCAT = IT_STDCAT

TPLCAT = IT_TPLCAT

EXCEPTIONS

CALL_INVALID = 1

MATERIAL_NOT_FOUND = 2

NO_WHERE_USED_REC_FOUND = 3

NO_WHERE_USED_REC_SELECTED = 4

NO_WHERE_USED_REC_VALID = 5

OTHERS = 6.

T-Code：CS02，确保递归BOM的比例在0.95左右。即：产品A，其BOM中的A的消耗量应该小于0.95。