Fund - Fund Center mapping

[Former Member]

Hi all,

When Fund 1 is mapped to Funds center A and there have been several postings made to this combination and then the Funds Center is changed from FC A to FC B on Fund 1, then do we have to manually repost the old transactions to the new Funds Center?

Do postings occur on the Fund or on the Fund-Fund Center combination?

Has any one else encountered this scenario wherein an incorrect fund center was mapped to a fund and then had to be rectified?

Please help.

Thanks.

AJ

[mar_novalbos · Accepted solution]

Hello AJ

Wrongly assigned documents can be changed by using the standard reassignment tools. See the online help:

[http://help.sap.com/saphelp_erp60_sp/helpdata/en/b3/fa3a95ecd9465c82957992e30e1ff2/content.htm]

Under 'Recording Actual and commitment data -> Reassignment' you will find out how to do it.

You may have to change your derivation strategies in order to map the new Funds Center.

Postings will occur on the combination of the complete account assignment (i.e. commitment item + fund + funds center)

I hope this will help you.

Cheers

Mar

[Former Member]

Hi Mar and other experts,

Is the reassignment option relevant only for the multiyear budget execution scenario?

If that is the case, then how do we change FM account assignments (primarily the fund center) on existing documents.

As mentioned above, in our case, we have a lot of postings that have the incorrect fund center on them (because the wrong fund center was mapped to the fund). How do we change these documents (actual, commitments etc) to reflect the correct fund-fund center combinations?

PLEASE HELP!!!

Thanks.

AJ

[Former Member]

Hi Eli / Mar / Minghong / Others,

Can one of you please explain how exactly reassignment works? Our scenario is similar to the one described by AJ above. I am not really clear how to design the deriv. strategy for reassingment. If you need to reassign (change) only one account assignment (e.g. funds center) do i just have one derivation rule that replaces the funds center based on the master data mapping?

Also, what is the FMCG transaction for? What is the tr. FMCT for? Do you execute FMCG and then FMCT? How does this tie in with closing?

Does anyone have a step by step process document for reassignment?

Mar - in your response you mention " 'Recording Actual and commitment data -> Reassignment' you will find out how to do it" where is this? can you send a hyperlink or provide more details.

Please take time to respond to this query. I really appreciate it.

Thanks a lot in advance....

PSM

[iklovski]

Hi,

No need to shout for HELP!!!!! We can hear you...

Reassignment has nothing to do with multi/single-year; it could be done for both scenarios.

Please, read the material on the links Mar has provided. You can reassign document either in chain (FMCB) or by value type (FMCG) imposing the reassignment strategy.

Regards,

Eli

[Former Member]

Thanks Eli, as always.

So i guess, i first need to design a derivation strategy. Since only funds center needs to be changed in our case, will i have only one rule in the deriv. str?

Also after i execute FMCG, do i have to execute FMCT next? or is just FMCG enough?

Please let me know.

Thanks again

[iklovski]

Exactly: define a strategy (do not forget to assign it to FM area), then FMCG (to create a worklist) and finally FMCT (to execute the reassignment).

[Former Member]

So, will I have only one rule in the derivation strategy?

A function module that reads fund master data, have the source field as the Fund and target field as the 'Target Funds Center'?

I tried this and it does not seem to work.

Example: I had fund 1 mapped to Funds center 'A' originally. I changed it to FC 'B'. Now when i test the deriv. str using Fund 1, it derives Funds center A and not B. What am i missing? I even have an initialization step before this - that didnt help either.

Let me know.

AJ

[iklovski]

Hi,

Where do you define derivation strategy? It should be in FMYC transaction... Make sure that you define it correctly posing the SOURCE and TARGET fields in their place. Make sure that you overwrite the value with your TARGET field (fund centre). When you say 'testing', do you mean FMCG?

Regards,

Eli

[Former Member]

Thanks for your prompt responses Eli - I really appreciate it.

Yes - I created the deriv. str in FMYC; assigned it to the FM area. Here are the two steps i have:

a. Initialization of the target funds center field.

b. Function module 'Read fund master data'. In this one, the source fields are the source_fund and fm area. The target field is target_funds center which is selected to 'overwrite with new value'.

By test, i mean testing the derivation strategy and checking the before and after values.

What am i doing wrong? Again, my req is to change the funds center to the funds center currently mapped in the fm master data. But in test mode, it seems to be pulling in the old funds center.

Thanks again,

AJ

[iklovski]

A function module? Do you mean FMDT_READ_MD_FUND? But what field do you map as Fund centre via this module?

I would simply create a simple derivation rule putting fund as source and fund centre as target. Then, fill the values and that's it.

[Former Member]

Thanks a lot Eli!!!! That seems to be working.

A

[Former Member]

Hi again Eli,

I ran FMCG for one fund / fund center. It generated one document. When I then run FMCT, however, i get the following error:

FM account assignment - cannot be posted in posting ledger 9A

Message no. FMBS123

The check of the budget structure ended with the return code 4.

Return code 4:

The derivation strategy used for deriving the budget address from the posting address derives an invalid budget address. You can use the program for displaying of budget structure settings to find out which derivation strategy is used. Check the Derivation Strategy for Budget Addresses in Customizing. This error may also be caused by inconsistent customizing of active FM account assignment elements in BCS and FM. This can be checked in IMG activity Activate Account Assignment Elements in Budget Control System.

We do not have a deriv str for budget addresses. All other fields in the document (Receiver commitment item, receiver funds center, receiver grant etc.) seem to be correctly filled.

Can you please tell me how this can be fixed?

Thanks a lot.

AJ

[iklovski]

Hi,

Apparently, you are working with budget structure in your system. In this case, when you reassign to new FM objects, the combination of these objects (fund centre, commitment item, fund, etc.) should be defined as posting address (FMBSPO - Individual Processing).

Regards,

Eli

[Former Member]

That is what is wierd - we do not use budget structure. All settings pertaining to the budget structure (Define settings for budget structure, define deriv. str for budget addresses, etc) are all BLANK (they just have the standard SAP settings - nothing specific to our client).

I did find note 627165 that deals with this issue - this is an old note and we have upgraded since this note. So i am not sure if we should implement it.

Any thoughts?

AJ

[iklovski]

What update profile do you have?

[Former Member]

Update profile 102

[iklovski]

Hi,

If you are absolutely sure that no budget structure is defined in your client, you'd better open OSS message as this error should not come in the first place.

Regards,

Eli

[Former Member]

Hi Eli,

I checked the "Create budget structure" and "Define settings for budget structure" both only have the standard SAP setting for FM area 0001. This to me tells me that budget structure is not being used - correct? Or do I need to see other areas to make sure.

Please confirm.

AJ

[iklovski]

I guess, that's it.

[Former Member]

Hi Eli and Others,

For the FM reassignment tool, is there a way to select documents for reassignment? I know you can select by value type, FM acct assignments etc in FMCG - but of the documents that are listed based on the selected criteria, is there a way to further select only few documents to reassign? Please advise.

Thank you,

AJ

[mar_novalbos]

Hi,

Have a look at t-code FMCN and technical program documentation. After FMCN, you will have to run FMCT too

cheers

Mar

[Former Member]

Hi Mar,

Thanks for your response.

I tried t-code FMCN. I used the selection criteria to pull up 10 documents. Of these 10 documents, I want to reassign only 7. I wasnt sure how to do this through FMCN. I did not find any option of selecting from the worklist. Can you tell me how this can be done? Or if there is an option that i am missing.

Thanks.

AJ

[mar_novalbos]

Hi

You should either make a more restricted selection (by entering your 7 documents, or defining other doc number intervals..) or you can also use the tool to delete documents from the worklist : transaction FMCD

cheers

Mar