接到需求,要求显示工艺路线组的各个工作中心以及BOM组件
获取工作中心逻辑:
首先调用函数 CALL FUNCTION 'CARO_ROUTING_READ'
代码:
DATA:BEGIN OF LT_OPR_TAB OCCURS 0.
INCLUDE TYPE CAPP_OPR .
DATA: ARBPL TYPE crhd-ARBPL,
END OF LT_OPR_TAB.
CALL FUNCTION 'CARO_ROUTING_READ'
EXPORTING
PLNTY = 'N' "keko-plnty
PLNNR = lt_main-PLNNR "keko-plnnr 任务清单组码
PLNAL = lt_main-ALNAL "keko-plnal 组计数器
MATNR = lt_main-MATNR "keko-matnr 物料编号
DATE_FROM = '19000101'
TABLES
* TSK_TAB = T_TSK_TAB "
* SEQ_TAB = T_SEQ_TAB " 参加结构CAPP_SEQ定义
OPR_TAB = LT_OPR_TAB
* COM_TAB = T_COM_TAB
EXCEPTIONS
NOT_FOUND = 1
REF_NOT_EXP = 2
NOT_VALID = 3
OTHERS = 4.
然后根据表LT_OPR_TAB里的ARBID去表CRHD里找到对应的工作中心ARBPL
SELECT SINGLE ARBPL FROM CRHD INTO LT_OPR_TAB-ARBPL
WHERE CRHD~OBJID = LT_OPR_TAB-ARBID.
获取BOM组件逻辑:
SELECT
mast~matnr
mast~werks
mast~stlan
* mast~stlbez
stko~STLAL
stpo~idnrk
stpo~menge
stpo~meins
INTO CORRESPONDING FIELDS OF TABLE gt_result
FROM mast
INNER JOIN stko ON mast~STLNR = stko~STLNR AND stko~STLAL = mast~STLAL
INNER JOIN stas on stko~STLAL = stas~STLAL AND stko~STLNR = stas~STLNR
INNER JOIN stpo ON stko~STLNR = stpo~STLNR AND stpo~STLKN = stas~STLKN
WHERE mast~matnr = lt_main-matnr
AND mast~werks = lt_main-werks
AND mast~stlan = lt_main-stlan
AND mast~STLAL = lt_main-STLAL.
主要是涉及mast stko stop stas这四个表,之前就是因为漏了stas这个表导致总是取错,得到的字段IDNRK就是BOM组件的料号了。




