You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

In order to be able to have in Salesforce the Customer Product information we created :

  • Created a new Object "Customer Product"
  • Created an interface from SAP to SF to load Customer Product


Records stored in this new object will be used in oder to add some information in the Quote PDF.


// For this object & integration we had the followinf Product DA : Product DA - IPP-1547 : Quotes - Add customer material number in the quote PDF - Google Slides


Customer Product Object



Organization-Wide Defaults

ObjectDefault Internal AccessDefault External AccessGrant Access Using Hierarchies
Customer ProductPublic Read OnlyPublic Read Only
Checked


OWD will change following :  Unable to locate Jira server for this macro. It may be due to Application Link configuration.



Profiles That Override Customer Product Sharing

ProfileCustom Profile


Organization-Wide Permissions
View All DataModify All Data



Customer Product Permissions
View AllModify All


API profile for integration
Checked
Checked
Not Checked
Checked
Not Checked
Agent Lightning
Checked
Not Checked
Not Checked
Checked
Checked
B2BMA Integration User
Not Checked
Checked
Not Checked
Checked
Not Checked
Premier Support User
Not Checked
Checked
Checked
Checked
Checked
Sales Insights Integration User
Not Checked
Checked
Not Checked
Checked
Not Checked
SalesforceIQ Integration User
Not Checked
Checked
Not Checked
Checked
Not Checked
System Administrator
Not Checked
Checked
Checked
Checked

Checked


Permission Set : Manage One Sales Quote & One Sales Quote can READ of fields of this object


FIELD LABELFIELD NAMEDATA TYPE
Created ByCreatedByIdLookup(User)
CurrencyCurrencyIsoCodePicklist
CustomerPP_Customer__cLookup(Account)
Customer Product DescriptionPP_Customer_Product_Description__cText(250)
Customer Product NameNameAuto Number
Customer Product NumberPP_Customer_Product_Number__cText(250)
Distribution ChannelPP_Distribution_Channel__cText(250)
Last Modified ByLastModifiedByIdLookup(User)
OwnerOwnerIdLookup(User,Group)
ProductPP_Product__cLookup(Product)
Solvay Sales OrgPP_Solvay_Sales_Org__cLookup(Solvay Sales Organisation)

Interface

Unable to locate Jira server for this macro. It may be due to Application Link configuration.


1/ Scope

All the Novecare Product retrieved from both WP1 and PF1 SAP should be interfaced.


Existing rule from the Product2

  • All Product existing product in SF should be interfaced

    • Select ALL actives product from SF from specific GBU involved in NOVECARE and Level = “Level 5”

      and then we have the “SAP Origin” in SF.

      In the interface

      • If "SAP Origin" = RCS --> Go to SAP-WP1

        If "AP Origin" = PF1 --> Go to SAP-PF1


  • Only sync Product where KNMT.KDMAT(Customer Material Number) or KNMT.POSTX (Customer's description of material) if filled.


2/ Specificities

The interface should : CREATE / UPDATE / DELETE.

There is no impact (business perspective) for the delete if we go in hard delete.

The interface need to run minimum Daily

3/ Interface mapping 


Source CIMR CMIR export.xlsx - Google Sheets

FK

SAP Table

Target SF

Transformation

X

CIMR.Sales Organization

KNMT.VKORG

Customer Product.Sales Org

select id from “Solvay Sales Organisation” where “Sales Organisation Code” = CIMR.Sales Organization

X

CIMR.Distribution Channel

KNMT.VTWEG

Customer Product.Distribution Channel


X

CIMR. Customer (zerofill 10 digits)

KNMT.KUNNR

Customer Product.Customer

WP1 : Select Id from Account where RCS_ID__c= $CIMR.Customer

PF1 : Select Id from Account where PRS_ID__c= $CIMR.Customer

X

CIMR.Material (zerofill 18 digits)

KNMT.MATNR

Customer Product. Product

WP1 : SELECT Id FROM Product2 WHERE SLV11_PRO_GBU__c = 'Novecare' AND SLV5_1_SAP_Origin__c = 'RCS' AND ProductCode = $CIMR.Material AND Type__c = 'Level 5'

PF1: SELECT Id FROM Product2 WHERE SLV11_PRO_GBU__c = 'Novecare' AND SLV5_1_SAP_Origin__c = 'PF1' AND ProductCode = $CIMR.Material AND Type__c = 'Level 5'


CIMR.Customer Material Number

KNMT.KDMAT

Customer Product. Customer Product Number



CIME.Customer's description of material

KNMT.POSTX

Customer Product.Customer Product Description


  • No labels