The records selected using report RSADRQU1 are adjusted to the new data in the GAV tables when the /TRILLIUM/RSADRQU2 is processed. The records are not written back to the database but are stored temporarily using an INDX type cluster table.
You can use the /TRILLIUM/RSADRQU2 report with the details report, which lists the before and after postal validation values. The /TRILLIUM/RSADRQU2 report can also be used for analysis prior to the data being updated to the database.
To initialize the /TRILLIUM/RSADRQU2 report
-
Call the /TRILLIUM/RSADRQU2 program by either:
-
Using transaction /nSA38 – ABAP Editor
-
Selecting ABAP Editor from the SAP Tools menu (Tools > ABAP workbench > Development > ABAP Editor)
The Report Calling window opens.
-
-
Enter the program name /TRILLIUM/RSADRQU2 and click
.The Report Selection window opens.
-
Enter the required values as described in the Table: Table 1.
-
Submit the report online by clicking
or submit it as a background job by selecting
Program > Execute in Background.The Figure displays the statistics report that is created after the /TRILLIUM/RSADRQU2 report has read through all the records and made the necessary adjustments. The Table: Table 2 describes the statistical messages that appear in the report.
-
If you selected the Produce Detail Listing option on the report selection window (Figure: Figure 1), click
twice to view the detail
listing.
Sample details reports are shown in Figures Figure 3 and Figure 4. The Table: Table 3 describes the field names and descriptions generated from the address check and update.
|
Parameter |
Value |
Description |
|---|---|---|
|
Test mode (no updates) |
Yes/No |
Default is Test Mode. Uncheck the selection to run and update the database table with created indexes. |
|
Create detail report |
Yes/No |
Check the selection to include details report of the original and new value prior to update |
|
Exclude addresses that were not checked (country or userexit) |
Yes/No |
Check the selection to exclude the records not checked (for example, inactive country).
|
|
Exclude addresses that are clean and unchanged |
Yes/No |
Check the selection to exclude the records that are clean and unchanged. |
|
Use ALV list display (sorted by application table and key) |
On/Off |
Default is On. Switch this on for the detail report to be listed using ALV. This option is limited by the number of lines it will produce. |
|
Use ABAP list (sorted by address number)
|
On/Off |
Default is Off. Switch this on for the detail report to be listed using the ABAP standard listing. This report will allow an unlimited number of lines to be listed. Note that this will affect the system performance if processing large data volume. Note: Use ABAP list for large amounts of data.
|
|
Use two lines per address (for long addresses) |
Yes/No |
Check the selection to allow two lines in the street address columns. |
|
Message |
Description |
|---|---|
|
Number of addresses with error messages |
Number of address records in which Trillium Quality encountered a condition type of ‘E’ while attempting to check the record. These records will not be written back to the database. |
|
Number of addresses with warning messages |
Number of address records in which Trillium Quality encountered a condition type of ‘W’ while attempting to check the record. |
|
Number of addresses with information messages |
Number of address records in which Trillium Quality encountered a condition type of ‘I’ while attempting to check the record. |
|
Number of addresses without messages |
Number of address records in which Trillium Quality encountered no condition and therefore was unable to provide a message. |
|
Number of addresses with inactive countries |
Number of address records that have a country code that is not flagged for checking. See the configuration settings in the /TRILLIUM/CNTRY table. These records are not written back to the database. |
|
Number of addresses with no changes |
Number of address records that have no changes as a result of the GAV table changes. |
|
Number of addresses to be updated |
Number of address records that changed as a result of the postal data changes and did not encounter any errors during processing, and will update in the address database. |
|
Number of addresses to be updated (status only) |
Number of address records that required status updates only. |
|
Field |
Description |
|---|---|
|
City |
Two-character country code of the listed record. |
|
Table |
Application table of the record being displayed. |
|
Application key |
Master data record number. |
|
S/P |
Street or postal address; either S=Street or P=Postal. |
|
Addr. No. |
Address number of the record being displayed. |
|
Person |
Person number of the record being displayed. |
|
OStat |
Original check status of the record being displayed; either Blank=Not checked, C=Checked against city index, or D=Differs from city index. |
|
NStat |
New check status of the record being displayed: Blank=Not checked, C=Checked against city index, or D=Differs from city index. |
|
Original street addr |
Data value (Street or PO Box Address) prior to postal validation.Lists database on the address line and separated by a forwardslash (/). |
|
New street addr |
Data value (street or PO Box Address) following postal validation.Lists database on the address line and separated by a forward slash. |
|
Message text |
Trillium Quality messages. |