Interoperability of Batches Between ERP and EWM [PDF]

Zitiervorschau

Interoperability of Batches between ERP and EWM Current System for EWM and ERP Product

Version

SAP SCM

7

SAP Extended Warehouse management

9.3

EHP7 FOR SAP ERP 6.0

EHP7 FOR SAP ERP 6.0

Purpose The purpose of this blog is unravel the ‘’Batch Determination Process’’ in SAP EWM and further asynchronous interoperability/update of batches in ERP delivery documents. Overview Batch management is deployed primarily for below reasons ● For Traceability, usage of Real batches (Inventory managed) or Documentary batches(Non Inventory managed) can be used. ● For recording the characteristics of batches like SLED(Shelf Life Expiration Date, Country of Origin, Status of Batch and Production date) in Warehouse and delivery documents ● For valuation of Batch, when product is either procured externally or produced internally. Usage of Split valuation, ●

In earlier version before EWM 9.2,​ first Batch​ entry was mandatorily created in ERP which is the leading system and later batches were updated asynchronously in EWM.

●

From EWM 9.2 and ECC 6.06 SP13 / ECC 6.07 SP06 the following option is also available: if the Switch CIF_SWFS_BATCH_INT in the Business Function LOG_SCM_EWM_INT on ECC side is Active then CIF transfers the used Batch Class and Type and these are stored on SCM side in the Product Master (so not in the standard Classification table) • EWM can use this information to create the first Batch already with characteristic values

Even EWM can work without any classification system, in this case S​AP ERP only transfers the characteristics as batch selection criteria to SAP EWM. In our example, we are not transferring any characteristics from ERP to EWM. Activation of Batches in SAP ERP Batch activation is Material level or at client level before SAP EWM 9.40. We have used activation at material level. Now, in SAP EWM 9.4(​SAP ERP 6 Enhancement Pack 6)​ and higher version, Batch can be activated at Plant level, consulting note, ​2221258 - Integration of SAP EWM 9.40 and higher to a Batch on Plant SAP ERP System

Modus Operandi of Batch determination in EWM ●

Determine batch in outbound process during Warehouse Task creation in EWM and asychonoulsy update batch in ER​P

Configuration and Prerequisite: All ERP batch management customizing is available in T code OCHA.

●

Activation of Batch in ERP

●

Number assignment in ERP

●

Valuation for Goods Movement in Inventory Management

●

Activate Automatic Batch Determination in SD

Activate Automatic Batch Determination for Delivery Item Categories

Integration Customization. Logistics Execution-->SAP EWM Integration--->Basic Setup of Connectivity-->Configure SAP EWM-Specific Parameters

​Note​:->The flag "Batch Determination in EWM" field T340D-BATCH_DETERM_EWM, is set for the warehouse 150 ensure that no sales batch determination occurs in ERP.

-->In case - If for the selected warehouses - the flag "Batch Determination in EWM" is ​NOT​ set, ​ batch determination occurs in Sales order ERP not in EWM​.

Customization in EWM ● Extended Warehouse Management-->Cross-Process Settings-->Batch Management-->Define Number Range for Batch

●

Number range should be internal

Avoid Automatic Batch Split for (Picking) Confirmation ●

Extended Warehouse Management-->Cross-Process Settings-->Define General Settings for Parallel Processing and Performance

Note​:● If "No Split" is ticked.​ This indicator determines whether an automatic batch split of a delivery item is carried out during picking WT and posting change confirmation. ●

If ​it is blank ' ' (Space)​ then, a subitem for the batch of the picking WT is created and the batch is written on the subitem, in case of full quantities as well. As a result, if batch split has happened, cancel pick deletes the batch split item and only the main item remains, which is not batch relevant.

Set Update Control (Centralized, Decentralized) It is mandatory settings required to create the first batch in EWM, maintain the customization in table /​SCWM/TBATCHUPD

Note​:● ●

It is recommended to use value as ​3​ by SAP. SAP consulting note 2569979​(Batch valuation does not exist yet, message /SCWM/BATCH047 in /SCWM/WM_BATCH_MAINTAIN), ​1875500(Asynchronous batch replication from EWM to ECC not possible)

