SD- Surya- Prudvi- 2016-03-01 - 22568 - Spec - Product Characteristics Data File (Craig by 2016-04-30) #abapquality #ABAPFORMS #salesorders #EMEA

SPECIFICATIONS

22568 - Spec - Product Characteristics Data File


Purpose

Generate Excel output for order acknowledgements for EMEA

Admin Info

Purpose
 Generate Excel output for order acknowledgements for EMEA
Requested By
 Craig Spangler
Spec Created By
 Surya Basa
Spec Created Date
 03/01/2016
Spec QA by
 Surya Basa
Objects
 ZSD00100_EXTMAIL_EXCEL
V_T682
VN_T685B
V_T683_XX
Document Status
 Completed


Estimates


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

TOTAL
 80

References

Prior Tickets

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


Documents

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

OA requirements - template 190216.xlsx


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
 Remove colour and COO fields from the output
 Craig
 03/29/2016
2
 Remove fabric Composition from the output
 Rizwan
 04/12/2016
3
 Update multiple issue for ZBEA output
 Rizwan
 04/20/2016
4
 Change the access sequence for ZBEA output
 Rizwan
 04/25/2016
5
 Update disclaimer in the ZBEA Excel file
 Rizwan
 04/28/2016
6
 Change the fomat of Excel file to text
 Rizwan
 05/05/2016

Functional Requirement

Purpose/WHY:

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

Overall Context and Requirement

The existing OA is only on PDF format and does not contain enough information. EMEA Customers use the OA to input the data into their systems and have correct Masterdata. All of them are requesting to have the OA modified and generated in an Excel format

The required info to comply the questions is the following : RRP Retail Recommended Price (SAP MSRP), Team, License, Full Colour Description (not in SAP), Country of Origin, Fabric Composition

In Scope:

[List the activities to be included in scope]

Output will be triggered manually only by the user. Email will trigger to the contact person and to the id maintained under general data in the customer master.

Out of Scope:

[Out of scope activities]

Solution Summary

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

1. Create a new output type for OA Email
2. Develop a program to trigger email in excel output format
3. Assign the program to the output type


Test Plan

[List test scenarios/cases to be executed here]

Test ID
 Test Scenario
 Expected Result
SD-001
 1.Create a EDI ZOR SO in 2000,10,00 sales area.
2.Issue ZBEA OA email output in the SO.
 The OA excel file should be generated.
SD-002
 1.Create a manual ZOR SO in 2000,10,00 sales area.
2.Issue ZBEA OA email output in the SO.
 The OA excel file should be generated.
SD-003
 1.Create a manual ZOR SO in 2000,10,00 sales area.
2. Reject some of the line items.
3.Issue ZBEA OA email output in the SO.
 The rejected items shouldn't display any quantities in the OA excel file should be generated.
SD-004
 1.Create a manual ZOR SO in 2000,10,00 sales area.
2. some of the line items should be split with multiple sizes.
3.Issue ZBEA OA email output in the SO.
 The split sizes should also be displayed along with other items in the OA excel file.
SD-005
 1.Create a manual ZU3P SO in 2000,10,00 sales area.
2.Issue ZBEA OA email output in the SO.
 The OA excel file should be generated.
SD-006
 1.Create a manual ZWEB SO in 2000,20,00 sales area.
2.Issue ZBEA OA email output in the SO.
 The OA excel file should be generated.
SD-007
 1.Create a EDI ZWEB SO in 2000,20,00 sales area.
2.Issue ZBEA OA email output in the SO.
 The OA excel file should be generated.
SD-008
 1. Create Contract and corresponding calloff in 2000,10,00 sales area.
2. Issue ZBEA OA email output in the Calloff.
 The OA excel file should be generated.
SD-009
 1. Create Contract and corresponding (partial quantity) calloff in 2000,10,00 sales area.
2. Issue ZBEA OA email output in the Calloff.
 The OA excel file should be generated with selected line items.

Solution Details

[Provide complete technical details for configuration or programming here]

Old config:

1. A new access sequence ZBEA is created and table 902(sales org/sold to party) is assigned to it.


ZBEA Access sequence.JPG



2. A new output type ZBEA is created and the access sequence ZBEA is assigned to it.

ZBEA OA Excel Output type for EMEA.JPG


New config:

2. A new output type ZBEA is created and the access sequence ZMAI is assigned to it.

Assign ZMAI access sequence to ZBEA output type.JPG


3. A new program is created and assigned to ZBEA output with external send as medium.\

ZBEA OA Excel output with new program.JPG

4. The ZBEA output type is assigned to procedure.

Assigning of ZBEA Output to procedure.JPG


5. Disclaimer is added in the ZEBA OA Excel output file as below.

Please note this spreadsheet is not a legal binding document
Please refer to your original PDF order acknowledgment

Issues

[List Issues / Bugs identified in configuration or development]