Bug
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.
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
Manufacturing_Plant__c .PP_GBU__c = ‘Novecare’
Only Active Utility Plant should be used to do the mapping between SF & SAP values :
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 |
| view : MRP1
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 |
| View : MRP2 MARC.ZZST_HOLD | Mapping to be done see below |
HS Code | Material Plant SKU, record type Shipping Plant |
| View : Foreign Trade MARC.STAWN | |
Special Status | Material Plant SKU, record type Shipping Plant |
| View : MRP1 MARC.MMSTA | |
Is Deleted | Material Plant SKU, record type Shipping Plant |
| 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.