on 09-05-2014 8:45 PM
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.
Thanks
Hello,
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.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Darrin,
You can create a Query in SQVI by joining the 3 tables- QALS, JCDS and TJ30T.
Hope it helps
Thanks
Sahil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Darrin,
Have you tried the option of selection profile?
I think using selection profile you can do this.
Create selection profile with required status in QA32,then create a variant for QA32.
You can run this variant in background and get the list of required lots.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.