執(zhí)行如下report，輸入要查詢的settype id:

REPORT ZPROD_SETTYPE_WHERE_USED.PARAMETERS: id TYPE comc_settype-frgtype_id OBLIGATORY DEFAULT 'COM_TA_R3_ID'.START-OF-SELECTION. DATA: lv_guid TYPE comc_settype-frgtype_guid, lt_cat TYPE STANDARD TABLE OF COMM_CATFRGR-category_guid, lt_catt TYPE STANDARD TABLE OF comm_category-category_id. SELECT SINGLE frgtype_guid INTO lv_guid FROM comc_settype WHERE frgtype_id = id.IF sy-subrc <> 0. WRITE: / 'settype id invalid. '. RETURN. ENDIF.SELECT category_guid INTO TABLE lt_cat FROM COMM_CATFRGR WHERE frgtype_guid = lv_guid. IF sy-subrc <> 0. WRITE: / 'no category has contained this settype.'. RETURN. ENDIF.SORT lt_cat. DELETE ADJACENT DUPLICATES FROM lt_cat.SELECT category_id INTO TABLE lt_catt FROM comm_category FOR ALL ENTRIES IN lt_cat WHERE category_guid = lt_cat-table_line.LOOP AT lt_catt ASSIGNING FIELD-SYMBOL(<ID>). WRITE: / <id> COLOR COL_NEGATIVE. ENDLOOP.

輸出所有包含該settype的product category:

除了OBJ_0401外，還有4個(gè)category里包含了這個(gè)settype，需要從這些category里手動(dòng)刪除。

從其他product category里刪除settype時(shí)，又報(bào)已經(jīng)存在基于這些settype的product了，需要先刪除這些product。

例如希望得到所有基于product category MAT_JERR創(chuàng)建的product list:

輸出product ID和創(chuàng)建時(shí)間:

REPORT PROD_LIST_CREATED_BY_CATEGORY.PARAMETERS: id TYPE COMM_CAtegory-category_id OBLIGATORY DEFAULT 'MAT_JERR'.START-OF-SELECTION. DATA: lv_guid TYPE comm_category-category_guid, lt_guid TYPE STANDARD TABLE OF COMM_PRODUCT-product_guid, lt_prod TYPE STANDARD TABLE OF comm_product.SELECT SINGLE category_guid FROM comm_category INTO lv_guid WHERE category_id = id. IF sy-subrc <> 0. WRITE: / 'category id not valid.'. RETURN. ENDIF.SELECT product_guid INTO TABLE lt_guid FROM COMM_PRPRDCATR WHERE category_guid = lv_guid. IF sy-subrc <> 0. WRITE: / 'no product exists which are created based on current category.'. RETURN. ENDIF.SELECT * INTO TABLE lt_prod FROM COmm_product FOR ALL ENTRIES IN lt_guid WHERE product_guid = lt_guid-table_line. SORT lt_prod BY product_id. LOOP AT lt_prod ASSIGNING FIELD-SYMBOL(<prod>). WRITE: / <prod>-product_id COLOR COL_NEGATIVE, 'Created on: ' , <prod>-valid_from. ENDLOOP.

根據(jù)report輸出將這些product 一個(gè)一個(gè)刪除。
要獲取更多Jerry的原創(chuàng)文章，請(qǐng)關(guān)注公眾號(hào)"汪子熙":

總結(jié)

以上是生活随笔為你收集整理的settype where used list - set type where use list - equipment download environme的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。