Data Source for Sales Order ID in Marketing

[Former Member]

Hello Experts,

We are loading sales order into marketing cloud successfully from C4C, attributes like product id, name, amount, quantity etc..are using in segmentation from the different data source like SAP_CE_IC_COMPANY_SALES_DATA etc..,

Now the issue is I am not able to find the attribute for Sales order Id in any of the data source which I loaded in segmentation configuraction.

please help me to provide the data source name and attribute name to keep sales order id in my segmentation.

Thanks in advance,

regards,

Sudhakar Y.

[edgardc_rodrigues]

Thank you Saurabh for the response, I will test it.

Best Regards,

[edgardc_rodrigues]

Hi Experts,

I have a scenario where I´m replicating Corporate Accounts from C4C to SMC, these accounts are being saved with the Data Origin = SAP_MKT_BUPA. I´m also creating Opportunities in C4C and replicating to SMC, these documents come with the Data Origin = SAP_C4C_BUPA. I understand that this Data Origin determination is working by default, and it´s ok.

However, I have to bring the Sales Orders from ECC (I didn´t find a standard way to bring it from C4C...is there how to do this?). The Sales Order that are coming from ECC are with the ID_ORIGIN: SAP_ERP_CUSTOMER (for partner), so the Order is not connected to the correct partner (since different Origin ID don´t Merge), and it is saved as a anonymous interaction.

Could you please help me to find the best approach to integrade de Sales Order in SMC and connected it with the correct partner? Is it possible change this ID_ORIGIN for partners in Order integration from ERP, modifing the iflow or using a BADI?

Thank you,

[former_member226]

Hello,

First of all Data Origin determination is not working by default but rather it is configured as part of CPI iflow mapping when transferring the data from SOAP/OData-based channel from C4C to SMC.

May be you can check if BADI "Find Interaction Contact" of context "Marketing: Contact and Corporate Account" could be used. Here you can write a small logic that says if the imported interaction is SALES_ORDER and ID_ORIGIN is SAP_ERP_CUSTOMER then assign it to an existing contact with SAP_C4C_BUPA ID Origin and respective ID.

[Former Member]

Hi Saurabh,

Many thanks for your hint, I will check this

[former_member226]

Hi,

Did you check SOURCE_OBJECT_ID field of segmentation attribute? This should contains the Sales Order ID from the C4C/ERP system.

https://my30XXXX.s4hana.ondemand.com/sap/bc/ui5_ui5/ui2/ushell/shells/abap/FioriLaunchpad.html#SegmentationConfiguration-maintain&/ChangeSegObject/Attribute/(ApplicationId='SAP_ADT',SegmentationObjectId='SAP_CE_CONTACT_ENGAGEMENT',DataSourceAlias='SAP_CE_IC_CONTACT',AttributeName='SOURCE_OBJECT_ID')

[Former Member]

Hi Sudhakar, hi Silvia,

I have the same challenge. I got order details from the ERP System, but I have no clue how to map/connect the data to use it for segmentation.

In yMKT I can see the order details like OfferID/PromotionID but how I can use this existing Informations in the Segmentation engine?

Best regards,
Marco

[silviabackes]

Hi Sudhakar, Have you checked the interaction data?

Kind regards,

Silvia