--- sourceDocument: Yokohama Finance and Supply Chain sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/yokohama/source-to-pay-operations Release : - yokohama ft:locale : - en-US ft:publication_title : - Yokohama Finance and Supply Chain ft:clusterId : - stpop bundleId : - stpop workflow : - Employee --- # Look up primary data # Look up primary data in SAP {#ariaid-title1} * Release version: Yokohama * * Updated July 31, 2025 * * ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read You can run a job to look up primary data (for example, Currencies) from different ERP sources into ServiceNow. Before you start the ERP integration, you must configure the integration services record for the target ERP source using the `sn_fcms_intg_service` table. The `sn_fcms_intg_service` table is a mapping table between sub flows and target ERP source. For more information on creating an integration service record, see [Create Integration Service record](https://servicenow-prod.fluidtopics.net/gcMl94qzHYy5r1Yp8QPjXQ "Create Integration Service records for entities using the sn_fcms_intg_service table."). Figure 1. Look up currencies in SAP You can manually run jobs for the following entities:{#look-up-primary-data-sap__table_dtd_mwx_y2c__entry__2} | Entity | Table name | |-|-| | Currencies | [FX Currency Stage inbound staging table](https://servicenow-prod.fluidtopics.net/zPxpalWIo1UiMuerILCBaA "The FX Currency Stage inbound [sn_fcms_intg_fx_currency_stage] staging table temporarily stores important data about FX currencies before this data is sent to the primary table.") | | Legal entities | [Legal Entity Stage inbound staging table](https://servicenow-prod.fluidtopics.net/YhUPIstj0WPfg11nTjNCsA "The Legal entity stage inbound [sn_fcms_intg_legal_entity_stage] staging table temporarily stores important data about legal entities before this data is sent to the primary table.") | | FX Currency rates | [FX Rate Stage inbound staging table](https://servicenow-prod.fluidtopics.net/j6~T~lUp81K0Z3hVjwSb3A "The FX Rate Stage inbound [sn_fcms_intg_fx_rate_stage] staging table temporarily stores important data about FX rates before this data is sent to the primary table.") | | Cost Centers | [Cost Center Stage inbound staging table](https://servicenow-prod.fluidtopics.net/_W~jZX99UIajd0C1gfW2fA "The Cost Center Stage inbound [sn_fcms_intg_imp_cost_center] staging table temporarily stores important data about cost centers before this data is sent to the primary table. You can use this table to lookup all the cost center details.") | | Departments | [Department Stage inbound staging table](https://servicenow-prod.fluidtopics.net/VmNQ6G1dRncgyiLZFMGg0g "The Department Stage inbound [sn_fcms_intg_department_stage] staging table temporarily stores important data about departments before this data is sent to the primary table.") | | Payment Terms | [Payment Terms Stage inbound staging table](https://servicenow-prod.fluidtopics.net/L4Cer3sid4HG5rL8NGxaGA "The Payment Terms Stage inbound [sn_fcms_intg_payment_term_stage] staging table temporarily stores important data about payment terms before this data is sent to the primary table.") | | Purchasing Organizations | [Purchase Entity Stage inbound staging table](https://servicenow-prod.fluidtopics.net/TmPZ7nJLHcMQWWCsf9nQ2Q "The Purchase Entity Stage inbound [sn_fcms_intg_imp_purchase_entity] staging table temporarily stores important data about purchase entities before this data is sent to the primary table.") | | GL Accounts | [GL Account Stage inbound staging table](https://servicenow-prod.fluidtopics.net/eFPhaRummAMFFYEmwtUnwQ "The GL Account Stage inbound [sn_fcms_intg_gl_account_stage] staging table temporarily stores important data about General Ledger (GL) accounts before this data is sent to the primary table.") | | Plant Addresses | [CMN Location Stage inbound staging table](https://servicenow-prod.fluidtopics.net/r2pzhCfLKxS1EZQaYlMObg "The CMN Location Stage inbound [sn_fcms_intg_cmn_location_stage] staging table temporarily stores important data about locations before this data is sent to the primary table.") | | Suppliers | [Supplier location inbound staging table](https://servicenow-prod.fluidtopics.net/a49DydWrkEhGj1NAnVBNOQ "The Supplier location inbound [sn_fcms_intg_supplier_location_inbound] staging table temporarily stores important data about the geographical location of a supplier before this data is sent to the Supplier Location [sn_slm_m2m_location] and Location [cmn_location] primary tables.") | | Product Models | [Product Model Stage inbound staging table](https://servicenow-prod.fluidtopics.net/pUXpMnRL6~XzM0N3seGe7g "The Product Model Stage inbound [sn_fcms_intg_cmdb_model_stage] staging table temporarily stores important data about product models before this data is sent to the primary table.") | | Invoices | [Invoice import inbound staging table](https://servicenow-prod.fluidtopics.net/S1tW7ZiPIWrwBnDB4xQI4A "The invoice import inbound [sn_spend_intg_imp_invoice] staging table temporarily stores important data about the imported invoice before this data is sent to the [sn_shop_invoice] primary table.") | | Unit of Measure | [Unit of Measure inbound staging table](https://servicenow-prod.fluidtopics.net/TcnjWHdSl2z8iFHfZB4x7w "The Third Party Unit [sn_fcms_intg_imp_uom] staging table temporarily stores important data on third party units before this data is sent to the primary table.") | | Product Categories | [Product Model Stage inbound staging table](https://servicenow-prod.fluidtopics.net/pUXpMnRL6~XzM0N3seGe7g "The Product Model Stage inbound [sn_fcms_intg_cmdb_model_stage] staging table temporarily stores important data about product models before this data is sent to the primary table.") | [Table 1. Integration services available as a part of the base system for SAP] {#look-up-primary-data-sap__table_dtd_mwx_y2c} ## Transformation maps and subflows {#look-up-primary-data-sap__section_ptd_b2b_1fc} To learn more about the Transformation maps and subflows, see [Source-to-Pay integration framework transform maps and subflows](https://servicenow-prod.fluidtopics.net/0Qg6pQO6FqaUw0q9tDH4Rg "The transform maps transform the source-to-pay data from the inbound staging tables to the Source-to-Pay primary data tables. The subflows move the source-to-pay data from the outbound staging tables to a third-party ERP system."). **Related concepts** * [ERP Source Configuration for SAP](https://servicenow-prod.fluidtopics.net/geV3xd~9o98BwxoTwlUmOg "Configure your Source-to-Pay (S2P) instance to support inbound and outbound integration with your ERP system. This integration configuration enables you to automatically post purchase order, receipt, invoice, and download primary data from the ERP.") * [Scheduled jobs to look up primary data in SAP](https://servicenow-prod.fluidtopics.net/Vs_qiljARQqJTiQijoyCsg "You can schedule on-demand jobs to be run at specific intervals of time to fetch primary data from different SAP ERP sources into ServiceNow.") **Related tasks** * [Define ERP source configuration for SAP](https://servicenow-prod.fluidtopics.net/rvjc3KAbx5GXPkiulfK26A "ERP source configuration determines the ERP source to which your ERP system connects. Map the integration payload with the SAP tables.") * [Configure integration services for SAP](https://servicenow-prod.fluidtopics.net/RJ~oHHZgb0dvFyridLSCcQ "For configuring integration services, provide the connection end point and the SAP ERP credentials that you set up for your authentication profile. Also, create a separate integration service record for each service request that you want to customize.") * [Manually execute flows or subflows in SAP (Inbound)](https://servicenow-prod.fluidtopics.net/3Ws9RBtQqdXT0AmJw9THoA "You can manually trigger flows or subflows in SAP on demand. Follow these steps to manually trigger a flow or subflow.")