query error msg

[Former Member]

Hi Guru's.

when i'm trying to run a query on 0COOM_CO2 cube, the system is throwing a error msg.

error msg:

No value could be determined for variable 0P_FVAEX.

Message no. BRAIN632

Diagnosis

This error diagnosis is specific only to the variables 0P_FVAEX or

0P_CTPCA !

Termination message BRAIN 632 appears:

Could not determine value for variable 0P_FVAEX (or 0P_CTPCA).

System response

1. Operation method of SAP-Exit-Variables 0P_FVAEX or 0P_CTPCA

With queries from the CO application, both SAP-Exit-Variables look for

an entry for 'controlling area'. With this controlling area from the

selection screen, the SAP-Exit-Variables program reads the attributes

for InfoObject 0CO_AREA (controlling area).

With queries from the FI application, the SAP Exit Variable 0P_FVAEX

looks for an entry for 'company code'. With this company code from the

selection screen, the SAP Exit Variables program reads the attributes

for InfoObject 0COMP_CODE (Company Code).

0P_FVAEX determines the fiscal year variant (attribute 0FISCVARNT) from

the attributes for 0CO_AREA (CO queries) or 0COMP_CODE (FI queries).

0P_CTPCA determines the currency type of the profit center local

currency (attribute 0CURTP_PCA) from the attributes for 0CO_AREA.

2. Cause of Error

The attributes for the controlling area (InfoObject 0CO_AREA) or company

code (InfoObject 0COMP_CODE) were not loaded into the BW system, or the

attributes for the controlling area are not active in the BW system.

Check whether this is the cause of the error in your BW system. Display

the contents of table /bi0/mco_area or /bi0/mcomp_code using transaction

se16.

Application CO:

Check whether the attributes 'fiscal year variant' (field FISCVARNT) and

'profit center local currency currency type' (field CURTP_PCA) are

filled in the 'A' version (field OBJVERS) for the selected controlling

area. If the fiscal year variant in the OBJVERS = 'A' is empty, then the

error is with variable 0P_FVAEX. If the currency type of the profit

center's local currency in OBJVERS = 'A' is empty, then the error is

with variable 0P_CTPCA.

Application FI:

Check whether or not the attribute 'fiscal year variant' (field

FISCVARNT) is filled in the 'A' version (field OBJVERS) for the selected

controlling area. If the fiscal year variant is empty in OBJVERS= 'A',

then the error is with variable 0P_FVAEX.

Procedure

Using InfoSource 0CO_AREA, load the attributes for the controlling area

or company code into your BW system.

Afterwards, activate the attribute changes in your BW system. To do

this, use transaction rsa1, path 'Tools > Hierarchy/Attribute changes',

functions button 'InfoObject list'. Choose InfoObject 0CO_AREA or

0COMP_CODE from this list, and activate the attribute changes.

Procedure for System Administration

where do i start to debug it.

Thanks in advance,

Mav

[Former Member · Accepted solution]

Hi,

load master data, at least the attributes, to 0CO_AREA and 0COMP_CODE, than it will work.

I had the same error last week, and with loading and activating of the data of this two infoobjects, it was solved.

regards

Siggi

Message was edited by: Siegfried Szameitat

[Former Member · Accepted solution]

The variable 0P_FVAEX fills the fiscal year variant based on the following checks in the order:

1. If you have a variable for 0CO_AREA the system looks into the first entry and determines the attribute 0FISCVARNT of 0CO_AREA.

2. The same for 0COMP_CODE.

3. Check if there is a variable for IM Program hierarchy and look for 0FISCVARNT.

4. Check project data for fiscal year variant.

5. Check CO area of the asset.

6. Get Fiscal Year variant from Oracle company(!)

7. Get FY variant from Oracle company code.

8. Get FY variant from Oracle organization.

So you need to use one of these info Objects in your variables.

Best regards

Dirk

[Former Member · Accepted solution]

Hi Dirk,

Thanks for the reply.

could u pls let me know the steps that has to be followed in trouble shooting this problem. That would be of great help. Thanks in advance.

[Former Member · Accepted solution]

Hi Siggi,

i checked, 0CO_AREA and 0COMP_AREA already has data in it. Now what has to be done. Thanks in advance.

Mav.

[Former Member · Accepted solution]

Hi all,

can somebody help me out with this problem

Thanks,

Mav

[Former Member · Accepted solution]

Hi Mav,

usually all SDN/BW experts look at both BW forums...so you don't need to post the same question in two forums !!!

Bye,

Roberto

[Former Member · Accepted solution]

Hi Roberto,

Ok i'll keep that in mind. Anyways, can u help me with my problem.

Thanks,

Mav

[Former Member · Accepted solution]

Hi Siggi,

as u said u had the same problem can u pls tell me the steps that u followed to overcome this problem.

My situation is so:

i already have data(attributes and text) in both the IO's... now my question is should i delete the existing data and reload the data?

And even they are part of the process chain too.... do reloading anyway effect the process chain? if yes, what has to be done?

And can u pls give me the steps that has to be followed to load the data ?

Any help is appreciated.

Thanks In advance.

MAV

[Former Member · Accepted solution]

Roberto helped me solve it. Thanks alot for everyone who tried to help me. I'm assigning full pionts to Roberto.

Thanks,

Mav

[Former Member · Accepted solution]

Hi Maverick,

I have the same error too, can you post the method that Roberto told you? Thanks.

[Former Member · Accepted solution]

Hi Mav,

I am having the same problem and checked in /bi0/mco_area and also in /bi0/mcomp_code. There is data in it.

Can you please let me know how to fix this error message.

Thanks

MK

[Former Member · Accepted solution]

Hi Roberto,

Please help me resolve this same issue.

I get an error for a Var ZTCPER1 when I execute the Query and error msg talks about loading data for 0CO_AREA and 0COMP_CODE etc which we dont use.

Var ZTCPER1 uses an exit and has ABAP code .Pls suggest.

Thanks,

Rup

Edited by: Rup Kris on Jun 3, 2008 8:03 PM

[Former Member · Accepted solution]

Hi experts;

I'm having the same error, the query is working well in dev environnement, but after transport to integration environnement it's giving me the error.

I have all master data loaded and activated; Can anyone help me please ?

Regards

Raed

[Former Member]

Hi Maverick and Roberto

can you please suggest me i have the same problem?thanks so much

regards

[Former Member]

Hi

have solved your problem.

best regard

Francoise

[Former Member]

HI

can you post the solution to me?thanks so much

I'm having the same problem.

[Former Member]

Hi

I'm having the same problem. Can someone please post the solution to this? thansk so much.

[Former Member]

Hi Maverick and Roberto

can you please suggest me i have the same problem

regards

Vasu

[Former Member]

HI,

from the message I understand the systems expects somemaster data .why dont u see the infoobjects are active and data is extracted for them.

After that u can go the data provoder right click.when u do that it would show you infosource overview.U might need to extract all the data which ever has red lights .

Then try the queries if they work?

Thanks

Sampath