FM Account Assignments not derived in PM Order

[muhammad_waseem]

Dear Experts,

I am trying to establish FM derivation at time of PM Order creation in IW31.

I filled the 'Responsible Cost Center' field (KOSTV) in IW31 under the tab "Additional Data" along with other maintenance order related data.

We already have a derivation rule (Cost Center = Funds Center) working fine for all other transactions. However no FM account assignment is deriving for IW31.

All FM account assignment fields are set as 'Optional Entry' with object type 03 in SPRO node "Maintain Field Status for Assigning FM Account Assignments" as per note 1268001 (section 2).

Following are the two different approaches i have tried in FMDERIVE:

A- Function module FMDT_READ_ORDER_PM_FROM_FMZUOB activated as below:

B-

i. Function Module FMDT_READ_MD_ORDER activated as below:

Target Fields:

ii. Derivation Rule as:

The Commitment Item is already being derived for all other transactions from GL master using the function module FMDT_READ_MD_ACCOUNT_COMPANY but not for IW31.

Note: In FM trace, nothing is being picked up in source fields probably because order number is not generated and above derivation strategies depend on order number availability. So I saved order and also released it. Then in IW32, I checked trace again but still source fields are blank.

Please guide how to overcome this issue. Is there any different approach which may help in deriving Fund, Funds Center and Commitment Item?

Requesting guru eli.klovski for helpful insight.

Regards,

[iklovski]

Guru to Muhammad 🙂 : what is your SAP release?

[muhammad_waseem]

Hi Eli,

Of course You are Guru 😉

The release is S4HANA ON PREMISE 2020 02 (05/2021).

Regards,

[iklovski]

Hi Muhammad,

Can you check if your settings are compliant with recommendations of note:

2984564 - Error FI135 - FM account assignment is incomplete

Regards,

Eli

[muhammad_waseem]

Hi Eli,

I have checked the note completely, all suggested settings are already in place.

All FM account assignment fields are set as 'Optional Entry' with object type 03 in FM-PM integration node.

Regarding derivation rules and Function module FMDT_READ_ORDER_PM_FROM_FMZUOB same settings are already done (as explained with screenshots above).

Regards,

[iklovski]

Sorry, too busy to look at the forum 🙂

Let me ask you this: if you activate a trace in FMDERIVE and then try and create the order in IW31, does the system go into it? According to what you say - yes. But then, are there any fields filled at all? Can you show the screenshot from FMDERIVE panel, when the trace is on?

[muhammad_waseem]

Dear Eli,

No problem at all, I understand 😉 Let me explain the system behavior upon saving the order in IW31.

It is not deriving anything from the source fields of Function modules FMDT_READ_ORDER_PM_FROM_FMZUOB or FMDT_READ_MD_ORDER. I may safely assume, system is not reading these FMs or even any other custom derivation rules I tried to get read during processing of IW31.

I have attached the FM Trace screenshot for your review.

You may notice:

1. Funds Center is being derived based on Cost Center but this derivation is due to the reason that I assigned Cost Center in master data of Functional Location (t-code: IL02). Same functional location is assigned in Order master so Cost Center is being read from Functional Location Master and subsequently Funds Center from Cost Center master data. Cost Center = Funds Center derivation rule is working this way.

2. As highlighted in screenshot, Cost Element and Commitment Item both fields are blank in trace. Our objective is to read the Commitment Item based on the primary Cost Element, which system is fetching from Valuation Class given in Material Master (OBYC transaction GBB). You can see this Cost Element in Order master tab "Costs", click on button "Rep. Plan/Act" and following screen will show it.

If you need further explanation of the scenario, please do let me know.

Regards,

[iklovski]

So, fund centre is well derived... it has been a while since I was in a project where they created PM orders, but in any case, FM you mentioned would read pre-derived or manually introduced values, but won't be able to derive them from the scratch, though :(. If I recall well, you might consider using EXIT_SAPLFRC4_001 to enrich your account assignment in PM order.

[muhammad_waseem]

Hi Eli,

Thanks very much, I yet have to try the user exit you suggested.

Recently I also raised OSS ticket for the same and today I got following the response:

"When creating a Stock PM order, there is no budget associated with the transaction. Therefore, there is no GL Account assigned and the Commitment Item is not derived. If you want to have a Commitment Item, you will need to assign one for Stock PM orders".

So I guess, the only functional solution is manual assignment of Commitment Item.

Regards,

[iklovski]

Yes, that's unfortunate 😞 Indeed, you wouldn't have any other choice, I'm afraid. Unless, of course, you engage yourself in some development 🙂

[muhammad_waseem]

Hi Eli,

Some good news to update for knowledge sharing mutually and for anyone visiting SCN in future for same requirement.

I have been able to achieve the objective without any customization, just with a little modification in derivation strategy.

Here is the logical sequence of finalized steps:

1. Table Lookup: AUFK

2. Derivation Rule : Cost Center = Funds Center (To read Funds Center from Cost Center, that is, already read in above Table Lookup).

3. Function Module: FMDT_READ_MD_ACCOUNT_COMPANY (To read Commitment Item from Cost Element Master)

Note: System still does NOT read Cost Element during PM Order creation in IW31, hence no derivation of Commitment Item. It derives only Funds Center as per previous understanding. However, Commitment Item derivation does happen at time of Goods Issuance in MIGO (with Movement Type 261) which is fine for business user. Similarly, Fund is also derived in MIGO posting.

Regards,