how to get 'Plant' data from inspection plan

[Former Member]

Hello Experts,

Can anyone tell me how to get 'Plant' data from inspection plan? I'm trying to add another 'Plant' field to datasource 2LIS_05_QE2 (Inspection result: Quantitative data) which will come from the inspection plan but I don't know from what table to get it from. Can I get it from table CRHD?

Hoping for your immediate responses.

Thanks in advance.

Tan

[Former Member]

Can you let use know what is exact requirement? can you rephrase the question?

[Former Member]

Hi,

This is the requirement:

The user wants to see from BW report the data on 'Plant' field coming from 'Inspection plan' and not the 'Plant' shown on the inspection lot header. Current structure of the datasource I mentioned above is, it gets the 'Plant' data from the inspection lot header (from table QALS). Now, we are going to add another 'Plant' field on the extract structure of the datasource which will should come from the inspection plan.

Thanks!

[Former Member]

Plant data from inspection plan is stored in the field QALS-SELWERK.