Sync product sales text data

Product sales text can be synchronized along with the product data. To enable this functionality, follow these steps:

1. In SAP Cloud Connector, enable the RFC_READ_TEXT BAPI. This BAPI reads the sales text from SAP ERP.
2. Sign in to Zilliant CPQ with your administrator credentials.
3. From the left navigation area, select Administration.
4. From the top navigation bar, select Master Data Management.
5. Scroll or search to locate Setting Boolean and select it from the list.
6. Select SettingProductSyncDownloadProductSalesText.
7. Set the Setting Value Boolean switch to YES.

Lookup tables used for synchronization

MVKE and LANGUAGEKEYS lookup tables in Zilliant CPQ are used for the data synchronization. In those tables, sales organizations, distribution channels, and languages must have their corresponding ERP IDs.

In SAP ERP, sales text can have translations is several languages, but during synchronization, only the languages maintained in Zilliant CPQ are fetched.

MVKE table

The MVKE table contains records on product, sales organization, and distribution channel relationships. Data for this table can be synced directly from the corresponding SAP ERP tables. You can create a database view in the ERP system to filter data for synchronization.

The MVKE table consists of the following columns:

• MATNR—Product ERP ID.
• VKORG—Sales organization ERP ID.
• VTWEG—Distribution Channel ERP ID.

LANGUAGEKEYS table

The LANGUAGEKEYS table maps language keys to corresponding 2-character SAP language codes. The corresponding table in SAP ERP is T002.

The LANGUAGEKEYS table consists of the following columns:

• SPRAS—Language key
• LAISO—2-character SAP language code

Extension point for mapping languages

Use a Groovy extension point to map the user’s locale language to the sales text language. Use UserLangToTextLangMappingScript to code a custom logic for the mapping. The system runs the uploaded script to determine the sales text language. For details on the Groovy service, read About Groovy.

Sample script:

/* This script determines sales text language based on a language of a specific user. The script is run while reading the sales text in Zilliant CPQ.

 * Binding objects

*  userLanguage : String // User's language (for example, "en")

*  textType : String // Text type (for example, "SALES_TEXT")*

*/

if (textType.equals("SALES_TEXT")) {

return "en_sg";

}

return userLanguage;