cancel
Showing results for 
Search instead for 
Did you mean: 

How to search SAP for Inspection Lots with a specific User Status and extract the data

former_member626955
Participant
0 Kudos


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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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

sahil_bhardwaj
Explorer
0 Kudos

Hello Darrin,

You can create a Query in SQVI by joining the 3 tables- QALS, JCDS and TJ30T.

  1. First put the lot in QALS table and get object number- OBJNR.
  2. Now put the OBJNR in JCDS table and get STAT.
  3. Pass the STAT and STSMA = "use status" (ZQL00001 in this case) in TJ30T table and get the user status for the lots.

Hope it helps

Thanks

Sahil

Former Member
0 Kudos

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.