on 09-20-2018 1:33 PM
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
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
Hi Arvinth,
Please have a look at the following help page:
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Experts,
Please can you help me on this.
Many Thanks.
Kind Regards,
Arvinth
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
8 | |
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.