Error when assigning SID: Action VAL_SID_CONVERT table 0FISCPER

[former_member1262147]

Hi Guys,

Can someone help me on this issue when loading data from PSA,?the following error was pop-up:

Fiscal year variant WK is not maintained for calendar year 2014.

I confirmed that I got the WK fiscal variant value from ECC side via Transfer global setting, and BW side contained the 'WK' value in T009B table.In Debugging model, field 0FISCPER can get the right value,and error came up from generating SID for Cube.

But I didn't know why this happened when loading data from PSA.

[RamanKorrapati]

Hi Rojay,

Error clearly saying as variant WK not maintained.

Please do the global transfer settings-->fiscal year variants.

later you can run your load.Even though if you got failed message, then ask FI Team to maintain variant at table level(T009/9B).

thanks

[former_member1262147]

Hi
I have done these before as what you said. In table T009/9B,There is ' WK' . Maybe 'you need to see my clear information as above, and I have said field 0FISCPER could get the right value in DTP Debugging model, like 20140401(Posting date)---->2014014(FISCPER customizing week).

[RamanKorrapati]

Hi,

Sorry, its my mistake.

Can you check at table T009B, are you able to see like below records?

Fisyrvaraint     Postingdate YYYY        Month(posting date in )    Calendar day 

  WK                   2014                               MM                             DD

at T code OB59, need to select Year Dependant for WK firscal yr variant.

Thanks

[former_member1262147]

Hi,

That's all right .But I must thank you for the reply!

Yes, I can see records in the table T009B of BW system. And what you said, OB59 is a t-code of ECC side,not in BW side. WK is a customizing kind of fiscal year variant, and stands for week, so 0FISCPER will get week value like 2014014(20140401--->2014014).

Thanks.