CELL_INPUT / ROW INPUT functions use

[Former Member]

Hello,

In my current project, we would need to:

_ Validate the values of a process for some partners (specific program)

_ Once the process is validated, normal user would not be able anymore to change all the values in the past of some key figures for the partners for which it is validated. Yet a central super user could do so. When entering in the planning book the day after, on Day-1 which is not past anymore the user should be able to change the values.

To do this, we could:

_ after validation of the process, use macro function CELL_INPUT to put the key figures in output only on all past days for the partners of a selection. The day after, Day-1 would come in the horizon and would be open for change.

=> can the function CELL_INPUT be launched in background for a list of partners(characteristic)? I saw in a forum that notu2026?

=> how could we let super users the access to change the key figures values? We could create another dataview with all key figures there in input/output, and access to this data view only for super users.. yet Iu2019m not sure this would work: the CELL_INPUT value does not depend on a data view..?

Thanks for your help and feedback!

Matthieu

[srinivas_krishnamoorthy · Accepted solution]

If you have a list of users who need to have edit capability, a long term solution would be to have a dedicated data view with appropriate authorizations.

If not, then you can use these functions like CELL_INPUT to selectively open the key figures to entry for certain users. You can have conditions such as user ID checks like USER(NAME) (check http://help.sap.com/saphelp_scm50/helpdata/en/f3/852d3af6ecd02ae10000000a114084/frameset.htm for syntax)

If the user IDs follow a patters for business pattern, it becomes easier.

These functions are supposed to be overtly invoked in foreground using default/startup macros. They cannot be invoked in background.