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

Compare with Current View Page History

« Previous Version 11 Next »


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

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

Scope


  • All Product existing product in SF should be interfaced

    • Select ALL product from SF from specific GBU involved in NOVECARE

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

      In the interface

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

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

  • All Record in the SAP Material - Plant should be included (MARC table) (if product is in SF)

  • All Existing Product where Level = “Level 5”


We want only to make UPDATE on exising “Material plant SKU - Shipping plant”== No Creation. It has to be done in the Talend Interface.

Technical Connection

Tehnically this interface is handled through a Talend Job that Read SAP WP1 and PF1 then it also Read an Write in Saleforce some date.


Talend uses the follwing user to connect to Salesforce : 

It is linked to the email : dataops@solvay.com and has a specific profile Salesforce Integration that provide the limited access to Salesforce.

Each interface will be granted of a specific permission set that will allow to access relvant information in Saleforce.



Interface Mapping

An interface should fill the following fields

SF Key :

"LVORM = ''" (this is the deletion flag from SAP)

  • Material Plant SKU.Product__c.Product Code == marc.matnr

    • select Id from Product2 where isActive = true AND ( SLV11_PRO_GBU__c = 'Novecare' ) AND Product Code == marc.matnr

  • Material Plant SKU. Utility. Plant = “Plant” && Material Plant SKU. Utility.Name === marc.werks

  • Material Plant SKU. Record Type = “Shipping Plant”

    • select id from RecordType where SobjectType ='Manufacturing_Plant__c' and DeveloperName = 'Shipping_Plant'

  • “Product”.Level (Type__c) =”Level 5”


+ Only Shipping plant related to "Novecare" must be updated  


  • Unable to locate Jira server for this macro. It may be due to Application Link configuration. Manufacturing_Plant__c .PP_GBU__c = ‘Novecare’


Only Active Utility Plant   should be used to do the mapping between SF & SAP values : 

  • SLV_Type__c = Plant
  • SLV5_1_Is_Active__c = true
    • Unable to locate Jira server for this macro. It may be due to Application Link configuration.


The Field “Catalogue Lead Time” will not be interfaced as is. We will keep the Manual Loading of this data until we have a way to retreive it into SF easily.



/!\ In the Shipping plant interface we hard coded Novecare at two places : 

  • Extract of Product
  • Filter on what shipping plant to update


Field Name

SF Object

Functional Key

SAP Source

Business Rule 

MOQ

Material Plant SKU, record type Shipping Plant

  • Product

  • Utility ( Plant)

  • Record Type = Shipping Plant

view : MRP1

IF( MARC.DISLS = EX) then : MARC.BSMTI


IF( MARC.DISLS = FX) then : MARC.BSTFE

Else : Empty


If stock holding strategy = MTO-FB Then 

IF( MARC.DISLS = EX) then : MARC.BSMTI

IF( MARC.DISLS = FX) then : MARC.BSTFE

Else : Empty


Only if If stock holding strategy = MTO-FB :

Lot Size Key (DISLS)= FX then MOQ = Fixed Lot Size (MARC.BSMTI)

Lot Size Key (DISLS)= EX then MOQ = Minimum Lot Size (MARC.BSTFE)



Else Empty




Stock Holding Strategy

Material Plant SKU, record type Shipping Plant

  • Product

  • Utility ( Plant)

  • Record Type = Shipping Plan

View : MRP2

MARC.ZZST_HOLD

Mapping to be done see below


HS Code

Material Plant SKU, record type Shipping Plant

  • Product

  • Utility ( Plant)

  • Record Type = Shipping Plan

View : Foreign Trade

MARC.STAWN


Special Status

Material Plant SKU, record type Shipping Plant

  • Product

  • Utility ( Plant)

  • Record Type = Shipping Plan

View : MRP1

MARC.MMSTA



Is Deleted

Material Plant SKU, record type Shipping Plant

  • Product

  • Utility ( Plant)

  • Record Type = Shipping Plan


Is set to True if it has been deleted into SAP

Stock Holding Strategy mapping :

SOURCE : SAP Code (MARC.ZZST_HOLD)

SAP Description (For Info)

TARGET : SF API Name -SLV48_Stock_Holding_Strategy

MTF

Make To Forecast

Make To Forecast

MTO

Make To Order

Make To Order

MTO-FB

Make To Order Full Batch

Make To Order - Full Batch

MTS

Make To Stock

Make To Stock

PTO

Purchase to Order

Purchase to Order

PTS

Purchase to Stock

Purchase to Stock

Error Management


If the interface fails for SF reason (validation rules…) , send an email to : @François Pellissier-ext @Nestor Teijeiro Prado @Romain Bablot-ext with the lines in error.


  • No labels