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.
This is stdn SAP solution where you use layouts and variants for such specific reporting requirement.
Another way is to use Selection profile where you assigned the specific status and use this profile in QA32 for retrieving the data.
Use QA32/33 and create your layout and execute the same no specific development or customization required.
You can create a Query in SQVI by joining the 3 tables- QALS, JCDS and TJ30T.
Hope it helps