28.9.11

SAP Note 28042 - Drill-down rep.: Numbering for >99 columns in report

Symptom:

Module - R/3 Business Planning and Control
Transaction: Change Drill-Down Report
The following problem occurs in reports with more than 99 lines when you use the function 'Sort lines':
1. Page 0 of 0 - no page number
2. The next line after line 99 is displayed without numbering and is then continued again from the beginning with 1, 2 .... When scrolling, the following message is output 'Please enter a valid value'.
The problem also occurs when you use the functions 'Sort characteristics', 'Sort key figures', and 'Sort columns' within drill-down reporting.

Cause and prerequisites

ad 1. Program error in 2.2.
ad 2. Dialog box is designed for a maximum of 90 entries.

Solution
ad 1. (The problem only occurs in 2.2)
Choose the fullscreen editor for program SAPLKEBR and screen 1000 in transaction SE51, position the cursor on the line "Page __ of __" and choose 'Edit -> Edit lines -> Delete line' to delete the line.
Then make the source code changes described below to reduce the size of the screen.
ad 2. (Releases 2.2 and 3.0)
First change the domain from NUMC2 to NUMC3 for data element RKE_RFLG with transaction SE11. You can then change the length of the heading to three. Activate the data element.
Then choose the fullscreen editor for program SAPLKEBR and screen 1000 in transaction SE51.
Release 2.2:
The field for entering the numbers must be moved 1 byte to the left and extended from two to three characters.
Branch to the change mode, mark field RKB1B-NUMMER01, move the field one byte to the left and then extend the field by adding an underline "_". Generate the screen. adding an underscore "_".
Release 3.0
The field can be extended with the "Field Attribute" button: Change
Vis. lenth to 3.
Then correct the following error message in both releases:
Transaction SE91, Change message class KH.
Message 045:
Sort number & is not allowed (only numbers: 1 to 990)
Message 348:
Enter a number between 1 and 990.

Additional key words

Transaction KCR0, KE30, KCR1, KE31, KCR2, KE32

No comments:

Post a Comment