Fetching Alternate item Data from Order Confirmation SAP

[shailesh_mishra5]

Dear ABAP Experts,

Need your help to map the below requirement.

There is BOM of FG. It has 3 components, 1 semifinished and 2 packaging Drums.

The  FG material at the time of confirmation(COR6N), may consume anyone of Packaging  material depending upon the Packaging drum availability in stock.

To may this scenario, i have used the concept of Alternate Item group for both the Packaging Drum items.

I have assigned the same A1 with below screen shots in BOM of FG.

Based on my FG Material and their Batch in delivery(VL01N), I want to know the exact which drum is consumed against that Process Order.

So I want to know the Table and Fields to fetch the Particular drum being consumed in that process order.

Best regards

Shailesh

[former_member206498 · Accepted solution]

Hi Shailesh,

If you have the Process Order number, you can get all consumed materials for that order from MSEG table by passing the order number (AUFNR) and movement type (BWART) = "261" and get the returned material number (MATNR).

You can get the same result using AUFM table. It's smaller table compared to MSEG. To use this table, please ensure that parameter "Planned Goods Issue" and "Unplanned Goods Issue" parameters are ticked in the "Documented Goods Movements" section in "Order Type Dependent Parameters" customizing in SPRO or transaction OPL8.

Regards,

Julian

[former_member214153]

  Dear Shalish,

1st of all you take your batch & material No and enter in MB51 screen with mov. 101 after that click execute button you will get your process order No. Take the process order number and Go to T-code COOISPI . please find the screen shot...

  

Thanks,

Anurudh

[shailesh_mishra5]

Dear Julian,

Thanks a lot. Your logic of fetching data is perfectly working. I am able to fetch data from both the ways you have suggested. Latter one is more short and precise. Closing the thread.

Best regards

Shailesh