--- sourceDocument: Yokohama IT Asset Management sourceDocumentLink: https://www.servicenow.com/docs/r/yokohama/it-asset-management Release : - yokohama ft:locale : - en-US ft:publication_title : - Yokohama IT Asset Management ft:clusterId : - itam bundleId : - itam workflow : - Technology --- # Tables installed with the SAP publisher pack # Tables installed with the SAP publisher pack {#ariaid-title1} * Release version: Yokohama * * Updated January 30, 2025 * * ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 3 minutes to read Summarize ![AI sparkle icon](https://servicenow.com/docs/portal-asset/ai-sparkle-icon) 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 (Release version: Yokohama), installs multiple tables that store data imported from SAP systems. These tables enable ServiceNow customers to manage SAP license compliance and optimize SAP usage by capturing detailed information on users, roles, connections, license metrics, and activities. Show full answer Show less For a comprehensive list of all components installed with the SAP publisher pack, customers should refer to the Application Files table within the system. ## Key Tables and Their Purpose * **Named User Type Role \[sampnamedusertypehasrole\]**: Maps roles assigned to each named user type. * **SAP Client \[sampsapclient\]**: Stores RFC destinations that connect ABAP systems to external systems; accessible via SAP Compliance and Optimization administration. * **SAP Connection \[sampsapconnection\]**: Contains details of SAP system connections. * **SAP Engine Usage \[sampsapswclientaccess\]**: Records the latest engine usage metrics for SAP clients based on license metrics. * **SAP License Metric \[sampsaplicensemetric\]**: Maintained by the ServiceNow Content Service, this table lists all SAP license metrics used by engines. It updates periodically to reflect changes in SAP licensing. * **SAP License Metric Measurement \[sampsaplicensemetricmeasurement\]**: Stores monthly engine usage measurements per SAP client. * **SAP Roles \[sampsaprole\]**: Contains SAP roles pulled directly from SAP systems. * **SAP System User \[sampsapsystemuser\]**: Holds discovered SAP users; mapped to system user records for identity correlation. * **SAP User Activity \[sampsapuseractivity\]**: Captures user activity metrics such as time spent and database records created or updated. * **SAP User Roles \[sampsapuserhasrole\]**: Links SAP users to their assigned roles. * **SAP Web Activity \[sampsapwebactivity\]**: Tracks web or RFC connection activities, including call counts and data volumes. * **SAP User Active Transactions \[sampnamedusertypehastransactions\]**: Records named user transaction activities based on SAP transaction codes (e.g., ME21N for purchase order creation). * **SAP USMM Rules \[sampsapusmmrule\]**: Contains USMM rules data from connected SAP applications. Additional tables outside the core SAP publisher pack include: * **Price List \[samppricelist\]**: Stores SAP price list data. * **Named User Type \[sampnamedusertype\]**: Stores named user types pulled from SAP. * **SAP Digital Access \[sampsapdigitalaccess\]**: Captures digital access details such as client, user name, document types, and measurement data. ## Practical Use for ServiceNow Customers These tables collectively enable customers to: * Track and analyze SAP user roles, activities, and license consumption accurately. * Maintain up-to-date SAP license metric data aligned with SAP's licensing changes. * Manage SAP system connections and client configurations efficiently. * Optimize SAP license usage through detailed transaction and user activity data. * Integrate SAP data with ServiceNow's Software Asset Management tools for licensing compliance and cost control. ## Related Actions and Resources * Deploy the ABAP program for SAP integration. * Establish SAP system connections within ServiceNow. * Create and map entitlements, software models, named user types, and price lists specific to SAP. * Import custom SAP named user types and price lists as needed. * Leverage Software Publisher Analytics dashboards and SAP publisher overview resources for enhanced reporting and insights. 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](https://www.servicenow.com/docs/access?context=find-components&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US). Demo data is available for the SAP publisher pack. ## Tables {#component-installed-sap-plugin__section_s1x_dzh_wdb} {#component-installed-sap-plugin__table_cvs_4lx_4fb__entry__2} | 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 OptimizationAdministrationSAP Clients. | | SAP Connection \[samp_sap_connection\] | SAP system connections. To view the table, navigate to SAP Compliance and OptimizationAdministrationSAP 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 OptimizationAdministrationEngines. 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 OptimizationAdministrationSoftware 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 OptimizationLicensingAll 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 OptimizationLicensingAll 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. | [ ] {#component-installed-sap-plugin__table_cvs_4lx_4fb} 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. * Price list data is pulled and stored in the Price List table \[samp_price_list\].To view the table, navigate to SAP Compliance and OptimizationAdministrationPrice Lists. * Named user types are pulled and stored in the Named User Type table \[samp_named_user_type\].To view the table, navigate to SAP Compliance and OptimizationAdministrationNamed User Types. * The Digital Access details such as Client, User name, Document type, Document type count, and Measured by are pulled from the SAP systems and stored in the SAP Digital Access \[samp_sap_digital_access\] table. To view the data in the table, navigate to AllSoftware Asset WorkspaceLicense operationsDiscoverySAP Digital Access Data. {#component-installed-sap-plugin__ul_cgl_fhh_ylb} **Related concepts** * [SAP USMM-based optimization](https://www.servicenow.com/docs/uwPUVpBsV7cRJtcPyhoMZA "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/ttCgrMF_tuRjneFFWz6I1w "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/4rDmPrURJdVEN5Vuz5E5kg "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/8hkSXLAgcAZzQOL8zuZtbA "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/QyJF_KihUEf2UVfr6fHpiw "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/jB9yEmPA_LVJ9EqAvB5b_A "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/tXEduM~rpiHuDdl3a3Gdvw "Create software models to record SAP product information.") * [Create a custom SAP named user type](https://www.servicenow.com/docs/_vPe_8Int7ebTsMUH3BTvg "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/s02iX7RIst~KJrcIQ9ngFw "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/~WtHYnqg1IJmUHme9Vx3vg "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/M7kEks7MHxrRICL3INjbUQ "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.") * [Import custom SAP price lists](https://www.servicenow.com/docs/QN6LV1LZ5K3bG20I7_jVIQ "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.") **Related reference** * [Software Publisher Analytics dashboard for SAP in Software Asset Management classic](https://www.servicenow.com/docs/tuE4tmbDytMQ2s8DEZDV9A "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/Sfts7rFJTziElasKmE4GAg "View license usage information related to SAP in the publisher overview for SAP in the Software Asset Workspace.") *[\>]: and then