Change value in default queries (POWL)

[siowfong_chen]

Hi! We want to change the current query SAPSRM_OP_PURCHASING_01_02 to allow the status field to have the value of 'Saved' by default. I made the change via POWL_QUERY. However, the change is not reflected on the portal when I check it. Is there something else that I have to do to get the changes through on the portal?

Cheers!

SF

[Former Member · Accepted solution]

Hi SF,

Please run report POWL_D01 (Delete queries from database) to clear previous query of your testing user. I think the related application ID is SAPSRM_OP_PURCHASING.

Regards,

Donald

[siowfong_chen · Accepted solution]

Thanks for the information. Now that I have deleted the queries, the changes came through. However, I found that those queries assigned more specifically to the role (i.e. application id plus role) do not appear for the user. Is there anything else I need to do?

The current set up is

SAPSRMGP_PROCUREMENT_PURCH SAPSRM_OP_PURCHASING_01_01 SC

SAPSRMGP_PROCUREMENT_PURCH SAPSRM_OP_PURCHASING_01_02 SC

SAPSRMGP_PROCUREMENT_PURCH SAPSRM_OP_PURCHASING_01_03 SC

SAPSRMGP_PROCUREMENT_PURCH SAPSRM_OP_PURCHASING_01_05 SC

SAPSRMGP_PROCUREMENT_PURCH SAPSRM_OP_PURCHASING_03_01 PO

SAPSRMGP_PROCUREMENT_PURCH SAPSRM_OP_PURCHASING_03_02 PO

SAPSRMGP_PROCUREMENT_PURCH SAPSRM_OP_PURCHASING_03_03 PO

SAPSRMGP_PROCUREMENT_PURCH SAPSRM_OP_PURCHASING_03_04 PO

SAPSRMGP_PROCUREMENT_PURCH SAPSRM_OP_PURCHASING_03_05 PO

SAPSRMGP_PROCUREMENT_PURCH SAPSRM_OP_PURCHASING_03_06 PO

SAPSRMGP_PROCUREMENT_PURCH SAPSRM_OP_PURCHASING_06_01 DOUT ---> not active

SAPSRMGP_PROCUREMENT_PURCH ZROLE1 SAPSRM_OP_PURCHASING_06_01 DOUT ---> active so that user with this role can see the query.

SAPSRMGP_PROCUREMENT_PURCH ZROLE1 SAPSRM_OP_PURCHASING_01_05 SC

Regards

SF

Edited by: SF on Jan 26, 2011 1:26 PM

Edited by: SF on Jan 26, 2011 1:28 PM