SD-Deepak- Damodhier - Mahesh - 2015-12-11 - 23860 - Spec - Hot Market Exclusion for QR Orders (Jeff by 2016-03-25) #ARUN #OrderEntry #US #salesorders

SPECIFICATIONS

23860-Spec- Reject specific materials for ZQR orders

Purpose

Reject HOT market materials in ZQR orders.

Admin Info

Purpose	Reject HOT market materials in ZQR orders
Requested By	Jeffrey Mau
Spec Created By	Surya Basa/Deepak
Spec Created Date	12/11/2015
Spec QA by	Surya Basa
Objects	TVARVC V_TVAG MV45AFZZ
Document Status	Completed

Estimates

Sl.No	Activity	Estimation in Hours(single selection set)	Estimation in Hours(multiple selection sets)
1	Research	08	04
2	Documentation	04	04
3	Development/ Config	20	24
4	Unit test in DEV	10	14
5	Unit test in QUA	00	00
6	Other activity
	TOTAL	42	46

References

Prior Tickets

[Provide links of prior associated Spec / Break Fix BOSS document(s)]

None

Documents

[Attach any document(s) received for the requirement(s)]

None

Spec Changes

[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]

Sl.	Change Details	Requested By	Requested On	Notes if any
1	Need to read the materials from multiple selection sets in TVARVC table	Craig Spangler	02/25/2016

Functional Requirement

Purpose/WHY:

[Explain the purpose of the project and the reason why this requirement has come]

The HOT market materials needs to be rejected in the ZQR orders so that the stock of these materials can be given to other specific customers.

In Scope:

[List the activities to be included in scope]
It is restricted to ZQR orders

Out of Scope:

[Out of scope activities]
Other order types are not affected by this change.

Solution Summary

[Discuss this section with Requester and get approval prior to beginning work]

1. A new rejection reason needs to be created to display at item level to reject the HOT market maerials.

2.The SO userexit needs to be changed to compare the HOT market materials with the materials of allocation run selection set.These materials in the ZQR orders needs to be rejected and the remaining materials should be delivered as per the rush order sales process.

Test Plan

[List test scenarios/cases to be executed here]

With single selection set material:

Test ID	Inventory position	Test Scenario	Expected Result in the SO
Test ID	Inventory position	Test Scenario	Expected Result in the SO
SD001	Sufficient Inventory	Create EDI ZQR order with HOT market materials	1.The HOT market materials should be rejected with ZQ rejection reason. 2.Subsequent delivery shouldn't be created
SD002	Sufficient Inventory	Create EDI ZQR order with both HOT market and standard materials	1. The HOT market materials should be rejected with ZQ rejection reason. 2.The standard materials should be auto allocated and delivery should be created.
SD003	Sufficient Inventory	Create EDI ZQR order with HOT market material. After the ZQR order is created add the standard and another HOT market material and save the order	1. The HOT market materials should be rejected with ZQ rejection reason. 2. The standard materials should be auto allocated and delivery should be created.
SD004	Sufficient Inventory	Create EDI ZQR order with HOT market material. After the ZQR order is created add another HOT market material and save the order	1. The HOT market materials should be rejected with ZQ rejection reason. 2. The new HOT market material should also be rejected with ZQ rejection reason.
SD005	Sufficient Inventory	1.Create EDI ZQR order with HOT market material. 2.After the ZQR order is created , remove the initial HOT market material from the selection set and remove the ZQ rejection reason manually in the SO.	1.Initially the HOT market material should be rejected with ZQ rejection reason. 2.After removing the material from the selection set , the ZQ rejection reason shouldn't be applied once it is manually removed. 3. The HOT market material should be auto allocated and the subsequent delivery and invoice is created.
SD006	Sufficient Inventory	Create manual ZQR order with HOT market material. After the ZQR order is created add the standard and another HOT market material and save the order	1. The HOT market materials should be rejected with ZQ rejection reason. 2.The standard materials should be auto allocated and delivery should be created.
SD007	Sufficient Inventory	Create manual ZQR order with HOT market material. After the ZQR order is created add another HOT market material and save the order	1. The HOT market materials should be rejected with ZQ rejection reason. 2. The new HOT market materials should also be rejected with ZQ rejection reason.
SD008	Sufficient Inventory	Create EDI ZOR order with HOT market materials	The HOT market materials shouldn't be rejected.
SD009	Sufficient Inventory	Create EDI ZOR order with both HOT market and standard materials	The HOT market and standard materials shouldn't be rejected.
SD010	Sufficient Inventory	Create manual ZOR order with both HOT market and standard materials	The HOT market and standard materials shouldn't be rejected.
SD011	Partial Inventory	Create a EDI ZQR with HOT market materials.	1. The HOT market materials are rejected with ZQ rejection reason and subsequent delivery shouldn't be created
SD012	Partial Inventory	Create EDI ZQR order with both HOT market and standard materials	1 .The HOT market materials should be rejected with ZQ rejection reason. 2. The standard materials with the available partial quantities should be auto allocated and delivery should be created.
SD013	Partial Inventory	Create a EDI ZOR with HOT market materials.	The HOT market materials shouldn't be rejected.
SD014	Partial Inventory	Create EDI ZOR order with both HOT market and standard materials	The HOT market and standard materials shouldn't be rejected.
SD015	No Inventory	Create a EDI ZQR with HOT market materials.	The HOT market materials should be rejected with ZQ rejection reason and subsequent delivery shouldn't be created
SD016	No Inventory	Create EDI ZQR order with both HOT market and standard materials	1. The HOT market materials should be rejected with ZQ rejection reason. 2. The standard materials are also rejected with Z9 rejection reason as there is no stock.
SD017	No Inventory	Create a EDI ZOR with HOT market materials.	The HOT market materials shouldn't be rejected.
SD018	No Inventory	Create EDI ZOR order with both HOT market and standard materials	The HOT market and standard materials shouldn't be rejected.

