BI-Dhananjay - 2017-10-27 - 63407 - Enhancement - PNC310 Field Addition (Saravanan Lakshmanan by 2017-10-31) #wipdoc
ENHANCEMENT
63407 - PNC310 - BI report
Requirement Summary
Need to add vendor payment terms to the report and export issue fixes.
Admin Info
Purpose
|
Need to add vendor payment terms to the report and export issue fixes.
|
Requested By
|
Saravanan Lakshmanan
|
Spec Created By
|
Dhananjay G
|
Spec Created Date
|
10/26/2017
|
Spec QA by
|
Uday Kumar P
|
Objects
|
PNC310
|
Document Status
|
WIP
|
Estimates
Sl.No
|
Activity
|
Estimation in Hours
|
1
|
Research
|
00
|
2
|
Documentation
|
01
|
3
|
Development/ Config
|
19
|
4
|
Unit test in DEV
|
02
|
5
|
Unit test in QUA
|
00
|
6
|
Other activity
|
00
|
|
TOTAL
|
22
|
References
Prior Tickets
None
Documents
None
Spec Changes
Sl.
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
1.
|
Report Title and Company name's are exported separated columns in PNC310 report
|
Saravanan Lakshmanan
|
12/04/2017
|
IM
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
For the BI report we need to add the vendor payment terms to the report.
In Scope:
Global Region
Out of Scope:
Other Regions
Solution Summary
1. Need to add LFB1-ZTERM (vendor payment terms) to pnc310
field in a new column.
2. Need to validate the report with SAP ECC tables.
3. Need to promote the report into BI Production after successful validation.
4. Need to change the headers from RH to PH for fixing the export issue in BI Porduction.
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 changes made for PNC310 Global report:
a). Added LFB1 table to the report and below join IS given to BSEG:
BSEG.LIFNR -Inner Join-> LFB1.LIFNR
b). Year Prompt is created for limit the data as {BSEG.GJAHR} in{?Year}
2. Validated the report with SAP ECC tables.
3. Promoted the report into BI Production after successful validation.
4. Changed all headers from RH to PH section and applied the suppress condition for not displaying headers on each page as PageNumber>1.
Issues
None