2013-06-25-7521.200-spec-UPDATE WMS VAS Reports #ABAP

SPECIFICATIONS

7521.200 Update WMS VAS Reports


Purpose

Update table ZSDVAS table with all new key combinations VAS codes

Admin Info

Purpose
 Update table ZSDVAS table with all new key combinations for VAS codes
Requested By
 Thi Tran
Spec Created By
 Venkat Kondapally
Spec Created Date
 06/25/2013
Spec QA by
 Surya Basa
Objects
 Table : ZSDVAS, Program : ZRSD_VAS_UPDATE
Document Status
 Complete

References

Prior Tickets

None

Documents

SDE007-01 - WMS VAS Reports Update.docx


Functional Requirement

Update report WMS530 to include all new key combinations of VAS. WMS530 pulls VAS data from table ZSDVAS .So table ZSDVAS should be updated with all new key combinations of VAS codes.

Table Update
The ZSDVAS that stores all these VAS details also needs to be updated, because it includes all fields of all key combinations in order to store the data to be pulled by the reports.
The missing fields that need to be added are:
  1. PH6 – product hierarchy 6 – license
  2. PH4 – product hierarchy 4 – silhouette

Program Updates
Program ZRSD_VAS_UPDATE also needs to be updated to accommodate the new key combinations and populate the correct fields in the table based on the condition record and key combinations.

Solution Summary

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

Modify table ZSDVAS to include two new fields.
There is a limitation with number key fields with table ZSDVAS to include the two new fields, so the table is redesigned to hold all the new vas codes and the program ZRSD_VAS_UPDATE is modified to accommodate the new key fields and new VAS codes.


Test Plan

[List test scenarios/cases to be executed here]
Test Scenario
 Expected Results
Program variant ALLVAS updated
 Program variant is populated with all VAS tablesthat exist in configuration
Program ZRSD_VAS_UPDATE is updated
 Program is updated to include all VAS tablesthat exist in configuration
Table ZSDVAS updated
 New fields for PH4 and PH6 have been added tothe table and are populated appropriately

Solution Details

[Provide complete technical details for configuration or programming here]

The table ZSDVAS has a limitation to have number of key feilds to hold all the New Vas key combinations. So ZSDVAS is completely redesigned with the following new key fields.

1. Client - MANDT
2. Condition Type - VASTYPE
3. VAS Code - VASCODE
4. Access Table - VASACCESS
5. Condition Number - KNUMH

The program ZRSD_VAS_UPDATE is modified to accommodate the new key fields and new VAS codes.

Issues

None