Where are the key figures in standard 0PCA_C01 queries?

[Former Member]

Hello BW experts

I am evaluating the standard BI content queries related to profit center accounting. I found all 0PCA_C01_q* queries don't have any key figures in their column. But when I execute the query It brings out the value. How is that possible? Is it something related to global structure? Where can I see the information?

Further more, I can not drag and drop any key figures from left panel to the column area. Why is that?

Your help is very much appreciated

Thanks

Subbu

[Former Member · Accepted solution]

What query are you lookinga at ?

Query Elements do exist like Plan, Actual - Check the selections.

You cannot change a Buss Content Query , make a copy of it to change it.

Use Tcode - RSZC or do Save As new query.

[Former Member · Accepted solution]

Roberto

I am looking at 0PCA_C01_Q0004, My question is about the columns. It has Plan, Actual, etc. But if I double click each of them, they are all characteristics (0version and 0vtype. Not key figures,. And I can not add any key figures (0credit, 0debit etc) from the left pannel. I made a copy from that query to another query the symptom is still the same. I am confused. I thought on the columns we need to have key figures not characters. But this query is strange.

Subbu

[Former Member · Accepted solution]

Look in the Filter Tab, Keyfigure used is 1KYFNM/Amount - 0ECPCA_K0001.

0ECPCA_K0001 - is a CKF - 0DEBIT + 0CREDIT.

Report is hardcoded to this keyfigure.

[Former Member · Accepted solution]

-

You have to get rid of 0ECPCA_K0001 from Filter to use other keyfigures.

[Former Member · Accepted solution]

Very helpful answer. You let me understand more about the Characteristic Restrictions. Thanks. Points awarded