cancel
Showing results for 
Search instead for 
Did you mean: 

Too many 0FISPCER entries in the Query FISCPER S4 Lookup

Martin_4
Participant
212

Hi,

BW Gurus:  Anybody has got a good solution ?

Finall Solution In Short: Delete in ob29 or SPRO the Fiscalperiod with too many entries ( if FI does not need it...)

The Problem:
SAP_BW              758         0001      SAPK-75801INSAPBW   SAP Business Warehouse

Martin_4_4-1736856343298.png

Too many Query Paramater 0FISCPER:

Martin_4_0-1736856343289.png

 

This data originates from the  0FISCPER3 SID Table /BI0/SFISCPER3:

Martin_4_1-1736856343291.png

The 0FSICPER3 masterdata table /BI0/PFISCPER3 is fine:

Martin_4_2-1736856343292.png

Solution approaches and investigations which DO NOT WORK OUT:

This is not due to 0FSICPER3 is using local implementation class CL_RSMD_RS_0FISCPER3:

Martin_4_3-1736856343295.png

Reinstall the 0FSICVPER from the RSA1 / Business Content wont help.

Martin_4_1-1736939988609 (1).png

Rebuild the data with RSRHIERARCHYVIRT, wont help:

Martin_4_0-1736939988602.png

RSDMDD_DELETE_BATCH won’t work because it’s the SID table.

Hard delete the obsolete in the SID Table /BI0/SFISCPER3
DELETE FROM /BI0/SFISCPER3 where CHCKFL <> ‘X’ and FISCPER3 = '365'.
Dont do this You cant edit the Masterdata ADT afterwords even If You do an update with the
same thing again.

SAP OSS Recommendations are:
https://me.sap.com/notes/801313/D - 801313 - Questions about queries based on virtual InfoCubes:
Fits only for physical: Cubes

https://me.sap.com/notes/801313/E 801313 - Questions about queries based on virtual InfoCubesNice summaray on the modes of a Infobject, Provider, Queery, but did not do

https://me.sap.com/notes/1565809/E  -1565809 - BW Query Input(F4) Help: Settings and Properties
not if You have Composite Providerrs: the annotation could do it : "...in certain cases "
Change the table rsadmin to changeable in SE11.
Enter bei RSADMIN manually RSMD_READ_MODE_D_FOR_VIEWS  X
This one worked oút
Mind: the setting is centrally for all and any querry on You box !

Coal Pit of 1565809 - BW Query Input(F4) Help: Settings and Properties
TheAfO Query FSICPER  F4  lookup gets fff slow.

Finally we tracked it down to the setup of the Fiscal Period:
OB29 or SPRO

Martin_4_0-1737655198445.png

We deleted the entry FISCPER = DL with 365 Days (after checking with the FI guys if its needed at all) and got only 52 remaining.
We deleted the entry FISCPER = WK  with 53 and FISCPER = WK  24 Days (after checking with the FI guys if its needed at all) and got only 12 remaining.

Martin_4_1-1737655235409.jpeg

...but 0FISCPER3 SID Table /BI0/SFISCPER3 did not change convicingly: (compare above):

Martin_4_0-1737655592173.png

Alternative:
Base the 0FSICPER3 on a HANA Calculation View and Calculation View with  the DE / EN Texts
with static 12 lines ( ...union ....)

Done. However.

Best Martin

Accepted Solutions (1)

Accepted Solutions (1)

Martin_4
Participant
0 Kudos

Cleared of Content

Martin_4
Participant
0 Kudos
Delete in ob29 or SPRO the Fiscalperiod with too many entries ( if FI does not need it...)

Answers (0)