To integrate Spectrum Technology Platform with SAP, 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 will have access to address validation and geocoding functionality from within SAP.
-
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 - Canada Database IGEO_CAN Enterprise Geocoding - U.S. Database EGM_US Enterprise Tax Database ETM Universal Addressing - Canada Database Canada Universal Addressing - Loqate Database Loqate Universal Addressing - U.S. Database UAM_US -
When you install the SAP, several dataflow files are
automatically installed. Other dataflow files must be manually copied into
Spectrum Technology Platform.
- If you are adding Enterprise Tax or Universal Addressing to an existing installation, open Spectrum Technology Platform Enterprise Designer, select View > Server Explorer, and delete this dataflow: SAPValidateAddressWithCandidates.
- Go to: SpectrumDirectory\server\modules\dataflows\sap.
-
Review the following table then copy the applicable dataflow files
to:
SpectrumDirectory\server\import
If you are installing this set of modules Copy these dataflow files to the import folder Universal AddressingModule ValidateAddressWithCandidates_UAM.df SAPBatchValidateAddress.df
Enterprise Geocoding ValidateAddressWithCandidates_EGM.df
Enterprise Geocoding
Universal AddressingValidateAddressWithCandidates_UAM_EGM.df
Enterprise Tax
Universal AddressingValidateAssignGeoTAXInfo.df
SAPBatchAssignGeoTAXInfo.df
SAPValidateAddressAndAssignGeoTAXInfo.df
ValidateAddressWithCandidates_UAM_ETM.df
Universal Addressing without Loqate
SAPValidateAddressWithCandidate_UAM.df
Universal Addressing without Loqate
Enterprise TaxValidateAssignGeoTAXInfo.df
SAPBatchAssignGeoTAXInfo.df
SAPValidateAddressAndAssignGeoTAXInfo.df
SAPValidateAddressWithCandidates.UAM_ETM.df
Universal Addressing with Loqate
ValidateAddressWithCandidates_UAM_Loqate.df
Universal Addressing with Loqate
Enterprise GeocodingValidateAddressWithCandidates_UAM_Loqate_EGM.df
Universal Addressing with Loqate
Enterprise TaxValidateAddressWithCandidates_UAM_Loqate_ETM.df
Universal Addressing with Loqate
Enterprise Geocoding
Enterprise TaxValidateAddressWithCandidates_UAM_Loqate_EGM_ETM.df
Universal Addressing, Loqate only
ValidateAddressWithCandidates_Loqate.df
Universal Addressing, Loqate only
Enterprise GeocodingValidateAddressWithCandidates_Loqate_EGM.df
Enterprise Geocoding
GeocodeUSAddressWithCandidates.df
ValidateAddressWithCandidates_EGM.dfEnterprise Tax
ValidateAssignGeoTAXInfo.df
ValidateAddressWithCandidates_ETM.df
SAPBatchAssignGeoTAXInfo.df
Note: If errors occur in Management Console or Enterprise Designer, delete the contents of WindowsTemporaryDirectory\g1Assemblies, where WindowsTemporaryDirectory is one of these: %TMP%, %TEMP%, %USERPROFILE%, or the Windows directory. Typically, C:\Documents and Settings\USERNAME\Local Settings\Temp\g1Assemblies. After deleting the contents of this folder, log in again.
-
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. The .SAR file is located on the Spectrum Technology Platform installer in the SAP Objects folder. For information about importing .SAR files into SAP applications, see your SAP Basis administrator.
-
Activate the business configuration (BC) sets. The
activation options and sequence differs for ECC and CRM installations.
-
Activate BC sets for ECC and S/4 HANA installations
- Log on to the client where the settings for the Spectrum Technology Platform SAP is to be configured.
- Enter the transaction code SCPR20. This activates BC sets and places the default entries on the Spectrum Technology Platform customizing tables.
- In the BC Set field, enter keyword *hsgrp1* and find all the BC Sets in this namespace.
- Activate it with the options Overwrite All
Data and Default Mode.
- Select and activate the BC sets with the activation options set
to Overwrite All Data and
Expert ModeNote: Activate these BC sets in the order listed.
- /HSGRP1/BCSET_BC_BAS_DES
- /HSGRP1/BCSET_BC_BAS_GTX
- /HSGRP1/BCSET_BC_BAS_PV
- /HSGRP1/BCSET_BUPA_CUSTOM
- /HSGRP1/BCSET_DQC_CUSTOM
- /HSGRP1/BCSET_VENDOR
- /HSGRP1/DD_TCODE
- /HSGRP1/FUZZY_SEARCH_INPUT_PARAM
- /HSGRP1/MERGE_SETTINGS
- /HSGRP1/ONP_PO
- /HSGRP1/SPOD_CON_TABLE
- /HSGRP1/SPOD_IN_TABLE
- /HSGRP1/SPOD_OPT_TABLE
- /HSGRP1/SPOD_OUT_TABLE
- /HSGRP1/SPOD_PO
-
Activate BC sets for CRM installations where ICWC isn’t required (IC
Web Client)
- Log on to the client where the settings for the Spectrum Technology Platform SAP is to be configured.
- Enter the transaction code SCPR20. This activates BC sets and places the default entries on the Spectrum Technology Platform customizing tables.
- In the BC Set field, enter keyword *hsgrp1* and find all the BC Sets in this namespace.
- Activate it with the options Overwrite All
Data and Default Mode.
- Select and activate the BC sets with the activation options set
to Overwrite All Data and
Expert ModeNote: Activate these BC sets in the order listed.
- /HSGRP1/BCSET_BC_BAS_DES
- /HSGRP1/BCSET_BC_BAS_GTX
- /HSGRP1/BCSET_BC_BAS_PV
- /HSGRP1/BCSET_BUPA_CUSTOM
- /HSGRP1/BCSET_DQC_CUSTOM
- /HSGRP1/BCSET_VENDOR
- /HSGRP1/DD_TCODE
- /HSGRP1/FUZZY_SEARCH_INPUT_PARAM
- /HSGRP1/HYBRID_CONFIG
- /HSGRP1/MERGE_SETTINGS
- /HSGRP1/ONP_PO
- /HSGRP1/SPOD_CON_TABLE
- /HSGRP1/SPOD_CON_ENTRY
- /HSGRP1/SPOD_IN_TABLE
- /HSGRP1/SPOD_OPT_TABLE
- /HSGRP1/SPOD_OUT_TABLE
- /HSGRP1/SPOD_PO
- /HSGRP1/SPOD_SSE_ENTRY
-
Activate BC sets for ECC and S/4 HANA installations
-
Set up the RFC destination for Spectrum OnPremise.
- Enter transaction code SM59.
- Click Create.
- In the RFC Destination field, enter a name of your choice.
- In the Connection Type field, enter G (HTTP connection to external server).
- In the Description 1 field, enter a meaningful description.
- 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.
-
After you save, click Connection Test.
Note: If there is a pop-up window, check the Accept All Further Cookies box and select YES.
-
When the test is successful, go to the Response
Body tab to view the Spectrum Technology Platform
page.
Note: To setup RFC Destination for Spectrum OnDemand, seeIntegration of SAP with Spectrum on Demand.
-
Set up the Spectrum Technology Platform Logging
Object
- Enter transaction code SLG0.
- Click New Entries.
- In the Object column, enter /HSGRP1/DQC.
- In the Object text column, enter DQC Logging.
- Save the change.
-
Configure the BuildGlobalAddress web service in the SAP Visual Admin:
- Go to drive:/usr./sap/system id/DVEBMGS01/j2ee/admin and click go.bat and enter J2EE_ADMIN as password.
- Go to Cluster > Server > Services > JCo RFC Provider and select the Bundles tab.
- Enter all the information needed by the application and click Set to save the changes.
- Go to Cluster > Server > Services > Web Services Security.
- Create a proxy in Web Services Client > sap.com > Dynamic WSProxies with the name ValidateAddressWithCandidates.
-
For the URL, enter:
http://spectrumservername:port/soap/ValidateAddressWithCandidates?wsdl
For example,
http://MySpectrumServer:8080/soap/ValidateAddressWithCandidates?wsdl
- Restart the application server.
- If you will be using French address validation, you must install the Data Normalization table cdq-TableLookup-SAP.tba on the Spectrum Technology Platform server. For more information, see the Spectrum Technology Platform Installation Guide.
-
To configure DPV and RDI options, open
T-code/hsgrp1/options, and specify
Y (to enable) or N (to
disable), as needed.
-
PVPO: For PO Box address validation
-
PVST: For street address validation
-
PVQU: For batch address validation
-