2012-09-25 - 5073 - Spec - ZHOT Enhancements #OpenOrders #US #abaphotmarket

SPECIFICATIONS

5073 - ZHOT Enhancements

Purpose

Calculate the total demand for a given Season / Material / Document / Sales Org using this report.

Admin Info

Title	5073 - ZHOT Enhancements
Requested By	Jason Delinko
Spec Created By	Jeffrey M, Mau / Deepak Yasam
Spec Created Date	09/25/2012
Spec QA by	Venkat Kondapally / Surya Basa
Objects	ZSD_HOTMARKET_REPORT
Status (WIP/Complete)	Complete

References

Prior Tickets

None

Documents

None

Functional Requirement

Enhance the ZHOT transaction to include the license of the material (located in the product hierarchy) along with the description of the license. Customer groups 7, 8 and 9 with the corresponding tests for the customer should be added, as well as the sales reps name (instead of the number). These fields should be added at the end of the file.

Solution Summary

Discuss this section with Requester and get approval prior to beginning work
ZHOT transaction is a Hot Market Query which displays the details of sales orders for season “HOT”.

Test Plan

List test scenarios/cases to be executed here

Test Scenario	Expected Results
Create contract with material 10015850 for size 700-100 EA	100 should appear in the open contract and open order qty field against the contract
Create contract with material 10015850 for size 700-100EA and a sales order with reference to contract for 10EA respectively	The open contract and open order qty field against the contract should appear as 90
Create contract with material 10015850 for size 700-100EA and two sales orders for 50EA and two deliveries for 50EA	The delivery qty should appear as 50EA against each of deliveries and the open ord qty should appear as ZERO against both the sales orders
Create contract with material 10015850 for size 700-100EA and two sales orders for 50EA and one delivery each for the sales order for 25EA	The open order qty against the contract should appear as ZERO. The delivery qty should appear as 25EA against each of deliveries and the open ord qty should appear as 25EA against each of the sales orders respectively.
Create contract with material 10015850 for size 700-100EA,718-100EA,714-100EA and; two sales orders for size 700,718,714-25EA and; two deliveries one each for the sales order for size 700,718,714-25EA and 700-15,718-10,714-13EA respectively	The open order qty against the contract should appear as 700-60,718-65,714-62. The delivery qty should appear as 700-40,718-35,714-48EA against deliveries and the open ord qty should appear as ZERO against each of the sales orders and their sizes respectively.
Create sales order with material 10015850 for 100EA against the sizes 612,658,634,678 and; Create two deliveries with sizes 612-85,658-100EA and 612-15,634-100,678-100EA respectively	The delivery qty should appear as 100EA against each of the sizes 612,658,634,678

Test Scenario	Expected Results
Create Sales Order with material 79000198 for size 2XL-10 and reject the item.	Order qty field should appear as 10, confirmed qty as ZERO, delivery qty as ZERO and open order qty as 10.
Create Sales Order with material 79000198 for size 2XL, 3XL and 4XL-10 respectively and reject size 3XL-10; create delivery for 2XL, 4XL-10 respectively.	The order qty field should appear as 10,10,10; Confirmed qty as 10,0,10; Delivery qty as 10,0,10; Open order qty as 0,0,0
Create Sales Order with material 79000198 for size 2XL, 3XL and 4XL-10 respectively and reject size 2XL-10; create partial delivery for 3XL-5, 4XL-5 respectively.	The order qty field should appear as 10,10,10; Confirmed qty as 0,10,10; Delivery qty as 0,5,5; Open order qty as 0,5,5
Create a contract with material 10015850 for size 700, 718, 714, 738 -10EA respectively and reject sizes 700,718 for 10EA respectively.	The order qty field should appear as 10,10,10,10; Confirmed qty as 0,0,10,10; Delivery qty as 0,0,0,0; Open order qty as 0,0,10,10

Solution Details

Provide complete technical details for configuration or programming here.
Transaction: ZHOT
SQL Query: ZHOTMARKET
Infoset: Z_HMSO
Selection criteria:

Logic to Fetch Data:

License Number Material:

Get Product Hierarchy (MARA-PRODH) from Material Master Table (MARA) based on Material Number (VBAP-MATNR) from Sales Order .
License Number = MARA-PRODH (11, 12, 13 characters)
Get License No Description (T179T-VTEXT) from Mat.Prod.Heirarchy table (T179T) based License Number (above step)

Customer Group

Get Customer Group7(VBAK-J_3AKVGR7),Customer Group8(VBAK-J_3AKVGR8), Customer Group9(VBAK-J_3AKVGR9) from Sales Order Header Table(VBAK)
Get Customer Group7 Description (TVV7T-BEZEI) from table Customer Group7 Text table (TVV7T) based on Customer Group7.
Get Customer Group8 Description (TVV8T-BEZEI) from table Customer Group8 Text table (TVV8T) based on Customer Group8.
Get Customer Group9 Description (TVV9T-BEZEI) from table Customer Group9 Text table (TVV9T) based on Customer Group9.

Sales Rep Name:

How should we fetch Sales Rep Name? We can fetch Sales Rep Name by following two methods.

Based on Sales Group Description which is maintained in Sales Order and the description in Sales Groups: Texts (TVGRT)
Based on Sold to Party partner function “ZH” in customer master.

Issues

The below reported issues/bugs were fixed-
1. Open order quantity should consider rejected items.
2. In case of partial deliveries, the sum total of the delivered items at size level should be added up to the last delivery of that item/size.
3. Open contract quantity should be copied to the open sales order quantity.
4. Incorrect calculation of delivered quantities, in case of multiple deliveries for a particular item/size.