Skip to Content
0

Hybris Marketing Products and Product Categories

Apr 13, 2017 at 08:44 AM

532

avatar image
Former Member

Hi All,

When i tried to import products in a form of csv using Import Data application, those products weren't in HANA (table CUAND_CE_IA_PROD), even though inUI I got "successful import" message. Can you please help me if anyone faced similar situation and how this was resolved?

Firstly I imported product categories. I am also interested if anyone knows in which table in HANA can i find product categories?

Thanks,

Ana

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
avatar image
Former Member Apr 14, 2017 at 12:29 AM
2

Table CUAND_CE_IA_PROD is used when you import Interactions that contain products.

The Product Master can be found in the following tables:

  • CUAND_PROD_CATEG Product Category - #GENERATED#
  • CUAND_PROD_DESC Product Name and Description - #GENERATED#
  • CUAND_PROD_FACET Product FACET - #GENERATED#
  • CUAND_PROD_FDESC Product Facet Name and Description - #GENE
  • CUAND_PROD_ROOT Product ROOT - #GENERATED#
  • CUAND_PROD_TOCAT Category Assignment - #GENERATED#

Please have a look at CUAND_PROD_ROOT, this one should be used when you use "Import Data" for Produtcs.

You can also check CUAND_PCAT_DESC to see whether your product categories were imported successfully.

Show 9 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Komur,

Thank you, your answer was very much helpful!

Do you know is there a documentation that covers Hybris Marketing related HANA tables?

BR,

Ana

0

Hi Ana,

Matthias Reiner shared a data model on this blog post, it contains most tables.

https://answers.sap.com/questions/339728/where-can-i-find-a-data-model-for-hybris-marketing.html

Kr,

Joyca

0
Former Member

Dear Ana,

I haven't found any such information yet.

I typically use se16 (or debugging) to find the tables I am looking for when working with Hybris Marketing.

Mostly CUAN* related tables/transactions are for Hybris Marketing

Regards,

Akil

0

Dear Komur,

I am working on HM On-premises 1702 .

I imported interaction contact in a form of csv, and check all the tables you have mentioned related to the products, I can see that all of them are populated and related, but not the table "CUAND_PROD_TOCAT".

I did a test loading the interaction contact file populating the "interest" field and only these information appears in the table "CUAND_PROD_TOCAT" .

My first doubt is why all the product master are populated but not the "CUAND_PROD_TOCAT".

The second doubt is what is the relationship between the products and the interest items.

I would appreciated your orientation regarding this .

Regards,

Belén.

0
Former Member
Belen Paladino

Dear Belen,

When you import interactions using CSV you are not able to upload products! For on-premise you have the following options:

1) create ABAP report to upload custom CSV which can include your products

2) Use OData to upload interactions containing products

these should popiulate CUAND_CE_IA_PROD, however to upload the products themselves, please use import data for Product Categories and Products. These two actions should populate the above-mentioned tables.

With regards,

Akil

1

Hi,

There's one other option in on-premise:

Standard ABAP report CUAN_CREATE_INTERACTION also allows to add products to your interaction.

But you can only post one interaction at a time with this report (so no mass upload of hundreds of sample interactions like you could with csv.).

1

Dear Kommur and Joyca,

Thank you so much for your answer. I've followed all the steps you've indicated and my products and categories were created. I've verified the tables and i saw that all the tables were populated but not the one who contains the relationship between product and category :

" CUAND_PROD_TOCAT Category Assignment - #GENERATED# " Empty

  • CUAND_PROD_CATEG Product Category - #GENERATED# OK
  • CUAND_PROD_DESC Product Name and Description - #GENERATED# OK
  • CUAND_PROD_FACET Product FACET - #GENERATED# OK
  • CUAND_PROD_FDESC Product Facet Name and Description - #GENE OK
  • CUAND_PROD_ROOT Product ROOT - #GENERATED# OK

As this page indicates the relationship between the product and the category only can be generated using Data Services :

https://cp.hana.ondemand.com/dps/d/preview/3f07b8545988b409e10000000a423f68/1603%20500/en-US/fcddd25536e98809e10000000a441470.html.

Regarding the relationship between INTEREST ITEM and PRODUCT i still don't understand it.

There is no customizing configuration for Interest item, it must created in the user interface. I've created and uploaded the interest file and category and this table was populated: "CUAND_PROD_TOCAT"

Could you please help me to understand the relationship between interest item and product, and their relationship between these and the category assignment?

With regards,

Belén

0
Former Member

Dear Belen,

below is the information from SAP in the Administration Guide 1711 - Manage Interests at: https://help.sap.com/viewer/ac1eab4c66bc490da7ac2c378c46b0e7/1711%20500/en-US/cffbc054daea6474e10000000a44538d.html

1

Dear Komur,

I appreciate a lot your help. I will read the information.

Regards,

Danitza

0