Segmentation based on Infosets and infoset coding

[Former Member]

Hello experts,

It is known that we can use marketing attributes, infosets, BI cube and external list management. Our requirement is to segment customers according to their orders' total gross value, net value and numbe of transactions (for example number of visits that are performed for each customer).

I think we should use here infoset in order to realize this segmentation in SAP CRM. I have created infoset by joining CRMD_ORDER_INDEX and CRMD_PRICING_I. In addition I have added new field into infoset called BP_GROSS (to indicate gross value per BP), written a code in order to retrive data tables and calculate the total gross per BP and write it into additional field.

However we couldn't create a target group by indicating BP_GROSS field (addtional field of infoset). I guess we have problem with coding on infoset. (same code works in ABAP editor-se38)

What might be the reason? Is the syntax in infoset different from ABAP editor or how can we append the total sales into our additional fields? Or should we follow another way in order to segment customers according to their sales order gross value? Any idea?

Thanks in advance.

M.

[Former Member]

Calculation of gross values is usually something that is done in a BI report. It would be much easier to create such a report and then refer to it as a data source.

I do not know how you implemented exactly the gross value calculation, but the infoset query usage for a datasource only reads the values that are on the database / visible in SQ01 when executing the infoset query. If you are writing the values down to the DB with the appropriate BADI you should not encounter the problem you mention.

Hope this helps,

Kai