Tables installed with the SAP publisher pack

  • Release version: Australia
  • Updated March 12, 2026
  • 3 minutes to read
    • Summarize
    Summarized using AI
    This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.

    Summary of Tables installed with the SAP publisher pack

    The SAP publisher pack, part of the Software Asset Management Professional for SAP plugin, installs a set of tables in ServiceNow. These tables store data imported from SAP systems and enable you to manage SAP license compliance and optimization effectively. Demo data is available for testing and exploration. You can view all installed components of the SAP publisher pack via the Application Files table.

    Show full answer Show less

    Key Tables and Their Purpose

    • Named User Type Role [sampnamedusertypehasrole]: Maps roles assigned to each named user type.
    • SAP Client [sampsapclient]: Stores Remote Function Call (RFC) destinations connecting ABAP systems to external systems. Accessible via SAP Compliance and Optimization > Administration > SAP Clients.
    • SAP Connection [sampsapconnection]: Details SAP system connections, viewable in SAP Compliance and Optimization > Administration > SAP Connections.
    • SAP Engine Usage [sampsapswclientaccess]: Contains recent engine usage measurements per SAP client based on license metrics.
    • SAP License Metric [sampsaplicensemetric]: Maintained by ServiceNow Content Service; lists all SAP license metrics, updated periodically to reflect latest SAP licensing changes.
    • SAP License Metric Measurement [sampsaplicensemetricmeasurement]: Holds monthly engine usage data for SAP clients, accessible through SAP Compliance and Optimization > Licensing > All SAP Engines.
    • SAP Roles [sampsaprole] and SAP User Roles [sampsapuserhasrole]: Store SAP roles and their assignments to users.
    • SAP System User [sampsapsystemuser]: Contains discovered SAP users, linked to system user records for comprehensive user management.
    • SAP User Activity [sampsapuseractivity]: Tracks user activities on SAP clients, such as time spent and database transactions.
    • SAP Web Activity [sampsapwebactivity]: Records web activity and RFC connections data on SAP clients.
    • SAP User Active Transactions [sampnamedusertypehastransactions]: Details user transaction activity by SAP transaction codes (e.g., ME21N for purchase orders).
    • SAP USMM Rules [sampsapusmmrule]: Contains USMM rules data from connected SAP applications.

    Additionally, staging tables and other tables outside the SAP publisher pack (e.g., Price List, Named User Type, SAP Digital Access) support broader SAP data management and licensing workflows.

    Mapping SAP and ServiceNow Tables

    The plugin maps SAP tables to corresponding ServiceNow tables, enabling streamlined data integration and management. For example:

    • /NOW/SAMPRFC → SAP Client [sampsapclient]
    • /NOW/MSAPROLES → SAP Roles [sampsaprole]
    • /NOW/MUSERDATA → SAP System User [sampsapsystemuser]
    • /NOW/MUSRTCODE → SAP User Active Transactions [sampnamedusertypehastransactions]
    • /NOW/MENGINES → SAP License Metric Measurement [sampsaplicensemetricmeasurement]

    Practical Use for ServiceNow Customers

    By leveraging these tables, ServiceNow customers can:

    • Establish and manage SAP system connections and users.
    • Monitor and optimize SAP license usage and compliance based on accurate engine and user activity data.
    • Create custom SAP named user types, price lists, and software models for tailored license management.
    • Map SAP roles and transaction activities to named user types for precise license allocation.

    These capabilities help maintain compliance, reduce licensing costs, and improve overall SAP asset management within ServiceNow.

    Related Tasks and Concepts

    • Set up SAP integration via basic authentication or OAuth 2.0.
    • Create entitlements, software models, custom named user types, and price lists.
    • Use dashboards and workspaces for analytics and license operations.

    Tables are installed with the Software Asset Management Professional for SAP plugin. The tables store data pulled from the SAP systems.

    Note:
    Use the Application Files table to see all components installed with the SAP publisher pack. For more information, see Find components installed with an application.

    Demo data is available for the SAP publisher pack.

    Tables

    Table Description
    Named User Type Role [samp_named_user_type_has_role] Roles assigned to each named user type.
    SAP Client [samp_sap_client] Remote Function Call (RFC) destination connecting Advanced Business Application Programming (ABAP) systems to external systems.

    To view the table, navigate to SAP Compliance and Optimization > Administration > SAP Clients.
    SAP Connection [samp_sap_connection] SAP system connections.

    To view the table, navigate to SAP Compliance and Optimization > Administration > SAP Connections.
    SAP Engine Usage [samp_sap_sw_client_access] Most recent engine usage measurements for SAP clients based on the license metric for each engine.
    SAP License Metric [samp_sap_license_metric] This table is populated by the ServiceNow Content Service. It’s a list of all license metrics that are used by SAP engines.

    To view the table, navigate to SAP Compliance and Optimization > Administration > Engines.

    Note:
    The table is periodically updated with new data from the Content Service. New license metrics may be added, and existing license metrics may be deactivated to reflect current SAP licensing. To view your software models that have deactivated license metrics, navigate to SAP Compliance and Optimization > Administration > Software Models with Deactivated SAP License Metrics.
    SAP License Metric Measurement [samp_sap_license_metric_measurement] Monthly engine usage measurements for SAP clients based on the license metric for each engine.

    To view the table, navigate to SAP Compliance and Optimization > Licensing > All SAP Engines.
    SAP Roles [samp_sap_role] SAP roles pulled from the SAP systems.
    SAP System User [samp_sap_system_user] Discovered users pulled from the SAP systems.

    To view the table, navigate to SAP Compliance and Optimization > Licensing > All SAP Users.

    Note:
    The Discovered Users table [samp_discovered_user] maps the discovered SAP users to system user records in the Users table [sys_user].
    SAP User Activity [samp_sap_user_activity] Data related to a user’s activity on an SAP client, such as the amount of time spent on an SAP system or the number of database records created or updated.
    SAP User Roles [samp_sap_user_has_role] SAP users and their assigned roles.
    SAP Web Activity [samp_sap_web_activity] Data related to web activity or RFC connections performed in the SAP client, such as the number of calls or amount of data received or sent by each connection.
    SAP User Active Transactions [samp_named_user_type_has_transactions] Data related to a named user's transaction activity on an SAP client. User transaction activity is based on SAP transaction codes, which are shortcuts for performing transactions or tasks on an SAP client. For example, the ME21N transaction code enables you to create a purchase order in SAP.
    SAP USMM Rules [samp_sap_usmm_rule] USMM rules information from all connected SAP applications.
    Note:
    Staging tables for SAP data are also installed.
    Data from SAP is also stored in some additional tables that aren't part of the SAP publisher pack.
    Table 1. Tables that aren't included in the SAP publisher pack
    Table Navigation
    Price List

    [samp_price_list]

    		 SAP Compliance and Optimization > Administration > Price Lists
    Named User Type

    [samp_named_user_type]

    		 SAP Compliance and Optimization > Administration > Named User Types
    SAP Digital Access

    [samp_sap_digital_access]

    		 Workspaces > Software Asset Workspace > License operations > Discovery > SAP Digital Access Data
    The Digital Access table stores the following fields: Client, User name, Document type, Document type count, and Measured by.

    Mapping between SAP tables and Software Asset Management tables

    SAP table Software Asset Management table
    /NOW/SAMP_RFC SAP Client [samp_sap_client]
    /NOW/M_SAP_ROLES SAP Roles [samp_sap_role]
    /NOW/SAP_TCODES SAP Transactions [samp_sap_transactions]
    /NOW/M_USER_DATA SAP System User [samp_sap_system_user]
    /NOW/M_USR_TCODE SAP User Active Transactions [samp_named_user_type_has_transactions]
    /NOW/M_USER_ROLE SAP User Roles [samp_sap_user_has_role]
    /NOW/M_USR_ACTIT SAP User Activity [samp_sap_user_activity]
    /NOW/WEB_ACTIVTY SAP Web Activity [samp_sap_web_activity]
    /NOW/M_ENGINES SAP License Metric Measurement [samp_sap_license_metric_measurement]
    /NOW/USMM_DATA SAP USMM Rules [samp_sap_usmm_rule]
    /NOW/DIGITAL_ACC SAP Digital Access [samp_sap_digital_access]