do we transport locally restricted Key figures ?

[Former Member]

hello,

Do we transport key figures/chars which we restrict locally? or we just transport the RKF?

Is it good idea to restrict locally if its not going to be used too much rather than vreating whole bunch of RKF?

and lastly how can we delete RKF if we dont need them?

Thanks

[former_member188975 · Accepted solution]

Hi K M,

The local restricted KF and formulas are collected along with the query when you collect the query for transport. You can see them among the objects in RSA1 > Transport connection when you have collected your query.

It is okay to create local restricted KF if yu are sure you do not need to reuse the smae definition in any other query. Else for sake of integrity and ease of maintenance, it is advised to create them on the left hand side.

You can right click (on the left hand side) and choose delete. The system will let you delete only if this RKF is not being used in any other query or other RKF or CKF.

Hope this helps...

[Former Member · Accepted solution]

Thanks Bhanu,

For some reason i was creating all RKF when actually I am going to use them only in that query, but when you pointe dout in the other post I think I have to go back and restrict most of them locally.

Thank you very much again.

[former_member188975 · Accepted solution]

Yes, if you are using in just one query it sometimes gets irritating to provide all those techincal names

[Former Member · Accepted solution]

Yeah I agree,

Once you know how to play around with varaibles do you think reporting becomes relatively easy ?

id there any other type of varaible or particular thing in reporting which is a "must know" before creating queries?

Thanks alot

[former_member188975 · Accepted solution]

Yes, I agree: variables are very important and useful to good query creation, esp since you can have all these different types of variables.

http://help.sap.com/saphelp_nw04/helpdata/en/cf/579b3c494d8e15e10000000a114084/content.htm

Not sure about a 'must know' list, but few things that are useful are knowledge of judicious use of filters, variables and free chars; creation of global RKF, CKF and structures; decision choice between 2 queries or 1 query and 2 workbooks; trying to use seelctions, instead of restrictions (when selecting values for restricting chars) etc.

Hope this helps...

[Former Member · Accepted solution]

Bhanu,

When you create a variable and it gives the user a input screen at the start of query run, thats what you refer as "filter" right or is it different ?

The other things that you have mentioned i guess those will come more with experience and what requirements you are exposed too. right

Thanks for the link it will be very helpful

[former_member188975 · Accepted solution]

In a sense yes, but I was referring to the Filters set up in the Filter area of the query definition. If you can restrict any char here, instead of in the free chars, it betters the query performance. And yes, you simply learn a lot just be facing requirements and having to fulfil them!