2014-12-09 - XXXXX - Spec - Include Drop ship Orders in ZHOT Report-(Jeff) #US #OpenOrders #ABAPREPORTS

SPECIFICATIONS

XXXXX -Spec - Include Drop ship orders in ZHOT Report


Purpose

Include drop ship orders in ZHOT report

Admin Info

Purpose
 Include drop ship orders in ZHOT report
Requested By
 Jeffrey Mau
Spec Created By
 Surya Basa
Spec Created Date
 12/09/2014
Spec QA by
 Surya Basa
Objects
 ZSD_HOTMARKET_REPORT
Document Status
 Project not confirmed


Estimates


Sl.No
 Activity
 Estimation in Hours
1
 Research
 08
2
 Documentation
 08
3
 Development/ Config
 24
4
 Unit test in DEV
 32
5
 Unit test in QUA
 32
6
 Other activity
 NA

TOTAL
 104

References

Prior Tickets

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

2012-09-25 - 5073 - Spec - ZHOT Enhancements

Documents

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

NA


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

























Functional Requirement

Purpose/WHY:

[Explain the purpose of the project and the reason why this requirement has come]
To include drop ship orders in ZHOT report - which basically shows open quantities on selected Sales Orders and Contracts.

In Scope:

[List the activities to be included in scope]
Drop Ship Orders, including SNC and non-SNC, will be included in the report.

Out of Scope:

[Out of scope activities]
NA

Solution Summary

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

Modify Report ZHOT to include Drop Ship Orders ( Sales Order with Item Category TAS) in the report.

Drop ship Sales orders are identified by Item Category TAS. If such a line is not rejected, then the corresponding PO will be identified and open order quantities will be determined from the PO.

Test Plan
[List test scenarios/cases to be executed here]
Originally there were 12 scenarios (ZHOT) to check the validity of the program.

The test plan here is based on the following

Test ID
 Test Scenario
 Expected Results
ZHOT-1
 Create contract with material X 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
ZHOT-2
 Create contract with material X 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
ZHOT-3
 Create contract with material X for size 700-100EA and two sales orders for 50EA and one delivery each
for the sales order for 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 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.
ZHOT-4
 Create sales order with material X 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
ZHOT-5
 Create Sales Order with material X 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.
ZHOT-6
 Create Sales Order with material X 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
ZHOT-7
 Create Sales Order with material X 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
ZHOT-8
 Create a contract with material X 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
ZHOT-9
 Created SO with sales org 1000 and 0110 plant with no delivery
 The delivery date field is filled from the SO
ZHOT-10
 Created SO with sales org 1000 and plant 0120 with delivery
 The delivery date field is filled from the SO and the last delivery date is filled with delivery number
ZHOT-11
 Created SO with size of two confirmation dates and created multiple deliveries for each confirmation date
 The last delivery date is displayed in the field for two confirmation dates
ZHOT-12
 Execute ZHOT transaction with material as input and download the report to Excel sheet
 The entire report should download without truncating the last characters
TAS-1
 Create one SO each in sales area 1000/10/00 with single material/size for 100EA with document types ZU3P, ZOR,
ZPTO and item category TAS
 100 should appear in the open order qty field against each SO.
TAS-2
 Create one SO each in sales area 1000/10/00 with multiple materials/size for 100EA with document types ZU3P, ZOR, ZPTO
and item category TAS. MIGO the documents
 The open order quantity field should appear as ZERO for each SO.
TAS-3
 Create one SO each in sales area 1000/10/00 with multiple materials/size for 100EA with document type ZU3P, ZOR, ZPTO
and item category TAS. Create inbound deliveries for each document.
 The open order quantity field should appear as ZERO for each SO.
TAS-4
 Create one SO each in sales area 1000/10/00 with multiple materials/size for 100EA with document type ZU3P, ZOR, ZPTO
and item category TAS. MIGO on one material completely and leave alone the others.
 The open order quantity field should only show the quantities for the materials that are not MIGOd.
TAS-4
 Create one SO each in sales area 1000/10/00 with multiple materials/size for 100EA with document type ZU3P, ZOR, ZPTO
and item category TAS. Create inbound delivery for one material and leave alone the others.
 The open order quantity field should only show the quantities for the materials for which inbound delivery is not created.
TAS-5
 Create one SO each in sales area 1000/10/00 with single material and multiple sizes for 100EA with document type ZU3P, ZOR, ZPTO and item category TAS. Completely reject one line.
 The open order quantity field should only show the quantities for the unrejected lines.
TAS-6
 Create one SO each in sales area 1000/10/00 with single material and multiple sizes for 100EA with document type ZU3P, ZOR, ZPTO and item category TAS. Partially reject quantities on two lines and leave alone others.
 The open order quantity field should only show the quantities for the unrejected lines.
TAS-7
 MIGO the PO for Test ID - TAS-5
 The open order quantity should appear as ZERO
TAS-8
 Repeat TAS-5 and MIGO the PO partially.
 The open order quantity should only show quantities for the lines that are not MIGOd
TAS-9
 Repeat TAS-5 and create one inbound delivery for all the PO lines.
 The open order quantity should appear as ZERO
TAS-10
 Repeat TAS-5 and create multiple inbound deliveries for all PO lines but one.
 The open order quantity should only show the quantity for the line for which Inbound delivery has not been created.
TAS-11
 One SO having multiple PO's and one PO containing multiple SO's should be tested
 The open order quantity should only show the lines for which MIGO/Inbound Delivery has not completed
REP-1
 Check report by input the following -
1. Contract only
2. Contract with call offs
3. Contract with call offs partially rejected
4. Contract with call offs with partial deliveries
5. Contract with call offs with complete deliveries
6. SO's containing item categories TAN and TAS
 1. The open order quantity field should show the full quantity of the contract
2. The open order quantity field should show the full quantity of the contract and call offs
3. The open order quantity field should should not show the quantities for rejected lines on the contract/call off
4. The open order quantity field should not show the quantities for which deliveries are created.
5. The open order quantity field should appear as ZERO
6. The open order quantity field should not show the lines for which deliveries are created or MIGO/Inbound delivery completed.

Solution Details

[Provide complete technical details for configuration or programming here]

Modify Report ZHOT to include Drop Ship Orders in the report.

- Remove filter to ignore Document Category TAS in the program.
- The Functionality of Normal Orders ( TAN and TAB) and Drop Ship Orders is Different.Normal Orders have Outbound Deliveries but DROP Ship Orders have Inbound deliveries.
-Open Order Quantity for Drop Ship Orders is based on completion of Inbound Delivery OR MIGO of corresponding PO.

Assumptions:
- The SNC PO is not partially delivered, i,e, A particular SO lines in PO are fully confirmed/delivered.
- A contract call off is not created with Item Category 'TAS'.

Issues

[List Issues / Bugs identified in configuration or development]

NA