SKU Plant/Warehouse （SKU Shipping in DiP）

DimensionHow to see SKU in DiPTerms
SourceSAP transaction code MM03 →  DynaSys DP → DynaSys DiP


Condition

a. The BU of Material x Plant should be part of DynaSys 's scope in BW filters (if not, ask SBS to tell BW team to add it)

b. The Plant/Warehouse should be part of DynaSys 's scope in SAP ( if not, ask SBS to tell BW team to add it)

c. At least one material x plant view (MRP1,2,3...) exists in SAP

d. At least 1 costing view exists in SAP


Frequency

Daily update

(update to DynaSys DiP during daily Static import)

*should bear 2 days of delay if the Plant/Warehouse not exist yet，

need to add the new material/shipto to SAP by creating a ticket thereafter SBS will interface this to DynaSys DP.

Trouble-shooting

Normally, a material that has all Material x Plant views (MRP views) & at least 1 costing view, should be created in DiP-PP (2 days of delay since moment of creation). If the SKU fulfills these 2 conditions but doesn't exist in DiP => contact SBS

Note: Another reason could be that the SKU belongs to a new plant, in that case raise a ticket to SBS to add it to the DynaSys's scope.



ABC Indicator

SAP Transaction MM03 allow the user to view the Material data

ABC Indicator is in tab MRP1


Batch size

SAP Transaction MM03 allow the user to view the Material data

Fixed lot size is in tab MRP1


Country of origin

SAP Transaction MM03 allow the user to view the Material data

Country of origin is in tab Foreign trade export


Frozen period production

SAP Transaction MM03 allow the user to view the Material data

Planning time fence is in tab MRP1


Good receipt processing time

SAP Transaction MD04 allow the user to view the Material data

GR processing time is in tab MRP2


HTS

SAP Transaction MM03 allow the user to view the Material data

Foreign trade data - Comm./imp. code no. is in tab Foreign trade import


Minimum run

SAP Transaction MM03 allow the user to view the Material data

Minimum Lot Size is in tab MRP1


Moving price

SAP Transaction MM03 allow the user to view the Material data

Moving price is in tab Accounting1


Procurement type

SAP Transaction MM03 allow the user to view the Material data

Procurement type is in tab MRP2


Rounding value

SAP Transaction MM03 allow the user to view the Material data

Rounding value is in tab MRP1


Safety stock days

SAP Transaction MM03 allow the user to view the Material data

Safety time/act.cov. is in tab MRP2


Safety stock quantity

SAP Transaction MM03 allow the user to view the Material data

Safety stock is in tab MRP2


Special Procurement key

SAP Transaction MM03 allow the user to view the Material data

Special procurement is in tab MRP2


Total Replenishment Lead time (RLT) from MRP3

SAP Transaction MM03 allow the user to view the Material data

Tot. repl. lead time is in tab MRP3


Unit standard cost (CCR)

SAP Transaction MM03 allow the user to view the Material data

Currency & Standard price is in tab Costing2


PIR Planned Delivery time


> The PIR Planned Delivery time will be used to determine the “Procurement LT for P&I”.

> There is an interface between SAP -> BW -> DynaSys to determine the 'PIR Planned Delivery time'

> The same interface is used to determine the 'Vendor number', 'Minimum Purchase Quantity' and 'Standard Purchase Quantity'

Number of Vendor / Suppliers


The “Number of Suppliers” (or “Number of vendors”) is calculated from the number of valide suppliers available in SAP Purchasing Source List, tcode ME03 (or can also access Table EORD).

In a nutshell, we take all sources and we apply the following filters in order to keep only the valid ones:



Note: as we can see above, we take almost the same filters as when calculating the 'PIR Planned Delivery time' except the 'flag MRP' or 'Fixed vendor'