Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Status

MTR

Page Status

Owner
Stakeholders
Jira Request ID

Jira
serverSyensqo's Jira
columnIdsissuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverIdd8efc1ef-48bd-3b4e-8714-ad827f4f059b
keyERP-327

Jira Development ID

Jira
serverSyensqo's Jira
columnIdsissuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverIdd8efc1ef-48bd-3b4e-8714-ad827f4f059b
keyERP-862

High- Level Specification

ParameterValue
Application SystemS/4Hana ROW, S/4Hana China, S/4Hana CUI
Business Process Reference06.11.02.01. Manage Outbound Material Flow w/wo Discrepancies for EWM

Functional Overview

The functional design of the enhancements describes the scenario(s) where enhancements to existing SAP programs are required.

Integration Topic #287

Topic:

Prevent Ready for Shipping Status when batch or stock is restricted (Integration Topic #287).

Description:

During the warehouse execution process such as, after picking and packing is completed, but Goods Issue is not posted yet, it is possible that the batches or stock are moved back to restricted status by QM. In this case, the system should stop allowing the revert delivery status from "Ready for Shipment status in EWM to be sent " to "Not-Ready for Shipping" in EWM and communicate it to TM, so that the packing information of restricted batches/stock is prevented from getting of being updated in TM . Batch job will run to check deliveries feasible to set up Ready for Shipping status.

Scenario 1) Block ready for shipping if batch restricted.

Scenario 2) if Ready for Shipping status already set up, enhancement on LO side to block LE-Outbound delivery.

=====

This approach will work before standard functionality to check Ready for Shipping status in outbound delivery (ODO EWM):

Business require "ready for shipment" status for outbound deliveries to be automatic after picking and packing is completed. Currently this status is provided with manual option in SAP EWM Monitor.

The "Ready for Shipping" status was automatically set using report

accordingly.

 

Requirement details:

1º.- A custom program is required, set as Application Job and run for the respective variant, to select relevant deliveries to set up "Ready for Shipping" status with additional check if all assigned batches and picked stock for respective delivery is Unrestricted.

2º.- Second step of this Application Job needs to cover additional check of the stock and batches assigned for every delivery with already set "Ready for Shipping" status but not yet posted Goods Issue, and in case of any batch moved to restricted or picked stock different then Unrestricted, to revert the status to "Not Ready for Shipping" for respective delivery.

Scope and Objectives


Scope:

The standard program cannot be executed automatically because the action needs to be repeated in respective time frames, and the Business Process requires to be scheduled to run as a Background Job. 

The program needs to be created with a special variant for Application Job execution for every EWM Warehouse, where this process is applicable.

The following scenarios are in scope for the Application Job:

  • Do not set "Ready for Shipping" status - if status of any batch assigned in the delivery is restricted or any of the picked stock for respective delivery is Blocked or in Quality Inspection.
  • Set "Ready for Shipping" status only if the batch status of the batch assigned to a delivery is unrestricted and stock status of the stock picked for respective outbound delivery is unrestricted.
  • If "Ready for Shipping" status already set for a delivery but not yet posted Goods Issue - Reverse to "Not-Ready for Shipping" status If status of any batch assigned to delivery is restricted or status of the stock for delivery is not Unrestricted.
  • Error handling - collect the error messages for the Job run and provide the possibility to display the log, based on the execution date.


Objectives:

As part of the SyWay EWM Outbound execution process, there is a requirement to set "Ready for Shipping" status automatically when picking is finished in EWM.

The "Ready for Shipping" status must be set only if all batches and stock, picked for respective delivery are Unrestricted.

The status change step "Ready for Shipping" sends the picking/packing details to Transportation Management system and update the respective FU/FO.

As the "Ready for Shipping" status is a prerequisite for Loading in TM, we need to prevent the Loading execution if any of the assigned batches or respective stock is other than Unrestricted for respective delivery.

In such way there is a need to automatically reverse back the status to "Not-Ready for Shipping" for a delivery with not yet posted Goods Issue, if any of the batches or stock was moved to other than Unrestricted status for respective delivery.

 


