How to search SAP for Inspection Lots with a specific User Status and extract the data
Does anyone know if there is a Function Module or BAPI that can be uses to run a background job to find all inspection lots that are set to a specific User Status.
Example: We have many user status's setup under a status profile (ZQL00001). I want to be able to run a background job that can go out and find any Inspection Lots that have a status of "MOLD" etc... I then want to export this to an output file and save it as an xml or csv format. Our production lines want to track the number of lots that get produced through each of the status's shown in yellow below. If their is a way of extracting the data from SAP then we can use a large monitor / TV to display the data as it is processed at each of our production lines.. Any help would be greatly appreciated.