MFG Salesforce Products System API - Implementation Template
Data mappings
This document provides information generated from the DataWeave scripts included in the project, such as function definitions, variable definitions, and data mapping tables.
| Module | Description |
|---|---|
| assign-pricebookentry-records | Global and Standard Pricebook Entry Records Assign Mapping |
| create-pricebookentry-request | Pricebooks Create Mapping for Manufacturing Cloud |
| create-product-category-request | Product Category Create Mapping |
| pricebook-entries-select | Pricebooks Query Mapping for Manufacturing Cloud |
| pricebook-put-pricebookentrybody | Pricebooks Create Mapping for Manufacturing Cloud |
| product-image-prepare-entries-to-be-created | ProductMedia Create Mapping for Manufacturing Cloud |
| product-media-select | ProductMedia Query Mapping for Manufacturing Cloud |
| product-primarycategory-select | ProductCatalog Query Mapping for Manufacturing Cloud |
| product-response-get | Product Query Mapping for Manufacturing Cloud |
| product-var-put-payload | Product Upsert Mapping for Manufacturing Cloud |
| search-products-response | Product Query Mapping for Manufacturing Cloud |
| update-pricebookentry-request | Pricebooks Update Mapping for Manufacturing Cloud |
assign-pricebookentry-records
Global and Standard Pricebook Entry Records Assign Mapping
Source:
./src/main/resources/dwl/assign-pricebookentry-records.dwl
create-pricebookentry-request
Pricebooks Create Mapping for Manufacturing Cloud
Source:
./src/main/resources/dwl/create-pricebookentry-request.dwl
Mapping Tables
Maps CIM PricebookEntry to Manufacturing Cloud PricebookEntry format
| Manufacturing Cloud | CIM | Description |
|---|---|---|
| IsActive | true | Indicates whether or not the pricebookEntry is active |
| Pricebook2Id | Pricebook2Id | The id of the pricebookEntry |
| Product2Id | productId | The id of the product |
| UnitPrice | unitListPrice | The unitListPrice of the pricebookEntry |
create-product-category-request
Product Category Create Mapping
Source:
./src/main/resources/dwl/create-product-category-request.dwl
pricebook-entries-select
Pricebooks Query Mapping for Manufacturing Cloud
Source:
./src/main/resources/dwl/pricebook-entries-select.dwl
Mapping Tables
Maps Manufacturing Cloud PricebookEntry to CIM PricebookEntry format
| CIM | Manufacturing Cloud | Description |
|---|---|---|
| id | Pricebook2Id | The id of the pricebookEntry in Manufacturing Cloud |
| unitListPrice | UnitPrice | The unit price of the pricebookEntry in Manufacturing Cloud |
| auditInfo.createdBy | CreatedById | Identifies the system or user which created the pricebookEntry entry |
| auditInfo.createdOn | CreatedDate | Timestamp of when the pricebookEntry entry was created |
| auditInfo.updatedBy | LastModifiedById | Identifies the system or user which last updated the pricebookEntry entry |
| auditInfo.updatedOn | LastModifiedDate | Timestamp of when the pricebookEntry entry was last updated |
| auditInfo.isDeleted | IsDeleted | Indicates whether or not the pricebookEntry has been soft-deleted |
pricebook-put-pricebookentrybody
Pricebooks Create Mapping for Manufacturing Cloud
Source:
./src/main/resources/dwl/pricebook-put-pricebookentrybody.dwl
Variables
var s
Maps CIM PricebookEntry to Manufacturing Cloud PricebookEntry format
Mapping Tables
Maps CIM PricebookEntry to Manufacturing Cloud PricebookEntry format
| Manufacturing Cloud | CIM | Description |
|---|---|---|
| IsActive | true | Indicates whether or not the pricebookEntry is active |
| Pricebook2Id | Pricebook2Id | The id of the pricebookEntry |
| Product2Id | productId | The id of the product |
| UnitPrice | unitListPrice | The unitListPrice of the pricebookEntry |
product-image-prepare-entries-to-be-created
ProductMedia Create Mapping for Manufacturing Cloud
Source:
./src/main/resources/dwl/product-image-prepare-entries-to-be-created.dwl
Variables
var s
Maps CIM ProductImage to Manufacturing Cloud ProductMedia format
Mapping Tables
Maps CIM ProductImage to Manufacturing Cloud ProductMedia format
| Manufacturing Cloud | CIM | Description |
|---|---|---|
| ProductId | productId | The product code of the product to be updated |
| ElectronicMediaGroupId | ElectronicMediaGroupId | The Electronic Media Group Id of the Product image |
| ElectronicMediaId | ElectronicMediaId | The Electronic Media Id of the Product image |
product-media-select
ProductMedia Query Mapping for Manufacturing Cloud
Source:
./src/main/resources/dwl/product-media-select.dwl
Mapping Tables
Maps Manufacturing Cloud ProductMedia to CIM ProductImage format
| CIM | Manufacturing Cloud | Description |
|---|---|---|
| id | Id | The id of the product image in Manufacturing Cloud |
| name | Name | The name of the product image in Manufacturing Cloud |
| isDefaultImage | isDefaultImage | Indicates whether or not the product image is default image - default set to false |
| auditInfo.createdBy | CreatedById | Identifies the system or user which created the product image entry |
| auditInfo.createdOn | CreatedDate | Timestamp of when the product image entry was created |
| auditInfo.updatedBy | LastModifiedById | Identifies the system or user which last updated the product image entry |
| auditInfo.updatedOn | LastModifiedDate | Timestamp of when the product image entry was last updated |
| auditInfo.isDeleted | IsDeleted | Indicates whether or not the product image has been soft-deleted |
product-primarycategory-select
ProductCatalog Query Mapping for Manufacturing Cloud
Source:
./src/main/resources/dwl/product-primarycategory-select.dwl
Mapping Tables
Maps Manufacturing Cloud to CIM product.primaryProductCategory
| CIM | Manufacturing Cloud | Description |
|---|---|---|
| id | ProductCategoryProduct.ProductCategory.Id | The identifier of the product category |
| name | ProductCategoryProduct.ProductCategory.Name | The name of the product category |
| activeFromDate | ProductCategoryProduct.ProductCategory.CreatedDate | Timestamp of when the product category entry was created |
| parentCategory | ProductCategoryProduct.ParentCategoryId | The parent category id of the product category |
| productCatalog.id | ProductCatalog.CatalogId | The identifier of the product catalog |
| productCatalog.name | ProductCatalog.Name | The name of the product catalog |
| productCatalog.activeFromDate | ProductCatalog.CreatedDate | Timestamp of when the product catalog entry was created |
product-response-get
Product Query Mapping for Manufacturing Cloud
Source:
./src/main/resources/dwl/product-response-get.dwl
Mapping Tables
Maps Manufacturing Cloud Product2 to CIM Product format
| CIM | Manufacturing Cloud | Description |
|---|---|---|
| id | ID | The id of the Product in Manufacturing Cloud |
| name | Name | The name of the Product in Manufacturing Cloud |
| longDescription | Description | The description of the Product in Manufacturing Cloud |
| description | Short_Description__c | The description of the Product in Manufacturing Cloud |
| externalSourceRecord | External_ID__c | The external id of the Product in Manufacturing Cloud |
| isSellable | IsActive | Indicates whether or not the product is active |
| type | Family | The family of the Product in Manufacturing Cloud |
| productCategory.id | ProductCategory.Id | Id of Product Category |
| productCategory.name | ProductCategory.Name | Name of Product Category |
| productCategory.activeFromDate | ProductCategory.CreatedDate | Created Date of Product Category |
| productCategory.parentCategory | ProductCategory.ParentCategoryId | Product Category Id |
| productCategory.productCatalog | Catalog.Name | Product Category Catalog Name |
| productCatalog.id | CatalogId | Id of Product Catalog |
| productCatalog.name | Catalog.Name | Name of Product Catalog |
| productCatalog.activeFromDate | Catalog.CreatedDate | Created Date of Product Catalog |
| priceBookEntry.id | Id | Id of Price Book Entry |
| priceBookEntry.useStandardPrice | UseStandardPrice | Standard Price of Price Book Entry |
| priceBookEntry.unitListPrice | UnitPrice | Unit Price of Price Book Entry |
| primaryProductCategory | productCategory | The product category of the product retrieved using a separate call |
| productId | ProductCode | The id of the Product in Manufacturing Cloud |
| productSKU | StockKeepingUnit | The sku of the Product in Manufacturing Cloud |
| productStatus | Status__c | The status of the Product in Manufacturing Cloud |
| externalIds.externalIdType | "MDM" | Master data management |
| externalIds.externalId | Global_Product_Id__c | Global Product id |
| externalIds.id | Id | External Id |
| externalIds.statusLastChangedDate | LastModifiedDate | Last Modified Date of Product |
| externalIds.status | "VALID" | Status of External Id |
| externalIds.externalIdType | "SAP_4HANA" | SAP4HANA Id |
| externalIds.externalId | SAP_4HANA_Id__c | SAP4HANA Id |
| externalIds.id | Id | External Id |
| externalIds.status | "VALID" | Status of SAP4HANA Id |
| auditInfo.createdBy | CreatedById | Identifies the system or user which created the product entry |
| auditInfo.createdDate | CreatedDate | Timestamp of when the product entry was created |
| auditInfo.updatedBy | LastModifiedById | Identifies the system or user which last updated the product entry |
| auditInfo.updatedDate | LastModifiedDate | Timestamp of when the product entry was last updated |
| auditInfo.isDeleted | IsDeleted | Indicates whether or not the product has been soft-deleted |
product-var-put-payload
Product Upsert Mapping for Manufacturing Cloud
Source:
./src/main/resources/dwl/product-var-put-payload.dwl
Mapping Tables
Maps CIM Product to Manufacturing Cloud Product2 format
| Manufacturing Cloud | CIM | Description |
|---|---|---|
| Id | productId | Id of the product |
| Name | name | Name of the product |
| ProductCode | productSKU | The product code of the product to be updated |
| Product_Catalog__c | "All Products" | Product catalog set to "All products" |
| Description | longDescription | The long description of the product |
| Item_Long_Description__c | longDescription | The long description of the product |
| Short_Description__c | description | The description of the product |
| Item_Short_Description__c | description | The description of the product |
| Status__c | productStatus | The status of the product |
| External_ID__c | externalSourceRecord | The external id of the product |
| ExternalId | externalSourceRecord | The external id of the product |
| SAP_4HANA_Id__c | sapId | SAP4HANA Product Id |
| Family | type | The type of the product |
| IsActive | isSellable | Indicates whether or not the product is active |
| StockKeepingUnit | productSKU | The sku of the product |
| Global_Product_Id__c | mdmGlobalProductId | Global product Id |
search-products-response
Product Query Mapping for Manufacturing Cloud
Source:
./src/main/resources/dwl/search-products-response.dwl
Variables
var s
Maps Manufacturing Cloud Product2 to CIM Product format
Mapping Tables
Maps Manufacturing Cloud Product2 to CIM Product format
| CIM | Manufacturing Cloud | Description |
|---|---|---|
| id | ID | The id of the Product in Manufacturing Cloud |
| name | Name | The name of the Product in Manufacturing Cloud |
| longDescription | Description | The description of the Product in Manufacturing Cloud |
| description | Short_Description__c | The description of the Product in Manufacturing Cloud |
| externalSourceRecord | External_ID__c | The external id of the Product in Manufacturing Cloud |
| isSellable | IsActive | Indicates whether or not the product is active |
| type | Family | The family of the Product in Manufacturing Cloud |
| productCategory.id | ProductCategory.Id | Id of Product Category |
| productCategory.name | ProductCategory.Name | Name of Product Category |
| productCategory.activeFromDate | ProductCategory.CreatedDate | Created Date of Product Category |
| productCategory.parentCategory | ProductCategory.ParentCategoryId | Product Category Id |
| productCategory.productCatalog | Catalog.Name | Product Category Catalog Name |
| productCatalog.id | CatalogId | Id of Product Catalog |
| productCatalog.name | Catalog.Name | Name of Product Catalog |
| productCatalog.activeFromDate | Catalog.CreatedDate | Created Date of Product Catalog |
| priceBookEntry.id | Id | Id of Price Book Entry |
| priceBookEntry.useStandardPrice | UseStandardPrice | Standard Price of Price Book Entry |
| priceBookEntry.unitListPrice | UnitPrice | Unit Price of Price Book Entry |
| primaryProductCategory | productCategory | The product category of the product retrieved using a separate call |
| productId | ProductCode | The id of the Product in Manufacturing Cloud |
| productSKU | StockKeepingUnit | The sku of the Product in Manufacturing Cloud |
| productStatus | Status__c | The status of the Product in Manufacturing Cloud |
| externalIds.externalIdType | "MDM" | Master data management |
| externalIds.externalId | Global_Product_Id__c | Global Product id |
| externalIds.id | Id | External Id |
| externalIds.statusLastChangedDate | LastModifiedDate | Last Modified Date of Product |
| externalIds.status | "VALID" | Status of External Id |
| externalIds.externalIdType | "SAP_4HANA" | SAP4HANA Id |
| externalIds.externalId | SAP_4HANA_Id__c | SAP4HANA Id |
| externalIds.id | Id | External Id |
| externalIds.status | "VALID" | Status of SAP4HANA Id |
| auditInfo.createdBy | CreatedById | Identifies the system or user which created the product entry |
| auditInfo.createdDate | CreatedDate | Timestamp of when the product entry was created |
| auditInfo.updatedBy | LastModifiedById | Identifies the system or user which last updated the product entry |
| auditInfo.updatedDate | LastModifiedDate | Timestamp of when the product entry was last updated |
| auditInfo.isDeleted | IsDeleted | Indicates whether or not the product has been soft-deleted |
update-pricebookentry-request
Pricebooks Update Mapping for Manufacturing Cloud
Source:
./src/main/resources/dwl/update-pricebookentry-request.dwl
Mapping Tables
Maps CIM PricebookEntry to Manufacturing Cloud PricebookEntry format
| Manufacturing Cloud | CIM | Description |
|---|---|---|
| Id | vars.pricebookEntryRecordList[0].Id | The Identifier of the existing standard pricebook entry |
| IsActive | true | Indicates whether or not the pricebookEntry is active |
| UnitPrice | unitListPrice | The unitListPrice of the pricebookEntry |