{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":25899,"path":"it-asset-management/software-asset-management/component-installed-sap-plugin.md","title":"Tables installed with the SAP publisher pack","bundle":null,"doc_type":null,"release":"australia","body":"\n# Tables installed with the SAP publisher pack\n\nTables are installed with the Software Asset Management Professional for SAP plugin. The tables store data pulled from the SAP systems.\n\n**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://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/platform-administration/find-components.md).\n\nDemo data is available for the SAP publisher pack.\n\n## Tables\n\n<table id=\"table_cvs_4lx_4fb\"><thead><tr><th>\n\nTable\n\n</th><th>\n\nDescription\n\n</th></tr></thead><tbody><tr><td>\n\nNamed User Type Role \\[samp\\_named\\_user\\_type\\_has\\_role\\]\n\n</td><td>\n\nRoles assigned to each named user type.\n\n</td></tr><tr><td>\n\nSAP Client \\[samp\\_sap\\_client\\]\n\n</td><td>\n\nRemote Function Call \\(RFC\\) destination connecting Advanced Business Application Programming \\(ABAP\\) systems to external systems.To view the table, navigate to **SAP Compliance and Optimization** &gt; **Administration** &gt; **SAP Clients**.\n\n</td></tr><tr><td>\n\nSAP Connection \\[samp\\_sap\\_connection\\]\n\n</td><td>\n\nSAP system connections.To view the table, navigate to **SAP Compliance and Optimization** &gt; **Administration** &gt; **SAP Connections**.\n\n</td></tr><tr><td>\n\nSAP Engine Usage \\[samp\\_sap\\_sw\\_client\\_access\\]\n\n</td><td>\n\nMost recent engine usage measurements for SAP clients based on the license metric for each engine.\n\n</td></tr><tr><td>\n\nSAP License Metric \\[samp\\_sap\\_license\\_metric\\]\n\n</td><td>\n\nThis 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** &gt; **Administration** &gt; **Engines**.\n\n **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** &gt; **Administration** &gt; **Software Models with Deactivated SAP License Metrics**.\n\n</td></tr><tr><td>\n\nSAP License Metric Measurement \\[samp\\_sap\\_license\\_metric\\_measurement\\]\n\n</td><td>\n\nMonthly engine usage measurements for SAP clients based on the license metric for each engine.To view the table, navigate to **SAP Compliance and Optimization** &gt; **Licensing** &gt; **All SAP Engines**.\n\n</td></tr><tr><td>\n\nSAP Roles \\[samp\\_sap\\_role\\]\n\n</td><td>\n\nSAP roles pulled from the SAP systems.\n\n</td></tr><tr><td>\n\nSAP System User \\[samp\\_sap\\_system\\_user\\]\n\n</td><td>\n\nDiscovered users pulled from the SAP systems.To view the table, navigate to **SAP Compliance and Optimization** &gt; **Licensing** &gt; **All SAP Users**.\n\n **Note:** The Discovered Users table \\[samp\\_discovered\\_user\\] maps the discovered SAP users to system user records in the Users table \\[sys\\_user\\].\n\n</td></tr><tr><td>\n\nSAP User Activity \\[samp\\_sap\\_user\\_activity\\]\n\n</td><td>\n\nData 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.\n\n</td></tr><tr><td>\n\nSAP User Roles \\[samp\\_sap\\_user\\_has\\_role\\]\n\n</td><td>\n\nSAP users and their assigned roles.\n\n</td></tr><tr><td>\n\nSAP Web Activity \\[samp\\_sap\\_web\\_activity\\]\n\n</td><td>\n\nData 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.\n\n</td></tr><tr><td>\n\nSAP User Active Transactions \\[samp\\_named\\_user\\_type\\_has\\_transactions\\]\n\n</td><td>\n\nData 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.\n\n</td></tr><tr><td>\n\nSAP USMM Rules \\[samp\\_sap\\_usmm\\_rule\\]\n\n</td><td>\n\nUSMM rules information from all connected SAP applications.\n\n</td></tr></tbody>\n</table>**Note:** Staging tables for SAP data are also installed.\n\nData from SAP is also stored in some additional tables that aren't part of the SAP publisher pack.\n\n<table id=\"table_gkk_vfl_njc\"><thead><tr><th>\n\nTable\n\n</th><th>\n\nNavigation\n\n</th></tr></thead><tbody><tr><td>\n\nPrice List\\[samp\\_price\\_list\\]\n\n</td><td>\n\n**SAP Compliance and Optimization** &gt; **Administration** &gt; **Price Lists**\n\n</td></tr><tr><td>\n\nNamed User Type\\[samp\\_named\\_user\\_type\\]\n\n</td><td>\n\n**SAP Compliance and Optimization** &gt; **Administration** &gt; **Named User Types**\n\n</td></tr><tr><td>\n\nSAP Digital Access\\[samp\\_sap\\_digital\\_access\\]\n\n</td><td>\n\n**Workspaces** &gt; **Software Asset Workspace** &gt; **License operations** &gt; **Discovery** &gt; **SAP Digital Access Data**\n\n</td></tr></tbody>\n</table>The Digital Access table stores the following fields: Client, User name, Document type, Document type count, and Measured by.\n\n## Mapping between SAP tables and Software Asset Management tables\n\n|SAP table|Software Asset Management table|\n|---------|-------------------------------|\n|/NOW/SAMP\\_RFC|SAP Client \\[samp\\_sap\\_client\\]|\n|/NOW/M\\_SAP\\_ROLES|SAP Roles \\[samp\\_sap\\_role\\]|\n|/NOW/SAP\\_TCODES|SAP Transactions \\[samp\\_sap\\_transactions\\]|\n|/NOW/M\\_USER\\_DATA|SAP System User \\[samp\\_sap\\_system\\_user\\]|\n|/NOW/M\\_USR\\_TCODE|SAP User Active Transactions \\[samp\\_named\\_user\\_type\\_has\\_transactions\\]|\n|/NOW/M\\_USER\\_ROLE|SAP User Roles \\[samp\\_sap\\_user\\_has\\_role\\]|\n|/NOW/M\\_USR\\_ACTIT|SAP User Activity \\[samp\\_sap\\_user\\_activity\\]|\n|/NOW/WEB\\_ACTIVTY|SAP Web Activity \\[samp\\_sap\\_web\\_activity\\]|\n|/NOW/M\\_ENGINES|SAP License Metric Measurement \\[samp\\_sap\\_license\\_metric\\_measurement\\]|\n|/NOW/USMM\\_DATA|SAP USMM Rules \\[samp\\_sap\\_usmm\\_rule\\]|\n|/NOW/DIGITAL\\_ACC|SAP Digital Access \\[samp\\_sap\\_digital\\_access\\]|\n\n**Parent Topic:**[Software Asset Management publisher pack for SAP](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/it-asset-management/software-asset-management/sap-publisher-pack.md)\n\n**Related topics**  \n\n\n[Set up SAP integration to establish a connection with SAP]()\n\n[Establish an SAP connection using basic authentication]()\n\n[Establish an SAP connection using OAuth 2.0]()\n\n[Create entitlements for SAP]()\n\n[Create software models for SAP]()\n\n[Create a custom SAP named user type]()\n\n[Map a role to a named user type]()\n\n[Create custom SAP price lists]()\n\n[Import custom SAP named user types]()\n\n[Import custom SAP price lists]()\n\n[SAP USMM-based optimization]()\n\n[User transaction activity for named user types]()\n\n[Self-declaring SAP engine license usage]()\n\n[Software Publisher Analytics dashboard for SAP in Software Asset Management classic]()\n\n[Publisher overview for SAP in the Software Asset Workspace]()\n\n"}}