Home

SAP Module User`s Guide - Support

1. New Zealand NZ NZL Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module Nicaragua NI NIC Address Now Module Enterprise Geocoding Module Latin America Universal Addressing Module 10 Monaco is covered by the France geocoder SAP Module User s Guide 75 Country ISO Codes and Module Support 76 ISO Country Name Niger Nigeria Niue Norfolk Island Northern Mariana Islands Norway Oman Pakistan Palau Palestinian Territory Occupied Panama Papua New Guinea Paraguay Peru ISO 3116 1 Alpha 2 NE NG NU NF MP NO OM PK PW PS PA PG PY PE ISO 3116 1 Alpha 3 NER NGA NIU NFK MNP NOR OMN PAK PLW PSE PAN PNG PRY PER Supported Modules Address Now Module Enterprise Geocoding Module Africa Universal Addressing Module Address Now Module Enterprise Geocoding Module Africa 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 Enterprise Routing Module Universal Addressing Module GeoComplete Module Address Now Module Enterprise Geocoding Module Middle East Universal Addressing Module Address Now Module Universal Addressing Module Address Now Module Universal Addressing Module
2. 1844 US BS BG 86 85 Bb BS Bb BS BS Bb BS Only a COMPLETED Address will be Accepted Accept Changes Accept Current 3 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 Spectrum Technology Platform 9 0 SP2 9 Chapter 3 Using the SAP Interface CR7 1 100 PBBI SAP DQC Component Search E jbeach st san francisco CA US Search Fields In Context Alternatives Out of Context Alternatives Dinew Search No Values J No Values Address Fiel Search Proposed Address sin Context Alternatives Out of Context Alternatives 20706 City LANHAM MD PRINCE GEORGES PARLIAMENT PL GROUP 1 State County Street Company Building Premise No 4200 Sub Building RB STE 600 PO Box 44 Country 26 6 86 Bo Bb G6 85 BE BS Bb BS Only a COMPLETED Address will be Accepted a Accept Changes amp amp Accept Current 9 Note You can choose a new search provided you have not selected the Accept Changes button Once the Accept Changes button has been selected the committed address will be reflected in the create data screen 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 vali
3. Universal Addressing Module with Loqate Enterprise Geocoding Module Enterprise Tax Module Universal Addressing Module Loqate only SAPValidateAddressWithCandidates ANOW df SAPGenerateCASSReport df SAPValidateAddressWithCandidates ANOW df ValidateAddressWithCandidates UAM df SAPBatchAssignGeoTAXInfo df SAPGenerateCASSReport df SAPValidateAddressAndAssignGeoTAXInfo df SAPValidateAddressWithCandidates UAM ANOW ETM df ValidateAssignGeoTAXInfo df SAPGenerateCASSReport df ValidateAddressWithCandidates UAM df SAPBatchAssignGeoTAXInfo df SAPGenerateCASSReport df SAPValidateAddressAndAssignGeoTAXInfo df ValidateAddressWithCandidates UAM ETM df ValidateAssignGeoTAXInfo df ValidateAddressWithCandidates UAM Logate df ValidateAddressWithCandidates UAM Loqate EGM df ValidateAddressWithCandidates UAM Loqate ETM df ValidateAddressWithCandidates UAM Loqate EGM ETM df ValidateAddressWithCandidates Loqate df Spectrum Technology Platform 9 0 SP2 Chapter 2 Integrating SAP with Spectrum If you are installing this set of Copy these dataflow files to the import folder modules Universal Addressing Module ValidateAddressWithCandidates_Loqate_EGM df Loqate only Enterprise Geocoding Module Enterprise Geocoding Module GeocodeUSAddressWithCandidates df ValidateAddressWithCandidates_EGM df Enterprise Tax Module SAPBatchAssignGeoTAXInfo df ValidateAssignGeoTAXInfo df Note If errors occur in Management Console or Enterpri
4. 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 Enterprise Geocoding Module Latin America Universal Addressing Module Tunisia TN TUN Address Now Module Enterprise Geocoding Module Africa Universal Addressing Module Turkey TR TUR Address Now Module Enterprise Geocoding Module Enterprise Routing Module 80 Spectrum Technology Platform 9 0 SP2 Appendix A Country ISO Codes and Module Support ISO Country Name ISO 3116 1 ISO 3116 1 Supported Modules Alpha 2 Alpha 3 Universal Addressing Module GeoComplete Module Turkmenistan TM TKM Address Now Module Universal Addressing Module 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 Africa Universal Addressing Module Ukraine UA UKR Address Now Module Enterprise Geocoding Module Universal Addressing Module United Arab Emirates AE ARE Address Now Module Enterprise Geocoding Module Middle East Universal Addressing Module United Kingdom GB GBR Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module GeoComplete Module United States US USA Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module Ge
5. f ee coun aaBrowser Component Structure amp BOL Model Browser Runtime Repository Editor b Favorites 7 d Component 4 Component Controller b Windows D Custom Controllers 2 E3 Views Ej HSGRP1 BUPA CMP VIEW BuPADetailEmptySelect PR ICCMP BP DETAIL BuPaCommaAccount 9 Click the Configuration tab 1 Wizard Log ee SAP Reference IMG i i Find View Layout Structure 77 E3IHSGRPT BUPA CMP VIEW BuPa Ej HSGRP1 BUPA CMP VIEW B G View Controller 0 BuPaDetailSelectDuplC Implementation Cla b Context b Context related Meth b Breadcrumbs and M b Toolbar related Meth b Controller Initializatic h On the edit screen select Full Name Telephone Street City and Country context then click the right arrow button and arrange them in this order Full Name Telephone Street City Country i Save the configuration 11 If you will be using French address validation you must install the Data Normalization Module table cdq TableLookup SAP tba on the Spectrum Technology Platform server For more information see the Spectrum Technology Platform Installation Guide SAP Module User s Guide 19 Using the SAP Interface In this section e Searching for Records 00 eee eee eee eee 22 Address Validation 0 cece eee eee eee 23 Deduplication 0 04 e oo Ren 26 Viewing the Log cece e eee eee eee 28 e Resynchronizing the
6. 8080 j Click the Special Options tab k Select No Timeout l Select HTTP 1 1 m After you save click Connection Test Note If there is a pop up window check the Accept All Further Cookies box and select YES n When the test is successful go to the Response Body tab to view the Spectrum Technology Platform page Set up the Spectrum Technology Platform Logging Object a Enter transaction code SLGO b Click New Entries c In the Object column enter HSGRP1 DQC d In the Object text column enter DOC Logging e Save the change Enable the Pitney Bowes Software IC WebClient Enhancement Set a Enter the transaction code SM30 In the Table View field enter BSPWDV EHSET ASG Click Maintain d Click New Entries In the Client field enter the client number where the enhancement set will take effect f In the Enhancement Set field enter HSGRP1 ENHANCEMENT SET Add the IC WebClient Configurations a Enter the transaction code BSP WD CMPWB In the Component field enter ICCMP DETAIL Click the check icon d In the Enhancement Set field enter HSGRP1 ENHANCEMENT SET Click Display f Expand the Views folder and select IHSGRP1 BUPA CMP VIEW BuPaDetailSelectDuplCustomer Spectrum Technology Platform 9 0 SP2 Chapter 2 Integrating SAP with Spectrum Structure of Component ICCMP BP DETAIL Enhancement Set HSGRP1 E
7. 94109 1001 929 Beach St San Francisco CA 94109 1001 y of50 Row SAP Module User s Guide Ifthe address could not be validated the Invalid Address popup is displayed 47 Customers 48 SAP DQC Postal Validation Request failed Address not found Street 000 Something Road City New York Region MA Postal Code To use the validated address in the business partner you are creating click Accept Changes 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 Name2 First 23 v 100 0 136 4 PO Box 1 New York NY 10002 0001 v 100 0 50 1 Po Box 1 New York NY 10116 0001 fono 0 C TES o Essence Speo Fert X canol 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 To continue with saving the new business partner a
8. 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 59 Data Deduplication 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 Deduplication Data deduplication 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 deduplication takes place after address validation The
9. 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 ot50 x fthe address could not be validated the Invalid Address popup is displayed SAP DQC Postal Validation Request failed Address not found Address Fields 2 2 Street 000 Something Road City New York Region CA Postal Code Country Us Tax Jurisdiction Code EE rowhor7 T 1 Gf 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 BP Number Description Name 1 Last Name 2 First i ea v 100 0 136 4 PO Box 1 New York NY 10002 0001 v 100 0 50 J Po Box 1 New York NY 10116 0001 EEL Row rors FEE The PV column Postal Validation indicates whether the address has been validated The
10. 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 Cj Result List 2 Account s found Account Account ID Street Postal Code City Telephone Extension __ Sample 93 Milk St 02109 5101 Boston __ Sample2 94 Water St 01238 9006 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 a 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 E Create Account Installed Base Object Account Component a Account ID 95 Product ID s Street House Number a Identification City G 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 Data De duplication SAP Module User s Gui
11. Index Pool 29 Initializing Search Key lesse 29 Searching for Records Searching for 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 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 Nam
12. Module Andorra is covered by the Spain geocoder 64 Spectrum Technology Platform 9 0 SP2 Appendix A Country ISO Codes and Module Support ISO Country Name ISO 3116 1 ISO 3116 1 Supported Modules Alpha 2 Alpha 3 Armenia AM ARM Address Now Module Universal Addressing Module Aruba AW ABW Address Now Module Enterprise Geocoding Module Latin America Universal Addressing Module Australia AU AUS Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module Austria AT AUT Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module GeoComplete 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 Enterprise Geocoding Module Middle East Universal Addressing Module Bangladesh BD BGD Address Now Module Universal Addressing Module Barbados BB BRB Address Now Module Enterprise Geocoding Module Latin America 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 GeoComplete Module Belize BZ BLZ Address Now Module Enterprise Geocoding Module Latin America Universal Addressing Module SAP Module User s Guide 65 Country ISO Cod
13. Searching for an Address with Advanced Search Viewing and Modifying a Vendor In a web browser open the Pitney Bowes Spectrum Data Quality Connector for SAP page Click Display Vendor 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 52 Click Change Edit the vendor For additional information see Viewing and Modifying a Vendor on page 52 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 Om ON gt 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 52 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 binoculars icon The possible mat
14. St San Francisco CA 94109 1001 927 Beach St San Francisco CA 94109 1001 929 Beach St San Francisco CA 94109 1001 Address fields Go Street City Region MA Postal Code Country Us of 50 C ETE Row rjote CEE Chapter 4 Using SAP Dynpro 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 PV Status Similarity BP Number a Description Name 1 Last Name 2 First Vv 1000 136 1PO Box 1 New York NY 10002 0001 Vv 1000 50 1 Po Box 4 New York NY 10116 0001 EIEL Row jora 7 SAP Module User s Guide Switch to Duplicate sp Display Partner 3 Cancel 45 Customers 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 t
15. Validation DPV processing Y DPV confirmed Mail can be delivered to the address N Mail cannot be delivered to the address S The building number was validated but the unit number could not be confirmed A building number is the primary address number for a building A unit number is a number of a distinct mailing address within a building such as an apartment suite floor and so on For example in this address 424 is the building number and 12 is the unit number 424 Washington Blvd Apt 12 Oak Park IL 60302 USA D The building number was validated but the unit number was missing from input A building number is the primary address number for a building A unit number is a number of a distinct mailing address within Spectrum Technology Platform 9 0 SP2 Field RDI EWS Telephone Fax Email Chapter 4 Using SAP Dynpro Description a building such as an apartment suite floor and so on For example in this address 424 is the building number and 12 is the unit number 424 Washington Blvd Apt 12 Oak Park IL 60302 USA 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 ch
16. 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 exclusive 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 9 2014 TomTom All rights reserved TomTom and the TomTom logo are registered trademarks of TomTom N V 9 Copyright NAVTEQ All rights reserved Data 9 2014 NAVTEQ North America LLC Fuente INEGI Instituto Nacional de Estad stica y Geograf a Based upon electr
17. and 12 is the unit number 424 Washington Blvd Apt 12 Oak Park IL 60302 USA The address matches multiple valid delivery points U The address could not be confirmed because the address did not code at the ZIP 49 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 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 SP2 Chapter 4 Using SAP Dynpro Address Fields zz ee Street Water St water st i City Lee lee Region MA MA Postal Code 01238 9008 01238 9008 Cou
18. duplicate result list shows the candidate duplicate or duplicates of the record being created Identify Account f Back 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 deduplication and account creation Same as Check button 60 Spectrum Technology Platform 9 0 SP2 Chapter 5 Using the Interaction Center WebClient 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 SAP Module User s Guide 61 A Country ISO Codes and Module Support In this section Country ISO Codes and Module Support 64 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 modules that support addressing geocoding and routing for each country No
19. 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 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 sam
20. 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 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
21. renumbering or a addresses only 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 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 Pitney 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 th
22. st san francisco CA US Search Fields context Alternatives Out of Context Alternatives No Values No Values Address Fiel search Proposed Address ln Context Alternatives Out of Context Alternatives State County Street Company Building Premise No Sub Building PO Box 4 Country Only a COMPLETED Address will be Accepted T Accent Current X To commit a 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 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 In Context Alternatives Out of Context Alternatives Dinew Search No Values No Values Address Fiel Search Proposed Address n Context Alternatives Out of Context Alternatives 20706 LANHAM MD PRINCE GEORGES PARLIAMENT PL GROUP 1 4200 Sub Building STE 600 PO Box 44 Country
23. the main screen to the selected record in the pop up screen Merge Duplicate To Current Merges the selected record of the pop up screen to the record of the main screen If the Batch Merging option is set to PBBI Merge Process the records are merged automatically If the Batch Merging option is set to SAP Merge Process the data cleansing cases are created and the cleansing case process must be done manually to complete the merge Note The Batch Merging option can be accessed by entering transaction code NSPRO clicking SAP Reference IMG then expanding SAP NetWeaver gt Application Server gt Basis Services gt Address Management gt PBBI SAP DQC gt Merging 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 depends on whether the Merge Settings are set to Pitney Bowes Business Insight Merge Process or SAP Merge Process Enter the transaction code NSE38 In the Program field enter HSGRP1 BP MERGING Press the F8 key or click the execute icon Enter the package size and specify whether you want the merged record to be archived Press the F8 key or click the execute icon After executing a message confirming that batch merging has been completed is displayed e o Rode gt Performing Batch Deduplication Batch deduplication is
24. 0 SP2 Copyright Software and to permit persons to whom the Software is furnished to do so provided that the above 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 HOLDERS 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
25. Address Now Module Universal Addressing Module Address Now Module Enterprise Geocoding Module Latin America Universal Addressing Module Address Now Module Universal Addressing Module Address Now Module Enterprise Geocoding Module Latin America Universal Addressing Module Address Now Module Enterprise Geocoding Module Latin America Universal Addressing Module Spectrum Technology Platform 9 0 SP2 Appendix A Country ISO Codes and Module Support ISO Country Name ISO 3116 1 ISO 3116 1 Supported Modules Alpha 2 Alpha 3 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 GeoComplete Module Portugal PT PRT Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module GeoComplete Module Puerto Rico PR PRI Address Now Module Universal Addressing Module Qatar QA QAT Address Now Module Enterprise Geocoding Module Middle East Universal Addressing Module Reunion RE REU Address Now Module Enterprise Geocoding Module Universal Addressing Module Romania RO ROU Address Now Module Universal Addressing Module Enterprise Routing Module Russian Federation RU RUS Address Now Module Enterprise Geocoding Module Enterprise Routing Module Uni
26. NB Address Now Module Universal Addressing Module Gibraltar is covered by the Spain geocoder 3 Guadeloupe is covered by the France geocode 70 Spectrum Technology Platform 9 0 SP2 Appendix A Country ISO Codes and Module Support ISO Country Name ISO 3116 1 ISO 3116 1 Supported Modules Alpha 2 Alpha 3 Guyana GY GUY Address Now Module Enterprise Geocoding Module Latin America 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 Universal Addressing Module Honduras HN HND Address Now Module Enterprise Geocoding Module Latin America 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 Enterprise Routing Module Universal Addressing Module GeoComplete 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 Modu
27. Spectrum Technology Platform Version 9 0 SP2 SAP Module User s Guide Contents Chapter T SAP MOdule reo inier reet a aa aaia 5 SAP Module Services eR niit 6 SAP Modul Databas Scii Ieri teta teen 6 Chapter 2 Integrating SAP with Spectrum eee 11 Integrating with SAP Web Dynpro eere nnm nnn 12 Integrating with SAP Interaction Center WebClient 15 Chapter 3 Using the SAP Interface iussiieeseix tis ska n an6 a Lbs FR p naa aer rR RESP pP RRE AKA 21 Searching for Records erre tr PH ERE PER 22 Address Validation tp m eiie itus eu este ure iiu eire 23 Validating an Address iccse rnein a uod derE Adae dddE 23 Validating Address Comporients iussis ee eite crate tenete 23 Performing Batch Address Validation eee 25 Viewing the Address Validation Report eee 26 Deduplicatlon 5 eerte aaaeaii aaa 26 Deduplicating a Business Partner iore recte hec bbb ames 26 Merging Business Partner ReGOIds at iit et Eo ease Eo bras a 2r Batch Merging Business Partner Records sssseee 28 Performing Batch Deduplicatiori 2 iuo iret ipee acteur erect Costo eee SERRE eden 28 Viewing the Log ener ritenere nenne 28 Resynchronizing the Index Pool eeeeeeeeneeeenne nnns 29 Initializing Scarch KGgy 4 terree e
28. a 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 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 DQC Postal Validation Address Changed Address Fields aru Lg Gn Water St water st Lee lee MA MA 01238 9008 01238 9008 US US Ifthe address matches multiple addresses in the postal data the Address List pop up displays 44 Spectrum Technology Platform 9 0 SP2 SAP DQC Postal Validation Ga 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
29. ches 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 Spectrum Technology Platform 9 0 SP2 Chapter 4 Using SAP Dynpro 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 4 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 5 Click the binoculars icon next to a blank field to see options for that field 6 Continue searching until all fields are complete enough for it to be considered as a complete and vali
30. d gt lt columns gt lt records gt record lt field value 0000010610 gt count id value guest gt gt service name value SAPGenerateMatchScore gt 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 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 Enter the transaction code NS In the Program field enter HSGRP1 RSADRINI Press the F8 key or click the execute icon Select the appropriate options gu dec e N SAP Module User s Guide Press the F8 key or click the execute icon 29 Using SAP Dynpro In this section INtrOdUCTION sisi x mr acteechisaats 32 Business Partners 0 cece eee ee 33 s QustomelSs 122 2 86959 tea deimee dae ciungaud 43 Nendor seg sostener MU DNE RE Ede d 49 Searching for an Address with Advanced Search 52 Introduction Introduction The Spectrum Technology Platform SAP Module improves the quality of y
31. d address 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 Inthe 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 53 Using the Interaction Center WebClient In this section Searching iiiise suu rr 56 e Creating a Business Partner Account 57 Modifying a Business Partner Account 58 Me an Address orm RUE 58 Data Deduplication nannaa nananana ee 60 Searching Searching Error tolerant search allow users to find customers vendors prospects or business partners even if the pieces of information are incomplete or partly wrong The querying page of CRM IC Web Client is the default page that will be l
32. dation Performing Batch Address Validation Batch address validation is the process of updating address data in a data set so that the address data is valid and cleansed If a record has been saved with uncleansed data e g lower cased address running the batch address cleansing will automatically cleanse the record 1 2 mor Ro oO N 10 11 12 13 14 Enter the transaction code NSE38 In the Program field enter RSADRQUI Note This is a standard SAP program for the quarterly adjustment process Press the F8 key or click the execute icon Complete the fields to specify the records you want to include in the batch address validation Press the F8 key or click the execute icon When you see a message saying INDX created click the back icon until you are at the screen titled ABAP Editor Initial Screen In the Program field enter HSGRP1 RSADRQU2 Press the F8 key or click the execute icon Choose one of the following options Address Validation Only This will only validate and cleanse the records GeoTAX Validation Only This will only perform tax jurisdiction assignments on the records This option only works if you have the Enterprise Tax Module installed on the Spectrum Technology Platform server Address Validation and This will validate cleanse and perform tax jurisdiction assignments GeoTAX on the records This option only works if you have the Enterprise Tax Module installed on the Spectrum Tec
33. ddress 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 58 Spectrum Technology Platform 9 0 SP2 Chapter 5 Using the Interaction Center WebClient 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 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 903 Beach St San
34. ddress in the business partner 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 BP Number Description Name 1 Last Name2 First 23 v 100 0 136 4 PO Box 1 New York NY 10002 0001 v 100 0 50 1 Po Box 1 New York NY 10116 0001 fono 0 C TES o Essence m x A The PV column Postal Validation indicates whether the address has been validated The icons in the column 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 6 After you have validated the address and checked for duplicates click Save SAP Module User s Guide 51
35. de 57 Modifying a Business Partner Account Modifying a 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 B Back 2 B 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 Ze 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 4 5 Data De duplication Validating an A
36. ding Module Universal Addressing Module In this section SAP Module Services 00 00 cece eres 6 SAP Module Databases eese es 6 SAP Module Services SAP Module Services The SAP Module consists of the following services which run on the Spectrum Technology Platform server These services provide address validation deduplication tax jurisdiction assignment and geocoding functions SAP Batch Assign GeoTax Info This service identifies the tax districts that apply to a given address It also corrects and validates addresses SAP Batch Validate Address This service standardizes and validates address data using batch processing SAP Generate CASS Report This service generates a USPS CASS 3553 report This report is used to obtain postal discounts from the U S Postal Service when submitting a mailing with addresses that have been processed through CASS Certified software 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 service generates a search key using metaphone substring and consonant algorithms SAP Generate Search Key Consonant Used in Search Key Generation for Cons
37. dress when creating a business partner so that address data entered into your system is valid 1 Enter the transaction code NBP to create a new business partner 2 On the Address tab enter the address for the business partner 3 Press the F8 key or click the check icon 4 lf the address you entered needs to be corrected the Address Changed window appears listing the corrected version of the address If the address you entered matched multiple candidate addresses the Address Search window appears listing the candidate addresses Click Accept Changes to save the corrected version of the address to the record If there are multiple addresses listed select the address you want to use before clicking Accept Changes Click Accept Current to keep the address as you entered it 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 23 This option will be available only if the Simple Advanced Search option is enabled and the address entered does not produce a unique result Click the red X to cancel the validation Note If the Enterprise Tax Module is being used and the Tax Jurisdiction Code is required the Tax Jurisdiction Code is returned with the address 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 messa
38. e Name Street Address Street House number Postal Code City iviix 3 Execute the search to display the Results pop up with a list of possible matches PB1 1 100 Fuzzy Rough Search Pitney Bowes Business Insight A v m B c v m s n Results for Pitney Bowes Business Insight Pv StatudCustomer No Similarity Namei LastName Name2 First 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 SE cancel 22 Spectrum Technology Platform 9 0 SP2 Chapter 3 Using the SAP Interface 4 Select from 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 XD02 or when you create or update a business partner via transaction code BP in SAP Validating an Address You can validate an ad
39. e 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 SP2 Chapter 1 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 Thursdays You can download the EWS file from the USPS website at ribbs usps gov Lacs Database Optional but Pitney Bowes required for CA ftware monthl The LACS database allows you to correct addresses that a ed To SASS I inci Certified subscription have changed as a result of a rural route address converting processing U S to street style address a PO Box
40. eave 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 Mail can be delivered to the address N Mail cannot be delivered to the address S The building number was validated but the unit number could not be confirmed A building number is the primary address number for a building A unit number is a number of a distinct mailing address within a building such as an apartment suite floor and so on For example in this address 424 is the building number and 12 is the unit number 33 Business Partners 34 Field RDI EWS Telephone Fax Email Description 424 Washington Blvd Apt 12 Oak Park IL 60302 USA D The building number was validated but the unit number was missing from input A building number is the primary address number for a building A unit number is anumber of a distinct mailing address within a building such as an apartment suite floor and so on For example in this address 424 is the building number
41. ecked 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 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 changed i Address Fields i Street i City i Region Postal Code Country E Tax Jurisdiction Code i Latitude i Longitude CMRA DPV RDI Ews Row 1 of 13 z d Water St water st Lee lee MA MA 01238 9008 01238 9008 US US 2753 u u EZ Accept Changes te Accept Current Ifthe address matches multiple addresses in the postal data the Address List pop up displays SAP Module User s Guide 41 Business Partners 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
42. en supplies the correct secondary address information SAP Module User s Guide 9 Integrating SAP with Spectrum In this section Integrating with SAP Web Dynpro 12 Integrating with SAP Interaction Center WebClient 15 Integrating with SAP Web Dynpro Integrating with SAP Web Dynpro Before continuing verify the following SAP Application SAP NetWeaver 7 01 with Patch 3 and Spectrum Technology Platform is available PBS SCA files have been deployed System Landscape Directory SLD has been properly configured To integrate Spectrum Technology Platform with SAP Web Dynpro you need to install supporting databases and dataflows on the Spectrum Technology Platform server and then configure your SAP system to communicate with Spectrum Technology Platform Once you do this users of SAP Web Dynpro will have access to address validation and geocoding functionality from within SAP Web Dynpro 1 On the Spectrum Technology Platform server install the databases required to perform address validation geocoding and tax jurisdiction assignment and define database resources for each database You must give the database resources the following names Database Required Name for Database Resource Enterprise Geocoding Module Canada Database IGEO CAN Enterprise Geocoding Module U S Database EGM_US Enterprise Tax Module Database ETM Universal Addressing Module Canada Database Canada Univer
43. erify that this entry is not already in the SAP system This helps prevent you from creating a duplicate record SAP Module User s Guide 35 Business Partners 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 a pan i DORMI v 1000 136 1PO Box 1 New York NY 10002 0001 v 100 0 50 1 Po Box 1 New York NY 10116 0001 gt Row 1Jot3 gt wf Continue EE Switch to Duplicate y Display Partner 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 4 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 Creating a Busin
44. es and Module Support ISO Country Name ISO 3116 1 ISO 3116 1 Supported Modules Alpha 2 Alpha 3 Benin BJ BEN Address Now Module Enterprise Geocoding Module Africa 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 Enterprise Geocoding Module Latin America 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 Africa Universal Addressing Module Bouvet Island BV BVT Address Now Module Universal Addressing Module Brazil BR BRA Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module GeoComplete 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 Africa Universal Addressing Module Burundi BI BDI Address Now Module Enterprise Geocoding Module Africa Universal Addressing Module Cambodia KH KHM Address Now Module Universal Addressing Module 66 Spectrum Technolo
45. ess 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 Field Description Title Select Company Name The name of the company or organization Street House No ni organization s street and house or building number For example 430 Main t City The municipality name Postal Code The postal code for the address Country The country for the address 36 Spectrum Technology Platform 9 0 SP2 Field Region Tax Jurisdiction PO Box PO w o number Postal Code Latitude Longitude CMRA DPV RDI SAP Module User s Guide Chapter 4 Using SAP Dynpro Description 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 calc
46. g e Save the change 7 Setup JCO destinations 14 Spectrum Technology Platform 9 0 SP2 Chapter 2 Integrating SAP with Spectrum a Goto the NetWeaver Portal Content Administrator URL and log in as J2EE_ADMIN or an account that has an Administrator Privilege b Expand Deployed Content then pb com then pb com dqc On the Details window select the JCO Connections tab c Select WD DQC MODELDATA DEST and click Create Complete all the required information to be able to run and test the connection d Repeat the steps and complete the required information for WD DQC MODELDATA DEST Note WD DQC MODELDATA DEST is the Application Data and WD DQC RFC METADATA DEST is the Dictionary Metadata 8 Configure the BuildGlobalAddress web service in the SAP Visual Admin a Go to drive usr sap system id gt DVEBMGS01 j2ee admin and click go bat and enter J2EE ADMIN password b Goto Cluster gt Server gt Services gt JCo RFC Provider and select the Bundles tab c Enter all of the information needed by the application and click Set to save the changes d Go to Cluster gt Server gt Services gt Web Services Security e Create a proxy in Web Services Client gt sap com gt Dynamic WSProxies with the name PBBIWebServiceConnectorBGA f Forthe URL enter http spectrumservername port soap BuildGlobalAddress wsdl For example http MySpectrumServer 8080 soap BuildGlobalAddress wsdl 9 Restart the app
47. ge is displayed 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 SAP Module User s Guide 23 Address Validation 24 4 Results are only displayed on the Out Of Context Alternatives box when entries are found out of the scope of the search criteria 5 To begin a search enter the address to 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 a beach
48. gy Platform 9 0 SP2 ISO Country Name ISO 3116 1 Alpha 2 Appendix A Country ISO Codes and Module Support ISO 3116 1 Supported Modules Alpha 3 Cameroon Canada Cape Verde Cayman Islands Central African Republic Chad Chile China Christmas Island Cocos Keeling Islands Colombia Comoros Congo Congo The Democratic Republic Of The Cook Islands SAP Module User s Guide CM CA CV KY CF TD CL CN CX CC CO KM CG CD CK CMR Address Now Module Enterprise Geocoding Module Africa Universal Addressing Module CAN Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module GeoComplete Module CPV Address Now Module Universal Addressing Module CYM Address Now Module Universal Addressing Module CAF Address Now Module Universal Addressing Module TCD Address Now Module Universal Addressing Module CHL Address Now Module Enterprise Geocoding Module Universal Addressing Module GeoComplete Module CHN Address Now Module Enterprise Geocoding Module Universal Addressing Module CXR Address Now Module Universal Addressing Module CCK Address Now Module Universal Addressing Module COL Address Now Module Universal Addressing Module COM Address Now Module Universal Addressing Module COG Address Now Module Enterprise Geocoding Module Africa Universal Addressing Module COD Address Now Module Enter
49. he 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 7 After you have validated the address and checked for duplicates click Save Creating a Customer Consumer 46 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 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
50. hnology Platform server Press the F8 key or click the execute icon When you see a message saying that the process has ended click the back icon until you are at the screen titled ABAP Editor Initial Screen In the Program field enter HSGRP1 RSADRQUS Press the F8 key or click the execute icon Press the F8 key or click the execute icon again SAP Module User s Guide 25 Deduplication Batch address validation is now complete Viewing the Address Validation Report The address validation report lists address information for records that have been processed through batch and interactive address validation The report contains information such as the address RDI and DPV codes and whether the address is cleansed 1 Enter the transaction code N HSGRP1 MASTER 2 Inthe By Address and By Address Type sections specify the filter criteria to use to select records to include in the report 3 Inthe By Address Status section select one or more of the following Cleansed Check this box to include addresses that the system has validated and cleansed Not Yet Cleansed Check this box to include addresses that the system has not attempted to validate or cleanse Differing Check this box to include addresses that were entered into the system at a time when address validation was disabled 4 Inthe Maximum No of Hits field enter the maximum number of records you want to include in the report 5 Press the F8 key or click the e
51. icons in the column are described in the following table 42 Spectrum Technology Platform 9 0 SP2 Chapter 4 Using SAP Dynpro Table 6 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 a Business Partner 1 In a web browser open the Pitney Bowes Spectrum Data Quality Connector for SAP page 2 Click Display Business Partner 3 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 43 4 Click Change 5 Editthe business partner For additional information see Creating a Business Partner Organization on page 36 and Creating a Business Partner Person on page 33 Searching for a Bu
52. ilable by subscription from Pitney Bowes Software and is updated monthly 6 Spectrum Technology Platform 9 0 SP2 Universal Addressing Module Databases Table 1 Universal Addressing Module Databases Database Name amp Description Chapter 1 SAP Module 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 Municipality 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
53. ings lt USERNAME gt Local Settings Temp g1Assemblies After you delete the contents of this folder log in again 3 Import SAR files A SAR file is a file that contains a third party add on package for SAP such as the Spectrum Technology Platform SAP Module The SAR file is located on the Spectrum Technology Platform installer in the SAP Objects folder For information on importing SAR files into SAP applications see your SAP Basis administrator 4 Activate the BC sets a Log on to the client where the settings for the Spectrum Technology Platform SAP Module is to be configured b Enter the transaction code SCPR20 This activates Business Configuration BC sets This will place the default entries on the Spectrum Technology Platform customizing tables c In the BC Set field enter HSGRP1 BCSET_BC BAS PV SAP Module User s Guide 13 Integrating with SAP Web Dynpro d Activate it with the options Overwrite All Data and Default Mode Activation Options Ev Caution You have started the BC Set activation If you continue new data records will be created and or existing ones overwritten Activation Options FSALVADOR Overwrite Data 15 09 2008 16 06 05 9 Overwrite All Data DC 100 O Default values not Overwritten Workbench Regst Not Required Customizing Reqst DC6kK900105 Select Activation Mode Activation Links Create Locally Default Mode Reccomend O Expe
54. l Addressing Module Address Now Module Universal Addressing Module GeoComplete Module Address Now Module Enterprise Geocoding Module Middle East Universal Addressing Module Spectrum Technology Platform 9 0 SP2 Appendix A Country ISO Codes and Module Support ISO Country Name ISO 3116 1 ISO 3116 1 Supported Modules Alpha 2 Alpha 3 Kyrgyzstan KG KGZ Address Now Module Universal Addressing Module Lao People s Democratic LA LAO Address Now Module Republic Universal Addressing Module Latvia LV LVA Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module Lebanon LB LBN Address Now Module Enterprise Geocoding Module Middle East Universal Addressing Module Lesotho LS LSO Address Now Module Enterprise Geocoding Module Africa 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 GeoComplete Module Lithuania LT LTU Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module Luxembourg LU LUX Address Now Module Enterprise Geocoding Module r Enterprise Routing Module Universal Addressing Module GeoComplete Module Macao MO MAC Address Now Module Enterprise Geocoding Module Universal Add
55. l 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 37 Business Partners 38 Field EWS Telephone Fax Email Description 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 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 Address changed Address Fields ks uh Sia ee Street Water St water st i City Lee lee i Region MA MA Postal Code 01238 9008 01238 9008 Country US Us H Tax Jurisdiction Code 2753 i Latitude i Longitude CMRA u DPV U RDI R H EWS EEE Row ioris CEE EE Accept Changes E Accept Current 38 If the address matches multiple addresses in the postal data the Address List pop up displays SAP DQC Postal Validation by beach st san francisco Address 903 Beach St San Fra
56. le Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module GeoComplete Module 5 The Vatican is covered by the Italy geocoder SAP Module User s Guide 71 Country ISO Codes and Module Support 72 ISO Country Name Isle Of Man Israel Italy Jamaica Japan Jersey Jordan Kazakhstan Kenya Kiribati Korea Democratic People s Republic Of Korea Republic Of Kosovo Kuwait ISO 3116 1 Alpha 2 JM JP JE JO KE KI KP KR KS KW ISO 3116 1 Alpha 3 IMN ISR ITA JAM JPN JEY JOR KEN KIR PRK KOR KOS KWT 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 GeoComplete Module Address Now Module Enterprise Geocoding Module Latin America Universal Addressing Module Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module GeoComplete 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 Africa Universal Addressing Module Address Now Module Universal Addressing Module Address Now Module Universal Addressing Module Address Now Module Universa
57. lication server 9 If you will be using French address validation you must install the Data Normalization Module table cdq TableLookup SAP tba on the Spectrum Technology Platform server For more information see the Spectrum Technology Platform Installation Guide Integrating with SAP Interaction Center WebClient Before continuing verify the following The Interaction Center WebClient user has the CRM UI PROFILE parameter ID with IC AGENT as the Parameter Value The duplicate option is activated in SPRO under ICWC SPRO gt CRM gt ICWC gt Define Account Identification Profiles To integrate Spectrum Technology Platform with SAP Interaction Center WebClient you need to install supporting databases and dataflows on the Spectrum Technology Platform server and then configure your SAP system to communicate with Spectrum Technology Platform Once you do this users of SAP Interaction Center WebClient will have access to address validation and geocoding functionality from within SAP Interaction Center WebClient 1 On the Spectrum Technology Platform server install the databases required to perform address validation geocoding and tax jurisdiction assignment and define database resources for each database You must give the database resources the following names Database Required Name for Database Resource Enterprise Geocoding Module Canada Database IGEO CAN Enterprise Geocoding Module U S Database EGM_US Enterp
58. mum platform support but can leverage products written in other languages by building Java based components on top of these other products 32 Spectrum Technology Platform 9 0 SP2 Chapter 4 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 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 St Number 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 Longitude CMRA DPV SAP Module User s Guide 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 l
59. n nnn u keine uc kia nare cauaa 58 BEL EWBITepejculmeme RT 60 Appendix A Country ISO Codes and Module Support 63 Country ISO Codes and Module Suppolt seeceeeceeeeeeeeeeeeeeeeeneeeeeeeeeenes 64 Spectrum Technology Platform 9 0 SP2 SAP Module The 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 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 The following diagram illustrates how Spectrum Technology Platform integrates with SAP NetWeaver Platform ECC CRM ABAP Workbench t Web Dynpro Q N T Data Quality Connector a Postal Validation Business Add In RS Data Quai Duplicate Check and Error Tolerant J Components Search Add In NR Bi SAP GUI Enterprise Portal DQC Business Application Programming Interface Connector f d Web Services XML Over HTTP Spectrum Technology Platform Services Address Now Module Advanced Matching Module Enterprise Tax Module Enterprise Geoco
60. ncisco 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 lt J Row 1 orso gt v x xx Accept Changes gh Accept Current 3 Cancel Spectrum Technology Platform 9 0 SP2 Chapter 4 Using SAP Dynpro If the 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 Iz Row t otz Tz Ej Accept Current X 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 following window is displayed i PV Status Similarity BP Number Description Name 1 Last Name 2 First Com os
61. nd 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 Spectrum Technology Platform 9 0 SP2 Chapter 4 Using SAP Dynpro Viewing and Modifying a Customer 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 PON gt 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 49 Click Change Edit the customer For additional information see Creating a Customer General on page 43 and Creating a Customer Consumer on page 46 om Searching for a Customer Error tolerant searches allow you to 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 Pitney Bowes Spectrum Data Quality Connector for SAP page At the top of the page click Customer Click Fuzzy Rough Search In the Name field enter the name of the customer you are searching for Under Street Address e
62. ng Module Seychelles SC SYC Address Now Module Universal Addressing Module 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 GeoComplete Module Sint Maarten Dutch Part SX SXM Universal Addressing Module 12 San Marino is covered by the Italy geocoder 78 Spectrum Technology Platform 9 0 SP2 Appendix A Country ISO Codes and Module Support ISO Country Name ISO 3116 1 ISO 3116 1 Supported Modules Alpha 2 Alpha 3 Slovakia SK SVK Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module GeoComplete Module Slovenia Sl SVN Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module GeoComplete 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 GeoComplete 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 GeoComplete Module Sri Lanka LK LKA Add
63. nter as much address information as you know o Oro 67M o Click Fuzzy Rough Search Vendor Creating a Vendor A Vendor is typically used for an individual person who acts as a vendor to your organization 1 In a web browser open the Pitney Bowes Spectrum Data Quality Connector for SAP page 2 Click Create Vendor 3 Complete the following fields Field Description Tile A title of respect or a professional title If the vendor is an organization and not a person select Company Name The name of the vendor This can be a person or a company 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 PO Box A post office box number PO w o 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 SAP Module User s Guide 49 Vendor Field Description 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 4 Click Validate to validate the address If the address can be validated the Address Changed wind
64. ntry 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 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 row orz CET Ea Accept Current ant x gt Cancel To use the validated address in the business parter you are creating click Accept Changes 5 Click Deduplicate to v
65. 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 Spectrum Technology Platform 9 0 SP2 5 Click Validate to validate the address Chapter 4 Using SAP Dynpro 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 01238 9008 SAP DQC Postal Validation Address Changed Address Fields cra gh House Number S080 Street Water St City Lee Region MA Postal Code 01238 9008 Country US US fthe address matches multiple addresses in the postal data the Address List pop up displays SAP DQC Postal Validation c beach st san francisco Address ae 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
66. oComplete 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 SAP Module User s Guide 81 Country ISO Codes and Module Support ISO Country Name ISO 3116 1 ISO 3116 1 Supported Modules Alpha 2 Alpha 3 Address Now Module Universal Addressing Module Virgin Islands British Address Now Module Universal Addressing Module Virgin Islands U S Address Now Module Universal Addressing Module Wallis and Futuna Address Now Module Universal Addressing Module Western Sahara Address Now Module Universal Addressing Module Address Now Module Universal Addressing Module Address Now Module Enterprise Geocoding Module Africa Universal Addressing Module Zimbabwe Address Now Module Enterprise Geocoding Module Africa Universal Addressing Module 82 Spectrum Technology Platform 9 0 SP2 Notices 84 2014 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
67. oaded after you have login to IC Web Client Interaction Center ti fX Accept Reject an Identify Account Account Identification Account Fact Sheet Account Overview Interaction Record Interaction History Fax Letter Unfinished E Mails Case Knowledge Search Script Index Inbox Hold Retrieve Hang Up Transfer Warm Transfer Consult Conference Toggle Account End Dial Pad Installed Base Object E Back gt First Name Last Name Account Account ID Street House Number City Postal Code Region Country Telephone E Mail Address Transaction ID Fax Relationship Has Contact Person Search Account Clear C Re ist Component Product ID Identification Search Clear Account Account ID B No result found PostalCode City Telephone Extension Button Search Account Clear E 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 56 Function Clear all the fields Perform search using the provided information Go to create account page Spectrum Technology Platform 9 0 SP2 2 Local intranet Chapter 5 Using the Interaction Center WebClient Identify Account Gback Account Installed Base Object First Name Last Name Component Account sampl Product ID Account
68. on v 100 0 136 4 PO Box 1 New York NY 10002 0001 v 100 0 50 1 Po Box 1 New York NY 10116 0001 Rew 1 ots wf Continue EEE Switch to Duplicate amp y Display Partner _ 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 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 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 SAP Module User s Guide 39 Business Partners 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 Crea
69. onant 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 Validate Address and Assign GeoTAX Info This service validates the address and determines tax jurisdictions for the location Validate Address With Candidates This service validates the address If an address matches multiple addresses in the postal data it returns the candidate addresses 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 Forinstructions 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 ava
70. onic 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 9 Copyright Second Decimal LLC Copyright Canada Post Corporation This CD ROM contains data from a compilation in which Canada Post Corporation is the copyright owner O 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 License 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 Spectrum Technology Platform 9
71. ou 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 P SAP NetWeaver Portal XMLHTTP MeN SAP R 3 Instance Spectrum Technology Platform Figure 1 System Architecture SAP NetWeaver Portal SAP NetWeaver Portal offers a single point of 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 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 maxi
72. ow displays As you can see the validated address is properly cased and the postal code has been added Address Changed Address Fields Era Go House Number S050 Street Water St water st City Lee lee Region MA MA Postal Code 01238 9008 01238 9008 Country us us Rew 1etz 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 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 Rew 1 otso vx fthe address could not be validated the Invalid Address popup is displayed 50 Spectrum Technology Platform 9 0 SP2 Chapter 4 Using SAP Dynpro SAP DQC Postal Validation Request failed Address not found Street 000 Something Road City New York Region MA Postal Code To use the validated a
73. ow is displayed This window shows the candidate duplicate or duplicates of the record you are creating Click Continue to ignore any duplicates displayed in the pop up and create the new record Click Switch to Duplicate to display the selected candidate duplicate and cancel the creation of the current duplicate Click Display Partner to view the selected duplicate record After viewing the duplicate record click the back button to return to this window Click Create Cleansing Case to merge the two records manually using the transaction code NBUPA CLEAR This option allows you to choose which record is the source record and which one is the target record for the merge Click the red X to cancel the deduplication process 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 for Business Partner records 1 Enter the transaction code N HSGRP1 MASTER 2 In the By Address and By Address Type sections specify the filter criteria to use to select records to include in the report 3 In the By Address Status section select one or more of the following Cleansed Check this box to include addresses that the system has validated and cleansed Not Yet Cleansed Check this box to include addresses that the system has not at
74. prise Geocoding Module Africa Universal Addressing Module COK Address Now Module Universal Addressing Module 67 Country ISO Codes and Module Support 68 ISO Country Name Costa Rica C te d lvoire Croatia Cuba Curacao Cyprus Czech Republic Denmark Djibouti Dominica Dominican Republic Ecuador Egypt ISO 3116 1 Alpha 2 CR HR CU CW CY CZ DK DJ DM DO EC EG ISO 3116 1 Alpha 3 CRI CIV HRV CUB CUW CYP CZE DNK DJI DMA DOM ECU EGY Supported Modules Address Now Module Enterprise Geocoding Module Latin America Universal Addressing Module Address Now Module Universal Addressing Module Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module Address Now Module Enterprise Geocoding Module Latin America Universal Addressing Module Address Now Module Universal Addressing Module Address Now Module Universal Addressing Module Address Now Module Enterprise Geocoding Module Universal Addressing Module GeoComplete Module Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module GeoComplete Module Address Now Module Universal Addressing Module Address Now Module Universal Addressing Module Address Now Module Enterprise Geocoding Module Latin America Universal Addressing Module Address Now Module En
75. ress Now Module Universal Addressing Module Sudan SD SDN Address Now Module Universal Addressing Module Suriname SR SUR Address Now Module Enterprise Geocoding Module Latin America Universal Addressing Module Svalbard And Jan Mayen SJ SJM Address Now Module Universal Addressing Module Swaziland SZ SWZ Address Now Module Enterprise Geocoding Module Africa Universal Addressing Module SAP Module User s Guide 79 Country ISO Codes and Module Support ISO Country Name 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 GeoComplete Module Switzerland CH CHE Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module GeoComplete 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 Africa 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 Africa Universal Addressing Module
76. ressing Module Macedonia Former Yugoslav MK MKD Address Now Module Republic Of Universal Addressing Module Madagascar MG MDG Address Now Module Universal Addressing Module Liechtenstein is covered by the Switzerland geocoder Luxembourg is covered by the Belgium geocoder SAP Module User s Guide 73 Country ISO Codes and Module Support ISO Country Name ISO 3116 1 ISO 3116 1 Supported Modules Alpha 2 Alpha 3 Malawi MW MWI Address Now Module Enterprise Geocoding Module Africa 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 Africa Universal Addressing Module 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 Enterprise Geocoding Module Africa Universal Addressing Module Mauritius MU MUS Address Now Module Enterprise Geocoding Module Africa Universal Addressing Module Mayotte YT MYT Address Now Module Enterprise Geocoding Module Universal Addressing Module Mexico MX MEX Address Now Module Enterprise Geocoding Module Uni
77. ries TF ATF Address Now Module Universal Addressing Module Gabon GA GAB Address Now Module Enterprise Geocoding Module Africa Universal Addressing Module French Guiana is covered by the France geocoder SAP Module User s Guide 69 Country ISO Codes and Module Support ISO Country Name ISO 3116 1 ISO 3116 1 Supported Modules Alpha 2 Alpha 3 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 GeoComplete Module Ghana GH GHA Address Now Module Enterprise Geocoding Module Africa Universal Addressing Module Gibraltar GI GIB Address Now Module Enterprise Geocoding Module Universal 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 Universal Addressing Module Guam GU GUM Address Now Module Universal Addressing Module Guatemala GT GTM Address Now Module Enterprise Geocoding Module Latin America Universal Addressing Module Guernsey GG GGY Address Now Module Universal Addressing Module Guinea GN GIN Address Now Module Universal Addressing Module Guinea Bissau GW G
78. rise Tax Module Database ETM SAP Module User s Guide 15 Integrating with SAP Interaction Center WebClient Database Required Name for Database Resource Universal Addressing Module Canada Database Canada Universal Addressing Module Loqate Database Loqate Universal Addressing Module U S Database UAM US 2 When you install the SAP Module several dataflow files are automatically installed Other dataflow files must be manually copied into Spectrum Technology Platform 8 If you are adding the Address Now Module Enterprise Tax Module or Universal Addressing Module to an existing installation open Spectrum Technology Platform Enterprise Designer select View gt Server Explorer and delete this dataflow SAPValidateAddressWith Candidates b Goto SpectrumFolder server modules dataflows sap c Review the following table then copy the applicable dataflow files to 16 SpectrumFolder server app import If you are installing this set of Copy these dataflow files to the import folder modules Address Now Module Address Now Module Universal Addressing Module Address Now Module Enterprise Tax Module Universal Addressing Module Universal Addressing Module without Loqate Universal Addressing Module without Loqate Enterprise Tax Module Universal Addressing Module with Loqate Universal Addressing Module with Loqate Enterprise Geocoding Module Universal Addressing Module with Loqate Enterprise Tax Module
79. rt Mode German English Li Activation Languages EE e Select and activate the remaining BC sets with the activation options set to Overwrite All Data and Expert Mode Note Active these BC sets in the order listed IHSGRP1 BCSET BC BAS GTX IHSGRP1 MERGE SETTINGS IHSGRP1 BCSET BUPA CUSTOM IHSGRP1 BCSET BC BAS DES 5 Setup the RFC destination a Enter transaction code SM59 b Click Create c In the RFC Destination field enter a name of your choice d In the Connection Type field enter G HTTP connection to external server e In the Description 1 field enter a meaningful description f Press the Enter key Click the Technical Settings tab In the Target Host field enter the computer name or IP Address of the Spectrum Technology Platform server In the Service No field enter 8080 Click the Special Options tab Select No Timeout Select HTTP 1 1 m After you save click Connection Test Note If there is a pop up window check the Accept All Further Cookies box and select YES 2 Q CSS I AI n When the test is successful go to the Response Body tab to view the Spectrum Technology Platform page 6 Setup the Spectrum Technology Platform Logging Object a Enter transaction code SLGO b Click New Entries c In the Object column enter HSGRP1 DQC d In the Object text column enter DOC Loggin
80. sal Addressing Module Loqate Database Loqate Universal Addressing Module U S Database UAM US 2 When you install the SAP Module several dataflow files are automatically installed Other dataflow files must be manually copied into Spectrum Technology Platform a If you are adding the Address Now Module Enterprise Tax Module or Universal Addressing Module to an existing installation open Spectrum Technology Platform Enterprise Designer select View gt Server Explorer and delete this dataflow SAPValidateAddressWith Candidates b Goto SpectrumFolder server modules dataflows sap c Review the following table then copy the applicable dataflow files to SpectrumFolder server app import If you are installing this set of Copy these dataflow files to the import folder modules Address Now Module SAPValidateAddressWithCandidates ANOW df Address Now Module SAPGenerateCASSReport df Universal Addressing Module SAPValidateAddressWithCandidates ANOW df ValidateAddressWithCandidates UAM df Address Now Module SAPBatchAssignGeoTAXInfo df Enterprise Tax Module SAPGenerateCASSReport df Universal Addressing Module SAPValidateAddressAndAssignGeoTAXInfo df SAPValidateAddressWithCandidates UAM ANOW ETM df ValidateAssignGeoTAXInfo df Universal Addressing Module SAPGenerateCASSReport df without Loqate ValidateAddressWithCandidates UAM df 12 Spectrum Technology Platform 9 0 SP2 Chapter 2 Integrating SAP with Spectrum If
81. se Designer delete the contents of lt WindowsTemporaryDirectory gt glAssemblies where lt WindowsTemporaryDirectory gt is one of the following TMP TEMP USERPROFILE or the Windows directory Typically C Documents and Settings lt USERNAME gt Local Settings TempYg 1 Assemblies After you delete the contents of this folder log in again 3 Import SAR files A SAR file is a file that contains a third party add on package for SAP such as the Spectrum Technology Platform SAP Module The SAR file is located on the Spectrum Technology Platform installer in the SAP Objects folder For information on importing SAR files into SAP applications see your SAP Basis administrator 4 Activate the BC sets a Log on to the client where the settings for the Spectrum Technology Platform SAP Module is to be configured b Enter the transaction code SCPR20 This activates Business Configuration BC sets This will place the default entries on the Spectrum Technology Platform customizing tables c In the BC Set field enter HSGRP1 BCSET BC BAS PV d Activate it with the options Overwrite All Data and Default Mode c Activation Options E Caution You have started the BC Set activation If you continue new data records will be created and or existing ones overwritten Activati formation Activation Options At y FSALVADOR Overwrite Data Date Time 15 08 2008 16 06 05 Overwrite All Data Sys
82. siness 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 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 9 On PON 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 Atthe top of the page click Customer 3 Click Create Customer then click Create Customer General SAP Module User s Guide 43 Customers 4 Complete the following fields Field Title Name Street House Number City Postal Code Country Region PO Box Postal Code Telephone Fax Email Description A title of respect or professional title If the customer is a company enter 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 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 are
83. te Business Partner then click Group 3 Complete the following fields Field Title 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 40 Description Optional If desired you may select Mr and Mrs The name of one of the individuals in the group The name of one of the individuals in the group 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
84. te that the Enterprise Geocoding Module includes databases for Africa 30 countries Middle East 8 countries and Latin America 20 countries These databases cover the smaller countries in those regions that do not have their own country specific geocoding databases The Supported Modules column indicates which countries are covered by these Africa Middle East and Latin America databases Also the Geocode Address World database provides geographic and limited postal geocoding but not street level geocoding for all countries ISO Country Name 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 GeoComplete Module Angola AO AGO Address Now Module Enterprise Geocoding Module Africa 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
85. tem Client DCB 188 O Default Values not Overwritten Workbench Reqst Not Required Customizing Reqst DCBK800105 Select Activation Mode Activation Links Create Locally Default Mode Reccomend i Ta O Expert Mode German Activation Languages English lH __ e Select and activate the remaining BC sets with the activation options set to Overwrite All Data and Expert Mode Note Active these BC sets in the order listed SAP Module User s Guide 17 Integrating with SAP Interaction Center WebClient 18 5 10 HSGRP1 BCSET_BC_BAS_GTX HSGRP1 MERGE_SETTINGS HSGRP1 BCSET_BUPA_CUSTOM HSGRP1 BCSET_BC_BAS_DES Activate the following BC set with activation options set to Overwrite All Data and Expert Mode HSGRP1 BCSET_DQC_CUSTOM Activate the BC set for IC WebClient The BC setis HSGRP1 ICWC SETTINGS Specify the activation options Overwrite Data and Expert Mode Set up the RFC destination a Enter transaction code SM59 b Click Create c Inthe RFC Destination field enter a name of your choice d Inthe Connection Type field enter G HTTP connection to external server e Inthe Description 1 field enter a meaningful description f Press the Enter key g Click the Technical Settings tab h In the Target Host field enter the computer name or IP Address of the Spectrum Technology Platform server i In the Service No field enter
86. tempted to validate or cleanse Differing Check this box to include addresses that were entered into the system at a time when address validation was disabled 4 In the Maximum No of Hits field enter the maximum number of records you want to include in the report 5 In the Duplicate Check Threshold field enter a threshold for considering two records duplicates The threshold is a percentage that indicates the amount of similarity between two records that qualifies them to be duplicates For example if you enter 30 0 any records that are 3096 the same will be considered duplicates You must enter the percentage in the format percentage 0 6 Press the F8 key or click the execute icon The records that match your criteria are displayed The Status column indicates the address validation status for each record Table 3 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 7 Click Check for Duplicates to view the candidate duplicate or duplicates for the selected record SAP Module User s Guide 27 Viewing the Log 8 Inthe Duplicates window select the record that is a duplicate of the one you selected in the main window then click one of the following buttons Merge Current To Duplicate Merges the record from
87. terprise Geocoding Module Latin America Universal Addressing Module Address Now Module Enterprise Geocoding Module Middle East Universal Addressing Module Spectrum Technology Platform 9 0 SP2 Appendix A Country ISO Codes and Module Support ISO Country Name ISO 3116 1 ISO 3116 1 Supported Modules Alpha 2 Alpha 3 EI Salvador SV SLV Address Now Module Enterprise Geocoding Module Latin America 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 Enterprise Routing 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 FJl Address Now Module Universal Addressing Module Finland Fl FIN Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module GeoComplete Module France FR FRA Address Now Module Enterprise Geocoding Module Enterprise Routing Module Universal Addressing Module GeoComplete Module French Guiana GF GUF Address Now Module Enterprise Geocoding Module 7 Universal Addressing Module French Polynesia PF PYF Address Now Module Universal Addressing Module French Southern Territo
88. the process of initializing the duplicate status field in the table HSGRP1 MATCHKEY 1 Enter the transaction code NSE38 2 Inthe Program field enter HSGRP1 RSADRDEDUP 3 Press the F8 key or click the execute icon 4 Enter the package size then press the F8 key or click the execute icon Viewing the Log 28 The SAP Module uses the built in application log of SAP To view the log entries you can enter the transaction SLG1 1 Enter the transaction code SLG1 2 In the Object field enter HSGRP1 DQC This is the object name used to view logs specific to Spectrum Technology Platform 3 Enter any filtering criteria you want to use to limit the transactions displayed in the log 4 Press the F8 key or click the execute icon 5 To view the XML message passed or received by the Spectrum Technology Platform server select a log and press the F7 key or click the details icon Spectrum Technology Platform 9 0 SP2 Chapter 3 Using the SAP Interface Note XML message logs are created depending on the General Behavior settings Display logs lt xml version 1 0 encoding utf 8 gt lt message gt lt propertysets gt lt propertyset name context gt lt property ke lt property lt property lt propertyset gt lt propertysets gt dataset columns column name AddressNumber gt count password v column name MatchGroup gt column name Threshol
89. ue EEUU 29 Chapter 4 Using SAP DynhpEFO uuaxscseko rici naui kd la Ri dep dan nisl 31 INTO MU CCON 32 Business Partner S eiiiai ena 33 Creating a Business Partner Person mens 33 Creating a Business Partner Organization sssssssss 36 Creating a Business Partner Group ciini teresa basic 40 Viewing and Modifying a Business Partner sssssess 43 Searching Tor a Business Partiier occi occ naia 43 Customefts tempe a A3 Creating a Customer General senta pedian arininn 43 Creating a Customer COnSUITIGr oaa Ea 46 Viewing and Modifying a Customer c ente cb et Her tes Eae ER dE Tee pudeat 49 Searching for a CUstomWel losa nianna aai aia tuc eu 49 b npnnl 49 Cregtihg a Velltok saenesasveesete oed Pe tend ete eer aec te tede seed 49 Viewing and Modifying a Vendor oie ertet inerte aa 52 Si uedekem B eemcc aaa e nA 52 Searching for an Address with Advanced Search 52 Chapter 5 Using the Interaction Center WebClient 55 KI enpmee 56 Creating a Business Partner Account eene 57 Modifying a Business Partner Account seeeenenen 58 Validating an Addroess eren innere
90. ulated 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 Mail can be delivered to the address N Mail cannot be delivered to the address S The building number was validated but the unit number could not be confirmed A building number is the primary address number for a building A unit number is a number of a distinct mailing address within a building such as an apartment suite floor and so on For example in this address 424 is the building number and 12 is the unit number 424 Washington Blvd Apt 12 Oak Park IL 60302 USA D The building number was validated but the unit number was missing from input A building number is the primary address number for a building A unit number is a number of a distinct mailing address within a building such as an apartment suite floor and so on For example in this address 424 is the building number and 12 is the unit number 424 Washington Blvd Apt 12 Oak Park IL 60302 USA 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 residentia
91. versal 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 3 Martinique is covered by the France geocoder 3 Mayotte is covered by the France geocoder 74 Spectrum Technology Platform 9 0 SP2 Appendix A Country ISO Codes and Module Support ISO Country Name ISO 3116 1 ISO 3116 1 Supported Modules Alpha 2 Alpha 3 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 Africa Universal Addressing Module Mozambique MZ MOZ Address Now Module Enterprise Geocoding Module Africa Universal Addressing Module Myanmar MM MMR Address Now Module Universal Addressing Module Namibia NA NAM Address Now Module Enterprise Geocoding Module Africa 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 GeoComplete Module New Caledonia NC NCL Address Now Module Universal Addressing Module
92. versal Addressing Module GeoComplete Module Rwanda RW RWA Address Now Module Enterprise Geocoding Module Africa 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 11 Reunion is covered by the France geocoder SAP Module User s Guide 77 Country ISO Codes and Module Support ISO Country Name ISO 3116 1 ISO 3116 1 Supported Modules Alpha 2 Alpha 3 Saint Kitts and Nevis KN KNA Address Now Module Enterprise Geocoding Module Latin America 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 i Universal Addressing Module Sao Tome And Principe ST STP Address Now Module Universal Addressing Module Saudi Arabia SA SAU Address Now Module Enterprise Geocoding Module Middle East Universal Addressing Module Senegal SN SEN Address Now Module Enterprise Geocoding Module Africa Universal Addressing Module Serbia RS SRB Address Now Module Universal Addressi
93. xecute icon The records that match your criteria are displayed The Status column indicates the address validation status for each record 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 6 Click Show Statistics to view a count of the records included in the report Deduplication Deduplication is the process of identifying duplicate records in a data set The SAP modules allow you to identify duplicate business partner records 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 Deduplicating a Business Partner When you create a business partner record you can check to make sure you are not creating a duplicate of an existing business partner 1 Enter the transaction code NBP to create a new business partner 2 Create the new business partner 26 Spectrum Technology Platform 9 0 SP2 Chapter 3 Using the SAP Interface 3 When you are done entering information press the F8 key or click the check icon 4 lf the address you entered is not valid you are prompted to choose a valid address 5 Ifa record in the system is similar to the record being created the deduplication wind
94. you are installing this set of Copy these dataflow files to the import folder modules Universal Addressing Module SAPBatchAssignGeoTAXInfo df without Loqate SAPGenerateCASSReport df Enterprise Tax Module SAPValidateAddressAndAssignGeoTAXInfo df ValidateAddressWithCandidates UAM ETM df ValidateAssignGeoTAXInfo df Universal Addressing Module ValidateAddressWithCandidates UAM Logqate df with Loqate Universal Addressing Module ValidateAddressWithCandidates UAM Loqate EGM df with Loqate Enterprise Geocoding Module Universal Addressing Module ValidateAddressWithCandidates UAM Loqate ETM df with Loqate Enterprise Tax Module Universal Addressing Module ValidateAddressWithCandidates UAM Loqate EGM ETM df with Loqate Enterprise Geocoding Module Enterprise Tax Module Universal Addressing Module ValidateAddressWithCandidates Loqate df Loqate only Universal Addressing Module ValidateAddressWithCandidates Loqate EGM df Loqate only Enterprise Geocoding Module Enterprise Geocoding Module GeocodeUSAddressWithCandidates df ValidateAddressWithCandidates EGM df Enterprise Tax Module SAPBatchAssignGeoTAXInfo df ValidateAssignGeoTAXInfo df Note If errors occur in Management Console or Enterprise Designer delete the contents of lt WindowsTemporaryDirectory gt glAssemblies where lt WindowsTemporaryDirectory gt is one of the following TMP TEMP USERPROFILE or the Windows directory Typically C Documents and Sett

SAP Module User`s Guide - Support

Contents

Download Pdf Manuals

Related Search

Related Contents