Insp. characteristics from all routings

[Former Member]

Hello SAP Experts,

I have a requirement from the business to fetch all MIC's assigned to all routings within a particular plant. I tried fetching the data by creating a SQVIu using table - MAPL, PLPO and PLMK but the data for each plant is so huge that the report dumps out everytime I run it. Then I thought of taking the o/p only from PLMK and from a combination of MAPL/PLPO --> then do a vlookup for both the files to get the material number, routing operation details and the characteristics assigned to each operation but that looks like is not going to work as I can't find a common field to do a Vlookup. I am not sure if group no will yield correct results.

Please advice if you have came across a similar situation before.

TIA

[busyaban7]

Hi,

Please try transaction QS28 and QS26 if that resolves your issue. May be you can run them in background so that your query do not dump or throw timeout error.

Thanks,

Arijit