Custom CRM Infoset for segmentation

[Former Member]

Hi All,

For the segmentation none of the standard info sets( these are not BI infosets.But these are the infosets that pull data from the crm master tables) provided by SAP are useful so i need to create custom infoset. In tcode sq02 i have created the custom infoset with tables,checked the join condition and save it.

I created data source and attribute list using the custom infoset.

But when i created the target group from graphic modeler the contacts not being pulled.I need the contact person info customer group,department,bp role,function.

Can anyone please help with the issue.

Any input will be appreciated and awarded.

Thanks,

SP

[Former Member · Accepted solution]

Hi S P,

Here is some information which might help.

For creating and using infosets for "Attribute list" you have to do the following steps:

1) Create User Group – SQ03

2) Create Infoset – SQ02

3) Assigning User Group to Infoset – SQ03

For details click on the link: http://www.erpgreat.com/abap/step-for-using-query-sq01-sq02-sq03.htm

Next step, for the Data source check whether this entry is maintained i.e. Details -> Business Partner -> BUT000-PARTNER_GUID

In my view, the Target group you are trying to create for Business partners, BP role should be "Contact person" and other attributes would be customer group, department and function. Here for "BP role:  Contact person" information can be found in Tables: BUT050 & BUT051

You may have done these steps, but I have listed them for your reference, just in case you missed any one of them.

If you need further help then provide me with more information for the infosets or screenshots and I'll try to help.

Thanks

[Former Member]

Hi,

Please use function module CRM_MKTTG_PF_BP_TAB_TO_CP while creating your data source.

You can use the standard infoset or custom infoset. This FM will pull the contacts from accounts.

Regards,

Sunil

[Former Member]

Hi Sunil.

Thanks! for responding.I have used the FM when creating the datasources.

I did the sq02 but i didn't assign the user groups in sq03 specified by pankaj.I have to try it.

thanks,

SP