●

This settings ensures asynchronous batch replication from EWM to ECC.

Set Control Parameters for ERP Version Control

●

Extended Warehouse Management-->Interfaces-->ERP Integration-->General Settings-->Set Control Parameters for ERP Version Control

●

Batch Management in the Outbound Delivery

Extended Warehouse Management-->Goods Issue Process-->Outbound Delivery-->Batch Management in the Outbound Delivery Assign the document category Outbound Delivery Order PDO. Other fields are non mandatory but it can be used.

Note:The batch selection criteria in EWM cannot be changed at all and it is transferred from the outbound delivery in the ERP to the PDO in EWM. So it is always greyed out. However, for specific requirement BADi can be used. ->SCWM/BT_BATCH_SEL - Determine Batch Selection Criteria and Transfer to the Batch Search to change de selection criteria. The BAdI uses the interface /SCWM/IF_EX_BT_BATCH_SEL. Using this, the user can select batches, that do not meet the selection criteria.

Master data required. 1. Batch-managed material with assigned batch selection class and characteristics is created. 2. Corresponding stock in batches with the required characteristics is available 3. CIF the material from ERP to EWM without selecting any class/ characteristics. Combination should be Product/Batch only in CFM1.

​Process Flow chart

1) Create a Sales order in ERP

Maintain the partner number as your ERP warehouse number which is connected to EWM 4 digit warehouse.

Enter, material, plant and Quantity, it can be observed that Batch field is not filled in SO.

Save the delivery it is distributed to EWM system. It can be observed that Batch field is till not filled.

2​)Go to EWM system, logon to Outbound delivery request /SCWM/ODR : Delivery is activated in EWM system

3)​Go to /SCWM/PRDO - Outbound Delivery -> Maintain Outbound Delivery Order and check the outbound delivery. Create warehouse task from Follow on Function.

Note:​It can be seen that batches with stock is appearing in Tab( Stock that can be removed). Here batches were directly created in EWM system by Production Order Confirmation CO15.

Now, click on Create+Save button. Warehouse order will be created

4)​Check the Warehouse order in Monitor screen, and it can be seen the ​Batch is picked in W​T. Confirm, the warehouse order.

The picking of batches has followed FIFO rule because of setting in Storage type search.In standard SAP EWM, sorting of​ storage bin is done based on ​Goods Receipt Date and Time

So, batch 0000000118 is picked considering FIFO rule.

In EWM standard, the GR date is always a combination of date and time. So if sorting is conducted by field WDATU, it will always include the time.

5) Confirm WO

6) ​Check the delivery in ERP. Batch number has been updated in Outbound delivery.

7)​ ​Check the status of Outbound delivery in EWM, Picking is completed and Goods issue is not started. Since, packing and loading activity is not used, so not required to conduct these steps.

Click on Goods Issue.

8) Check the status of delivery in EWM in PRDO, all relevant activities are completed​.

8)​ ​Check corresponding Outbound delivery in ERP, goods movement is posted and status is updated as C through PPF action from EWM.

What if Analysis for Storage type settings in following cases ● ●

Batch neutral Batch specific

1) Batch Neutral ​-Blank Available Quantity: Batches

Check the Monitor screen for storage type 5001

There is batch 0000000114 stock in storage type 5001, storage bin 01-01-01

Try to create a Warehouse task by moving Product from one storage type to another storage type by /SCWM/ADPROD

Batch is picked during Warehouse task creation ​if setting is Batch Specific. 2) ​Batch neutral Setting: Take a storage type where Available Quantity of Batches is set 1- Batch neutral.

Try to create Warehouse task by ADPROD, system behaves differently Note:​-​ ​Batch is not picked during Warehouse creation and system gives error, So, always try to keep ‘’Batch Specific’’​ setting in case of Product which is Batch Managed else warehouse task will not be created for batch neutral settings

Written By: Shailesh Mishra Principal Consultant-SAP EWM Linkedin URL- ​https://www.linkedin.com/in/shailesh-mishra-6b138894/ Email Id: ​[email protected] Contact number: +91-8956035667