Master data missing for Fiscal period ?

[Former Member]

Hi Gurus,

I am facin g a strange behaviour.

We are creating a BI-IP applcation. One of the first step is to create a specific document in our cube to store a Fiscal Period as a key point.

So, in my Visual Composer model, I offer the user the list of possible Fiscal Period so taht they can choose.

We are in 2011, and try to choose for example 2015/007

Using this data, we will then repost he recod we have in the cube from the old value to 2015/007

The system issues a message explaining that there is no master data for the chosen fiscal period or we do not have authorization...

But if we choose another fiscal period much closer in time to 2011 (I did not find yet the cut off period), it works fine...

How can I a enforce the master data creation of 0FISCPER, as if I look into the table T009B, for the fiscal variant we use, we have data till end of 2030...

I am confused. Any help ?

PY

[gregor_dieckmann · Accepted solution]

Hi,

the time interval used for the F4 help might be relevant here. The system generates the time values based on the setting maintained in transaction RSRHIERARCHYVIRT. Check the time interval on the first tab.

Regards,

Gregor

[Former Member · Accepted solution]

hi Gregor

Thanks for the input. But actually,we knew that before and made the time interval open from 2004/05/01 to 2031/05/01, but I can not make any repost in 2015 for example...

Another idea ?

Py

[gregor_dieckmann · Accepted solution]

HI,

you are talking about Visual Composer, how do you use it, what function modules do you call? You may try to create some records using the planning modeler using the 0FISCPER values. Does this work?

When a functions module is used: Are you using the correct format for 0FISCPER, e.g. external versus internal format?

Regards,

Gregor

[Former Member · Accepted solution]

Hi Gregor

We use VC to display the data.

In the specific case I have, here how I get the fiscal period:

when the user enters the screen, I run a cusotm function through IP to create the needed records, then I run a BI query to display the data in a table.

I use a share to add an input ready cell in the table. That cell is a combo box. Thus I offer the user a list based on a BI query returning the possible fiscal periods (simple query reading 0FSICPER). When the user chooses a value, it is entered in the input ready cell.

Then, when the user decides to save, we use the content of the input ready cell as the target for a standard repost function.

When we we enter a value before 2015/001, it works fine !

As soon as we enter a value after 2015/001 (including 2015/001), I have an error message like "The characteristic Fiscal Period has no master data for "2015/001" or you do not have any authorization"

But when I look into the T009B table, I have all the necessary data. The interval you mentionned is wide open, and it works for more recent fiscal period...I am a bit lost.

Later in the model, we are planning cost against fiscal period. I have no problem to add values for periods older than 2015/001...

So I don't know where to search

Thanks for your help

PY

[Former Member · Accepted solution]

Hi,

I have just opened an OSS messaeg. Will keep you posted

PY

[Former Member · Accepted solution]

Hi,

could you please check the following setting in your input ready query for Fiscal period, choose "Adanced" tab there you will find the following groups

1. Access Type for Result Values

a] Posted Values

b] Characteristice Relationships

c] Master Data -- Choose this option

2. Filter Value Selection During Query Execution

a] Only posted Values for Navigation

b] Only Values in Infoprovider

c] Values in Master Data Table --Choose this option.

d] Characterisitc Relationships

Please choose "Master Data " on 1st group and on the 2 group choose " Values in Master Data Table"

These will allow you read the master data table for Fiscal period.

Hope it helps....

Cheers ,

Balaji

[Former Member · Accepted solution]

Hi Balaji

thanks for the feed back, but my query is not an input ready query. I just need it to display the data and offer a field to enter the new value.

The repost function will effectiveley repost the data. May be I could be more precise with an example

Step 1 : user enter the screen for E-OTP A-001

Step 2 : as there is not yet any go Live period, I create in my planning cube a record like this :

- E-OTP : A-001

- Fiscal year/period : 0000000

- Fiscal Variant : Z1

- 0AMount : 1

Step 3 : I run a regular query showing the created record and I use a share object to create an cell to let the user change the date

Step 4: in the screen , the user select for the "input ready" cell a fiscal year period, coming from the result of a query reading master data

Step 5 : the user click on a button to start the repost function taking the orignal fiscal year/period to repost it to the newly chosen one.

When, in step 4, the user chooses a value before 2014/012, the step 5 works.

When, in step 4, the user chooses a value after 2015/001 (inclusively), the step 5 breaks and I have the message "Characteristic fiscal year/period has no master data for "xxxx/xxx" or you do not have enough authorization"

My guess for now is that the issue comes from the VC java portal which is a NW 7.1 EHP1SP4, while my BI java portal is NW 7.0 EHP1 SP5...

To try to validate that, as all my IP functions run in a planning sequence, I created a variant to execute the repost function in the BI java portal and paid attention to "check" the data I entered => no error messages with a fiscal year/period 2015/001...

After that I ran the repost function with my variant in the BI server : No error, and the psoting was OK!!!

I opened a message at OSS....

PY

[former_member93896 · Accepted solution]

Hello PY,

some backgroun: fiscal period is checked against the SID table /BI0/SFISCPER (not T009* tables). The SIDs are created automatically based on the time interval mentioned in the posts above. They are create when the system has to generate the list of fiscal periods for the first time using the value help (or an equivalent API). Apparently, your VC application did not use the standard value help or APIs (that's what Gregor was talking about before).

Regards,

Marc

SAP Techology RIG

[Former Member · Accepted solution]

Hi Marc

Thanks for your feedback. But actually, the SIDs are generated. I checked them in the tables. Moreover, using regular ready for input queries we can post data against periods after 2015/001.

Indeed the other objective of the application is to forecast projects costs for the following ten years, and when we post against any period it works fine...

So I am still confused

PY

[Former Member · Accepted solution]

Hi Gurus

Just to let you know that my message is at the second level of support at SAP, and as soon as I have some feedback, you will get it.

PY

[Former Member · Accepted solution]

Hi

I got a patch from SAP...

there was an OSS note, but no easy key words to find it

PY

[or_ish-shalom2 · Accepted solution]

Hi PY,

Could you please post the OSS note number.

i cpuld not find it.

Thanks,

Or.

[Former Member · Accepted solution]

Hi

Look at OSS note 1403320

Summary

Symptom

Symptom 1: Creating new rows in planning query not possible.

Symptom 2: The system throws an error 'Charateristic fiscal year/period has no master data for xxxx' for valid values.

Other terms

planning, new, entries, rows, _VALUE_GENERATE, 0CALMONTH, 0CALQUARTER, 0CALWEEK, 0CALYEAR, 0FISCYEAR, maxrows

Reason and Prerequisites

This is caused by a program error.

PY