---
sourceDocument: Xanadu IT Asset Management
sourceDocumentLink: https://www.servicenow.com/docs/r/xanadu/it-asset-management

 Release :

    - xanadu

ft:locale :

    - en-US

ft:publication_title :

    - Xanadu IT Asset Management

ft:clusterId :

    - itam

bundleId :

    - itam

workflow :

    - Technology


---

# Import custom SAP price lists

# Import custom SAP price lists {#ariaid-title1}

* Release version: Xanadu
* 
* Updated August 1, 2024
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 3 minutes to read

Import custom SAP price lists into your ServiceNow® instance so that you can track and manage SAP licenses based on the contracts that are specific to your SAP system.

## Before you begin

Role required: admin

## Procedure

1. Go to [KB1299127](https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB1299127) to download the Microsoft Excel spreadsheet template (imp_samp_sap_custom_price_list.xlsx) that you can use to import custom SAP price list data into your ServiceNow instance. {#import-custom-sap-price-list__dl-template}
{#import-custom-sap-price-list__dl-template}
2. Fill in the spreadsheet with all the custom SAP price list data that you want to import.  
   The Client, System, and Price list value fields are required for every entry on the spreadsheet.  
   Note:  
   You must fill in a separate spreadsheet for each custom SAP price list that you want to import data for.
3. From your ServiceNow instance, open the SAP Custom Price List Data \[imp_samp_sap_custom_price_list\] table.  
   Note:  
   The Application Scope of your ServiceNow instance must be set to Software Asset Management Professional for SAP.
   1. On the page header of your ServiceNow instance, select All.
   2. In the menu navigation filter, enter <kbd class="ph userinput">imp_samp_sap_custom_price_list_list.do</kbd>.  
      The SAP Custom Price List Data \[imp_samp_sap_custom_price_list\] table opens.
   {#import-custom-sap-price-list__substeps_pyc_mb4_qxb}
4. Right-click the table header and then select Import.
5. On the form, fill in the fields.  
   {#import-custom-sap-price-list__table_k3z_qln_qxb__entry__2}

   | Field | Description |
   |-|-|
   | Do you want to insert or update data? | Option that indicates whether you're inserting new data or updating existing data in the SAP Custom Price List Data \[imp_samp_sap_custom_price_list\] table. |
   | Do you want to create an Excel template to enter data? | Option to generate the Microsoft Excel spreadsheet template that you can use to insert or update data in the SAP Custom Price List Data \[imp_samp_sap_custom_price_list\] table. Enable this option only if you didn't already download the spreadsheet template in [step 1](https://www.servicenow.com/docs/U1m8N4G~Zb9soCcu1JYhng#import-custom-sap-price-list__dl-template). |
   | Step 1: Create an Excel template file to enter data Note: This form section appears only when you enable the Do you want to create an Excel template to enter data? option. ||
   | Include all fields in the template | Option to include all available fields in the Microsoft Excel spreadsheet template. |
   | Create Excel Template | Option to generate the Microsoft Excel spreadsheet template. |
   | Step 2: Upload the template file ||
   | Excel template file | Microsoft Excel spreadsheet that contains the data that you want to insert or update in the SAP Custom Price List Data \[imp_samp_sap_custom_price_list\] table. |
   [Table 1. Import external data into SAP Custom Price List Data form]

   {#import-custom-sap-price-list__table_k3z_qln_qxb}
6. Select Upload.
7. On successful upload, select Preview Imported Data.  
   The Imp Tmpl Imp Samp Sap Custom Price Lists page opens.
8. Verify that the correct number of entries were uploaded for your custom SAP price list and then select Complete Import.  
   The data for your custom SAP price list is imported into your ServiceNow instance. The price list is then added to the Price Lists \[samp_price_list\] table.
9. **Optional:** Associate your custom SAP price list with additional SAP named user types.  
   By default, the Software Asset Management application automatically associates your custom SAP price list with the SAP named user types that you specified in the imported Microsoft Excel spreadsheet. However, you can associate your price list with additional SAP named user types by adding custom named user types to it.
   1. On the page header of your ServiceNow instance, select All.
   2. In the menu navigation filter, enter <kbd class="ph userinput">samp_price_list_list.do</kbd>.  
      The Price Lists \[samp_price_list\] table opens.
   3. Select your custom SAP price list.  
      The Price List record opens.
   4. In the Named User Types related list, select New.
   5. On the form, fill in the fields.  
      {#import-custom-sap-price-list__table_uz2_3vj_4fb__entry__2}

      | Field | Description |
      |-|-|
      | Name | Name of the named user type. |
      | Price List | Price list that you want to associate the named user type with. This field populates automatically. |
      | Is developer | Option that indicates if users with this named user type have a developer role. |
      | Grants access to | Applications that the named user type has access to. |
      | Value | Alphanumerical value that identifies the named user type. |
      | Rank | Priority of the named user type during reconciliation. Lower rank values correlate with a higher priority during reconciliation. |
      | Is licensable | Option that indicates if the named user type can be licensed. |
      | Active | Option that indicates if the named user type is active. |
      [Table 2. Custom Named User Type form]

      {#import-custom-sap-price-list__table_uz2_3vj_4fb}
   6. Select Submit.
   7. Repeat steps d to f for each custom named user type that you want to add.
   {#import-custom-sap-price-list__substeps_k5b_55n_qxb}
**Related concepts**   

* [SAP USMM-based optimization](https://www.servicenow.com/docs/qRTcHy_OIgydghucJQvSZQ "Optimize licensing through SAP User License Measurement (USMM) rules that map roles to the Named User Type for an SAP client.")
* [User transaction activity for named user types](https://www.servicenow.com/docs/1VpMoElF3QC6CTR7fep44g "Determine license optimizations for your SAP named user types based on your SAP user transaction activity.")
* [Self-declaring SAP engine license usage](https://www.servicenow.com/docs/tFogFHwqumbeJJCDYZYICg "You can self-declare the license usage for any SAP engines that cannot be measured by the automated SAP engine measurement process. Use this information to gain more comprehensive visibility into your SAP license compliance position so that you can optimize your licensing costs.")  
**Related tasks**   

* [Deploy the ABAP program for SAP](https://www.servicenow.com/docs/fQHBuDJFxorawxAIs90YpA "To begin establishing a connection between your SAP system and your ServiceNow instance, deploy the Advanced Business Application Programming (ABAP) program. Deploying the ABAP program allows data to be shared between SAP and your ServiceNow instance.")
* [Establish an SAP connection](https://www.servicenow.com/docs/EOMMFRzWdXfObebvsk1DEg "After you have deployed the Advanced Business Application Programming (ABAP) program in your SAP system, create a connection profile to establish a connection between your SAP system and your ServiceNow instance.")
* [Create entitlements for SAP](https://www.servicenow.com/docs/kRebl1Oq76huKPR8xKOkcQ "Create software entitlements to record your license information for SAP products. You can create entitlements individually or import them from a spreadsheet.")
* [Create software models for SAP](https://www.servicenow.com/docs/nFh9OIzbo9fn3B1sFt5zsw "Create software models to record SAP product information.")
* [Create a custom SAP named user type](https://www.servicenow.com/docs/LVDqrUpgTr6fXIaJ8q1y3A "Create a custom SAP named user type so that you can track and manage your SAP licenses based on the named user type that is specific to your SAP system.")
* [Map a role to a named user type](https://www.servicenow.com/docs/p6adZg2utKcvAR02c0NiOw "You can optimize your SAP licenses by mapping roles to a named user type. During reconciliation, discovered user roles and their assigned named user types are compared against these roles to identify user that can be given a lower named user type.")
* [Create custom SAP price lists](https://www.servicenow.com/docs/THYuG2DwdO0tDH7XR_zJsg "Create custom SAP price lists so that you can track and manage SAP licenses based on the contracts that are specific to your SAP system.")
* [Import custom SAP named user types](https://www.servicenow.com/docs/wkQOCpDvPacdaHPV91EqGg "Import custom SAP named user types into your ServiceNow instance so that you can track and manage SAP licenses based on the named user types that are specific to your SAP system.")  
**Related reference**   

* [Tables installed with the SAP publisher pack](https://www.servicenow.com/docs/yoyA2GTdYkhDVPPKFzGknA "Tables are installed with the Software Asset Management Professional for SAP plugin. The tables store data pulled from the SAP systems.")
* [Software Publisher Analytics dashboard for SAP in Software Asset Management classic](https://www.servicenow.com/docs/~4Gdncvf5oBZJt9g7a9Y7w "View your license compliance position for SAP on the Software Publisher Analytics dashboard in the Software Asset Management classic application.")
* [Publisher overview for SAP in the Software Asset Workspace](https://www.servicenow.com/docs/CM6vbAykqCo1SNLWB4Tyjg "View license usage information related to SAP in the publisher overview for SAP in the Software Asset Workspace.")