Process Flow Diagram

The following 2 scenarios are in scope:


Scenario 1

Automatic Ready for Shipping process

> Variant 1) Set "Ready for Shipping" status only if the batch status of the batch assigned to a delivery is unrestricted and stock status of picked stock for respective outbound delivery is unrestricted.

> Variant 2) Do not set "Ready for Shipping" status - if status of any batch assigned in the delivery is restricted or any of the picked stock for respective delivery is Blocked or in Quality Inspection.

draw.io Diagram
bordertrue
diagramNamePrevent Ready for Shipping d.1
simpleViewerfalse
linksauto
tbstyletop
lboxtrue
diagramWidth961
height129
revision2


Scenario 2

Automatic revert from Ready for Shipping to Not-Ready for Shipping process

> Variant 1) If "Ready for Shipping" status already set for a delivery but not yet posted Goods Issue - Reverse to "Not-Ready for Shipping" status If status of any batch assigned to delivery is restricted or status of the stock for delivery is not Unrestricted.

draw.io Diagram
bordertrue
diagramNameRevert Ready for Shipping d.2
simpleViewerfalse
linksauto
tbstyletop
lboxtrue
diagramWidth741
height336
revision2



Execution step, as part of SAP SIGNAVIO Outbound flow'

06.11.02.01. Manage Outbound Material Flow for EWM Storage Locations

Image Added 

Execution Flow


Step

Description

Comment

1.List Deliveries relevant for the changing the status to "Ready For Shipping", with EWM ODO picking status Completed.This step will be done by the standard program /SCWM/R_SET_DSH_STAT_AUTOMATIC.
2.Loop through the list of selected EWM Outbound Delivery Orders.
2.1.Check if all of the batches, picked for EWM ODO are Unrestricted.

field BATCHNO table /SCDL/DB_PROCI_O

select based on the batch number and check the field ZUSTD in table MCHA for blank value - "Unrestricted".

2.2.Check if all of the Stock, picked for EWM ODO is Unrestricted.field STOCK CATEGORY table /SCDL/DB_PROCI_O with value F Unrestricted
2.3.Set the status "Ready for Shipping" for respective EWM ODO only if both previous checks are passed and stock and batches are Unrestricted. 
2.4.Confirm if the status "Ready for Shipping" is set or check the error messages. 
3.Output the messages. 
4.List Deliveries with status "Ready For Shipping" with not posted Goods Issue.

Based on field STATUS TYPE "Ready for Shipping" Status DSH with value 9 "Ready" table  /SCDL/DB_STATUS

Based on field STATUS TYPE Goods Issue Status DGI with value 1 "Not Started" table  /SCDL/DB_STATUS

5.Loop through the list of selected EWM Outbound Delivery Orders. 
5.1.Check if any of the batches, picked for EWM ODO is not Unrestricted.

field BATCHNO table /SCDL/DB_PROCI_O

select based on the batch number and check the field ZUSTD in table MCHA for value X - "Restricted".

5.2.Check if any of the stock, picked for EWM ODO is not Unrestricted.field STOCK CATEGORY table /SCDL/DB_PROCI_O with value different then F Unrestricted
5.3. Reverse the status "Ready for Shipping" to "Not-Ready for Shipping", for respective EWM ODO, if any of the both previous checks are passed and any of the stock or batches are not Unrestricted."Ready for Shipping" Status DSH with value 1 "Not Ready" table  /SCDL/DB_STATUS
5.4.Confirm if the change of the status to "Not-Ready for Shipping" is set or check the error messages. 
6.Output the messages. 


Assumptions

It can be used the standard configuration option to change the status "Ready for Shipping" and enhancement is required to prevent change of the status if any of the batches are "Restricted" or any of the stock is not "Unrestricted".

It is planned to create an Application Job for automatic change of the status of respective deliveries to "Ready for Shipping", and in case of already set status revert it to "Not-Ready for Shipping" in case of any batch or stock not Unrestricted for deliveries not Goods Issue posted.

