Skip to Content
0
Former Member
Jul 31, 2010 at 10:08 AM

Filtering records with deletion flag in Query report

874 Views

Dear Friends,

We are using ECC6.00 (EHP4) for one of our QM requirement, i have created a query in SQ01 with the tables QMEL,AUFK,AFKO,QMFE etc., to get the details of production order and notification.

The report will list out the production scheduler wise, order wise, defect wise quantity with the notification number also in the display.

For notifications which are created wrongly, the users set deletion flag. The same i.e., notifications with deletion flag should not appear in the report and hence i have called the field and filtered the value in the output (i.e., field value not equal to X where X is for deletion flag set records).

Everything works fine upto this, but when users (to carry out analysis) send the data to the spread sheet, the filter values are removed and all records are populated in the excel sheet (even records with deletion flag).

To select and display only records without deletion flag, i want to introduce coding in the query. Kindly tell me whether this is possible, if so where and what code should be written to meet my requirement.

The records with the deletion flag (notifications) should be eliminated from the selection and display.

Experts help required.

Regards,

M.M