Source-to-Pay integration framework transform maps and subflows

  • Release version: Xanadu
  • Updated August 1, 2024
  • 4 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 Source-to-Pay integration framework transform maps and subflows

    The Source-to-Pay integration framework in ServiceNow facilitates seamless data movement between inbound staging tables, primary Source-to-Pay data tables, and outbound staging tables for integration with third-party ERP systems. This framework usestransform mapsto convert and load data from inbound staging tables into primary tables andsubflowsto transfer data from primary tables to outbound staging tables for ERP communication.

    Show full answer Show less

    Transform Maps

    Transform maps are key to converting and loading data into the Source-to-Pay primary tables. They handle a wide range of data types including:

    • Product and service models, categories, and related configurations
    • Locations such as CMN location, office location, and ERP plant address
    • Financial master data including cost centers, GL accounts, purchasing entities, payment terms, and FX currency/rate
    • Supplier details covering supplier master data, contacts, payment information, legal entities, and addresses
    • Transactional data like purchase orders, order lines, receipts, invoices, invoice lines, payments, shipments, and fixed asset details
    • Tax and legal entity information

    Each transform map reads data from a specific inbound staging table and loads it into the corresponding primary ServiceNow table, ensuring that your Source-to-Pay system maintains accurate, up-to-date information from your data sources.

    Subflows

    Subflows are designed to move processed Source-to-Pay data from primary tables to outbound staging tables, preparing it for transmission to external ERP systems. These subflows cover:

    • Cost allocation data
    • Purchase orders and purchase order lines
    • Receipts
    • Supplier-related data including contacts, legal entity details, locations, master data, payments
    • Organizational tax details

    By automating the movement of data to outbound staging tables, subflows enable efficient and reliable integration with third-party ERP systems, supporting end-to-end Source-to-Pay processes.

    Practical Implications for ServiceNow Customers

    • Data accuracy and consistency: Using the predefined transform maps ensures your Source-to-Pay primary tables are populated correctly from inbound data sources.
    • Integration readiness: Subflows streamline the preparation of outbound data for ERP systems, reducing manual effort and integration errors.
    • Comprehensive coverage: The framework supports a wide variety of Source-to-Pay data domains, enabling full lifecycle management from procurement to payment.
    • Customization and extensibility: Customers can leverage these maps and subflows as templates to tailor data transformations and integrations according to their specific ERP and business needs.

    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.

    Transform maps

    The following transform maps transform the source-to-pay data from the inbound staging tables to the Source-to-Pay primary data tables.
    • Load product model:

      Transforms product model data from the sn_fcms_intg_cmdb_model_stage staging table to the cmdb_model primary table.

    • Load service model:

      Transforms service model data from the sn_fcms_intg_cmdb_service_model_stage staging table to the cmdb_service_product_model primary table.

    • Transform CMN location:

      Transforms CMN location data from the sn_fcms_intg_cmn_location_stage staging table to the cmn_location primary table.

    • Master data cost center:

      Transforms cost center data from the sn_fcms_intg_imp_cost_center staging table to the cmn_cost_center primary table.

    • Load department:

      Transforms department data from the sn_fcms_intg_department_stage staging table to the cmn_department primary table.

    • Transform ERP Plant Address:

      Transforms ERP plant address data from the sn_fcms_intg_erp_plant_address_mapping_stage staging table to the sn_fcms_intg_erp_plant_address_mapping primary table.

    • Load FX currency:

      Transforms FX currency data from the sn_fcms_intg_fx_currency_stage staging table to the sn_fin_fx_currency primary table.

    • Load FX rate:

      Transforms FX rate data from the sn_fcms_intg_fx_rate_stage staging table to the sn_fin_fx_rate primary table.

    • GL account load data:

      Transforms GL account data from the sn_fcms_intg_gl_account_stage staging table to the sn_fin_gl_account primary table.

    • Import availability updates:

      Transforms Import availability updates from the sn_spend_intg_imp_availability staging table to the sn_shop_supplier_product primary table.

    • Cost allocation stage:

      Transforms cost allocation data from the sn_spend_intg_imp_cost_allocation staging table to the sn_shop_cost_allocation primary table.

    • Order stage:

      Transforms purchase order data from the sn_fcms_intg_imp_order staging table to the sn_shop_purchase_order primary table.

    • Order line stage:

      Transforms purchase order line data from the sn_fcms_intg_imp_order_line staging table to the sn_shop_purchase_order_line primary table.

    • Receipt stage:

      Transforms receipts data from the sn_fcms_intg_imp_receipt staging table to the sn_shop_receipt primary table.

    • Transform legal entities:

      Transforms legal entity data from the sn_fcms_intg_legal_entity_stage staging table to the sn_fin_legal_entity primary table.

    • Transform office location:

      Transforms office location data from the sn_fcms_intg_office_location_stage staging table to the sn_shop_office_location primary table.

    • Load payment terms:

      Transforms payment terms data from the sn_fcms_intg_payment_term_stage staging table to the sn_shop_payment_term primary table.

    • Load product category:

      Transforms product category data from the sn_fcms_intg_cmdb_model_category_stage staging table to the cmdb_model_category primary table.

    • Master data purchase entity:

      Transforms purchase entity data from the sn_fcms_intg_imp_purchase_entity staging table to the sn_fin_purchasing_entity primary table.

    • Load supplier product:

      Transforms supplier product data from the sn_spend_intg_supplier_product_stage staging table to the sn_shop_supplier_product primary table.

    • Transform supplier contact details:

      Transforms supplier contact details data from the sn_fcms_intg_supplier_contact_inbound staging table to the vm_vdr_contact primary table.

    • Master data supplier:

      Transforms supplier data from the sn_fcms_intg_imp_supplier staging table to the sn_fin_supplier primary table.

    • Load legal entity mapping data:

      Transforms supplier legal entity data from the sn_fcms_intg_supplier_legal_entity_inbound staging table to the sn_fin_supplier_detail primary table.

    • Load supplier address information:

      Transforms supplier location data from the sn_fcms_intg_supplier_location_inbound staging table to the sn_slm_m2m_location primary table.

    • Transform supplier payment:

      Transforms supplier payment data from the sn_fcms_intg_supplier_payment_inbound_stage staging table to the sn_fin_supplier_payment primary table.

    • Invoice import:

      Transforms invoice details from the sn_spend_intg_imp_invoice staging table to the sn_shop_invoice primary table.

    • Invoice line import:

      Transforms invoice line details from the sn_spend_intg_imp_invoice_line staging table to the sn_shop_invoice_line primary table.

    • Invoice payment detail import:

      Transforms invoice payment details from the sn_spend_intg_imp_invoice_payment_detail staging table to the sn_shop_invoice_payment_detail primary table.

    • Transform organization tax details:

      Transforms organization tax details data from the sn_fcms_intg_org_tax_detail_inbound staging table to the sn_fin_org_tax_detail primary table.

    • Spend Shipment Import:

      Transforms spend shipment import details from the sn_spend_intg_imp_shipment staging table to the sn_shop_shipment_details primary table.

    • Fixed asset details:

      Transforms fixed asset details from the sn_fcms_intg_imp_fixed_asset_details staging table to the sys_import_set_row primary table.

    Subflows

    The following subflows move the source-to-pay data from the outbound staging tables to a third-party ERP system.
    • Create cost allocation on outbound table:

      Moves cost allocation data from the sn_shop_cost_allocation primary table to the sn_spend_intg_outbound_cost_allocation staging table.

    • Create purchase order on outbound order table:

      Moves purchase order data from the sn_shop_purchase_order primary table to the sn_spend_intg_outbound_purchase_order staging table.

    • Create purchase order line on outbound order line table:

      Moves purchase order line data from the sn_shop_purchase_order_line primary table to the sn_spend_intg_outbound_purchase_order_line staging table.

    • Create/update receipt on outbound table:

      Moves receipt data from the sn_shop_receipt primary table to the sn_spend_intg_outbound_receipt staging table.

    • Update Supplier Contact Outbound from trigger Supplier Contact:

      Moves supplier contact details data from the vm_vdr_contact primary table to the sn_spend_intg_supplier_contact_outbound staging table.

    • Update Supplier Legal entity details from Legal entity mapping:

      Moves supplier legal entity data from the sn_fin_supplier_detail primary table to the sn_fcms_intg_supplier_legal_entity_outbound staging table.

    • Update Supplier Location outbound from M2M location:

      Moves supplier location data from the sn_slm_m2m_location primary table to the sn_spend_intg_supplier_location_outbound staging table.

    • Update Supplier Outbound from trigger Supplier:

      Moves supplier data from the sn_fin_supplier primary table to the sn_spend_intg_outbound_supplier​ staging table.

    • Update Supplier Payment Outbound from trigger Payment:

      Moves supplier payment data from the sn_fin_supplier_payment primary table to the sn_spend_intg_supplier_payment_outbound_stage staging table.

    • Update tax details outbound from trigger tax details:

      Moves organization tax details data from the sn_fin_org_tax_detail primary table to the sn_spend_intg_outbound_tax_detail staging table.