Product import from ERP via SLT

[SauMaris]

We have imported products from ERP to SAP Marketing using the SLT. How to get product category assignment imported together with products?

[Josef_Ehbauer · Accepted solution]

Dear All,

as mentioned by Hakan, there is no standard functionality to assign products to product categories by means of a program in the Application server backend.

In standard we offer the ODATA service API_MKT_PRODUCT to make an assignment of a product to product categories.

Alternatively one can use the fiori app "Import Data" using CSV upload.

As prerequisite, however the product hierarchy with its categories must exist in the marketing systems.

Kind regards,
Josef Ehbauer
SAP Marketing Cloud

[hakan_kose · Accepted solution]

Hi mariss. ,

As josef.ehbauer puts an end to confusion about the scope of standard functionality, I highly suggest you to swtich to IDoCs for a comprehensive and real-time integration.

You should have a MM or SD consultant in your project, consult them to get a better information about material master IDoCs in ERP. When the proper IDoC setup is established, there should be a place (function module) for you where you can call SAP Marketing product API (API_MKT_PRODUCT) with a payload that bears all the information you need. That's going to be a custom development so you're really free to select whatever information you need about products.

IDoC's are even used in products integration for the standard integration packages of SAP ERP integration with SAP Marketing Cloud in SAP Cloud Platform Integration. We used IDoCs in one my on-premise projects to extract sales orders from SAP S/4 HANA and it really served us well.

I hope this helps

Regards,

Hakan Köse

[hakan_kose]

Hi Maris,

You imported products from SAP ERP via report CUAN_PRODUCT_MASTER_EXTR_FULL, right?

If so, you're right, this program derives only basic material information without production category assignments (I just checked the source code)

There's no other dedicated standard program related to products integration as per my knowledge, so I say you're right to create a support ticket for this.

Before you create a support ticket, though, I'd like to hear if this is part of standard functionality or not

Any ideas? theodor.lungstras chakita anton.peters

[former_member267312]

sophie could you kindly help with an answer to Mari's and Hakan's question? Thanks!

[SauMaris]

Hakan,

you are right. I used CUAN_PRODUCT_MASTER_EXTR_FULL.

Not only it does not have any product category (basic material group) assignment from the MARA table, it also is using leading zeros, which look ugly.

Another thing, there is no delta report, but I am assuming that same CUAN_PRODUCT_MASTER_EXTR_FULL can be used with "changed on" date selection.