Dependencies

N/A

Security, Integrity and Controls

Authorization check to be done via Authorization Group for process execution.

A background system user will be used to run the background job. 

Configuration Requirements

Standard configuration for triggering the change of the status for respective delivery, after picking is "Completed".

Language Requirements

KDD055 - Multi-Language Support


Special Requirements

N/A


Design Rationale

Functional Requirements

Business requires to reach automatically the warehouse (EWM) status to "Ready for Shipping" only if all assigned Batches and Stock are Unrestricted and also have the capability to revert  the status to "Not-Ready for Shipping" for all deliveries not yet Goods Issue posted if any of the assigned Batches or Stock are not Unrestricted.

The standard program /SCWM/R_SET_DSH_STAT_AUTOMATIC, for deliveries with Picking completed status, can be used as a base for the new custom program, and additional logic for the conditions of the batch and stock status will be added.

Proposed Technology to Use

Application Job

.

Requirement is to add additional check if the Batch is Restricted to do not send the status “Ready for Shipping” to TM.

Scope and Objectives

Process Flow Diagram

Step

Description

Comment

Assumptions

Dependencies

Security, Integrity and Controls

Configuration Requirements

Language Requirements

Special Requirements

Design Rationale

Functional Requirements

Proposed Technology to Use

Data Source Considerations


TableField NameComments/Calculation/Field Manipulation
/SCDL/DB_PROCI_OBATCHNOBatch
/SCDL/DB_PROCI_OSTOCK CATEGORYStock Type (F*)
MCHAZUSTDBatch Restricted
/SCDL/DB_STATUSSTATUS TYPE

DSH - Ready for Shipping Status

DGI - Goods Issue Status

DPI - Picking Status



Data Validation Considerations


TableField NameComments/Calculation/Field Manipulation
/SCDL/DB_PROCI_O

DOCID

Based on the Document ID we can find the Status in the table /SCDL/DB_STATUS
/SCDL/DB_PROCI_OBATCHNOBased on the Batch number we can find the Batch status in table MCHA field ZUSTD


Custom Tables

N/A

Master Data

N/A


FieldDescriptionData Type/LengthValidation rule/ Value Help









Configuration Table

N/A


FieldDescriptionData Type/LengthValidation rule/ Value Help








Selection Screen Enhancement

N/A


Field NameDescription

Select:

Data Type/LengthDefault Value/ Validation rule/ Value HelpSelection Logic













Processing Logic

The new custom program, to be executed in background several times a day (periodicity to be aligned with business), needs to have a selection screen for creating a variant for Application Job execution.

The new Application Job program needs to perform the following steps:

 A. Set status "Ready for Shipping" for all deliveries with picking status "Completed" only if Batch and Stock are "Unrestricted".

  1. Select all deliveries with status "Not-Ready for Shipping" and picking status "Completed".
  2. Check if all assigned batches for respective delivery are "Unrestricted".
  3. Check if all picked stock for respective delivery is "Unrestricted".
  4. If any of the 2 previous conditions (2 or 3) are not met - stop the process.
  5. If all the first 3 conditions (1, 2 and 3) are met - set status "Ready for Shipping".


B. Revert status from "Ready for Shipping" to "Not-Ready for Shipping" for deliveries with batch or stock different then "Unrestricted".

  1. Select all deliveries with Status "Ready for Shipping" and Goods Issue status "Not Started".
  2. Check if all assigned batches for respective delivery are "Unrestricted".
  3. Check if all picked stock for respective delivery is "Unrestricted".
  4. If both of the 2 previous conditions (2 or 3) are met - stop the process.
  5. If any of the 2 conditions (2 or 3) are not met - revert the status from "Ready for Shipping" to "Not-Ready for Shipping".


Volumetrics

More than 20.000 deliveries per month.


Performance Considerations

N/A


Error Handling

As this will be an Application Job, the system will collect all errors in a message and log it to an error log object.


Testing

How to Test

Prerequisites:

1) EWM ODO created and

2) Delivery Picking Status - Completed and

