FMDerivation Rule Error

[sam_m6]

Hello Eli and other experts,
We have a FMDerivation rule to derive Functional Area and Funded Program by Funds Center.
This rule is to derive specifically for one Fund Type where the FA and FP is static and this was working fine until now for (AP invoice / PO Cost Center based).

Source Field
Funds Center - 100001 - 100075

Target Fields

Functional Area = 2018FunctionArea (do not overwrite if field already filled)

Funded Program = ABCFundedPrg (do not overwrite if field already filled)

Now as New Fiscal Year approaches, there is a new Budget period and with new 2019FunctionArea, so the rule was changed to derive FA and FP with the new Budget Period. With new rule FA and FP not deriving.

Source Field

Funds Center - 100001 - 100075

Budget Period = 2018 -2018

Getting : Derivation not performed. Reason: Source field contains no value for Budget Period field empty in Trace

Funds Center - 100001-100075

Budget Period = 2019 - 2019

Target Fields
Functional Area = 2019FunctionArea (do not overwrite if field already filled)

Funded Program = ABCFundedPrg (do not overwrite if field already filled)

Was able to post AP invoice (FA and FP gets derived after pressing Enter button twice.) For PO based able to derive in second pass in trace but PO fields not getting updated.

Need your input where the issue could be.

Thanks,

Sam.

[iklovski]

Hi,

I don't get your problem. When you descrived your rule, you mentioned that you derive funded program and functional area based on fund centre. So, why do you mention 'budget period' afterwards? Do you actually used 'budget period'? Don't confuse beween calendar period, and 'budget period', which is an FM assignment object, like 'funded program', for example.

Regards,

Eli

[sam_m6]

Eli: Thanks for your response.

Yes we use Budget Period. Since new Functional area has been arrived for 2019, we added Budget Period as source field to differentiate between 2018 and 2019.

Regards: Sam.

[iklovski]

OK, suppose, you want to use it. But, how is it derived and/or introduced?

You have to understand that 'budget period' is a separate FM assignment object and its usage cannot be justified just by changing a year. If you want to distinguish your derivation rule based on a year, you have to incorporate the parameter of 'posting date' into your derivation strategy and that's all.

[sam_m6]

Yes you are correct, we are deriving the Budget Period by Posting date only.

There are 2 Functional Area's one it was used for 2017/18 Budget Period, the second one for 2019 Budget period.

Once the Budget Period is derived based on Posting date, based on the Budget period the Functional area should be derived. During Trace Budget Period is getting derived but not the Functional Area.

Regards: Sam.

[iklovski]

Why won't you derive also Functional area by posting date? Why complicate with Budget period?

[sam_m6]

Can somebody shed light on to it.

Thanks,

Sam.

[sam_m6]

Hello Tammy:

Thank you for your quick response.

Yes I did the trace and getting the following:

Source Field

Derivation not performed. Reason: Source field contains no value for Budget Period field empty in Trace even i have maintained the values in rule. (Screen prints above)

Funds Center - 100001

Budget Period = (blank)

Also Target fields set be overwritten with the new values

Thanks,

Sam.

[TammyPowlas]

Sam - please turn on the trace tool as outlined here https://wiki.scn.sap.com/wiki/display/ERPFI/FMDERIVE+-+Trace+tool - it should help debug the issue