forcing naming convention for queries and views

[Former Member]

Hello Friends,

Can anyone tell me how to Force user to save queries with starting letter 'Q' and all views with 'V'.

I know how to restrict queries ..

Please tell me how to Froce Views to save with first letter 'V'.

Thanks,

Ram

[Former Member]

you need these values in your role to restrict them save queries with starting letter 'Q' and all views with 'V'.

S_RS_COMP

RSZCOMPID-Q*

RSZCOMPTP - REP

S_RS_COMP

RSZCOMPID-V*

RSZCOMPTP - QVW

S_RS_COMP1

RSZCOMPID-Q, V

RSZCOMPTP - REP,QVW

and as you know activity will be 01 for giving create ability, don't forget to restrict on infocube and infoarea. one thing you have to rethink is why you want to use Q, V as a starting letter, I would prefer Y,Z.

and lot of companies do restrict for different naming conventions on different infoarea/infoprovider. just a casual suggestion, it will be better for your company in future, if you restrict the reporting component's naming conventions more specific. something like Zinfoprovider name_reporting component_*.

regards

Message was edited by:

Keerti Vemulapalli

[Former Member]

Hello

I am able to save query with Starting lette 'Z'.

but i am unable to save view with starting letter 'Y'.

i can save with what ever name i want.

With the given values.

Thanks,

Ram