Work center & operation number from the table?

[former_member224727]

Hi,

I have couple of entry for one inspection lot (03 inspection type) in QASR table.

Now I want pick one entry from this table and want to know what is the operation number and attached work center attached to this MIC? How can I know & from which table?

Reply appreciated.

[former_member211618]

Hi,

   Please check in thses tables : PLKO,PLPO,PLMK,V_QAPO.

[former_member224727]

Sorry but this doesn't help me. I'm preparing custom report as per business req. Actually I have 500 entry in QASR table now system store recorded value against MIC sample in this table. Now I have to display operation number of each line (MIC) and work center in the report output. Now what value I need to pick from QASR/ QALS to pull operation number & work center & from where?

Please suggest.

[former_member224727]

I pick node (VORGLFNR) from QASR table & pass in PLPO-PLNKN along with PLNTY and PLNNR to fetch operation number but this is not helping me. Somehow node logic is not picking correct operation number of MIC and because of this I'm not getting correct work center as well.