MM Connector Spare Part

We need to configure a plant that using MM Connector Spart Part by insert data into two tables mmcsp_tenant & mmcsp_plant. No default data is inserted when service starts up.

INSERT INTO [mmcsp_tenant]
       ([tenant_id]
       ,[tenant_name]
       ,[source_system])
 VALUES
       (<tenant_id, varchar(45),>
       ,<tenant_name, varchar(100),>
       ,<source_system, varchar(5),>)

INSERT INTO [mmcsp_plant]
       ([plant_code]
       ,[tenant_id]
       ,[plant_name]
       ,[language])
 VALUES
       (<plant_code, varchar(5),>
       ,<tenant_id, varchar(45),>
       ,<plant_name, varchar(100),>
       ,<language, varchar(10),>)

Example

INSERT INTO mmcsp_tenant
       ([tenant_id]
       ,[tenant_name]
       ,[source_system])
 VALUES ('ID_OF_A_TENANT', 'NAME_OF_A_TENANT', 'P87')

INSERT INTO mmcsp_plant
       ([plant_code]
       ,[tenant_id]
       ,[plant_name]
       ,[language])
 VALUES ('CODE_OF_A_PLANT', 'ID_OF_A_TENANT', 'NAME_OF_A_PLANT','EN')

To make this MM Connector Spare Part serve another plant, we need to manually add, update data into this 'mmcsp_tenant' & 'mmcsp_plant' tables.

To do the spare part reservation in SAP via S4R3 ODATA API, we need to configure data in table 'mmcsp_api_mappings'. This table contains the API endpoint and API key for communication with SAP.

Default endpoint is inserted by a liquibase script when the service starts for the first time. However it lacks information about, sap target system, sap api key. We need to manually update data in the table 'mmcsp_api_mappings'.

UPDATE [mmcsp_api_mappings]
SET [endpoint_url] = replace(endpoint_url,'[SAP_SYSTEM]','sap_target_system')
   ,[api_key] = <api_key, varchar(255),>

Example: sap_target_system = 'X87', api_key = 'API_KEY_FOR_SAP_ODATA_API'

UPDATE [mmcsp_api_mappings]
SET [endpoint_url] = replace(endpoint_url,'[SAP_SYSTEM]','X87')
  ,[api_key] = 'API_KEY_FOR_SAP_ODATA_API'

Scheduled tasks of spare part sync is configured at table 'mmcsp_scheduled_task'. We can update the cron_expression (follow Java Cron Expression) of the task at the table to change trigger time & frequency. Then restart mm spare part service to activate the change. As the spare part sync job takes several hours to complete synchronization, it’s recommended not to run the spare part sync job several times a day.

Default triggers are inserted by liquibase:

If we want to change trigger time of spare part sync job:

UPDATE [mmcsp_scheduled_task]
SET [cron_expression] = <cron_expression, varchar(50),>
 WHERE [task_code] = 0