BI-Dhananjay - 2018-01-22 - 74750 - Break Fix - BI Report TAX125 (Saravanan Lakshmanan by 2018-01-26) #wipdoc

BREAK FIX

74750 - BI Report TAX125

Problem Summary

Need to enhance the changes to TAX125 report.

Admin Info

Purpose	Need to enhance the changes to TAX125 report.
Requested by	Saravanan Lakshmanan
Issue Date	01-22-2018
Resolved by	Dhananjay
Resolved Date	01-26-2018
Document Status	WIP

Detailed Problem Description

Saravanan requested on 01-20-2018:

The report needs to be modified a little bit.
1) User should be able to input the state. Eg, CA. (if all is chosen it should display all or else the user should be able to enter states and see the tax data)
2) The tax jurisdiction group2 KNA1.TXJCD, should be removed
3) Add the kna1.txjcd to the details.
If possible add tax jurisdiction description in TTXJT table.

Saravanan requested on 02-02-2018:

Would like to see who the customer belongs to on the report, or run the report by company code.

Solution Analysis and Recommendations

1. Need to check the report parameters in BI production.
2. Need to check the functionality of the report.
3. Need to modified the requested changes in TAX125 report.
4. Need to create Company code as Optional Prompt in report and default value as 'ALL'.
5. Need to validate the report with ECC tables.
6. Need to place the report in BI development and inform NEC for promotion after successful validation.

Test Plan

Test ID	Test Scenario	Expected Results
1	Report Format.	Should be as per NEC crystal standard checklist.
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.

Prior Tickets:

15892

Resolution

1. The following changes are updated in TAX125 report:

1. Created State prompt(passed the value to the prompt as mandatory) as assigned the default value is 'ALL' and added the below condition in Saved Data Selection formula:
if {?State} = 'ALL' then true else
(Left ({KNA1.TXJCD},2 ) = {?State} or {KNA1.TXJCD} = {?State})
2. Removed Group2 section and added the below two fields to details section:
Tax Jurisdiction - KNA1.TXJCD
Tax Jurisdiction Desc - TTXJT.TEXT1
3. The below links are used in the report:
KNA1.MANDT -> TTXJT.MANDT
KNA1.TXJCD -> TTXJT. TXJCD
KNA1.SPRAS -> TTXJT.SPRAS
When we assign inner join between the tables, some of the data is missing because few states are not available in TTXJT table for example: CE,ES etc
due to this reason assigned as Left Outer Join.

2. Created Company code as Optional Prompt in report and default value as 'ALL'.

if {?Company Code} = '' or {?Company Code} = 'ALL' then true else

{KNB1.BUKRS} in {?Company Code}
3. Validated the report with ECC tables.
4. Placed the report in BI development and informed NEC for promotion after successful validation.