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”
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.
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 |