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.

[former_member1262147 · Accepted solution]

Hi all,

The issue is solved, and the root cause is WK fiscal year variant maintenance error in ECC side.

Thank you all !

[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.

[Former Member]

Hi Rojay,

In tranfermation give constant value as 'WK' for Fiscal variant .

Regards

Umashankar

[former_member1262147]

Hi Umashankar,

Yeah, I have set constant value 'WK' to Fiscal variant in transformation.

[KodandaPani_KV]

Hi,

select the your source system -> right click -> select the transfer global setting -> check the fiscal variants -> select the simulation and update and rebuild tables

then try.

check the T009 you have WK.

Thanks,

Phani.

[former_member1262147]

Hi Phani,

You are right, but I have done these before.

Thanks all the same.

[KodandaPani_KV]

Hi,

delete the data form cube again load it will work

your table T009B should be 'WK'

Thanks,

Phani.

[former_member1262147]

Hi Phani,

I have tried many times to delete data from cube with not keeping SID tables, and reload date from PSA, the errors still come up.

Thanks.