06-22-2009 6:18 AM
hello,
the info provider (ZIC_COPA) is having auth. relevant char. are 0COMP_CODE, PLANT, 0SALESORG.
When i am executing query which is built on ZIC_COPA info provider. It is checking all above charcteristics value. But in RSECADMIN i found that system is checking for not equal to values. For ex. please see below RSECADMIN trace. It is checking not equal to values for PLANT. does anybody know why it is checking NOT PLANT IN values??
0COMP_CODE
0PLANT
0SALESORG
SQL Format:
COMP_CODE IN ('1000',,'3200')
AND NOT PLANT IN ('1000','3200')
AND SALES
ORG IN ('1000',','3200',')
AND TCAACTVT = '03'
Note: There is no hardocoding or exclusion values in the query.
Regards
Imran
06-22-2009 7:09 PM
Hello imran,
check couple of things first; In your analysis authorization you have to assign # sign so if there is no data then # will be assigned and you will not going to have any error.
Second check your analysis authorization for CP, BP what you put and change some the values
Best Regards,
Faisal
06-22-2009 7:09 PM
Hello imran,
check couple of things first; In your analysis authorization you have to assign # sign so if there is no data then # will be assigned and you will not going to have any error.
Second check your analysis authorization for CP, BP what you put and change some the values
Best Regards,
Faisal
06-26-2009 9:30 AM
07-28-2009 11:50 AM