With multiple selection set materials:

SD-001	Create a ZQR EDI order in 1000,10,00 sales area as below. 1.With TVARVC selection set excluded materials 2.With non TVARVC selection set excluded materials.	The ZQR EDI order should be created as below. 1.With TVARVC selection set materials should be rejected with ZQR rejection reason. 2.With non TVARVC selection set materials should be auto allocated and subsequent delivery should be created.
SD-002	Create a ZQR EDI order in 1000,10,00 sales area as below. 1.With TVARVC multiple selection sets excluded materials 2.With non TVARVC multiple selection sets excluded materials.	The ZQR EDI order should be created as below. 1.With TVARVC selection set materials should be rejected with ZQR rejection reason. 2.With non TVARVC selection set materials should be auto allocated and subsequent delivery should be created.
SD-003	Create a ZQR EDI order in 2000,10,00 sales area as below. 1. With TVARVC selection set where materials are excluded in one sales org (2000)and included in another sales org(1000).	The ZQR EDI order should be created as below 1.The excluded materials should be rejected with ZQR rejection reason as they are excluded in corresponding SO s.org selection set.
SD-005	Create a ZOR EDI order in 1000,10,00 sales area as below. 1.With TVARVC selection set excluded materials 2.With non TVARVC selection set excluded materials.	The ZOR EDI order should be created as below. 1.With TVARVC and non TVARVC selection set materials shouldn't be rejected with ZQR rejection reason.
SD-006	Create a ZOR EDI order in 1000,10,00 sales area as below. 1.With TVARVC multiple selection sets excluded materials 2.With non TVARVC multiple selection sets excluded materials.	The ZOR EDI order should be created as below. 1.With TVARVC and non TVARVC selection set materials shouldn't be rejected with ZQR rejection reason.
SD-007	Create a ZOR EDI order in 2000,10,00 sales area as below. 1. With TVARVC selection set where materials are excluded in one sales org (2000)selection set and included in another sales org(1000)selection set.	The ZOR EDI order should be created as below. 1.The materials shouldn't be rejected with ZQR rejection reason though they are excluded in 2000 s.org selection set.
SD-008	Create a ZOR EDI order in 2000,10,00 sales area as below. 1. With TVARVC selection set where materials are included in one sales org (2000)selection set and excluded in another sales org(1000) selection set.	The ZOR EDI order should be created as below. 1.The materials shouldn't be rejected with ZQR rejection reason though they excluded in 2000 s.org selection set and included in 1000 s.org selection set.
SD-009	Create a manual ZQR order in 1000,10,00 sales area as below. 1.With both TVARVC and non TVARVC selection sets , with excluded and included materials.	The manual ZQR order should be created as below. 1. The excluded materials in TVARVC selection set should be rejected with ZQR rejection reason. 2. The excluded materials in non TVARVC selection sets should be auto allocated and delivery should be created.
SD-010	Create a manual ZOR order in 1000,10,00 sales area as below. 1.With both TVARVC and non TVARVC selection sets , with excluded and included materials.	The manual ZOR order should be created as below. The materials shouldn't be rejected with ZQR rejection reason for both TVARVC and non TVARVC selection sets.

Solution Details

[Provide complete technical details for configuration or programming here]

1. A new rejection reason ZS is created to display this for HOT market materials in ZQR orders.

2. Added logic in Sales Order Exit (MV45AFZZ) for Document Type (AUART) 'ZQR':

To read multiple Selection-set numbers from TVARVC table with the Variable Name (ZISD_HOTMARKET_EXL_MAT)
To read Specific Rejection Materials based on the Selection-set numbers using FM J_4AA_MAS_SELECTION_READ
Checking each material in the Sales Order with the Hot Market Rejection Materials, which are fetched in the above step, if the SO item material is a Hot market Rejected Material then passing 'ZQ' Rejection Reason at Size level (VBEP-J_3AABGRU)as well as Item level (VBAP-ABGRU).

Issues

[List Issues / Bugs identified in configuration or development]