ABAP-Venkat - 2015-10-13 - 22110-Expand product catalog capabilities(Filip by 2015-12-31) #ABAPEXTRACT
SPECIFICATIONS
2210-Expand Product Catalog capabilities
Purpose
Expand Product Catalog Capabilities
Admin Info
Purpose
|
Expand Product Catalog Capabilities
|
Requested By
|
Filip
|
Spec Created By
|
Venkat
|
Spec Created Date
|
10/13/2015
|
Spec QA by
|
Venkat
|
Objects
|
ZISD_EXT_PRODUCT_CAT_CHANGE,
ZISD_EXT_PRODUCT_CATALOG
|
Document Status
|
Complete
|
Estimates
Sl.No
|
Activity
|
Estimation in Hours
|
1
|
Research
|
|
2
|
Documentation
|
08
|
3
|
Development/ Config
|
112
|
4
|
Unit test in DEV
|
|
5
|
Unit test in QUA
|
|
6
|
Other activity
|
|
|
TOTAL
|
120
|
References
Prior Tickets
[Provide links of prior associated Spec / Break Fix BOSS document(s)]
Documents
[Attach any document(s) received for the requirement(s)]
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]
Modify ZCATALOG extract with the following
1) Allow option to send exclusively for customer and enter customer ID
2) Allow up to 3 currencies to be selected for output (Must select min. of 1)
3) Run extract from a ROC input file
- a. This can simply be a job that runs 2x a day that looks for a file on a network location
- i. We need to determine the inputs required in the flat file.
4) Option to send extract with a forced NEW status
The extract should be modified to include new fields
5) 9 TOTAL fields for Pricing – at least one price should be on the extract. An error would be introduced if there was not at least one LIST, MSRP and CURRENCY
- a. LIST1
- b. MSRP1
- c. CURRENCY1
- d. LIST2
- e. MSRP2
- f. CURRENCY2
- g. LIST3
- h. MSRP3
- i. CURRENCY3
6) Add customer Account – if a customer ID is entered then it is populated there, otherwise it should say CATALOG
- a. CUSTOMER
ROC Input File Layout:
The input file will have following fields:
- Sales Organization : Mandatory
- Currency 1 : Mandatory
- Currency 2 : Optional
- Currency 3 : Optional
- S/M Indicator(Season Material Indicator ): Mandatory Value should be S or M
- Season: Mandatory if S is selected in 5th column
- Collection : Optional
- Material: Mandatory if M is selected in 5th column
- Customer : Mandatory If 10th Column is selected
- Exclusive : Optional
- Status Flag : Optional
- Output File Path : Mandatory
Prd_cat_input_file_layout.xlsx
In Scope:
[List the
activities to be included in scope]
Out of Scope:
[Out of scope activities]
Solution Summary
[Discuss this section with Requester and get approval prior to beginning work]
Modify Programs ZISD_EXT_PRODUCT_CATALOG and ZISD_EXT_PRODUCT_CAT_CHANGE to accomodate the new changes. The file input is specific to program
ZISD_EXT_PRODUCT_CATALOG only.
Test Plan
[List test scenarios/cases to be executed here]
Testing will done by New Era.
Solution Details
[Provide complete technical details for configuration or programming here]
Modified Programs ZISD_EXT_PRODUCT_CATALOG and ZISD_EXT_PRODUCT_CAT_CHANGE to accomodate the new changes. The file input is specific to program
ZISD_EXT_PRODUCT_CATALOG only.
Issues
[List Issues / Bugs identified in configuration or development]