Home

SAP Module User`s Guide - Support

1. What is the SAP Module s eene 6 SAP Module Components ssuss 6 SAP Module Databases eese nene 6 What is the SAP Module What is the SAP Module Spectrum Technology Platform SAP Module optimizes the quality of your customer vendor and partner records so you can improve operations across the enterprise Because SAP is such a far reaching application introducing accurate address data provides equally far reaching benefits With real time data quality for over 220 countries the SAP Module identifies and manages duplicate records standardizes and validates addresses auto populates missing fields and gives you a single integrated view of your customers SAP Module Components The SAP Module consists of the following components SAP Generate CASS Report This service reads input data from a file that is located in Spectrum Technology Platform installation directory This file contains input addresses Each line contains one record and each record contains address information that is separated by tabs SAP Generate Match Key This service is used in generating a match key The match key is generated using Substring Metaphone and Consonant algorithms SAP Generate Match Score This service is used in comparing candidate records and generating a score that reflects its similarity The higher the score means the closer the match SAP Generate Search Key This serv
2. Chapter 2 Using the SAP Interface Note In CRM the deduplication pop up screen displays with the Merging buttons as seen in Table 4 Duplicate Pop up Screen Buttons on page 21 Table 4 Duplicate Pop up Screen Buttons on page 21 shows the Duplicate Pop up screen buttons and their corresponding function Table 4 Duplicate Pop up Screen Buttons Button Function Merge Current to Duplicate Merges the selected record of the Main screen to the selected record of the Pop up screen Merge Duplicate to Current Merges the selected record of the Pop up screen to the selected record of the Main screen A confirmation pop up displays as shown in Figure 7 Cleansing Case Created Cleansing Case Created Screen on page 21 displaying clearing case created Note The merging process depends on your merge settings If Merge Settings is set to Pitney Bowes Business Insight Merge Process the records are merged automatically If it is set to SAP Merge Process only the data cleansing cases are created and the cleansing case process must be done manually to complete the merge The Pitney Bowes Business Insight Merge Process automatically merges the two records Successful merging displays a status message as shown in Figure 8 Merge Status Message Merge Status Message on page 21 on the Address Master screen If SAP Merge Process is set in the Merge Settings a pop up displays as shown in Figure 7 Cleansing Case Created Cleansing Case Created Scre
3. Korea Republic Of Kosovo Kuwait Kyrgyzstan Lao People s Democratic Republic Latvia SAP Module User s Guide ISO 3116 1 Alpha 2 JM JP JE JO KE KI KP KR KS KW KG LA LV ISO 3116 1 Alpha 3 IMN ISR ITA JAM JPN JEY JOR KEN KIR PRK KOR KOS KWT KGZ LAO LVA Supported Modules Address Now Module Universal Addressing Module Address Now Module Universal Addressing Module Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module Address Now Module Universal Addressing Module Address Now Module Enterprise Geocoding Module Universal Addressing Module Address Now Module Universal Addressing Module Address Now Module Universal Addressing Module Address Now Module Universal Addressing Module Address Now Module Enterprise Geocoding Module Universal Addressing Module Address Now Module Universal Addressing Module Address Now Module Universal Addressing Module Address Now Module Universal Addressing Module Address Now Module Universal Addressing Module Address Now Module Universal Addressing Module Address Now Module Universal Addressing Module Address Now Module Universal Addressing Module Address Now Module Enterprise Geocoding Module Universal Addressing Module Appendix A Country ISO Codes and Module Support 73 Country ISO Codes and Module Support
4. Note When only the Postal Code Country and Region fields are populated the address list does not show any candidate records in the simple tab and an error message is displayed Note If Enterprise Tax is being used and the Tax Jurisdiction Code is required the addresses in the list will also contain the Tax Jurisdiction Code Validating Address Components The Advanced Search is helpful when there is uncertainty in the address entered This feature eases the difficulty of entering and searching even the most complex addresses The Component Tab contains Proposed and Current columns Initially the Proposed column does not contain any value This is because the values are selected per field Note This option will be available only if the Simple Advanced Search option is enabled and the address entered does not produce a unique result 1 Enter the address data in SAP 2 The address goes through the validation process The Advanced Search Tab screen is displayed with blank fields 3 To begin a search click Advanced button The Advanced Search screen is displayed On this screen the entered address is not displayed on the Proposed Address column The address to be searched has to be typed in the fields 4 Results are only displayed on the Out Of Context Alternatives box when entries are found out of the Scope of the search criteria SAP Module User s Guide 15 Address Validation 5 To begin a search enter the address t
5. Austria AT AUT Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module Azerbaijan AZ AZE Address Now Module Universal Addressing Module Bahamas BS BHS Address Now Module Enterprise Geocoding Module Universal Addressing Module Bahrain BH BHR Address Now Module Universal Addressing Module Bangladesh BD BGD Address Now Module Universal Addressing Module Barbados BB BRB Address Now Module Universal Addressing Module Belarus BY BLR Address Now Module Universal Addressing Module Belgium BE BEL Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module Belize BZ BLZ Address Now Module Universal Addressing Module Benin BJ BEN Address Now Module Enterprise Geocoding Module Universal Addressing Module Bermuda BM BMU Address Now Module Universal Addressing Module Bhutan BT BTN Address Now Module Universal Addressing Module Bolivia Plurinational State Of BO BOL Address Now Module Universal Addressing Module Bonaire Saint Eustatius And BQ BES Address Now Module Saba Universal Addressing Module Bosnia And Herzegovina BA BIH Address Now Module Universal Addressing Module Botswana BW BWA Address Now Module Enterprise Geocoding Module Universal Addressing Module SAP Module User s Guide 67 Country ISO Codes and Module Support ISO Country Name English ISO 3116 1 ISO 3116 1 Supported Modules Alpha 2 Alpha 3 Bouvet Isla
6. In Context Alternatives Out of Context Alternatives No Values Na Values Address Fiel Search Proposed Address In Context Alternatives Out of Context Alternatives 20706 LANHAM MD PRINCE GEORGES PARLIAMENT PL GROUP 1 4200 STE 600 Sub Building PO Box 4 Country 1844 US Only a COMPLETED Address wil be Accepted ss Accept Changes q5 Accept Current X Note Only a Completed Address will be accepted by the system 8 To make another search just click the New Search button in the advanced search screen 16 Spectrum Technology Platform 9 0 Chapter 2 Using the SAP Interface c CR7 1 100 PBBI SAP DOC Component Search G beach st san francisco CA US Search Fields In Context Alternatives Out of Context Alternatives No Values No Values Address Fiel Search Proposed Address n ContextAltematives Out of Context Alternatives 20706 LANHAM MD PRINCE GEORGES PARLIAMENT PL GROUP 1 City State County Street Company Building Premise No Sub Building PO Box 4 Country T 26 5 G6 86 Bb G6 BS BS BS Bb BS 4200 STE 600 1844 US Only a COMPLETED Address will be Accepted Accept Changes Accept Current 3 Note You can choose a new search provided you have not selected the Accept Changes button O
7. This service is used in comparing candidate records and generating a score that reflects their similarity The higher the score the closer the match 62 Spectrum Technology Platform 9 0 Chapter 5 Component Reference SAP Generate Search Key This service generates a search key using metaphone substring and consonant algorithms SAP Generate Search Key Consonant Used in Search Key Generation for Consonant Algorithm SAP Generate Search Key Metaphone SAP Generate Search Key Metaphone generates a search key using the metaphone algorithm The Metaphone algorithm codes words using their English pronunciation SAP Generate Search Key Substring SAP Generate Search Key Substring creates a search key by taking a portion of each field and combining the result SAP Validate Address and Assign GeoTAX Info SAP Validate Address and Assign GeoTAX Info validates the addresses and determines the tax jurisdictions that apply to the address SAP Validate Address With Candidates SAP Validate Address With Candidates validates addresses If an address matches multiple addresses in the postal data it returns the candidate addresses SAP Module User s Guide 63 A Country ISO Codes and Module Support In this section Country ISO Codes and Module Support 66 Country ISO Codes and Module Support Country ISO Codes and Module Support The following table lists the ISO codes for each country as well as the modu
8. 903 Beach St San Francisco CA 94109 1001 905 Beach St San Francisco CA 94109 1001 907 Beach St San Francisco CA 94109 1001 909 Beach St San Francisco CA 94109 1001 911 Beach St San Francisco CA 94109 1001 913 Beach St San Francisco CA 94109 1001 915 Beach St San Francisco CA 94109 1001 917 Beach St San Francisco CA 94109 1001 919 Beach St San Francisco CA 94109 1001 Back 1 2 3 4 5 Forward Accept Changes Accept Current 3 fthe address cannot be validated the Invalid Entry Popup displays with the appropriate error message SAP Module User s Guide 57 Data De duplication Z GROUP 1 SAP DQC Postal Validation Web Page Dialog RequestFailedAddress Not Found PostalCode City Address Fields Current Address House Number Street 000 INVALID STREET City INVALID CITY Region MD Postal Code Country US Tax Jurisdiction Code Accept Current 3 3 Choose the action you want to perform Click Accept Changes to accept the address in the Proposed Address column Click Accept Current to accept the address in the Current Address column Click x to cancel the validation Data De duplication Data De duplication is the process of identifying duplicate records in a data set These duplicate records will be presented to the user so that appropriate action i e ignore or choose duplicate record can be taken If a record in the system is similar with the record being created Data De duplication takes place after a
9. Chapter 3 Using SAP Dynpro Note To clear your results and start over click New Search 7 To create a new record using the address click Create Customer Advanced Search Example The following example illustrates how to search for an address when you only know parts of the address In this example you know the ZIP Code Street name and Suite number but not the city state In the Zip field enter 60610 and click the binoculars icon Under In Context Alternatives select 60610 and click Select In Context Click the binoculars button next to the Street field A list of streets in the 60610 ZIP Code is displayed Scroll down and select N STATE ST then click Select In Context Click the binoculars button next to the Premise No field A list of valid building numbers for N STATE ST in the 60610 ZIP Code is displayed Select 1050 then click Select In Context SAP Module User s Guide 51 Using the SAP ICWC In this section QQuerylhg i i55iin ecb iedsabanthacsdaawariasd toad 54 e Creating Business Partner Account 55 e Modifying Business Partner Account 56 e Validating an Address eee eee eee eee 56 Data De duplication 00 cee ee 58 Error Handling temer RE 59 Querying Querying Error tolerant search allow users to find customers vendors prospects or business partners even if the pieces of information are incomplete or partly wron
10. DPV processing SAP Module User s Guide Y DPV confirmed N Address is not deliverable S The primary number was validated but the secondary number could not be confirmed D The primary number was validated but the secondary number was missing from input M The address matches multiple valid delivery points 31 Business Partners 32 Field RDI EWS Telephone Fax Email Description U The address could not be confirmed because the address did not code at the ZIP 4 level V The address caused a false positive violation Return values indicating address type B The address is a business address R The address is a residential address M The address is both a residential and a business address null Not checked because the address did not code at a ZIP 49 level or RDI was not performed The Early Warning System EWS uses the USPS EWS File to validate addresses that are not in the ZIP 4 database One of the following Y Yes the address was validated using the EWS file N No the address was not validated using the EWS file The phone number for the person If there is an extension enter it in the Ext field The fax number for the person If there is an extension enter it in the Ext field The email for the person Click Validate to validate the address fthe address can be validated the Address Changed window displays As you can see the validated address is properly cased
11. Technology Platform 9 0 Appendix A Country ISO Codes and Module Support ISO Country Name English ISO 3116 1 ISO 3116 1 Supported Modules Alpha 2 Alpha 3 Sierra Leone SL SLE Address Now Module Universal Addressing Module Singapore SG SGP Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module Sint Maarten Dutch Part SX SXM Universal Addressing Module Slovakia SK SVK Address Now Module Enterprise Geocoding Module Universal Addressing Module Slovenia Sl SVN Address Now Module Enterprise Geocoding Module Universal Addressing Module Solomon Islands SB SLB Address Now Module Universal Addressing Module Somalia SO SOM Address Now Module Universal Addressing Module South Africa ZA ZAF Address Now Module Enterprise Geocoding Module Universal Addressing Module South Georgia And The South GS SGS Address Now Module Sandwich Islands Enterprise Geocoding Module Universal Addressing Module South Sudan Ss SSD Address Now Module Universal Addressing Module Spain ES ESP Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module Sri Lanka LK LKA Address Now Module Universal Addressing Module Sudan SD SDN Address Now Module Universal Addressing Module Suriname SR SUR Address Now Module Universal Addressing Module Svalbard And Jan Mayen SJ SJM Address Now Module Universal Addressing Module Swaziland SZ SWZ Address Now Modul
12. The organization s street and house or building number For example 430 Main St The municipality name The postal code for the address The country for the address A sub area within a country such as a province state or district You must select a country before you select a region The proprietary codes used in ADP Taxware tax compliance software You can use this code in your ADP Taxware application to find out the tax rate for the jurisdiction A post office box number Check this box if you leave the PO Box field blank If you are entering a PO Box address the postal code for the address The latitude of the address The latitude is a seven digit number in degrees calculated to six decimal places The longitude of the address The longitude is a seven digit number in degrees calculated to six decimal places Indicates if the address is a Commercial Mail Receiving Agency CMRA Y Yes the address is a CMRA N No the address is not a CMRA U Unconfirmed Indicates the results of Delivery Point Validation DPV processing Y DPV confirmed N Address is not deliverable S The primary number was validated but the secondary number could not be confirmed D The primary number was validated but the secondary number was missing from input The address matches multiple valid delivery points U The address could not be confirmed because the address did not code at the ZIP 4 level V The address caused a false p
13. Turkmenistan TM TKM Address Now Module Universal Addressing Module 80 Spectrum Technology Platform 9 0 Appendix A Country ISO Codes and Module Support ISO Country Name English ISO 3116 1 ISO 3116 1 Supported Modules Alpha 2 Alpha 3 Turks And Caicos Islands TC TCA Address Now Module Universal Addressing Module Tuvalu TV TUV Address Now Module Universal Addressing Module Uganda UG UGA Address Now Module Enterprise Geocoding Module Universal Addressing Module Ukraine UA UKR Address Now Module Enterprise Geocoding Module Universal Addressing Module United Arab Emirates AE ARE Address Now Module Universal Addressing Module United Kingdom GB GBR Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module United States US USA Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module United States Minor Outlying UM UMI Address Now Module Islands Universal Addressing Module Uruguay UY URY Address Now Module Enterprise Geocoding Module Universal Addressing Module Uzbekistan UZ UZB Address Now Module Universal Addressing Module Vanuatu VU VUT Address Now Module Universal Addressing Module Venezuela Bolivarian VE VEN Address Now Module Republic Of Enterprise Geocoding Module Universal Addressing Module Viet Nam VN VNM Address Now Module Universal Addressing Module Virgin Islands British VG VGB Address Now Module Univer
14. 4 5 Data De duplication Validating an Address When you enter an address into SAP the SAP Module attempts to validate the address and allows you to accept or reject the validated address 1 Enter the address data in SAP For example 56 Spectrum Technology Platform 9 0 Chapter 4 Using the SAP ICWC 33 milk st boston ma US Create Account Account Sample Account ID 95 Street House Number 33 milk st oa City boston 3 Postal Code Region ma Country US Telephone Fax E Mail Address x 2 When you save the record the address validation process attempts to validate the address Depending on the result of the validation process one of the following windows appears If the address can be validated the Postal Validation window shows the validated Proposed address and the address as you entered it Current Address Z GROUP 1 SAP DQC Postal Validation Web Page Dialog Address Changed Address Fields Proposed Address Current Address House Number 33 Street Milk St 33 milk st City Boston boston Region MA MA Postal Code 02109 5101 Country US US Tax Jurisdiction Code 220210900 Accept Changes Accept Current 3 fthe address you entered matches to multiple addresses in the postal data the Address List Popup displays candidate addresses Z GROUP 1 SAP DQC Postal Validation Web Page Dialog beach st san francisco CA Proposed Address 901 Beach St San Francisco CA 94109 1001
15. 901 Beach St San Francisco CA94109 1001 0 903 Beach St San Francisco CA 94109 1001 905 Beach St San Francisco CA 94109 1001 907 Beach St San Francisco CA 94109 1001 909 Beach St San Francisco CA 94109 1001 911 Beach St San Francisco CA 94109 1001 913 Beach St San Francisco CA 94109 1001 l 915 Beach St San Francisco CA 94109 1001 917 Beach St San Francisco CA 94109 1001 919 Beach St San Francisco CA 94109 1001 921 Beach St San Francisco CA 94109 1001 923 Beach St San Francisco CA 94109 1001 925 Beach St San Francisco CA 94109 1001 927 Beach St San Francisco CA 94109 1001 929 Beach St San Francisco CA 94109 1001 EE Row 1 otso Ifthe address could not be validated the Invalid Address popup is displayed 42 Spectrum Technology Platform 9 0 Chapter 3 Using SAP Dynpro i SAP DQC Postal Validation Request failed Address not found i 000 Something Road City New York Region MA Postal Code Country US EELA Ro w rlete T 2 To use the validated address in the business partner you are creating click Accept Changes 6 Click Deduplicate to verify that this entry is not already in the SAP system This helps prevent you from creating a duplicate record If one or more duplicate records are found the following window is displayed i SAP DQC Address Deduplication Result i PV Status Similarity BP Number Description Name 1 Last Na
16. ADRNR Message TSADRVGRPE KNAl ADRNR Ended Extract Index 24 11 2010 09 14 06 Started Matchkey Generation 24 11 2010 09 14 06 Processing Matchkey Record s Ended Matchkey Generation 24 11 2010 09 14 06 Total Address Processed 147 Total Matchkey Generated 147 Index Initialization Finished gt 24 11 2010 09 14 06 Error Handling There are two kinds of error messages provided in this system The first kind would be the standard error messages provided by SAP which will not be discussed in this document The second kind would be the error messages provided by the SAP DQC In Data Cleansing for example if the address entered was 000 INVALID STREET INVALID CITY MD US the figure below shows how this address entry is made in SAP Street Address Street House number INVALID STREET Ix Postal Code City E INVALID CITY Country US on m 5 Upon Saving or Checking the record this address will go through Address Validation A confirmation pop up prompts the user that the Address Validation was made In this particular case the address does not exist therefore the appropriate error message is returned In this pop up the error message is displayed e RequestFailed Address Not Found PostalCode City SAP Module User s Guide 27 Error Handling For other cases such as the HTTP request timed out or a connection to the host could not be established the error message returned by Sp
17. CA 94109 1001 913 Beach St San Francisco CA 94109 1001 915 Beach St San Francisca CA 94109 1001 917 Beach St San Francisco CA 94109 1001 919 Beach St San Francisco CA 94109 1001 921 Beach St San Francisco CA 94109 1001 923 Beach St San Francisco CA 94109 1001 925 Beach St San Francisco CA 94109 1001 927 Beach St San Francisco C4 94109 1001 929 Beach St San Francisco CA 94109 1001 931 Beach St San Francisco CA 94109 1001 Accept changes G5 Accept Current Advanced 3 Since the address contains multiple matches the address list pop up is displayed with all candidate addresses 2 To select a candidate address highlight it from the list and click the Accept Changes button When you click the Accept Changes button the Postal Validation Pop up is displayed with the selection you have made 3 Click the Accept Changes button to accept the validated cleansed address Click the Accept Current button to accept the address you entered Or click the red X to cancel the validation Click the Advanced button to access the Advanced Search window For more information on the Advanced Search window refer to Validating Address Components on page 15 Note When there are no candidates or you choose to click the Accept Current button from the Address List Pop up that displays all possible candidates the Postal Validation Pop up does not appear and the original value entered is retained
18. ISO Country Name English ISO 3116 1 ISO 3116 1 Supported Modules Alpha 2 Alpha 3 Lebanon LB LBN Address Now Module Universal Addressing Module Lesotho LS LSO Address Now Module Enterprise Geocoding Module Universal Addressing Module Liberia LR LBR Address Now Module Universal Addressing Module Libyan Arab Jamahiriya LY LBY Address Now Module Universal Addressing Module Liechtenstein LI LIE Address Now Module Enterprise Geocoding Module e Enterprise Routing Module Universal Addressing Module Lithuania LT LTU Address Now Module Enterprise Geocoding Module Universal Addressing Module Luxembourg LU LUX Address Now Module Enterprise Geocoding Module j Enterprise Routing Module Universal Addressing Module Macao MO MAC Address Now Module Enterprise Geocoding Module Universal Addressing Module Macedonia Former Yugoslav MK MKD Address Now Module Republic Of Universal Addressing Module Madagascar MG MDG Address Now Module Universal Addressing Module Malawi MW MWI Address Now Module Universal Addressing Module Malaysia MY MYS Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module Maldives MV MDV Address Now Module Universal Addressing Module Mali ML MLI Address Now Module Enterprise Geocoding Module Universal Addressing Module Liechtenstein is covered by the Switzerland geocoder i Luxembourg is covered by the Belgium geocoder 74 Spectrum Technology Pl
19. The messages are then displayed to the user There are error messages created by SAP CRM IC Web Client such as the account is required when saving message Identify Account Back Make an entry in field Account 2 Messages amp 9 Required field has no entry Create Account Installed Base Object Account Component Account ID 90 Product ID Street House Number a Identification City C Search Clear Postal Code Region a Country a Telephone Fax E Mail Address Another example is the postal validation was cancelled by the user message Identify Account KaBack EJ Cancelled by the user 1 Message Create Account Installed Base Object Account Sample Component a Account ID 91 Product ID a Street House Number 33 milk st City boston Postal Code Region 12345 MA Massachusetts Country US USA Telephone Fax E Mail Address SAP Module User s Guide Identification Search Clear 59 Component Reference In this section SAP Batch Assign GeoTAX Info llusss 62 e SAP Batch Validate Address 00 cece ee eeee 62 SAP Generate CASS Report i 62 SAP Generate Match Key sssuss 62 SAP Generate Match Score 0 cee eee eee 62 SAP Generate Search Key 2 00 e eee eee eee 63 SAP Generate Search Key Consonant 63 SAP Generate Search Key Metaphone 63 SAP Generate Search Key Substring
20. country company code Maximum No of Hits Customers by country Customers by personnel number Customers by Tax Information Customers by Address Attributes Proceed Initially According to Customer Sub Ledger Account JV partner in coding block Customers per account group Customers With Lease Out Customers per sales group Customers with plant reference Custorners for Head Offices Customers by class Customer By Real Estate Contract 2 Enter any information in any of the fields to perform the error tolerant search In this particular case the information Pitney Bowes Business Insight was entered in the name field zc PB1 1 100 Search for customers by address attributes fuzzy search Ea Name Name Street Address Street House number Postal Code City iviix PB1 1 100 Fuzzy Rough Search Pitney Bowes Business Insight 4 2 i 2 Ble s Results for Pitney Bowes Business Insight Pv StatudCustomer No Similarity Namei Last Name Name2 Fist Name Formatted Address 0000000007 100 0 Pitney Bowes Business Insight Pitney Bowes Business Insight 1210 Trinity Rd Raleigh NC 27607 4945 4945 w 0000000006 71 0 Pitney Bowes Pitney Bowes 1210 Trinity Rd Raleigh NC 27607 4945 4945 Open Selected Record WE cancel 12 Spectrum Technology Platform 9 0 Chapter 2 Using the SAP Interface 4 Select f
21. in the postal data the Address List pop up displays SAP DQC Postal Validation uh beach st san francisco Address 903 Beach St San Francisco CA 94109 1001 905 Beach St San Francisco CA 94109 1001 907 Beach St San Francisco CA 94109 1001 909 Beach St San Francisco CA 94109 1001 911 Beach St San Francisco CA 94109 1001 913 Beach St San Francisco CA 94109 1001 915 Beach St San Francisco CA 94109 1001 917 Beach St San Francisco CA 94109 1001 919 Beach St San Francisco CA 94109 1001 921 Beach St San Francisco CA 94109 1001 823 Beach St San Francisco CA 94109 1001 925 Beach St San Francisco CA 94109 1001 927 Beach St San Francisco CA 94109 1001 929 Beach St San Francisco CA 94109 1001 T T2 Row 1 jotso v x fthe address could not be validated the Invalid Address popup is displayed SAP Module User s Guide 39 Business Partners SAP DQC Postal Validation Request failed Address not found Address Fields uh NEL m Street 000 Something Road iml City New York Region CA Postal Code 3 Country us Tax Jurisdiction Code z Row s or7 Ej Accept Current 3 Cancel To use the validated address in the business parter you are creating click Accept Changes 5 Click Deduplicate to verify that this entry is not already in the SAP system This helps prevent you from creating a duplicate record If one or more duplicate records are found the f
22. page click Customer Click Create Customer then click Create Customer General Field Title First Name Last Name Street House Number City Postal Code Country Region PO Box Postal Code Telephone Fax Email Description A title of respect or professional title The person s given name For example in the name John Smith John is the first name The person s family name For example in the name John Smith Smith is the last name The person s street and house or building number For example 430 Main St The municipality name The postal code for the address The country for the address A sub area within a country such as a province state or district You must select a country before you select a region A post office box number If you are entering a PO Box address the postal code for the address The phone number for the person If there is an extension enter it in the Ext field The fax number for the person If there is an extension enter it in the Ext field The email for the person 5 Click Validate to validate the address 44 If the address can be validated the Address Changed window displays As you can see the validated address is properly cased and the postal code has been added Spectrum Technology Platform 9 0 Chapter 3 Using SAP Dynpro Ifthe address matches multiple addresses in the postal data the Address List pop up displays G beach st san fr
23. that Enhanced Carrier Route subscription mailings are sorted as close as possible to the actual delivery sequence the eLOT database is required for certain types of postal discounts You will receive monthly updates to your eLOT database on the same media as the U S Postal database You must install the U S Postal database and eLOT database from the same month i e September eLOT data must be processed with a September U S Postal database If the U S Postal database and the eLOT database are not from the same month there may be ZIP 4 Codes for which eLOT numbers cannot be assigned The ZIP Code ZIP 4 Code carrier route code and the delivery point of an address must be provided to assign a eLOT code EWS Database Optional U S Download for free addresses only from USPS The Early Warning System EWS database prevents address website validation errors that can result due to a delay in postal data reaching the U S Postal database The EWS database consists of partial address information limited to the ZIP Code street name pre and post directionals and a suffix For an address record to be 8 Spectrum Technology Platform 9 0 Chapter 1 Introduction to the SAP Module Database Name amp Description Required or Supplier Optional EWS eligible it must be an address not present on the most recent monthly production U S Postal database The USPS refreshes the EWS file on a weekly basis Thursday
24. the following fields Field Description Title A title of respect or professional title First Name The person s given name For example in the name John Smith John is the first name Last Name The person s family name For example in the name John Smith Smith is the last name Street House The person s street and house or building number For example 430 Main Number St City The municipality name Postal Code The postal code for the address Country The country for the address Region A sub area within a country such as a province state or district You must Tax Jurisdiction PO Box PO w o number select a country before you select a region The proprietary codes used in ADP Taxware tax compliance software You can use this code in your ADP Taxware application to find out the tax rate for the jurisdiction A post office box number Check this box if you leave the PO Box field blank Postal Code If you are entering a PO Box address the postal code for the address Latitude The latitude of the address The latitude is a seven digit number in degrees calculated to six decimal places Longitude The longitude of the address The longitude is a seven digit number in degrees calculated to six decimal places CMRA Indicates if the address is a Commercial Mail Receiving Agency CMRA Y Yes the address is a CMRA N No the address is not a CMRA U Unconfirmed DPV Indicates the results of Delivery Point Validation
25. the reference data Address has been checked and does not conform to the reference data Only the user can set this status Address has not been checked or it has failed cleansing No Address To continue with saving the new business partner and ignore the duplicates click Continue To view the selected duplicate and cancel the creation of the new business partner click Switch to Duplicate To view the selected duplicate in a new popup window click Display Partner To return to the new business partner without taking any action on the duplicates click Cancel 6 After you have validated the address and checked for duplicates click Save Creating a Business Partner Group A Business Partner Group is similar to a Business Partner Person except there are two names on the record An example would be a married couple 1 In a web browser open the Pitney Bowes Spectrum Data Quality Connector for SAP page 2 Click Create Business Partner then click Group 3 Complete the following fields Field Description Title Optional If desired you may select Mr and Mrs SAP Module User s Guide 37 Business Partners Field Name 1 Name 2 Street House No City Postal Code Country Region Tax Jurisdiction PO Box PO w o number Postal Code Latitude Longitude CMRA DPV RDI EWS Description The name of one of the individuals in the group The name of one of the individuals in the group
26. 1001 925 Beach St San Francisco CA 94109 1001 927 Beach St San Francisco CA 94109 1001 929 Beach St San Francisco CA 94109 1001 Row 1 of50 ACC fthe address could not be validated the Invalid Address popup is displayed SAP DQC Postal Validation Request failed Address not found Address Fields uh Street 000 Something Road City New York Region CA __ Postal Code Country us __ Tax Jurisdiction Code EE few rerz CET Ea Accept Current ent x gt Cancel To use the validated address in the business parter you are creating click Accept Changes 5 Click Deduplicate to verify that this entry is not already in the SAP system This helps prevent you from creating a duplicate record 36 Spectrum Technology Platform 9 0 Chapter 3 Using SAP Dynpro If one or more duplicate records are found the following window is displayed PV Status Similarity BP Number Description Name 1 Last Name 2 First 2a PHE i v 100 0 136 1 PO Box 1 New York NY 10002 0001 i v 100 0 50 1 Po Box 1 New York NY 10116 0001 LET ins A Continue Ee Switch to Duplicate yp Display Partner X Cancel The PV column Postal Validation indicates whether the address has been validated The icons in the column are described in the following table Table 6 Status Icons Description Address has been checked and conforms to
27. 63 SAP Validate Address and Assign GeoTAX Info 63 SAP Validate Address With Candidates 63 SAP Batch Assign GeoTAX Info SAP Batch Assign GeoTAX Info SAP Batch Assign GeoTAX Info identifies the tax districts that apply to a given address It also corrects and validates addresses Note There is a version of this service that uses the Enterprise Tax Module This version will be used if you require Taxware information such the Tax Jurisdiction Code or the Tax County SAP Batch Validate Address SAP Batch Validate Address standardizes and validates address data using batch processing SAP Generate CASS Report SAP Generate CASS Report reads input data from a file that is located in Spectrum Technology Platform installation directory This file contains input addresses Each line contains one record and each record contains address information that is separated by tabs SAP Generate Match Key This service is used in generating a match key The match key is generated using Substring Metaphone and Consonant algorithms These algorithms are described below Table 11 Key Generation Algorithms Algorithm Description Substring Returns a specified portion of the selected field Metaphone Returns a metaphone coded key of selected fields Metaphone is an algorithm for coding words using their English pronunciation Consonant Returns specified fields with consonants removed SAP Generate Match Score
28. Changes 5 Click Deduplicate to verify that this entry is not already in the SAP system This helps prevent you from creating a duplicate record If one or more duplicate records are found the following window is displayed PV Status Similarity BP Number Description Name 1 Last Name 2 First TE a i v 1000 136 1PO Box 1 New York NY 10002 0001 i v 1000 50 Po Box 1 New York NY 10116 0001 E gt Row 1 of3 wf Continue FEE Switch to Duplicate amp y Display Partner_ 9 Cancel The PV column Postal Validation indicates whether the address has been validated The icons in the column are described in the following table Table 10 Status Icons Description Address has been checked and conforms to the reference data Address has been checked and does not conform to the reference data Only the user can set this status Address has not been checked or it has failed cleansing No Address To continue with saving the new business partner and ignore the duplicates click Continue To view the selected duplicate and cancel the creation of the new business partner click Switch to Duplicate To view the selected duplicate in a new popup window click Display Partner To return to the new business partner without taking any action on the duplicates click Cancel 6 After you have validated the address and checked for duplicates click Save Viewing and Modifying
29. Data De duplication SAP Module User s Guide 55 Modifying Business Partner Account Modifying Business Partner Account The Modify Account page is used for displaying modifying of Business Partner Account It can be accessed by selecting an account in search screen Identify Account ID 93 Ki Back EJ Postal Validation complete 1 Message Account More Fields Installed Base Object First Name Last Name Component Function Product ID a Department Identification Account Sample Search Clear Street House Number Milk St 33 City Boston Postal Code Region 02109 5101 MA Massachusetts Country US USA Contact Info For Account Telephone Extension Fax Extension E Mail Address Confirm E X y Related Z7 Button Function Confirm Confirm the account Perform postal validation and data de duplication then save the account EJ Cancels the modify account process It will return to previous screen x Related Create related business partner or contact person Start modifying the account This button should be clicked to enable Save button 4 Perform postal validation and data de duplication To start modifying the account user must click Edit button When user have finished modifying the account and clicked the save button Data Cleansing and Data De duplication will be performed For more details about Data Cleansing please refer to section 4 4 Data Cleansing and for Data De duplication please refer to section
30. Database OFormat Completely from Archive You can filter by User and Date Transaction Code Program Object and by the Log Class Once inside you can view the different transactions made by the SAP Module oes m 1B 24 11 2010 07 41 02 ANSHUMAN logs are displayed Spectrum Technology Platform 9 0 2 SAP DQC 2 1 Problem class Additional information 2 b 24 11 2010 07 41 02 ANSHUMAN 2 SAP DQC 2 1 DQC Logging SESB 00000000000000002148 D 8 24 11 2010 07 41 02 ANSHUMAN 2 SAPDQC2 1 DQC Logging SE38 UDODDODDDODODOD02149 b 8 24 11 2010 07 41 02 ANSHUMAN 2 SAP DQC 2 1 DQC Logging SE38 UDODDODODODODODO2150 b 8 24 11 2010 07 41 02 ANSHUMAN 2 SAP DQC 2 1 DQC Logging SE38 4 00000000000000002151 b 24 11 2010 07 41 02 ANSHUMAN 2 SAPDQC2 1 DQC Logging SE38 00000000000000002152 b 8 24 11 2010 07 41 03 ANSHUMAN 2 SAPDQC2 1 DOC Logging SE38 00000000000000002153 b 68 24 11 2010 07 41 03 ANSHUMAN 2 SAPDQC2 1 DQC Logging SE38 00000000000000002154 b 24 11 2010 07 41 03 ANSHUMAN 2 SAPDQC2 1 DQC Logging SE38 90000000000000002155 b 8 24 11 2010 07 41 03 ANSHUMAN 2 SAPDQC2 1 DQC Logging SE3B 00000000000000002156 b 8 24 11 2010 07 41 03 ANSHUMAN 2 SAPDQC2 1 DQC Logging SE38 O0000000000000002157 b 24 11 2010 07 ANSHUMAN 2 SAPDQC2 1 DQC Logging SE38 00000000000000002158 b 24 11 2010 07 41 03 ANSHUMAN 2 SAPDQC2 1 DQC Logging SE38 00000000000000002159 b 8 24 11 2010 07 41 03 ANSHUMAN 2 SAPD
31. GRP1 RSADRDEDUP Greate Su ts Source Code O Variants O attributes ODocumentation OText elements Figure 12 Batch De duplication Program in SE38 PBBI SAP DQC Report Batch Deduplication es Package Size 2 500 Figure 13 Batch De duplication Initial Screen PBBI SAP DQC Report Batch Deduplication Process Run Date 24 11 2010 Started at 13 45 50 Process End Date 24 11 2010 Finished at 13 46 13 Total Records Processed 146 Figure 14 Batch De duplication Report Screen Viewing the Log The SAP Module uses the built in application log of SAP To view the log entries you can enter the transaction SLG1 Note HSGRP1 DQC is the object name to use to view logs specific to the SAP Module 1 To view the entries of this table enter the transaction SLG1 SAP Module User s Guide 23 Viewing the Log 24 3 To view the XML message passed or received by the SAP Module click on the Detail button The Analyse Application Log Object f Subobject 2 External ID From Date Time 24 11 2010 5 00 00 co 5 To Date Time 24 11 2010 5 23 59 se 5 Transaction code 5 Program B O Only very important logs Any O Only important logs O Dialog O Also less important logs O1Tn batch mode OBatch input Log S nattinc Format Completely from Database OFormat Only Header Data from
32. LDERS INCLUDED IN THIS NOTICE BE LIABLE FORANY CLAIM ORANY SPECIAL INDIRECT OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE DATA OR PROFITS WHETHER IN AN ACTION OF CONTRACT NEGLIGENCE OR OTHER TORTIOUS ACTION ARISING OUT OF OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE Except as contained in this notice the name of a copyright holder shall not be used in advertising or otherwise to promote the sale use or other dealings in this Software without prior written authorization of the copyright holder SAP Module User s Guide 85
33. QC2 1 DQC Logging SE3B 00000000000000002160 b 8 24 11 2010 07 41 03 ANSHUMAN 2 SAPDQC2 1 DQC Logging SE38 OO000000000000002161 b 24 11 2010 07 41 03 ANSHUMAN 2 SAPDOC2 1 DOC Loaging SE38 DDODDODODODO00002162 Chapter 2 Using the SAP Interface Display logs lt xml versionz 1 0 encoding utf 8 gt message lt propertysets gt propertyset name context gt property ke count id va ee j gt property ke count password v mS lt property key service name value SAPGenerateMatchScore gt lt propertyset gt lt propertysets gt dataset columns column name 2 column name Threshold gt lt columns gt records record field value 0000010610 gt 00010609 gt ney Bowes gt lt field value SAPDQC Note These XML message logs are created depending on the General Behavior settings In the case where the Host where the Enterprise Server is installed cannot be reached no received XML will be logged Resynchronizing the Index Pool Index Pool Resynchronization is the process of reinitializing the table HSGRP1 MATCHKEY If there are records created during a downtime of some sort there is a possibility that the search process will not provide complete results Upon creation update or search automatic resynchronization will take place to update the index If the number of unsync records exceeds the set threshold you
34. Spectrum Technology Platform Version 9 0 SAP Module User s Guide Contents Chapter 1 Introduction to the SAP Module sees 5 Whiatis the SAP Module uiii a s teb teile tlie 6 SAP Module Components cccccccceeceeeeeeeeeneeeeeeeeeeeeseeaseaneeeseseeeeseseesseesneaseesned 6 SAP Module Databases nere tke ener eeneid 6 Chapter 2 Using the SAP Interface secccceceeseseeseeeeeseeeeeeeseseeneeneeeeenenes 11 Locating Records eicere tea ku RR NEATA ENESENN ERR RD M BER Ri RRE IER 12 Address Validation orte Een 13 Validating an AddEess iu od oret mee dede xa ERR 13 Validating an Address with Multiple Matches seeeess 14 Validating Address Components 2 5 2 2 5 2 gabe eee d aset ente 15 Processing am Invalid Address ia ottiene ate et tini tete sets 17 Performing Batch Address Validation eere 18 Business Partner Record Deduplication seeeeeeeeeeeessese 19 Merging Business Partner FeCOFIdSs iiie etc titer tutore bebe eee 19 Batch Merging Business Partner Records ssssee 21 Batch JBesduplicatiOli ccn irai o ttn A RATA 22 Viewing the E 23 Resynchronizing the Index Pool eene nnns 25 Initializing Search Key sennen e aaa 25 Error Handling rU oai ies 27 Chapter 3
35. Using SAP DynpDEO uueiisaernickn kai karl R AMA RE E da b cio 29 IMO MU CUO 30 Business Parte MSiiiessccccceciscsceeecesscceeeecesticces castcaceresastecesesnscacesestsscaeeetesscceversstsiiee 31 Creating a Business Partner Person eene 31 Creating a Business Partner Organization ssssseess 34 Creating a Business Partner Group oes eene renati 37 Viewing and Modifying a Business Partner sssess 41 Searching for a Business Partir ues pons aia 41 Customers e rene A ted aati A1 Creating a Customer Generals ecco cedi ted nasties 41 Creating a Customer COnSUmeor iron ciii bobo Eee od ION AI De DUCERE Da S pcue A 44 Viewing and Modifying a Customoer iiici cope echt E eet ic apa toe e patet 46 Searching fora GUSIOGE occi Reiten pee pte und Eats dm viu PI ed AT GIN OMe casiscc coca sss a Eti uie directi AT Creating E R liso EE AT Viewing and Modifying Vendor ii apio c bevau Era ew vaa Ri pre Usa Lari 49 Searching Tora Vondo aids cane o Yet ro e Ea Ee er e i eese a eer eer 50 Searching for an Address with Advanced Search 50 Chapter 4 Using the SAP IGWU iiciesezsassitixbuxktR MR ERE Eap E xL XE EIER ASA Mau E LUE exa US 53 Queryilig uionuniiit e Hisp eric ie ett dece EE o coit Hide cree adire a Ea e edad 54 Creating Business Partner Account e
36. WS file The phone number for the organization If there is an extension enter it in the Ext field The fax number for the organization If there is an extension enter it in the Ext field The email for the organization 4 Click Validate to validate the address If the address can be validated the Address Changed window displays As you can see the validated address is properly cased and the postal code has been added SAP Module User s Guide 35 Business Partners Address Fields zz r2 Street Water St water st i City Lee lee Region MA MA Postal Code 01238 9008 01238 9008 Country us us i Tax Jurisdiction Code 2753 i ys Latitude Longitude CMRA u u R Row 1 ot13 s f Accept Current 3 fthe address matches multiple addresses in the postal data the Address List pop up displays SAP DQC Postal Validation uh beach st san francisco 901 Beach St San Francisco CA 94109 1001 903 Beach St San Francisco CA 94109 1001 905 Beach St San Francisco CA 94109 1001 907 Beach St San Francisco CA 94109 1001 909 Beach St San Francisco CA 94109 1001 911 Beach St San Francisco CA 94109 1001 913 Beach St San Francisco CA 94109 1001 915 Beach St San Francisco CA 94109 1001 917 Beach St San Francisco CA 94109 1001 919 Beach St San Francisco CA 94109 1001 921 Beach St San Francisco CA 94109 1001 923 Beach St San Francisco CA 94109
37. a Vendor 1 In a web browser open the Pitney Bowes Spectrum Data Quality Connector for SAP page 2 Click Display Vendor 3 Enter the vendor number If you do not know the vendor number you can look it up using the fuzzy search feature For more information see Searching for a Vendor on page 50 4 Click Change SAP Module User s Guide 49 Searching for an Address with Advanced Search 5 Edit the vendor For additional information see Viewing and Modifying a Vendor on page 49 Searching for a Vendor Error tolerant searches allow you to find vendors even if the pieces of information are incomplete or partly wrong The search displays a list of possible matches OCT c ON E In a web browser open the Pitney Bowes Spectrum Data Quality Connector for SAP page Click Vendor Click Fuzzy Rough Search In the Name field enter the name of the vendor you are searching for Under Street Address enter as much address information as you know Click Fuzzy Rough Search Searching for an Address with Advanced Search 50 Advanced search helps you find an address when you only know part of the address Note Advanced search is only available for addresses in Canada and the U S You must have licensed the Address Now Module in order to use Advanced Search In a web browser open the Pitney Bowes Spectrum Data Quality Connector for SAP page Click Advanced Search Enter part of the address that you know then click the binocul
38. ame Component Account sampl Product ID Account ID Identification Street House Number Search Clear City Postal Code Regian Country a Telephone E Mail Address Transaction ID Fax Relationship Has Contact Person Search Account Clear C Result List 2 Account s found Account Account ID Street PostalCode City Telephone Extension Sample 93 Milk St 02109 5101 Boston Sample2 94 Water St 01236 9005 Lee Here the user can choose select from the result list to display the details of the account or simply click on Clear button to reset the search Creating Business Partner Account The Create Account page is used for creating Business Partner Account It can be accessed by clicking the Create Account button in the search screen Identify Account Back EJ Create Account Installed Base Object Account Component a Account ID 95 Product ID s Street House Number a Identification City Cj Search Clear Postal Code Region a a Country m Telephone Fax E Mail Address x Function Perform postal validation and data de duplication and save the created account Cancels the create account process It will return to previous screen Perform postal validation and data de duplication During the creation of account Data Cleansing and Data De duplication will be performed For more details about Data Cleansing please refer to section 4 4 Data Cleansing and for Data De duplication please refer to section 4 5
39. ancisco Addre Ss m 903 Beach St San Francisco CA 94109 1001 905 Beach St San Francisco CA 94109 1001 907 Beach St San Francisco CA 94109 1001 909 Beach St San Francisco CA 94109 1001 911 Beach St San Francisco CA 94109 1001 913 Beach St San Francisco CA 94109 1001 915 Beach St San Francisco CA 94109 1001 917 Beach St San Francisco CA 94109 1001 919 Beach St San Francisco CA 94109 1001 921 Beach St San Francisco CA 94109 1001 923 Beach St San Francisco CA 94109 1001 925 Beach St San Francisco CA 94109 1001 927 Beach St San Francisco CA 94109 1001 929 Beach St San Francisco CA 94109 1001 5 3 Row 1 To use the validated address in the business partner you are creating click Accept Changes SAP Module User s Guide 45 Customers 6 Click Deduplicate to verify that this entry is not already in the SAP system This helps prevent you from creating a duplicate record If one or more duplicate records are found the following window is displayed i PV Status Similarity BP Number Description Name 1 Last Name 2 First Emo po v 1000 136 IPO Box 1 New York NY 10002 0001 v 100 0 50 Po Box 1 New York NY 10116 0001 EET row tjor3 T T f Continue z Switch to Duplicate amp y Display Partner 3 Cancel The PV column Postal Validation indicates whether the address has been validated The icons in the col
40. and the postal code has been added i SAP DQC Postal Validation i Address changed i Address Fields in um ee ee eee f Street Water St water st City Lee lee i Region MA MA Postal Code 01238 9008 01238 9008 Country US US E Tax Jurisdiction Code 2753 i Latitude i Longitude CMRA uU DPV u RDI R EWS Row 1 of 13 IE Accept Changes ma Accept Current 3 fthe address matches multiple addresses in the postal data the Address List pop up displays Spectrum Technology Platform 9 0 SAP DQC Postal Validation c beach st san francisco Address 903 Beach St San Francisco CA 94109 1001 905 Beach St San Francisco CA 94109 1001 907 Beach St San Francisco CA 94109 1001 909 Beach St San Francisco CA 94109 1001 911 Beach St San Francisco CA 94109 1001 913 Beach St San Francisco CA 94109 1001 915 Beach St San Francisco CA 94109 1001 917 Beach St San Francisco CA 94109 1001 919 Beach St San Francisco CA 94109 1001 921 Beach St San Francisco CA 94109 1001 923 Beach St San Francisco CA 94109 1001 925 Beach St San Francisco CA 94109 1001 927 Beach St San Francisco CA 94109 1001 929 Beach St San Francisco CA 94109 1001 Row 1 of50 x Chapter 3 Using SAP Dynpro fthe address could not be validated the Invalid Address popup is displayed SAP DQC Postal Validation Request failed Address not found Address Fields uh Street 000 Something R
41. are m Coe lend orien 0 Wesker St Gema V hse E rosas is TZ DE BPBIPEIEBEDEEEEEPEBEDEIS HEE KERETEN a Dov Opton Disbin RD Octon Ditke EDDA Bushes c Figure 4 Address Master Main Screen Duplicate Check Threshold 30 0 Maximum No of Hits Figure 5 Duplicate Check Threshold and Maximum No of Hits Filter Table 2 Status Icons on page 20 shows the Status icons in the Address Master main screen and their corresponding definition Table 2 Status Icons Description Address has been checked and conforms to the reference data Address has been checked and does not conform to the reference data Only the user can set this status Address has not been checked or it has failed cleansing No Address Table 3 Address Master Main Screen Buttons on page 20 shows the buttons seen in the Address Master main screen Table 3 Address Master Main Screen Buttons Button Function Check for Duplicates Displays the candidate duplicate or duplicates of the selected business partner Show Statistics Display overall statistics information of the selected addresses in Address Master Similar to the deduplication pop up screen that displays during the creation of customers vendors or business partners the duplicate pop up screen shown in Figure 6 Duplicate Pop up Screen Duplicate Pop up Screen on page 21 contains the candidate duplicate or duplicates of the selected record 20 Spectrum Technology Platform 9 0
42. ars icon The possible matches for your search are displayed in the In Context Alternatives and Out of Context Alternatives lists In context results are those that are valid in combination with the address elements you have already committed and out of context results are those that are not valid in combination with the elements you have already committed For example in the U S the following cities exist In Illinois CHICAGO CHICAGO HTS CHICAGO RIDGE NORTH CHICAGO WEST CHICAGO In Indiana EAST CHICAGO In Nevada CHICAGO PARK If you have already committed a value of IN Indiana for the state and then searched for the city chicago EAST CHICAGO would be an in context result because it exists in Indiana and all the other matches for chicago would be out of context results Likewise if you committed a value of IL Illinois for the state EAST CHICAGO and CHICAGO PARK would be out of context and CHICAGO CHICAGO HTS CHICAGO RIDGE NORTH CHICAGO and WEST CHICAGO would be in context Click the value you want in either In Conext Alternatives or Out of Context Alternatives then click Select in Context or Select Out of Context to apply your selection to the search criteria Click the binoculars icon next to a blank field to see options for that field Continue searching until all fields are complete enough for it to be considered as a complete and valid address Spectrum Technology Platform 9 0
43. atform 9 0 Appendix A Country ISO Codes and Module Support ISO Country Name English ISO 3116 1 ISO 3116 1 Supported Modules Alpha 2 Alpha 3 Malta ML MLT Address Now Module Universal Addressing Module Marshall Islands MH MHL Address Now Module Universal Addressing Module Martinique MQ MTQ Address Now Module Enterprise Geocoding Module Guadeloupe is covered by the France geocode Universal Addressing Module Mauritania MR MRT Address Now Module Universal Addressing Module Mauritius MU MUS Address Now Module Universal Addressing Module Mayotte YT MYT Address Now Module Enterprise Geocoding Module Universal Addressing Module Mexico MX MEX Address Now Module Enterprise Geocoding Module Universal Addressing Module Micronesia Federated States FM FSM Address Now Module Of Universal Addressing Module Moldova Republic Of MD MDA Address Now Module Universal Addressing Module Monaco MC MCO Address Now Module Enterprise Geocoding Module Universal Addressing Module Mongolia MN MNG Address Now Module Universal Addressing Module Montenegro ME MNE Address Now Module Universal Addressing Module Montserrat MS MSR Address Now Module Universal Addressing Module Morocco MA MAR Address Now Module Enterprise Geocoding Module Universal Addressing Module Mozambique MZ MOZ Address Now Module Enterprise Geocoding Module Universal Addressing Module P Martinique is covered by the France geocoder 3 Mayotte is covered
44. ation This will only perform tax jurisdiction assignments on the records Address Validation and GeoTAX This will validate cleanse and perform tax jurisdiction assignments on the records 18 Spectrum Technology Platform 9 0 Chapter 2 Using the SAP Interface The GeoTAX Validation Only and Address Validation and GeoTAX options will only operate properly if the Enterprise Tax module is installed Business Partner Record Deduplication Data deduplication is the process of identifying duplicate records in a data set The SAP modules allow you to identify duplicates based on a variety of fields Once duplicate records are found you can then choose to ignore them or create a master record by merging information found in each duplicate Merging Business Partner Records Record Merging is the process of reconciling duplicate records Duplicate records are reconciled by merging the duplicate to the current record or by merging the current to the duplicate record Note Merging is only available in SAP CRM and SAP ECC The Address Master screen provides a view of all SAP Application Objects that have standard addresses Use this application to merge Business Partner duplicate objects In the Address Master initial screen filter the list according to the address type status threshold and maximum number of hits E Program Edit Goto System Heb 28 eeenBus S505 AAM PBBI SAP DQC Address Information Filter Cr
45. by the France geocoder Monaco is covered by the France geocoder SAP Module User s Guide 75 Country ISO Codes and Module Support ISO Country Name English ISO 3116 1 ISO 3116 1 Supported Modules Alpha 2 Alpha 3 Myanmar MM MMR Address Now Module Universal Addressing Module Namibia NA NAM Address Now Module Enterprise Geocoding Module Universal Addressing Module Nauru NR NRU Address Now Module Universal Addressing Module Nepal NP NPL Address Now Module Universal Addressing Module Netherlands NL NLD Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module New Caledonia NC NCL Address Now Module Universal Addressing Module New Zealand NZ NZL Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module Nicaragua NI NIC Address Now Module Universal Addressing Module Niger NE NER Address Now Module Enterprise Geocoding Module Universal Addressing Module Nigeria NG NGA Address Now Module Enterprise Geocoding Module Universal Addressing Module Niue NU NIU Address Now Module Universal Addressing Module Norfolk Island NF NFK Address Now Module Universal Addressing Module Northern Mariana Islands MP MNP Address Now Module Universal Addressing Module Norway NO NOR Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module Oman OM OMN Address Now Module Universal Addressing Modul
46. ddress validation The duplicate result list shows the candidate duplicate or duplicates of the record being created Identify Account Back A A Business partner 101 is a duplicate 2 Messages E B Postal Validation complete Create Account Installed Base Object Account sample Component Business Partner 101 Product ID Street House Number Milk St 38 Identification City Boston Search Clear Postal Code Region 02109 5101 3 MA C Massachusetts Country US USA Telephone Fax E Mail Address Check E X Result List 1 Account s found Full Name Telephone Street City Cou __ Sample Milk St Boston us Button Function Check Check if the modified information still contains duplicates Pushes through with the creation of the current record al Cancels de duplication and account creation Same as Check button 58 Spectrum Technology Platform 9 0 Chapter 4 Using the SAP ICWC User can select the candidate duplicate by clicking on the Result List table When a duplicate was selected it will cancel the creation of current account Error Handling There are two kinds of error messages provided in this system The first kind are standard error messages provided by SAP Data Quality Connector which are discussed in the Using SAP Interface chapter The second kind are information and error messages provided by the SAP CRM IC Web Client Most error messages being handled are returned by SAP Data Quality Connector
47. dress e CR7 1 100 PBBI SAP DOC Postal Validation Address Changed Address Fields Ez 5 4200 Street Parliament PI 4200 parliament place City Lanham lanham Region MD MD Postal Code 20706 1852 20706 1852 Country us US Tax Jurisdiction Code 2752 Accept Changes m Accept Current 5 Click Accept Changes to accept the validated address Click Accept Current to accept the address you entered Or click the red X to cancel the validation Validating an Address with Multiple Matches The SAP modules provide two methods for validating addresses that may match multiple candidates In the first validation option when the address entered matches multiple candidates the SAP modules allow you to select the appropriate matching record from a list of candidates Note When the Simple Advanced Search option is disabled no candidate addresses will be suggested 1 Enter the address data in SAP The example shows the entry beach st san francisco CA US 14 Spectrum Technology Platform 9 0 Chapter 2 Using the SAP Interface c CR7 1 100 PBBI SAP DOC Address Search xj q beach st san francisco CA US Proposed Address Alternatives 901 Beach St San Francisco CA 94109 1001 903 Beach St San Francisco CA 94109 1001 905 Beach St San Francisco CA 94109 1001 907 Beach St San Francisco CA 94109 1001 909 Beach St San Francisco CA 94109 1001 911 Beach St San Francisco
48. e 76 Spectrum Technology Platform 9 0 Appendix A Country ISO Codes and Module Support ISO Country Name English ISO 3116 1 ISO 3116 1 Supported Modules Alpha 2 Alpha 3 Pakistan PK PAK Address Now Module Universal Addressing Module Palau PW PLW Address Now Module Universal Addressing Module Palestinian Territory PS PSE Address Now Module Occupied Universal Addressing Module Panama PA PAN Address Now Module Universal Addressing Module Papua New Guinea PG PNG Address Now Module Universal Addressing Module Paraguay PY PRY Address Now Module Universal Addressing Module Peru PE PER Address Now Module Universal Addressing Module Philippines PH PHL Address Now Module Enterprise Geocoding Module Universal Addressing Module Pitcairn PN PCN Address Now Module Universal Addressing Module Poland PL POL Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module Portugal PT PRT Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module Puerto Rico PR PRI Address Now Module Universal Addressing Module Qatar QA QAT Address Now Module Universal Addressing Module Reunion RE REU Address Now Module Enterprise Geocoding Module Universal Addressing Module Romania RO ROU Address Now Module Universal Addressing Module 11 Reunion is covered by the France geocoder SAP Module User s Guide 77 Country ISO Codes and Module Su
49. e Enterprise Geocoding Module Universal Addressing Module SAP Module User s Guide 79 Country ISO Codes and Module Support ISO Country Name English ISO 3116 1 ISO 3116 1 Supported Modules Alpha 2 Alpha 3 Sweden SE SWE Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module Switzerland CH CHE Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module Syrian Arab Republic SY SYR Address Now Module Universal Addressing Module Taiwan Province of China TW TWN Address Now Module Universal Addressing Module Tajikistan TJ TJK Address Now Module Universal Addressing Module Tanzania United Republic Of TZ TZA Address Now Module Enterprise Geocoding Module Universal Addressing Module Thailand TH THA Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module Timor Leste TL TLS Address Now Module Universal Addressing Module Togo TG TGO Address Now Module Enterprise Geocoding Module Universal Addressing Module Tokelau TK TKL Address Now Module Universal Addressing Module Tonga TO TON Address Now Module Universal Addressing Module Trinidad and Tobago TT TTO Address Now Module Universal Addressing Module Tunisia TN TUN Address Now Module Enterprise Geocoding Module Universal Addressing Module Turkey TR TUR Address Now Module Enterprise Geocoding Module Universal Addressing Module
50. ectrum Technology Platform is displayed in this pop up E PB1 2 100 Information a at this time 28 Spectrum Technology Platform 9 0 Using SAP Dynpro In this section Introd ction sini x ce RE ts acteeohiene ss 30 Business Partners llle esee 31 s Qustomels i122 28695 XR Rees EE Siu E SS 41 Mendotr s sostener ME ING E D deteuen d 47 Searching for an Address with Advanced Search 50 Introduction Introduction 30 The Spectrum Technology Platform SAP Module improves the quality of you address data by providing the following functions in your SAP Dynpro environment Address Cleansing correcting address information and validating addresses against a postal database amongst partial or complete records Address Duplicate Detection identifying duplicate records in a data set for appropriate action Fuzzy Rough Search searches for addresses that are already present on the database Advanced Search creation of new addresses by using interactive value generation and field requirements The diagram below shows a typical SAP NetWeaver Portal and system architecture Note the connection to Spectrum Technology Platform to provide address validation Web Browser SAP NetWeaver Portal XML HTTP MeN SAP R 3 Instance Spectrum Technology Platform Figure 15 System Architecture SAP NetWeaver Portal SAP NetWeaver Portal offers a single point o
51. eeeeeeeeeeeeennen nennen 55 Modifying Business Partner Account seeeeeeeeeennnenen n 56 Validating an Address aa eer xe rH REI Ree ERS 56 Data De duplication rere ttr nexo rientra urn xa eu IE BE E ERE IRR ERR REA 58 Error Handling nente tnn nnne tenuia eee ced 59 Chapter 5 Component Reference ccccccccccccceceeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeess 61 SAP Batch Assign GeoTAX Info esee nnns 62 SAP Batcli Validate Address rte Ecke Recipe 62 SAP Generate CASS Report saiisine arinena ernaar 62 SAP Generate Match Key iiicccicccisiccccccscissccccctsescocccctsececcnesseseccnesseeccceccssesscenssaeeoed 62 SAP Generate Match SCcOre erheben rb reete reed 62 SAP Generate Search Key eese nnne RATA 63 SAP Generate Search Key Consonant eene 63 SAP Generate Search Key Metaphone eee 63 SAP Generate Search Key Substring eene 63 SAP Validate Address and Assign GeoTAX Info eee 63 SAP Validate Address With Candidates eese 63 Appendix A Country ISO Codes and Module Support 65 Country ISO Codes and Module Support eese 66 Spectrum Technology Platform 9 0 Introduction to the SAP Module In this section
52. en on page 21 prompting you that the cleansing case was successfully created Le CR7 1 100 Duplicates Faith Christian Elementary B A w m B Gs e Results for Faith Christian Elementary 514 N Magnolia Ave Anahei vet No Similarity Name1 Last Name Name2 First Narne Formatted Address PV StatudBusiness Part 0000000024 69 0 Faith Christian University Faith Christin University S14 N Magnolia Ave Anaheim CA 92801 4937 w 0000000023 67 0 Faith Christian Colege Faith Christian College 514 N Magnolia Ave Anaheim CA 92601 4937 w 0000000025 66 0 Faith Christian School T Faith Christian School 514 N Magnolia Ave Anaheim CA 92801 4937 S 0000000022 65 0 Faith Christian High School Faith Christian High School 514 N Magnolia Ave Anaheim CA 92801 4937 w ih Merge Current to Duplicate Merge Duplicate to Current Figure 6 Duplicate Pop up Screen c CR7 2 100 Information Figure 7 Cleansing Case Created 7 Duplicate clearing case 3 has been successfully created Figure 8 Merge Status Message Batch Merging Business Partner Records Batch merge is the process of merging Business Partner candidates with corresponding duplicates Business Partner candidates flagged for archiving are not included in the process The merge behavior SAP Module User s Guide 21 Business Partner Record Deduplication depends on wh
53. ept Changes Accept Current x The validated cleansed address is at the Proposed Value column and the address that was entered uncleansed address is at the Current Value column The cleansed address information has been properly cased and the postal code has been provided If a record in the system is similar to the record being created the data deduplication process takes place and the deduplication pop up is displayed The data deduplication pop up displays all the candidate duplicate or duplicates of the record being created Click No Duplicate to ignore any duplicates displayed in the pop up and create the new record Click Select Duplicate to display the selected candidate duplicate and cancel the creation of the current duplicate Click the red X to cancel the deduplication process SAP Module User s Guide 13 Address Validation e CR7 1 100 Duplicates Pitney Bowes a sepan v s B s IBI Simi vb BPartner Description Name 1 last name Nm2fistm 133 Pitney Bowes 4200 Parliament PI Lanham MD 20706 1852 Pitney Bowes 85 0 134 Pitney Bowes Business Insight 4200 Parliament Pl Lanham MD 20706 1852 Pitney Bowes Business Insight tie Continue Switch to Duplicate amp e Display Partner L3 create cleansing case 4 If Enterprise Tax is being used and the Tax Jurisdiction Code is required the Tax Jurisdiction Code is returned with the ad
54. ether the Merge Settings are set to Pitney Bowes Business Insight Merge Process or SAP Merge Process Execute HSGRP1 BP MERGING Program HSGRPl BP MERGING O Geste O variants O attributes O Documentation O Text elements Ka Display 2 Change Figure 9 Batch Merge program in SE38 Enter the package size and specify whether you want the merged record to be archived PBBI SAP DQC Business Partner Merging Package Size 2 500 v Flag for Archiving Figure 10 Batch Merge Initial Screen After executing a message confirming that batch merging has been completed is displayed E Lst Edt goto System Hep PBBI SAP DQC Business Partner Merging Process End Date 24 11 2010 Finished at 13 41 37 Total Records Processed 146 Total Cleansing Cases Created 30 Total Cleansing Cases Processed 1 Figure 11 Batch Merge Report Screen Batch De duplication 22 Batch de duplication is the process of initializing duplicate status field in the table HSGRP1 MATCHKEY Execute HSGRP1 RSADRDEDUP After executing a message confirming that batch de duplication has been completed is displayed as shown in Figure 14 Batch De duplication Report Screen Batch De duplication Report Screen on page 23 Spectrum Technology Platform 9 0 Chapter 2 Using the SAP Interface ABAP Editor Initial Screen amekariri B9 debuaana G ariant 8e Program HS
55. f access to SAP and non SAP information sources enterprise applications information repositories databases and services inside and outside your organization through a single user experience SAP Server SAP is an Enterprise Resource Planning ERP system Originally dating back to the 1970s it took the then controversial approach of combining various business functions into one application and database In the 1980s SAP designed a new architecture for the new system using a multi tiered Client Server architecture with data storage on a database server running some relational database application code written in their ABAP 4 language running on a set of application servers Spectrum Technology Platform Server Spectrum Technology Platform provides integration for end users to execute services and process data The server is managed using NET clients Management Console Interactive Driver and Enterprise Designer The server itself is written in Java for maximum platform support but can leverage products written in other languages by building Java based components on top of these other products Spectrum Technology Platform 9 0 Chapter 3 Using SAP Dynpro Business Partners Creating a Business Partner Person A Business Partner Person is a record for an individual person 1 In a web browser open the Pitney Bowes Spectrum Data Quality Connector for SAP page 2 Click Create Business Partner then click Person 3 Complete
56. find customers even if the pieces of information are incomplete or partly wrong The search displays a list of possible matches In a web browser open the P Click Fuzzy Rough Search In the Name field enter the n O Ol Roo Click Fuzzy Rough Search Vendor Creating a Vendor A Vendor is typically used for an 1 In a web browser open the P 2 Click Create Vendor 3 Complete the following fields Field Title Name Street House Number City Postal Code Country Region PO Box PO w o number Postal Code Telephone Fax Email 4 Click Validate to validate the itney Bowes Spectrum Data Quality Connector for SAP page At the top of the page click Customer ame of the customer you are searching for Under Street Address enter as much address information as you know individual person who acts as a vendor to your organization itney Bowes Spectrum Data Quality Connector for SAP page Description A title of respect or a professional title If the vendor is an organization and not a person select Company The name of the vendor This can be a person or a company The person s street and house or building number For example 430 Main St The municipality name The postal code for the address The country for the address A sub area within a country such as a province state or district You must select a country before you select a region A post office box number Check this box if y
57. g The querying page of CRM IC Web Client is the default page that will be loaded after you have login to IC Web Client Interaction Center tig FR Accept Reject Account Identification Account Fact Sheet Account Overview Interaction Record Interaction History Fax Letter Unfinished E Mails Case Knowledge Search Script Index Hold Retrieve Hang Up Transfer Warm Transfer Consult Conference Toggle Identify Account Account End Dial Pad Installed Base Object E KjBack EJ First Name Last Name Account Account ID Street House Number City Postal Code Region Country Telephone E Mail Address Transaction ID Fax Component Product ID Identification Search Clear Relationship Has Contact Person Search Account Clear C Re ist Account Account ID Postal Code City Telephone Extension B No result found Inbox amp Local intranet Button Function Search Account Perform search using the provided information Clear Clear all the fields Go to create account page Ej Entering any information in the search field will perform the error tolerant search When multiple matches were found results will be displayed in the Result List table When exact match was found Modify Account page will be displayed 54 Spectrum Technology Platform 9 0 Chapter 4 Using the SAP ICWC Identify Account KiBack E Account Installed Base Object First Name Last N
58. he selected duplicate in a new popup window click Display Partner To return to the new business partner without taking any action on the duplicates click Cancel 6 After you have validated the address and checked for duplicates click Save Creating a Business Partner Organization A Business Partner Organization is a record for a company or other entity 1 In a web browser open the Pitney Bowes Spectrum Data Quality Connector for SAP page 2 Click Create Business Partner then click Organization 3 Complete the following fields 34 Field Description Title Select Company Name The name of the company or organization Street House No The organization s street and house or building number For example 430 Main St City The municipality name Postal Code The postal code for the address Country The country for the address Region A sub area within a country such as a province state or district You must Tax Jurisdiction PO Box PO w o number Postal Code Latitude select a country before you select a region The proprietary codes used in ADP Taxware tax compliance software You can use this code in your ADP Taxware application to find out the tax rate for the jurisdiction A post office box number Check this box if you leave the PO Box field blank If you are entering a PO Box address the postal code for the address The latitude of the address The latitude is a seven digit number in degrees calc
59. ice is used in Search Key Generation for All Algorithms A Search Key is used for Duplicate Detection and Error Tolerant Searching SAP Generate Search Key Consonant Used in Search Key Generation for Consonant Algorithm A Search Key is used for Duplicate Detection and Error Tolerant Searching SAP Generate Search Key Metaphone Used in Search Key Generation for Metaphone Algorithm A Search Key is used for Duplicate Detection and Error Tolerant Searching SAP Generate Search Key Substring Used in Search Key Generation for Substring Algorithm A Search Key is used for Duplicate Detection and Error Tolerant Searching SAP Validate Address and Assign GeoTAX Info This service accepts address data as input validates the address against the ValidateAddress and determines tax jurisdictions for the location using AssignGeoTAXInfo SAP Validate Address With Candidates This service accepts address data as input and validates the address against either the ValidateAddress service or the GetGlobalCandidateAddresses service depending on country of input SAP Module Databases The SAP Module relies on other Spectrum Technology Platform modules to provide various capabilities such as address standardization and geocoding Depending on the features you have licensed you may have one or more of the following modules Each module requires certain reference data databases to be installed on the Spectrum Technology Platform server Note F
60. is the process of updating uncleansed records in a data set These uncleansed records will pass through the normal data cleansing process which will automatically update records at one time If a record or records in the system has been saved with uncleansed data e g lower cased address running the batch address cleansing should automatically cleanse these records at the same time There are 3 report programs that should be run in order to complete this batch process RSADRQU1 HSGRP1 RSADRQU2 RSADRQU3 The first and last reports are SAP standard programs for the quarterly adjustment process 1 Navigate to the ABAP Editor Initial Screen Program Edit Goto Utilities Environment System Help a 10 6 C88 2800 FH oam Program PAHS GREL RSADR IZ i Create Subobjects Source Code O Variants O attributes O Documentation O Text elements S Display 2 Click the clock button to run or execute the specified program 3 The screen below results after running the batch address cleansing E Program Edit Goto System Help E 2a 418 00 Bumbmeese ma em PBBI SAP DQC Partner Report for Quarterly Adjustment RSADRQU2 i Choose Validation Type Address Validation Only OdGeoTAX Validation Only O Address Validation and GeoTAX There are 3 modes available for this process Address Validation This will only validate and cleanse the records GeoTAX Valid
61. ise Geocoding Module Universal Addressing Module Christmas Island CX CXR Address Now Module Universal Addressing Module Cocos Keeling Islands CC CCK Address Now Module Universal Addressing Module Colombia CO COL Address Now Module Universal Addressing Module Comoros KM COM Address Now Module Universal Addressing Module Congo CG COG Address Now Module Enterprise Geocoding Module Universal Addressing Module Congo The Democratic CD COD Address Now Module Republic Of The Enterprise Geocoding Module Universal Addressing Module Cook Islands CK COK Address Now Module Universal Addressing Module Costa Rica CR CRI Address Now Module Universal Addressing Module C te d lvoire CI CIV Address Now Module Universal Addressing Module Croatia HR HRV Address Now Module Enterprise Geocoding Module Universal Addressing Module Cuba CU CUB Address Now Module Universal Addressing Module Curacao CW CUW Address Now Module Universal Addressing Module Cyprus CY CYP Address Now Module Universal Addressing Module Czech Republic CZ CZE Address Now Module Enterprise Geocoding Module Universal Addressing Module Denmark DK DNK Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module SAP Module User s Guide 69 Country ISO Codes and Module Support ISO Country Name English ISO 3116 1 ISO 3116 1 Supported Modules Alpha 2 Alpha 3 Djibouti DJ DJI Address Now Module Universal Addre
62. iteria By Address Country to gt Y Region to G H Postal Code to E By Address Type Cl company Personal C workplace By Address Status Cleansed Not Yet Cleansed Differing Duplicate Check Threshold 30 0 Maximum No of Hits Figure 1 Address Master Initial Screen By Address Type Lcompany Personal C workplace Figure 2 Address Type Filters By Address Status Cleansed Not Yet Cleansed Differing Figure 3 Status Filters Figure 4 Address Master Main Screen on page 20 shows the results from Address Master Initial Screen rows highlighted in yellow are business partner already flagged for archiving SAP Module User s Guide 19 Business Partner Record Deduplication m Ec aec ei 2 JO 668 Den SH05 HE Os PBBI SAP DQC Address Master Fs rae Tapes emer pese a sucer ass 8 s 118 Sel ue Status Dupicata sine adii read ee cae qol owa y Jime 4 Name 2 et navete Formatted ans XN iind Ts Piney Bowes 1210 TY RIT ERE TEASE e Vas due jen crei 1 TERY RO TED E 27007 Wapes Antu Arcuri Vareni j 1210 T Rd Rach HC 27607A Vapa msume _ Arshuna Vara 1210 Tints Ra f Falsch NC 27607 4 vapen Ansurars Anshan Vapen 220 TN Re f fai cz Vapet antunes Arson Vape 12 Mk SE eestor Ma C2108 4 is om micans astra cha s Lg g amp TUTO PPS S amp amp amp XS amp amp amp S amp X amp amp S amp 4 amp amp Weser c
63. itney Bowes addresses only Software monthly subscription Suite corrects secondary address information for U S business addresses whose secondary address information could not be validated If Suite processing is enabled Validate Address attempts to match the value in the FirmName field to a database of known firm names Validate Address then supplies the correct secondary address information SAP Module User s Guide 9 Using the SAP Interface In this section Locating Records t e xn 12 Address Validation 0000 cee eee eee 13 Business Partner Record Deduplication 19 Viewing the Log onm tarkenne eiea 23 e Resynchronizing the Index Pool 25 Initializing Search Key cece eee eee 25 Error Handling 0 020 e eee eee ee 27 Locating Records Locating Records The SAP modules provide various ways in which you can search records Error tolerant searches allow you to find customers vendors prospects or business partners even if you don t have all their information or the information is incomplete or partly wrong 1 When searching for customers vendors prospects or business partners the error tolerant search feature allows you to use Rough or Fuzzy search logic to locate records c Customer Account Number 1 x Customers by Ai Customers general Cust ad Customers by company code Customers by
64. les that support addressing geocoding and routing for each country ISO Country Name English ISO 3116 1 ISO 3116 1 Supported Modules Alpha 2 Alpha 3 Afghanistan AF AFG Address Now Module Universal Addressing Module Aland Islands AX ALA Address Now Module Universal Addressing Module Albania AL ALB Address Now Module Universal Addressing Module Algeria DZ DZA Address Now Module Universal Addressing Module American Samoa AS ASM Address Now Module Universal Addressing Module Andorra AD AND Address Now Module Enterprise Geocoding Module Universal Addressing Module Angola AO AGO Address Now Module Enterprise Geocoding Module Universal Addressing Module Anguilla Al AIA Address Now Module Universal Addressing Module Antarctica AQ ATA Address Now Module Universal Addressing Module Antigua And Barbuda AG ATG Address Now Module Universal Addressing Module Argentina AR ARG Address Now Module Enterprise Geocoding Module Universal Addressing Module Armenia AM ARM Address Now Module Universal Addressing Module Aruba AW ABW Address Now Module Universal Addressing Module Australia AU AUS Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module 1 Andorra is covered by the Spain geocoder 66 Spectrum Technology Platform 9 0 Appendix A Country ISO Codes and Module Support ISO Country Name English ISO 3116 1 ISO 3116 1 Supported Modules Alpha 2 Alpha 3
65. me2 First ES i m 1000 136 1PO Box 4 New York NY 10002 0001 v 100 0 50 Po Box 1 New York NY 10116 0001 EEL Row rota A Continue EE Swich to Duplicate _ amp Display Partner X Cancel The PV column Postal Validation indicates whether the address has been validated The icons in the column are described in the following table Table 8 Status Icons Description Address has been checked and conforms to the reference data Address has been checked and does not conform to the reference data Only the user can set this status Address has not been checked or it has failed cleansing No Address SAP Module User s Guide 43 Customers To continue with saving the new business partner and ignore the duplicates click Continue To view the selected duplicate and cancel the creation of the new business partner click Switch to Duplicate To view the selected duplicate in a new popup window click Display Partner To return to the new business partner without taking any action on the duplicates click Cancel After you have validated the address and checked for duplicates click Save Creating a Customer Consumer A Customer Consumer record is for a customer that is a person rather than a company 1 2 3 4 Complete the following fields In a web browser open the Pitney Bowes Spectrum Data Quality Connector for SAP page Atthe top of the
66. nce the Accept Changes button has been selected the committed address will be reflected in the create data screen 9 Click the Accept Changes button to accept the validated completed address Click the Accept Current button to accept the address you entered Or click the red X to cancel the validation Processing an Invalid Address The SAP modules perform data cleansing on all records complete or partial so there may be times when the system is unable to cleanse the record using the postal database You can process addresses with or without the Simple Advanced Search option enabled 1 Enter the address data in SAP The example shows the entry 000 INVALID STREET INVALID CITY MD US Street Address Street House number 000 INVALID STREET Postal Code City INVALID CITY Country Us Region MD fal 2 When the address record is saved or checked this address will go through Address Validation Since the address does not exist the Address List pop up is displayed with the appropriate error message CR7 1 100 PBBI SAP DOC Postal Validation Address Validation Failed Address Fields uh 000 Street Invalid St City Invalid City Region MD Postal Code Country US cE accept current X 3 You can either accept the invalid address or cancel the address list pop up SAP Module User s Guide 17 Address Validation Performing Batch Address Validation Batch address cleansing
67. nd BV BVT Address Now Module Universal Addressing Module Brazil BR BRA Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module British Indian Ocean Territory IO IOT Address Now Module Universal Addressing Module Brunei Darussalam BN BRN Address Now Module Universal Addressing Module Bulgaria BG BGR Address Now Module Universal Addressing Module Burkina Faso BF BFA Address Now Module Enterprise Geocoding Module Universal Addressing Module Burundi BI BDI Address Now Module Enterprise Geocoding Module Universal Addressing Module Cambodia KH KHM Address Now Module Universal Addressing Module Cameroon CM CMR Address Now Module Enterprise Geocoding Module Universal Addressing Module Canada CA CAN Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module Cape Verde CV CPV Address Now Module Universal Addressing Module Cayman Islands KY CYM Address Now Module Universal Addressing Module Central African Republic CF CAF Address Now Module Universal Addressing Module Chad TD TCD Address Now Module Universal Addressing Module Chile CL CHL Address Now Module Enterprise Geocoding Module Universal Addressing Module 68 Spectrum Technology Platform 9 0 Appendix A Country ISO Codes and Module Support ISO Country Name English ISO 3116 1 ISO 3116 1 Supported Modules Alpha 2 Alpha 3 China CN CHN Address Now Module Enterpr
68. nnector for SAP page Click Display Business Partner Enter the business partner number If you do not know the business partner number you can look it up using the fuzzy search feature For more information see Searching for a Business Partner on page 41 Click Change Edit the business partner For additional information see Creating a Business Partner Organization on page 34 and Creating a Business Partner Person on page 31 Searching for a Business Partner Error tolerant searches allow you to find business partners even if the pieces of information are incomplete or partly wrong The search displays a list of possible matches Or ON gt In a web browser open the Pitney Bowes Spectrum Data Quality Connector for SAP page Click Business Partner Click Fuzzy Rough Search In the Name field enter the name of the business partner you are searching for Under Street Address enter as much address information as you know Click Fuzzy Rough Search Customers Creating a Customer General A Customer General record is typically used when the customer is an entity such as a business 1 In a web browser open the Pitney Bowes Spectrum Data Quality Connector for SAP page 2 At the top of the page click Customer 3 4 Complete the following fields Click Create Customer then click Create Customer General Field Description Title A title of respect or professional title Name If the customer is a company enter
69. nse Attribution License located at http creativecommons org licenses by 3 0 legalcode Your use of the GeoNames data described in the Spectrum Technology Platform User Manual is governed by the terms of the Attribution License and any conflict between your agreement with Pitney Bowes Software Inc and the Attribution License will be resolved in favor of the Attribution License solely as it relates to your use of the GeoNames data ICU Notices Copyright 9 1995 2011 International Business Machines Corporation and others All rights reserved Permission is hereby granted free of charge to any person obtaining a copy of this software and associated documentation files the Software to deal in the Software without restriction including without limitation the rights to use copy modify merge publish distribute and or sell copies of the Software and to permit persons to whom the Software is furnished to do so provided that the above Spectrum Technology Platform 9 0 Copyright copyright notice s and this permission notice appear in all copies of the Software and that both the above copyright notice s and this permission notice appear in supporting documentation THE SOFTWARE IS PROVIDED AS IS WITHOUT WARRANTY OF ANY KIND EXPRESS OR IMPLIED INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT OF THIRD PARTY RIGHTS IN NO EVENT SHALL THE COPYRIGHT HOLDER OR HO
70. o be searched and click on the binoculars button beside the field for which you want to search Searches are done on a field by field basis only The results are displayed either on the In Context Alternatives or the Out Of Context Alternatives c CR7 1 100 PBBI SAP DOC Component Search uh beach st san francisco CA US Search Fields In Context Alternatives Out of Context Alternatives No Values No Values Address Fiel Search Proposed Address In Context Alternatives jout of Context alternatives Li City State County Street Company Building Premise No Sub Building PO Box 4 Country Only a COMPLETED Address will be Accepted BS Accept Current 3 6 To commita field double click an entry on the In Context Alternatives box Once a field is committed the system will provide you with a list of possible entries based on what was committed This list is based on a search hierarchy The hierarchy is as follows Zip City State Street Company Building Premise No Sub Building PO Box Note When a search is made and there are no results matching the search criteria the next field in the hierarchy will be returned with its possible results 7T Continue searching until all fields are complete enough for the address to be considered a complete and valid address B beach st san francisco CA US Search Fields
71. oad City New York Region CA Postal Code Country Us Tax Jurisdiction Code EEE Row jorz CEI Gl Accept Current Cane To use the validated address in the business parter you are creating click Accept Changes 5 Click Deduplicate to verify that this entry is not already in the SAP system This helps prevent you from creating a duplicate record If one or more duplicate records are found the following window is displayed PV Status Similarity BPNumber Description i e IE Name 1 Last Name2 First Vv 1000 136 1PO Box 1 New York NY 10002 0001 v 1000 50 1 Po Box 4 New York NY 10116 0001 EIEL Row rora 17 s Continue EE Switch to Duplicate The PV column Postal Validation indicates whether the address has been validated The icons in the column are described in the following table SAP Module User s Guide 33 Business Partners Table 5 Status Icons Description Address has been checked and conforms to the reference data Address has been checked and does not conform to the reference data Only the user can set this status Address has not been checked or it has failed cleansing No Address To continue with saving the new business partner and ignore the duplicates click Continue To view the selected duplicate and cancel the creation of the new business partner click Switch to Duplicate To view t
72. ollowing window is displayed SAP DQC Address Deduplication Result i PV Status Similarity BP Number Description Name 1 Last Name2 First ES v 100 0 136 1 PO Box 1 New York NY 10002 0001 v 100 0 50 1 Po Box 1 New York NY 10116 0001 EEL rwo T2 T2 AZ Continue ZE Switch to Duplicate Gy Display Partner 3 Cancel i The PV column Postal Validation indicates whether the address has been validated The icons in the column are described in the following table Table 7 Status Icons Description Address has been checked and conforms to the reference data Address has been checked and does not conform to the reference data Only the user can set this status Address has not been checked or it has failed cleansing No Address To continue with saving the new business partner and ignore the duplicates click Continue To view the selected duplicate and cancel the creation of the new business partner click Switch to Duplicate To view the selected duplicate in a new popup window click Display Partner 40 Spectrum Technology Platform 9 0 6 Chapter 3 Using SAP Dynpro To return to the new business partner without taking any action on the duplicates click Cancel After you have validated the address and checked for duplicates click Save Viewing and Modifying a Business Partner 1 2 3 In a web browser open the Pitney Bowes Spectrum Data Quality Co
73. or Supplier Optional DPV Database Optional but Pitney Bowes required for CASS Software monthly The Delivery Point Validation database allows you to check the validity of an individual mailing address in the U S The DPV database enhances the U S Postal database s ability to validate mailing addresses Certified subscription processing U S addresses only Note The DPV database also contains the data required for Commercial Mail Receiving Agency CMRA processing Each time an edition of the U S Postal database is released a corresponding edition of the DPV database is released Although USPS licensing allows the use of the U S Postal database beyond the expiration date with certain restrictions DPV lookups may not be performed after the expiration date of the DPV database USPS licensing prohibits using DPV data for the generation of addresses or address lists To prevent the generation of address lists the DPV database contains false positive records False positive records are artificially manufactured addresses For each negative response that occurs in a DPV query a query is made to the False Positive table in the DPV database A match to this table will stop DPV processing USPS licensing also prohibits exporting the DPV data outside the United States eLOT Database Optional U S Pitney Bowes The Enhanced Line of Travel eLOT database is a U S addresses Only Selbiare monthly address database that ensures
74. orinstructions on installing these databases see the Spectrum Technology Platform Installation Guide Address Now Module Database The Address Now database contains postal data from all supported countries You can install the entire database or the data for specific countries only The database is installed on the server This database is available by subscription from Pitney Bowes Software and is updated monthly 6 Spectrum Technology Platform 9 0 Chapter 1 Introduction to the SAP Module Universal Addressing Module Databases Table 1 Universal Addressing Module Databases Database Name amp Description Required or Optional Supplier U S Postal Database The U S Postal Database is in a Pitney Bowes proprietary format It contains every house number range in the United States and is updated on a monthly basis The database files contain the following information ZIP 4 Code Standardized address elements City and state information The U S Postal Database also contains the data needed to perform Enhanced Street Matching ESM and All Street Matching ASM ESM and ASM apply extra matching logic to any input address that is not matched through the regular address validation process Canadian Postal Database The Canadian Postal database is in Pitney Bowes Software proprietary format The database files contain the following information Postal code Standardized address elements Municipalit
75. ositive violation Return values indicating address type B The address is a business address R The address is a residential address M The address is both a residential and a business address null Not checked because the address did not code at a ZIP 49 level or RDI was not performed The Early Warning System EWS uses the USPS EWS File to validate addresses that are not in the ZIP 4 database One of the following Y Yes the address was validated using the EWS file Spectrum Technology Platform 9 0 Field Telephone Fax Email Chapter 3 Using SAP Dynpro Description N No the address was not validated using the EWS file The phone number for the organization If there is an extension enter it in the Ext field The fax number for the organization If there is an extension enter it in the Ext field The email for the organization 4 Click Validate to validate the address fthe address can be validated the Address Changed window displays As you can see the validated address is properly cased and the postal code has been added i Address Fields i Street BE i Region Postal Code Country E s PERENNI Water St water st Lee lee MA MA 01238 9008 01238 9008 US US Tax Jurisdiction Code 2753 i Latitude i Longitude CMRA DPV RDI EWS i EET IR D CET X Accepi Changes Gg Accept Current fthe address matches multiple addresses
76. ou leave the PO Box field blank If you are entering a PO Box address the postal code for the address The phone number for the person If there is an extension enter it in the Ext field The fax number for the person If there is an extension enter it in the Ext field The email for the person address If the address can be validated the Address Changed window displays As you can see the validated address is proper SAP Module User s Guide ly cased and the postal code has been added 47 Vendor If the address matches multiple addresses in the postal data the Address List pop up displays G beach st san francisco Address 903 Beach St San Francisco CA 94109 1001 905 Beach St San Francisco CA 94109 1001 907 Beach St San Francisco CA 94109 1001 909 Beach St San Francisco CA 94109 1001 911 Beach St San Francisco CA 94109 1001 913 Beach St San Francisco CA 94109 1001 915 Beach St San Francisco CA 94109 1001 917 Beach St San Francisco CA 94109 1001 919 Beach St San Francisco CA 94109 1001 921 Beach St San Francisco CA 94109 1001 923 Beach St San Francisco CA 94109 1001 925 Beach St San Francisco CA 94109 1001 927 Beach St San Francisco CA 94109 1001 929 Beach St San Francisco CA 94109 1001 48 Spectrum Technology Platform 9 0 Chapter 3 Using SAP Dynpro To use the validated address in the business partner you are creating click Accept
77. pport ISO Country Name English ISO 3116 1 ISO 3116 1 Supported Modules Alpha 2 Alpha 3 Russian Federation RU RUS Address Now Module Enterprise Geocoding Module Universal Addressing Module Rwanda RW RWA Address Now Module Enterprise Geocoding Module Universal Addressing Module Saint Barthelemy BL BLM Address Now Module Universal Addressing Module Saint Helena Ascension amp SH SHE Address Now Module Tristan Da Cunha Universal Addressing Module Saint Kitts and Nevis KN KNA Address Now Module Universal Addressing Module Saint Lucia LC LCA Address Now Module Universal Addressing Module Saint Martin French Part MF MAF Address Now Module Universal Addressing Module Saint Pierre and Miquelon PM SPM Address Now Module Universal Addressing Module Saint Vincent And The VC VCT Address Now Module Grenadines Universal Addressing Module Samoa WS WSM Address Now Module Universal Addressing Module San Marino SM SMR Address Now Module Enterprise Geocoding Module Universal Addressing Module 12 Sao Tome And Principe ST STP Address Now Module Universal Addressing Module Saudi Arabia SA SAU Address Now Module Universal Addressing Module Senegal SN SEN Address Now Module Enterprise Geocoding Module Universal Addressing Module Serbia RS SRB Address Now Module Universal Addressing Module Seychelles SC SYC Address Now Module Universal Addressing Module 12 San Marino is covered by the Italy geocoder 78 Spectrum
78. ress Now Module Universal Addressing Module French Southern Territories TF ATF Address Now Module Universal Addressing Module Gabon GA GAB Address Now Module Enterprise Geocoding Module Universal Addressing Module Gambia GM GMB Address Now Module Universal Addressing Module Georgia GE GEO Address Now Module Universal Addressing Module Germany DE DEU Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module Ghana GH GHA Address Now Module Enterprise Geocoding Module Universal Addressing Module Gibraltar GI GIB Address Now Module Enterprise Geocoding Module 3Universal Addressing Module Greece GR GRC Address Now Module Enterprise Geocoding Module Universal Addressing Module Greenland GL GRL Address Now Module Universal Addressing Module Grenada GD GRD Address Now Module Universal Addressing Module Guadeloupe GP GLP Address Now Module Enterprise Geocoding Module 4 Universal Addressing Module Guam GU GUM Address Now Module Universal Addressing Module Guatemala GT GTM Address Now Module Universal Addressing Module Guernsey GG GGY Address Now Module Universal Addressing Module Gibraltar is covered by the Spain geocoder 5 Guadeloupe is covered by the France geocode SAP Module User s Guide 71 Country ISO Codes and Module Support ISO Country Name English ISO 3116 1 ISO 3116 1 Supported Modules Alpha 2 Alpha 3 Guinea GN GIN Address Now Module Unive
79. rom the given list and click on Open Selected Record or simply click on Cancel to cancel the search Address Validation Address validation is the process of correcting address information and validating addresses against the postal database and is performed on partial or complete records Address validation is done in several places in the SAP system Address validation is done whenever address information is created or updated for example when you create or update a customer record via transaction codes XD01 and or XD02 or when you create or update a business partner via transaction code BP in SAP CRM Validating an Address 1 Enter the address data in SAP The example shows the entry 4200 parliament place lanham md us Notice that the entry is in lower case letters and there is no postal code Street Address Street House number 4200 parliament place Postal Code City 20706 1852 lanham Country us Region ud Save or check the record A pop up confirms that the address validation was performed In this particular case the address exists and the validation confirmation pop up screen appears with the message Address Validated displayed at the top CR7 1 100 PBBI SAP DQC Postal Validation E Address Changed Address Fields dun eh 4200 Street Parliament Pl 4200 parliament place Lanham lanham MD MD Postal Code 20706 1852 20706 1852 Country US US dx Acc
80. rsal Addressing Module Guinea Bissau GW GNB Address Now Module Universal Addressing Module Guyana GY GUY Address Now Module Universal Addressing Module Haiti HT HTI Address Now Module Universal Addressing Module Heard Island and McDonald HM HMD Address Now Module Islands Universal Addressing Module Holy See Vatican City State VA VAT Address Now Module Enterprise Geocoding Module 3 Universal Addressing Module Honduras HN HND Address Now Module Universal Addressing Module Hong Kong HK HKG Address Now Module Enterprise Geocoding Module Universal Addressing Module Hungary HU HUN Address Now Module Enterprise Geocoding Module Universal Addressing Module Iceland IS ISL Address Now Module Universal Addressing Module India IN IND Address Now Module Enterprise Geocoding Module Universal Addressing Module Indonesia ID IDN Address Now Module Enterprise Geocoding Module Universal Addressing Module Iran Islamic Republic Of IR IRN Address Now Module Universal Addressing Module Iraq IQ IRQ Address Now Module Universal Addressing Module Ireland IE IRL Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module 5 The Vatican is covered by the Italy geocoder 72 Spectrum Technology Platform 9 0 ISO Country Name English Isle Of Man Israel Italy Jamaica Japan Jersey Jordan Kazakhstan Kenya Kiribati Korea Democratic People s Republic Of
81. s You can download the EWS file from the USPS website at ribbs usps gov Lacs Database Optional but Pitney Bowes Link required for CASS Software monthly Certified subscription processing U S addresses only The LACS database allows you to correct addresses that have changed as a result of a rural route address converting to street style address a PO Box renumbering or a street style address changing USPS licensing prohibits using LACS for the generation of addresses or address lists To prevent the generation of address lists the LACS database contains false positive records False positive records are artificially manufactured addresses For each negative response that occurs in a LACS query a query is made to the False Positive table in the LACS database A match to this table will stop LACS processing Link USPS licensing also prohibits exporting the LACS database outside the United States RDI Database Optional U S License directly The Residential Delivery Indicator RDI database contains adaressesi only rom USES data that can help you determine the best cost for shipping your packages RDI is similar to DPV in that the RDI data is supplied as hash tables However RDI is a much simpler process than DPV in that the standard hash algorithm is only determined for the 9 digit and 11 digit ZIP Code rather than the entire address Suite Database Optional U S P
82. sal Addressing Module Virgin Islands U S Vi VIR Address Now Module Universal Addressing Module Wallis and Futuna WF WLF Address Now Module Universal Addressing Module SAP Module User s Guide 81 Country ISO Codes and Module Support ISO Country Name English ISO 3116 1 ISO 3116 1 Alpha 2 Alpha 3 Western Sahara Zimbabwe 82 Supported Modules Address Now Module Universal Addressing Module Address Now Module Universal Addressing Module Address Now Module Enterprise Geocoding Module Universal Addressing Module Address Now Module Enterprise Geocoding Module Universal Addressing Module Spectrum Technology Platform 9 0 Notices 84 2013 Pitney Bowes Software Inc All rights reserved MapInfo and Group 1 Software are trademarks of Pitney Bowes Software Inc All other marks and trademarks are property of their respective holders USPS Notices Pitney Bowes Inc holds a non exclusive license to publish and sell ZIP 4 databases on optical and magnetic media The following trademarks are owned by the United States Postal Service CASS CASS Certified DPV eLOT FASTforward First Class Mail Intelligent Mail LACS NCOA PAVE PLANET Code Postal Service POSTNET Post Office RDI Suite United States Postal Service Standard Mail United States Post Office USPS ZIP Code and ZIP 4 This list is not exhaustive of the trademarks belonging to the Postal Service Pitney Bowes Inc is a non e
83. ssing Module Dominica DM DMA Address Now Module Universal Addressing Module Dominican Republic DO DOM Address Now Module Universal Addressing Module Ecuador EC ECU Address Now Module Universal Addressing Module Egypt EG EGY Address Now Module Universal Addressing Module El Salvador SV SLV Address Now Module Universal Addressing Module Equatorial Guinea GQ GNQ Address Now Module Universal Addressing Module Eritrea ER ERI Address Now Module Universal Addressing Module Estonia EE EST Address Now Module Enterprise Geocoding Module Universal Addressing Module Ethiopia ET ETH Address Now Module Universal Addressing Module Falkland Islands Malvinas FK FLK Address Now Module Universal Addressing Module Faroe Islands FO FRO Address Now Module Universal Addressing Module Fiji FJ FJI Address Now Module Universal Addressing Module Finland FI FIN Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module France FR FRA Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module French Guiana GF GUF Address Now Module Enterprise Geocoding Module 2 Universal Addressing Module French Guiana is covered by the France geocoder 70 Spectrum Technology Platform 9 0 Appendix A Country ISO Codes and Module Support ISO Country Name English ISO 3116 1 ISO 3116 1 Supported Modules Alpha 2 Alpha 3 French Polynesia PF PYF Add
84. the company name If the customer is a person enter the first name in the first field and the last name in the second field Street House Number The person s street and house or building number For example 430 Main St City The municipality name Postal Code The postal code for the address Country The country for the address Region A sub area within a country such as a province state or district You must select a country before you select a region SAP Module User s Guide 41 Customers Field Description PO Box A post office box number Postal Code If you are entering a PO Box address the postal code for the address Telephone The phone number for the person If there is an extension enter it in the Ext field Fax The fax number for the person If there is an extension enter it in the Ext field Email The email for the person 5 Click Validate to validate the address fthe address can be validated the Address Changed window displays As you can see the validated address is properly cased and the postal code has been added Address Changed Address Fields za gA House Number SO SD Street Water St water st City Lee lee Region MA MA Postal Code 01238 9008 01238 9008 Country US US Row 1Jor7 Ifthe address matches multiple addresses in the postal data the Address List pop up displays SAP DQC Postal Validation uh beach st san francisco Address
85. ulated to six decimal places Spectrum Technology Platform 9 0 Field Longitude CMRA DPV RDI EWS Telephone Fax Email Chapter 3 Using SAP Dynpro Description The longitude of the address The longitude is a seven digit number in degrees calculated to six decimal places Indicates if the address is a Commercial Mail Receiving Agency CMRA Y Yes the address is a CMRA N No the address is not a CMRA U Unconfirmed Indicates the results of Delivery Point Validation DPV processing Y DPV confirmed N Address is not deliverable S The primary number was validated but the secondary number could not be confirmed D The primary number was validated but the secondary number was missing from input The address matches multiple valid delivery points U The address could not be confirmed because the address did not code at the ZIP 4 level V The address caused a false positive violation Return values indicating address type B The address is a business address R The address is a residential address M The address is both a residential and a business address null Not checked because the address did not code at a ZIP 49 level or RDI was not performed The Early Warning System EWS uses the USPS EWS File to validate addresses that are not in the ZIP 4 database One of the following Y Yes the address was validated using the EWS file N No the address was not validated using the E
86. umn are described in the following table Table 9 Status Icons Description Address has been checked and conforms to the reference data Address has been checked and does not conform to the reference data Only the user can set this status Address has not been checked or it has failed cleansing No Address To continue with saving the new business partner and ignore the duplicates click Continue To view the selected duplicate and cancel the creation of the new business partner click Switch to Duplicate To view the selected duplicate in a new popup window click Display Partner To return to the new business partner without taking any action on the duplicates click Cancel After you have validated the address and checked for duplicates click Save Viewing and Modifying a Customer 46 Be gt In a web browser open the Pitney Bowes Spectrum Data Quality Connector for SAP page At the top of the page click Customer Click Display Customer Enter the customer number If you do not know the customer number you can look it up using the fuzzy search feature For more information see Searching for a Customer on page 47 Click Change Spectrum Technology Platform 9 0 Chapter 3 Using SAP Dynpro 6 Edit the customer For additional information see Creating a Customer General on page 41 and Creating a Customer Consumer on page 44 Searching for a Customer Error tolerant searches allow you to
87. will be prompted to choose whether to continue the resync process or not Initializing Search Key Search Key Initialization is the process of initializing the table HSGRP1 MATCHKEY 1 Navigate to the ABAP Editor Initial Screen SAP Module User s Guide 25 Initializing Search Key 26 Program HSGRP1 RSADRINI Source Code O Variants Oattributes O Documentation O Text elements 2 Click the clock button to run or execute the specified program The Pitney Bowes Business Insight SAP DQC Report HSGRP1 RSADRINI Screen appears Package Size 2 500 v Overwrite existing Index pools Detailed log 3 Select the appropriate options to view the Pitney Bowes Business Insight SAP DQC Report HSGRP1 RSADRINI Screen Spectrum Technology Platform 9 0 Chapter 2 Using the SAP Interface pue CHp OW Gy We ees Se URIUAP 0 2 LJ 42 62 A VEU Gul PBBI SAP DQC Report HSGRP1 RSADRINI PBBI SAP DQC Report HSGRPl RSADRINI Started Matchkey Generation 24 11 2010 09 14 06 Processing Matchkey Record s 147 Ended Matchkey Generation 24 11 2010 09 14 06 Processing BUT052 ADDRNUMBER Started Extract Index 24 11 2010 09 14 06 Ended Extract Index 24 11 2010 09 14 06 Started Matchkey Generation 24 11 2010 09 14 06 Processing Matchkey Record s o Ended Matchkey Generation 24 11 2010 09 14 06 Processing KNAl ADRNR Started Extract Index 24 11 2010 09 14 06 Error Processing KN l
88. xclusive licensee of USPS for NCOA processing Prices for Pitney Bowes Software s products options and services are not established controlled or approved by USPS or United States Government When utilizing RDI data to determine parcel shipping costs the business decision on which parcel delivery company to use is not made by the USPS or United States Government Data Provider and Related Notices Data Products contained on this media and used within Pitney Bowes Software applications are protected by various trademarks and by one or more of the following copyrights Copyright United States Postal Service All rights reserved 2013 TomTom All rights reserved TomTom and the TomTom logo are registered trademarks of TomTom N V 9 Copyright NAVTEQ All rights reserved Data 9 2013 NAVTEQ North America LLC Fuente INEGI Instituto Nacional de Estad stica y Geograf a Based upon electronic data 9 National Land Survey Sweden Copyright United States Census Bureau 9 Copyright Nova Marketing Group Inc Portions of this program are 9 Copyright 1993 2007 by Nova Marketing Group Inc All Rights Reserved Copyright Canada Post Corporation This CD ROM contains data from a compilation in which Canada Post Corporation is the copyright owner 2007 Claritas Inc The Geocode Address World data set contains data licensed from the GeoNames Project www geonames org provided under the Creative Commons Attribution Lice
89. y and province information Australia Post Postal Address File Database The Postal Address File is part of Australia Post s Address Matching Approval System AMAS program The database file contains the following information Postal code Standardized address elements International Postal Database The International Postal Database is a collection of postal address data from around the world Data from each country is categorized according to the level of data available The categories are Category A Enables the validation and correction of an address s postal code city name state county name street address elements and country name Category B Enables the validation and correction of an address s postal code city name state county name and country name It does not support the validation or correction of street address elements Category C Enables the validation and correction of the country name and the validation of the format of the postal code SAP Module User s Guide Required for U S address processing Required for Canadian address processing Required for Australian address processing Required for International address processing Pitney Bowes Software monthly subscription Pitney Bowes Software monthly subscription Pitney Bowes Software monthly subscription Pitney Bowes Software quarterly subscription SAP Module Databases Database Name amp Description Required

SAP Module User`s Guide - Support

Contents

Download Pdf Manuals

Related Search

Related Contents