on 2020 Jan 21 12:28 PM
Hello folks,
We have some reporting requirements where in to achieve this we need to convert a Key Figure to Characteristic in C4C.
This Key Figure is a KUT field which is of numeric type. Hence gets automatically created as a Key Figure in the Data Source/Report.
Is there anyway we can convert this to a characteristic?
Thanks and regards,
Nikhil
Request clarification before answering.
Hi,
You can may be try to create a another KUT field ZData_Str of type Text/String and configure a new WF rule (OnSave) to automatically copy the value from old "Numeric" field to new "String" based field and expose newly created field as reporting characteristic.
Note: if you use this approach then you may need to handle the ddelta uplaod for exoisting records either by manually changing or triggering a update via DWB.
BR
Saurabh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Saurabh,
Thank you for the response. Will this approach work for fields at Item level as well? The Numeric/Quantity Key Figure field is at Contract item level. I can create a new text/string field at Item level. However the workflow update to copy this value into the new text/string will not work for Item level fields 😞
Regards,
Nikhil
Hi,
Yes currently WF don't expose item-level fields in general. So I think in that case you need to write a small ABSL script which can then take the value from the old "Numeric" field to the new "String" based field.
Alternatively, If you integration with ECC/CRM for contracts then you can also think of doing this within CPI mapping.
BR
Saurabh
User | Count |
---|---|
22 | |
16 | |
4 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.