/BI0/SFISCVARNT & /BI0/SFISCYEAR tables have got wrong SIDs generated - Pls advice

[former_member751830]

As compared to other working BW on HANA systems, in our newly built BW on HANA, /BI0/RFISCVARNT & /BI0/SFISCYEAR tables have got wrong SIDs generated when we transferred the global settings from ECConHANA.

Issue: Even after all initial BW data loads (Transfer Global settings / MD / TD) were completed successfully, few of the PROD BW migrated 'PLANNING' queries (exactly the same) are not working, and it is erroring out in RSRT with System error in program CL_RSMD_RS_READ_MDATA and form _sidval_direct_read. When debugged the issue, we found the query is checking for variant value with SID# 5 (screenshot attached) raising an exception when it found no value.

Que1, Compared to T009* entries from all ECCon HANA systems , should all BW systems have similar SIDs generated for TIME char Info Objects ( like 0FISCVARNT , 0FISCYEAR, 0FISCPER , 0CAL* etc ) or not ? as we have found they have similar SIDs except 0FISCYEAR & 0FISCVARNT's.
Que2, if yes in Q1, then how to readjust these SID entries and fix query error?

Note: we've tried to rebuild FISC* tables data by transferring global settings with a rebuild option - but got no luck.

Appreciate your expert help here.

[Abhishek_Hazra]

Have you tried to rebuild/update tables later while transferring global settings?

[former_member751830]

Yes abhishek.hazra

[FCI]

As the SIDs are dependant on the system (you generally don't have the same SIDs on 2 different systems, it depends on the order with which the values are created), what surprised me is that the code is looking for a specific SID.

How is filled i_t_sidval ?

[former_member751830]

Yes @frederic Cincet. for other IOs, I also believe it depends upon the system and its data load sequences/values are created.

But for special IOs (especially for TIME IOs), my research is still on and needing help from you guys.

I_T_SIDVAL is filled from /BI0/RFISCVARNT view. pls advise

[FCI]

I don't have the same SID either. Seems normal to me.

I_T_SIDVAL can't be filled from /BI0/RFISCVARNT. Why should you redo a select afterwards on the same table ?

[former_member751830]

Oh this is good update.

And that is a standard code.

Class: CL_RSMD_RS_READ_MDATA, method: _SIDVAL_DIRECT_READ

[FCI]

Question was : how I_T_SIDVAL is filled in your example ?

As this is the only parameter of the method, it is filled by the calling entity (not in the _SIDVAL_DIRECT_READ method).

[former_member751830]

cl_rsdm_read_master_data=>get_reader

This method is bringing the 5 value for SID

[lucimar_moresco]

Hello

I would like recommend you to check kba 2582961 and following wiki:
https://wiki.scn.sap.com/wiki/display/BI/F4-Special+and+Time+Characteristics+and+Own+Implementation

I hope this help

Lucimar