ERP source
An ERP Source [sn_fin_erp_source] table is available in Source-to-Pay (S2P) as part of the Finance Common Architecture application.
You can use the ERP Source field available in tables to directly identify the correct ERP source if you have integrations with multiple ERP systems.
주:
- In some scenarios, for purchase orders, receipts, and invoice integration, the ERP source for records is still determined through the legal entity on those records. This is achieved by adding an ERP Source reference field on the Legal Entity [sn_fin_legal_entity] table. Also, Legal Entity is added as a related list for the ERP Source table.
- The ERP source column in the global table should be deprecated and migrated to local tables. Run the data migration script manually to move data from the impacted tables to the new mapping table. For more information, see Migrate ERP source data from global tables to the mapping table [KB1733450].
The Multi-ERP data will continue to function without migrating the ERP source column (for up to the next two family releases from Yokohama), but ensure migration to local tables is completed.
Tables containing the ERP Source column
The following tables contain the ERP Source column.
| Application | Table |
|---|---|
| Global | CMDB Categories [cmdb_categories] |
| Product Model [cmdb_model] | |
| Service Model [cmdb_service_product_model] | |
| Cost Center [cmn_cost_center] | |
| Department [cmn_department] | |
| Location [cmn_location] | |
| Source-to-Pay Common Architecture | Negotiation [sn_shop_negotiation] |
| Negotiation Event [sn_shop_negotiation_event] | |
| Office Location [sn_shop_office_location] | |
| Purchase Requisition [sn_shop_purchase_requisition] | |
| Sourcing Request [sn_shop_sourcing_activity] | |
| Supplier Product [sn_shop_supplier_product] | |
| Finance Common Architecture | Fixed Asset [sn_fin_fixed_asset] |
| Office Location [sn_fin_office_location] |