cancel
Showing results for 
Search instead for 
Did you mean: 

How to create Custom BO for custom table and then create segmentation profile for this CBO

arvinth
Explorer
0 Kudos

Dear Experts,

We are in yMKT 1709 SP01 on Premise.

I have one custom table : ZCUST_TABLE with 5 fields-> field1, field2, field3, field4 and field5. This table will be populated by background job.

Now I want to create CBO for this table and want to create segmentation profile/segmentation object.

I have checked below SAP link

https://help.sap.com/viewer/307cdb0f1a69422bb23b9ee426bd39f7/1802%20YMKT/en-US/482181566f2adc5fe1000...

But it is not clear. How to map the CBO custom fields structure (created in Custom Business Object App) with custom table fields? How to bring the value from custom table to CBO field?.

Many Thanks.

Kind Regards,

Arvinth



Accepted Solutions (0)

Answers (5)

Answers (5)

former_member267312
Contributor

Hi Arvinth,

Please have a look at the following help page:

Custom Business Objects

You can then load the data either via manual CSV import (Data Import app) or you have the option to generate an OData service for the CBO as described in the link I provided. Mapping would be done in either the CSV file or when sending data via Odata in a middleware such as CPI.

Hope this helps.

BR

Theo

0 Kudos

Hi Arvinth

Mapping can be done using HANA Views.
This blog article is a good starting point for your issue.
https://blogs.sap.com/2016/07/18/build-and-import-sap-hana-views-for-segmentation-in-s4hana-marketin...

It is important to download the structure of all relevant tables (contact table and cbo-table) from SAP Marketing Cloud and create them in your SAP HANA schema using the provided SQL statements.

arvinth
Explorer
0 Kudos

Dear Experts,

Please can you help me on this.

Many Thanks.

Kind Regards,

Arvinth

arvinth
Explorer
0 Kudos

Dear Theodor,

Thanks for the good link.

The SAP online help document is not more clear, it is not explaining the properties in detail.

I have one question in CBO creation.

In the structure header " Arv_BW_TEST_CBO " --> we can create fields from "Go to Fiedls and Logic" --> here we can see some predefined fields like Created On etc...

and also in the child " Arv_Test_Field " --> we can create fields from "Go to Fiedls and Logic"

What is the difference between those two and where to create my custom table & fields? My custom table structure is :

after publish this CBO where can I see data source " ZZ1_ARV_BW_TEST_CBO" and where can use this Data Source?


Many Thanks.

Kind Regards,

Arvinth

former_member267312
Contributor
0 Kudos

Hi Arvinth,

What you are showing in your screenshots is just a sub-level within your CBO. For your ZCUST_TABLE you can have the custom fields Field_1-3 on top level.

Please also refer to Custom Business Objects (Enhanced) to learn what is new in SAP Marketing on-prem 1709 (SP01).

johannes.hirling & maik.offerle kindly help Arvinth with his question how to leverage the generated OData service of the CBO.

BR

Theo

former_member245698
Active Participant
0 Kudos

Hi Arvinthkumar,

please find a nice explanation how to use OData service for a CBO here:

https://blogs.sap.com/2017/05/12/usage-of-odata-service-of-custom-business-object/

Thanks and regards

Maik

arvinth
Explorer
0 Kudos

Dear Theodor,

Thanks for the reply.

I am updating custom table fields via batch program not via CSV or OData. I am not updating this custom table using CBO. I want to use this custom CBO to read data from custom table and use it in segmentation for segmentatiuon.

What should I do in this case?.

Kind Regards,

Arvinth

former_member267312
Contributor
0 Kudos

Hi,

A CBO is a custom table and not just a custom view. If you are just replicating a custom table without the use of CBOs you might want to build a custom segmentation HANA view on top of your custom table to expose it to segmentation.

This can be a starting point:
SAP Hybris Marketing Segmentation: HANA views matter!

BR

Theo