BI-Dhananjay - 2017-09-27 - 48557 - Enhancement - TAX240 - Add Customer Information #wipdoc

ENHANCEMENT

48557 - 9972 - EMEA Requests - TAX240 - Add Customer Information

Requirement Summary

Need to add customer information to TAX240 report.

Admin Info

Purpose
 Need to add customer information in report.
Requested By
 Saravanan Lakshmanan
Spec Created By
 Dhananjay G
Spec Created Date
 09/27/2017
Spec QA by
 Uday Kumar P
Objects
 TAX240
Document Status
 Complete

Estimates

SNo
 Activity
 Estimation in Hours
1
 Research
 04
2
 Documentation
 01
3
 Development/ Config
 10
4
 Unit test in DEV
 00
5
 Unit test in QUA
 00
6
 Other activity
 00

TOTAL
 15

References

Prior Tickets

None

Document

None

Spec Changes

SNo
 Change Details
 Requested By
 Requested On
 Notes if any

Functional Requirement

Purpose/WHY:

The Finance Team needs to have the information of customers and address directly output by the report instead of systematically manually adding by VLookUp on the report after being extracted
The requirement is to add the customer name, the address, the country after the existing 6th column.

In Scope:

Global Region.

Out of Scope:

Other Regions.

Solution Summary

1. Need to add Customer full information to TAX240 report.
2. Need to validate the report with ECC tables
3. Need to promote the report into BI Production after successful validation.

Test Plan

SNo.
 Test Scenario
 Expected Results
1.
 Report Format.
 As per NEC standards.
2.
 Execute Crystal Report in Crystal Designer tool after changes.
 Report should execute successfully in Crystal Designer tool.
3.
 Schedule the Report in NEC BI Launch Pad.
 Report should execute successfully in NEC BI Launch Pad.

Solution Details
1. Here are the following Solution details as mentioned:

  1. Customer Name: Added KNA1 table to TAX240 report for getting Customer Name(KNA1.NAME1).
  2. Customer Address: Added ADRC table to tax240 for getting full address of Customer
    1. City = ADRC.CITY1
    2. Street = ADRC.STREET

Join Conditions:
VBRK.MANDT –Inner Joinà KNA1.MANDT
VBRK.KUNAG –Inner Joinà KNA1.KUNNR
KNA1.ADRNR –Inner Joinà ADRC.ADDRNUMBER

2. Validated the report with SAP tables successfully.
3. Promoted the report into BI Production after successful validation.

Issues

None