Splitting on customer defined fields in Grants Management

[Former Member]

Hi All,

I am implementing a grants management solution where funds are drawn down from the sponsor using resource related billing based on payments. As part of the reporting to the sponsor we are required to report information from the grants management ledger (payment documents) with information from a third party system which triggered the initial expenditure against the grant. The join between the information is a reference number passed from the interfaced system.

My solution is to put the reference number in a customer field in the coding block and have updated the GM field movement to populate the field in GMIA. I would like to put this field in the splittng rules in grants management so that for the reporting to sponsor can be a straight forward join on the interfaced system and the data from payments in GMIA (rather than splitting in the general ledger then joining GMIA, flex GL data and the interfaced system).

The fields which can be used in splitting in GM seem to be a predefined list. I have traced this in debug and found a function module GM_SPLIT_T8G40_FIELDS which is defining the list of fields availale and translating the the field name. Any field for which it cannot find a new field name in this function module is being deleted from the list of valid fields. Therefore, customer fields are deleted from the available fields for splitting.

Can anyone suggest a way around this?

Kind regards,

Geoffrey

[Former Member]

Hi Geoffrey,

Interesting problem.

I haven't found a way to do it.

Can you derive this customer field to the sponsored program and use it for splitting, or is the sponsored program used for standard functionalities?

Regards,

Shahaf

[Former Member]

Thanks,

Unfortunately we have the sponsored program in use for a different purpose.

If we cannot split the customer fields in GM, is it possible to specify that the field movement from GL to GM is based on the split information in the GL rather than the entry information in the GL (i.e. we can split based on the filed in the GL and do a field movement into GM). Any ideas on whether this is possible?

Cheers,

Geoffrey

[Former Member]

Hi Geoffrey,

Please elaborate regarding your idea. I'm not sure I understand it fully.

Did you try contacting SAP regarding the splitting through additional fields?

Regards,

Shahaf

[Former Member]

OK, it's something along the lines of:

Vendor Invoice posted in GL:

Entry view:

CR Vendor 1000 GBP

DR Expense/Customer field A 600 GBP

DR Expense/Customer field B 400 GBP

GL View (splitting on customer field):

CR Vendor/Customer field A 600 GBP

CR Vendor/Customer field B 400 GBP

DR Expense/Customer field A 600 GBP

DR Expense/Customer field B 400 GBP

GM document (not possible to split on customer field)

Value type 54 CR Vendor 1000 GBP

Value type 99 DR Expense/Customer field A 600 GBP

Value type 99 DR Expense/Customer field B 400 GBP

Payment Posted:

GL Entry Veiw

DR Vendor £1000

CR Bank Clearing £1000

General Ledger View (split on customer field)

DR Vendor/Customer field A 600 GBP

DR Vendor/Customer field B 400 GBP

CR Bank Clearing/Customer field A 600 GBP

CR Bank Clearing/Customer field B 400 GBP

GM Document (not possible to split on customer field)

Value Type 54 DR Vendor £1000

Value Type 57 CR Bank Clearing £1000

In GM, there is no link back to the values in the customer fields when the payment is made as the field movement from GL to GM is based on the line items and values in the the entry view and not the split general ledger view. If the split GL data were used to populate the GM tables, then the data would already be split by the customer field by the time it reaches GM, negating a need to split on the customer field once in GM.

It still feels, however, that the simplest solution would just be to have the GM ledger split by customer fields. I have tried raising a customer message with SAP, but this query falls outside of their support remit.

Kind regards,

Geoffrey

[Former Member]

Hi,

I see what you mean.

Try contacting the SAP development team and aske them directly, or perhaps try to create a development request.

As a workaround there may be another option.

I noticed that for the split processor the following fields are available:

AUFNR Order

GEBER Fund

FISTL Funds Center

FKBER Functional Area

FIPOS Commitment Item

GRANT_NBR Grant

SPONSORED_CLASS Sponsored Class

SPONSORED_PROG Sponsored Program

GSBER Business Area

KOSTL Cost Center

PRCTR Profit Center

PS_PSP_PNR WBS Element

Are you using the Functional Area field?

If not -you can try to derive it in the FM Derive BAdI, and then it is supposed to be available for the GM split processor.

The down side of this option, is that you'd have to create the master data of the Functional Area in advance so it can be derived.

Never tried it, though...

Good luck,

Shahaf