Skip to Content
avatar image
Former Member

How do I get results from 5 different objects on Finish good outgoing certificate???

Finished good Test Certificate needs to be created by fetching data from –

  • Outbound delivery
  • Sales Order
  • RM Chemistry recorded during RM inspection - in RM inspection lot
  • SFG mechanical properties recorded after Heat treatment inspection for some semi-finished good - in SFG inspection lot
  • SFG mechanical properties recorded after Wire drawing inspection for some semi-finished good - in SFG inspection lot

Till now, I have decided that I will keep "outbound delivery" as an input field on TC printing transaction and with the help of "outbound delivery", I will fetch delivery and Sales Order data.

Please help me in getting the results from multiple inspection lots / tell me how should I do it???

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 14 at 12:13 PM

    Hi Amruta,

    If I understood your requirement correctly, you want the results of the Inspection lots lower level batches used in manufacturing the FG. Use the below logic and I hope you can achieve it.

    Pass the Material, Plant and Batch from the Outbound Delivery to the FM CHVW_EXPLODE_ALL which will give you all the batches and materials consumed at below levels.Once you get all the low level batches and materials, pass them to QALS table to get the Inspection lots. One you get the Inspection lots it is not much difficult to get the results.

    Regards,

    Krishna Chandra Medasani

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      i execute it along with the material no.,plant and batch no..

      it is saying that it conatains no qty and moreover it is not displaying the sub-batches in it.

      where as i compare it to the BMBC tcode for the same options which i had given in dis reoport ,it is showing the showing the sub-batches of it.

      plzz give some guidence to me

  • Feb 16 at 07:02 PM

    Are you generating your COA's from within SAP? If so, this is standard functionality.

    If so, in the COA profile for each characteristic value you wish to publish, select the result origin to be from the production chain. Your materials must be batch managed and you must have the batch where-used list activated.

    Using this functionality you should be able to back to the GR inspection of the raw materials if you so choose.

    Craig

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello,

      Please elaborate a little.

      What I understood is that, I have to create certificate profile in QC01. Please elaborate.