SD - Surya - Damodhier - 2016-07-22 - 23923 - Spec- NA Retail Pro (Rizwan by 2016-06-01) #US #SDMiscellaneousReports #ABAPREPORTS

SPECIFICATIONS

23923 - Spec - NA Retail Pro

Purpose

Project to take back ownership and operation of North America Flagship stores from LIDS.
.

Admin Info

Purpose	Project to take back ownership and operation of North America Flagship stores from LIDS.
Requested By	Rizwan Shan
Spec Created By	Surya Basa
Spec Created Date	07/22/2016
Spec QA by	Surya Basa
Objects	ZIMM_XML_INVENTORY_OUTPUT ZSD_SCALE_NO
Document Status	Completed

Estimates

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

References

Prior Tickets

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

NA

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
1	Use material grid number field instead of grid value field J_3APGNR instead of J_3AKORD	Rizwan Shan	08/08/2016
2	Add new logic for SBS_NO for 1300 and 1800 Sales orgn.	Craig Spangler	10/05/2016

Functional Requirement

Purpose/WHY:

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

SAP feeds the material master data in an XML file inventory.xml. The ZIMM_XML_INVENTORY_OUTPUT program uses a retail flag on MM03 to determine what materials are retail relevant. The nightly job is also a delta so it only sends materials if they are new or the description, price or cost has changed.

For the new implementation of retail in NA, we need to assign the subsidiary to be populated the field is "sbs_no" currently it is blank. For US 1000 it should be 1 for Canada 1200 the value should be 2. We must make sure it doesn't affect the EMEA stores, they use the same program.

Also the "scale_no" number needs to be mapped to our grid values number not the description as Retail Pro cannot accept alpha numeric.

Lastly I would like to be able to run the job for multiple plants, as NA will have several plants that are shipping to the stores.

In Scope:

[List the activities to be included in scope]

The changes are applicable to Sales orgs 1000 (US) and 1200 (Canada) and the plants associated with them. Grid values and subsidiary numbers are assigned to the relevant fields on the extract.

Out of Scope:

[Out of scope activities]

- EMEA and Korea extracts are not impacted.
- Change logs on the Ztable

Solution Summary

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

1. SBS_NO should be mapped to sales orgs (1000 = 1 and 1200 = 2).
2. SCALE_NO should be mapped to translate grid values (e.g. SM = 12, OSFA = 1234, M = 2 etc.). A custom table should be created and a T.code assigned to it for user maintenance.

Material Grid Number (J_3APGNR) field should be Key field (J_3APGHD).

Representative example for Development (old)-

Grid Value	Retail Value
5S-XXL	1234
5950	12
678-800	993
FITTED_CAP_GRID	91
OSFA	4321

New (Change 08-08-2016)

Master Grid No.	Grid Text
420-550	19
420-620	21
5950	26
5S-XXL	29
5XS-3XL	30
638-634	41
678-800	43
FITTED_CAP_GRID	91
GIRLS YOUTH	53
M-XL	59
OSFA	64
S-2XL	50
S-5XL	52
S-L	70
S-XL	71
SM-LXL	74
SM-ML	75
TO/CH-CH/YO	76
XS-2XL	81
XS-L	82

3. Materials from the associated plants for 1000/20/00 and 1200/20/00 (V_TVKWZ_ASSIGN) should be exported to the extract based on the input selection.

Test Plan
[List test scenarios/cases to be executed here]

Test ID	Test Scenario	Expected Results
SD001	Sales Org - 1000; Plant - 0110; CUR - USD Variant - 0110	SBS_NO="1"; CURRENCY_NAME="USD" SCALE_NO should match the Ztable Text on the associated Master Grid; SCALE_NO="" If there's no matching entry in the Ztable
SD002	Sales Org - 1000; Plant - 0116; CUR - USD Variant - 0116	SBS_NO="1"; SCALE_NO should match the Ztable Text on the associated Master Grid; SCALE_NO="" If there's no matching entry in the Ztable
SD003	Sales Org - 1200; Plant - 0210; CUR - CAD Variant - 0210	SBS_NO="2"; CURRENCY_NAME="CAD" SCALE_NO should match the Ztable Text on the associated Master Grid; SCALE_NO="" If there's no matching entry in the Ztable
SD004	Sales Org - 2000; Plant - 0310; CUR - GBP Variant - 0310	SBS_NO="1"; CURRENCY_NAME="GBP"; SCALE_NO=""
SD005	Sales Org - 2200; Plant - 0320; CUR - EUR Variant - 0320	SBS_NO="1"; CURRENCY_NAME="EUR"; SCALE_NO=""

Change on 10/05/2016:
SBS_NO should be mapped to sales orgs (1300 = 1 and 1800 = 2)

Test ID	Test Scenario	Expected Results
SD001	Sales Org - 1300; Plant - 0145; CUR - USD Variant - 1300	SBS_NO="1";
SD002	Sales Org - 1800; Plant - 0215; CUR - CAD Variant - 1800	SBS_NO="2";

Solution Details

[Provide complete technical details for configuration or programming here]

The program ZIMM_XML_INVENTORY_OUTPUT is changed to fulfill the above requirements.

Issues

[List Issues / Bugs identified in configuration or development]