3) Delivery Goods Issue status - Not Started


Execution Steps:

  1. Execute the enhanced program.
  2. Check the status of respective EWM ODO.

Test Conditions and Expected Results

IDConditionExpected Result

Positive Test 1

All assigned Batches and Stock are Unrestricted - the enhanced program will set the new status Ready for Shipping. 

1Run the enhanced program for setting the status Ready for Shipping automatically, with all Batches and Stock Unrestricted for respective ODO.The program set the status Ready for Shipping for respective EWM ODO.
2Check the status of the EWM ODO.EWM ODO is with status Ready for Shipping.

Positive Test 2

Some of the assigned Batches was moved to Restricted status - the enhanced program will change the EWM ODO status from Ready for Shipping to Not-Ready for Shipping.

1Run the enhanced program for revert the status from Ready for Shipping to Not-Ready for Shipping automatically, with one of the assigned Batches moved to status Restricted for respective ODO.The new program reverts the status from Ready for Shipping to Not-Ready for Shipping for respective EWM ODO.
2Check the status of the EWM ODO.EWM ODO is with new status Not-Ready for Shipping.

Positive Test 3

Some of the Stock items was moved to not Unrestricted - the enhanced program will change the EWM ODO status from Ready for Shipping to Not Ready for Shipping.

1Run the enhanced program for revert the status from Ready for Shipping to Not-Ready for Shipping automatically, with one of the assigned Stock items moved to not Unrestricted for respective ODO.The new program reverts the status from Ready for Shipping to Not-Ready for Shipping for respective EWM ODO.
2Check the status of the EWM ODO.EWM ODO is with new status Not-Ready for Shipping.

Negative Test 1

Delivery with any Batch moved to Restricted status - the enhanced program will not change the ODO status from Not-Ready to Ready for Shipping.

1Run the enhanced program for setting the status Ready for Shipping automatically, with one of the assigned Batches is with status Restricted for respective ODO.The new program did not set the status Ready for Shipping for respective EWM ODO.
2Check the status of the EWM ODO.EWM ODO is with the initial status Not-Ready for Shipping.

Negative Test 2

Delivery with any of the Stock items moved to not Unrestricted - the enhanced program will not change the ODO status from Not-Ready to Ready for Shipping.

1Run the enhanced program for setting the status Ready for Shipping automatically, with one of the already picked Stock item not Unrestricted for respective ODO.The new program did not set the status Ready for Shipping for respective EWM ODO.
2Check the status of the EWM ODO.EWM ODO is with the initial status Not-Ready for Shipping.

Negative Test 3

Delivery with already set status Ready for Shipping and Goods Issue status Not Started with all Batches and Stock items Unrestricted - the enhanced program will not change the status. The status will remain Ready for Shipping.

1Run the enhanced program for revert the status from Ready for Shipping to Not-Ready for Shipping automatically, with all Stock items and assigned Batches Unrestricted for respective ODO.

The new program did not set the status Not-Ready for Shipping for respective EWM ODO.

No changes made for respective EWM ODO.

2Check the status of the EWM ODO.EWM ODO is with the initial status Ready for Shipping.


Test Conditions and Expected Results

N/A


IDConditionExpected Result










Test Considerations/Dependencies

N/A


Other Information

N/A


Development Details

Package


Package NameParent Package




Enhancement Implementation


Enhancement TypeStandard Definition NameCustom Implementation NameDesign Rationale Reference









Other Development Objects


Object TypeObject NamePurpose/High Level LogicDesign Rationale Reference








Appendix


Custom Authorization Group Naming Convention

This table is based on the Syensqo development standards document. It provides the naming conventions for authorization groups to associated with custom reports and tables to comply with security requirements.

ABAP

ZFIZMMZPSZCOZSDZBCZFIZCA
TABLESZFITZMMTZPSTZCOTZSDTZBCTZFITZCAT

See also

N/A


Attachments
previewfalse
patterns^(?!.*\.(png|jpg|jpeg|svg)$).*
sortOrderdescending

Change log

Change History
limit10