cancel
Showing results for 
Search instead for 
Did you mean: 

0FIAR_C02 - Account Receivable

0 Kudos

Hi all,

When i try to run the query 0FIAR_C02_Q0001 , they prompted me for 0P_FVANT fIscal year variant.

Single value entry. Compulsory. But in the infocube : 0FIAR_C02 where it load from i have checked that the field for  fiscal year is all empty and

the field for 0fiscyear are all 120.000.000.

So when run the query what value shall i enter for the 0P_FVANT?

If the Infocube has incomplete data, how shall i reload all overr again from start?

Please kiindly give the proper step and advise what the correct way to take to successfully run the query and generate the report or

reload again the data in order to take in fiscal year field?

Thank you for your help.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member194898
Active Contributor
0 Kudos

Hi,

Both 0fiscyear and 0fiscvar should be populated with data. There must have been made some error in ETL stage.

You see that 0fiscvar is in compounding for 0fiscyear ?

I would check if 0fiscvar if properly set in update rules against KF you use in that query.

Then the value of fiscal variant should be hardcoded in filter in querries.

Regards, Leszek

Message was edited by: Lesław Piwowarski