使用中间件从ERP下载SAP sales BOM到CRM

    技术2022-08-01  71

    Created by Jerry Wang, last modified on Oct 01, 2016

    In ERP, create a sales BOM via tcode CS01, BOM type choose 5 - Sales BOM

    For BOM header, choose material 1419. Maintain two component material 1421 and 1422, save the BOM.

    From table MAST you can find the BOM id from field STLAN: 2974

    In CRM, create a download request by specifying filter id = BOM id 2974 found in previous step:

    After this BOM is downloaded to CRM, you open parent product 1419 and could find its two components in assignment block “Set Components”.

    Via tcode SMW01, you can find detail data being downloaded from ERP:

    This information is also available in another CRM table:

    You can execute report COM_BOM_DELETE_ALL to clear all the existing BOM data from CRM and then do a fresh initial load of object BOM. Please note that in order to execute the above report you need to register first in table COMC_PR_TOOL_REG.Also,once this report is executed please cross check in the below tables for no records.

    CRMM_PR_MASTCOMM_IL_STRSETCOMM_IL_STRDISCOMM_IL_STRPRP And then perform the fresh initial load.

    要获取更多Jerry的原创文章,请关注公众号"汪子熙":

    汪子熙 认证博客专家 前端框架 Node.js SAP JerryWang,2007年从电子科技大学计算机专业硕士毕业后加入SAP成都研究院工作至今。Jerry是SAP社区导师,SAP中国技术大使。2020年5月下旬,Jerry做了脑部肿瘤的开颅切除手术,对编程和人生又有了新的感悟。
    Processed: 0.010, SQL: 9