Question Re: Error when assigning SID: Action VAL_SID_CONVERT table 0FISCPER in Technology Q&A

Error when assigning SID: Action VAL_SID_CONVERT table 0FISCPER

former_member1262147 — Mon, 21 Apr 2014 10:23:26 GMT

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.

Re: Error when assigning SID: Action VAL_SID_CONVERT table 0FISCPER

Former Member — Mon, 21 Apr 2014 10:28:21 GMT

Hi Rojay,

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

Regards

Umashankar

Re: Error when assigning SID: Action VAL_SID_CONVERT table 0FISCPER

RamanKorrapati — Mon, 21 Apr 2014 10:29:51 GMT

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

Re: Error when assigning SID: Action VAL_SID_CONVERT table 0FISCPER

former_member1262147 — Mon, 21 Apr 2014 14:25:00 GMT

Hi Umashankar,

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

Re: Error when assigning SID: Action VAL_SID_CONVERT table 0FISCPER

former_member1262147 — Mon, 21 Apr 2014 14:38:11 GMT

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

Re: Error when assigning SID: Action VAL_SID_CONVERT table 0FISCPER

KodandaPani_KV — Mon, 21 Apr 2014 14:44:31 GMT

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.

Re: Error when assigning SID: Action VAL_SID_CONVERT table 0FISCPER

RamanKorrapati — Mon, 21 Apr 2014 14:49:36 GMT

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

Re: Error when assigning SID: Action VAL_SID_CONVERT table 0FISCPER

former_member1262147 — Tue, 22 Apr 2014 01:30:15 GMT

Hi Phani,

You are right, but I have done these before.

Thanks all the same.

Re: Error when assigning SID: Action VAL_SID_CONVERT table 0FISCPER

KodandaPani_KV — Tue, 22 Apr 2014 01:44:13 GMT

Hi,

delete the data form cube again load it will work

your table T009B should be 'WK'

Thanks,

Phani.

Re: Error when assigning SID: Action VAL_SID_CONVERT table 0FISCPER

former_member1262147 — Tue, 22 Apr 2014 01:45:35 GMT

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.

Re: Error when assigning SID: Action VAL_SID_CONVERT table 0FISCPER

former_member1262147 — Tue, 22 Apr 2014 01:50:40 GMT

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.

Re: Error when assigning SID: Action VAL_SID_CONVERT table 0FISCPER

former_member1262147 — Tue, 22 Apr 2014 07:18:05 GMT

Hi all,

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

Thank you all !