Supply Area-BOM Level by Level

[kiran_k8]

Hi Folks,

I am having a problem in fetching the Supply area when a Component is having many sub-assemblies.

To be in detail,

I am fetching the DISTINCT Production Order(AUFNR) from MSEG w.r.t to MBLNR and MJAHR.

Then w.r.t to this AUFNR I am fetching the BOM category(STLTY) and BOM (STLNR).

Then w.r.to this STLTY and STLNR I am fetching the Supply area(PRVBE).

If the supply area is maintained at this level,then fine.If this BOM is having many sub-Assemblies and the supply area is maintained at a different level then we need to explode that BOM step by step and fetch the Supply Area.

To be precise CS11 gives the Supply Area according to the BOM Level by Level.I just wanna fetch the Supply Area as per that.Do anyone here has an idea about how this functionality can be achieved.

I am trying to find by debugging CS11,any valuable inputs from experts here will be helpful.

Thanks,

K.Kiran.

[Former Member]

Hi ,

u can try this FM CS_BOM_EXPL_MAT_V2

or

table STPO.

regards

Prabhu

[kiran_k8]

Prabhu,

While debugging CS11 we found a report RCS11001 is submitted which in turn is calling the function module mentioned in your reply.

CS_BOM_EXPL_MAT_V2

.........CS_BOM_EXPLOSION

We are trying to find out the fucntionality of these two function modules but not yet got any fruitful result.Any idea on how to use these function modules.

Thanks,

K.Kiran.

[kiran_k8]

Hi Folks,

Fine,we are trying this way.

SUBMIT RCS11001

WITH PM_MTNRV INCL WA_MSEG-MATNR

WITH PM_WERKS INCL WA_MSEG-WERKS

WITH PM_STLAL INCL C_STLAL

WITH PM_STLAN INCL C_STLAN

WITH PM_CAPID INCL 'PP01'

WITH PM_DATUV INCL SY-DATUM

WITH PM_MEHRS INCL 'X'

WITH PM_ENHDL INCL '1'.

It is showing the RCS11001 output even but I don't want that output to be displayed.

I am trying to submit RCS11001 report and planning to use its output(alv grid) in my zreport.Now the problem is as RCS11001 output is ALV GRID and not LIST it seems that we can't use LIST_FROM_MEMROY and LIST_TO_ASCI.

Any idea?

Thanks,

K.Kiran.

[kiran_k8]

Prabhu,

CALL FUNCTION 'CS_BOM_EXPL_MAT_V2'
          EXPORTING
                CAPID                        = 'PI01'
                DATUV                       =  v_aufld
                MKTLS                       = 'X'
                MEHRS                      = 'X'
                MTNRV                      = wa_afko-plnbez
                STLAL                       = wa_afko-stlal
                STLAN                       = wa_afko-stlan
                STPST                       =  0
                SVWVO                     = 'X'
                WERKS                     = wa_afko-werks
                VRSVO                      = 'X'
            TABLES
                  stb                           = bom_exp
            EXCEPTIONS
                   ALT_NOT_FOUND               = 1
                   CALL_INVALID                    = 2
                   MATERIAL_NOT_FOUND     = 3
                   MISSING_AUTHORIZATION  = 4
                   NO_BOM_FOUND                = 5
                   NO_PLANT_DATA                = 6
                   NO_SUITABLE_BOM_FOUND      = 7
                   CONVERSION_ERROR               = 8
                   OTHERS                                     = 9.

Got it.We missed out DATUV,MEHRS fields while executing.

Thanks,

K.Kiran.

[kiran_k8]

Hi,

The above function module is indeed getting me all the data but not exactly as per requirement.I need to fetch the supply area of only the DOCUMENTED GOODS MOVEMENT(CO03) for which a Material Document is Created.So,we had considered the Reservation Number and Item no of the reservation number for materials in the Material Document and then feeding the same to RESB table to get the corresponding Supply Area.It is working.

Thanks,

K.Kiran.