Dynamic where clause issue
The code returns system error which is caught in the Catch statement for the where condition:
( BRFAM LIKE '%L&%' ) AND ( ITPCK = '25' ) AND ( MKLEN = 'KS' ) AND ( MKTGR = 'SE04' ) AND PARPR IN LR_MATNR
If I take out the ITPCK field from the string the program works fine.
Including the ITPCK field which is a quan data type in the where clause works fine in the dev server but returns an error in the QA server.
I have checked the patch levels and the only noticeable diff is the kernel patch level which is 79 in Dev but 85 in QA.
Looking forward to your inputs.