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: sam_admin

Procedure

  1. Go to 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.
  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 imp_samp_sap_custom_price_list_list.do.
      The SAP Custom Price List Data [imp_samp_sap_custom_price_list] table opens.
  4. Right-click the table header and then select Import.
  5. On the form, fill in the fields.
    Table 1. Import external data into SAP Custom Price List Data form
    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.
    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.
  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 samp_price_list_list.do.
      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.
      Table 2. Custom Named User Type form
      FieldDescription
      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.
    6. Select Submit.
    7. Repeat steps d to f for each custom named user type that you want to add.