cancel
Showing results for 
Search instead for 
Did you mean: 

Limiting Subitem Field Length

can_erdogan
Explorer
0 Kudos

Dear Experts,

In our case of Group reporting implementation, one subitem category is linked to Functional Area. The client is using 8 digits for the functional area field, but for Group reporting/External reporting purposes they only need the first five digits of the values. Instead of using reporting rule ranges or functional area/subitem hierarchies to group these 8 digit FA values into 5 digit value reporting items/nodes, is it possible to restrict the values that are populated in Group reporting to the first 5 characters?

I tried changing the field length of the subitem category to 5 and creating the corresponding 5 digit subitem, but that did not work.In ideal scenario, it would be great to have 5 digits in the subitem and full 8 digits in the functional area field populated, but I understand that may be a reach.

Any suggestions?

Thank you

Can Erdogan

Accepted Solutions (0)

Answers (1)

Answers (1)

Florian_Roll
Advisor
Advisor
0 Kudos

Hi Can,

option you could explore:

- define the field length in the subitem category. Note you have to remove the sender field "functional area" in this case which defines the sender field of accounting for the subitem.

- if you have company codes to integrate with the release task, make use of GRPL, group reporting preparation ledger which comes with more flexibility in group field derivation. Assign functional area to subitem there and pick the first 5 characters by making use of the new substring() function.

I did not test this... Let us know if this worked for you.