Skip to Content
avatar image
Former Member

Extract BOM from ERP

Dear All,

is there any way that I can extract BOM (from PP/PM module in ERP) to BW?

Is there any standard datasource (attr/hier) that I can extract directly to BW?

If there some different way to do this, can you share the steps ?

Thanks, Dirk

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 15, 2008 at 01:41 PM

    Hi

    You can use the following DS for PM

    0PM_DSMNTL

    0PM_OM_OPA_1

    0PM_OM_OPA_2

    0PM_OM_OPA_3

    0PM_PRM_PLCS_1

    2LIS_17_I0ACTY

    2LIS_17_I0CAUSE

    2LIS_17_I0ITEM

    2LIS_17_I0NOTIF

    2LIS_17_I0TASK

    2LIS_17_I3HDR

    2LIS_17_I3OPER

    For PP

    0PP_DOWNTIME

    0PP_WCCP

    2LIS_04_PEARBPL

    2LIS_04_PECOMP

    2LIS_04_PEMATNR

    2LIS_04_P_ARBPL

    2LIS_04_P_COMP

    2LIS_04_P_MATNR

    Regards,

    Chandu.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Start with get plants, then get data from MAST table and use the function module 'CSAP_MAT_BOM_READ' to get explode multi level BOM. You have to keep adjusting the dates from level 1 all the way down to reflect the valid from and valid to dates on ERP. You may want to delete all inactive data from STKO like where WHERE bom status NE '03'.

      Thanks,

      Anirudh.

      Edited by: Anirudh on Oct 17, 2008 8:09 PM