IRDB Configuration Examples

Functional Location

About This Task

An end user is recommended to have a custom field in SAP to be extracted and added to a custom field in APM. Details on SAP and APM Families are as follows:

  • SAP Table Name: IFLOT
  • SAP Field Name: ERNAM
  • APM Family Name: MI_FLOC00
  • APM Field Name: CC_CREATED_BY

To update the interface, the following steps need to be followed:

Procedure

  1. Updates to autoextractor_control table
    1. Schema definition needs to be added to the extract_schema_definition field for batch name “Functional_Location_Step_1”. This can be done by appending “IFLOT|ERNAM” to the end of the extract_schema_definition.
  2. Updates to autoloader_control table
    1. Duplicate the row for batch_name=”Functional_Location_Step_1”
    2. In the new row, update
      1. table_name to a unique value (CUSTOM_FLOC)
      2. jobname to IR_Custom_Loader
  3. Update to autojoin_control table
    1. Update the sql field in the row where batch_name=”Functional_Location” and table_name=”MI_FNLOC00”
      1. Select the new field (IFLOT|ERNAM as CC_CREATED_BY)
      2. Add a left autojoin to include the custom table included in step 2 left outer join "CUSTOM_FLOC" on “IFLOT|TPLNR.” =” MI_FNCLOC00_FNC_LOC_C”

Equipment

About This Task

An end user is recommended to have a custom field in SAP to be extracted and added to a custom field in APM. Details on SAP and APM Families are as follows:

  • SAP Table Name: EQUI
  • SAP Field Name: ERNAM
  • APM Family Name: MI_EQUIP000
  • APM Field Name: CC_CREATED_BY

To update the interface, the following steps need to be followed:

Procedure

  1. Updates to autoextractor_control table
    1. a. Schema definition needs to be added to the extract_schema_definition field for batch name “Equipment_Step_1”. This can be done by appending “EQUI|ERNAM” to the end of the extract_schema_definition.
  2. Updates to autoloader_control table
    1. Duplicate the row for batch_name=”Equipment_Step_1”
    2. b. In the new row, update
      1. i. table_name to a unique value (CUSTOM_EQUI)
      2. jobname to IR_Custom_Loader
  3. Update to autojoin_control table
    1. a. Update the sql field in the row where batch_name=”Equipment” and table_name=” MI_EQUIP000”
      1. Select the new field (EQUI|ERNAM as CC_CREATED_BY)
      2. Add a left autojoin to include the custom table included in step 2 left outer join "CUSTOM_EQUI" on “EQUI|EQUNR.” =” MI_EQUIP000_EQUIP_ID_C”

Work History

About This Task

An end user is recommended to have a custom field in SAP to be extracted and added to a custom field in APM. Details on SAP and APM Families are as follows:

  • SAP Table Name: VIQMEL
  • SAP Field Name: ERNAM
  • APM Family Name: MI_EVWKHIST
  • APM Field Name: CC_CREATED_BY

To update the interface, the following steps need to be followed:

Procedure

  1. Updates to autoextractor_control table
    1. Schema definition needs to be added to the extract_schema_definition field for batch name “WORKHISTORY_STEP_1”. This can be done by appending “VIQMEL|ERNAM” to the end of the extract_schema_definition.
  2. Updates to autoloader_control table
    1. Duplicate the row for batch_name=” WORKHISTORY_STEP_1”
    2. In the new row, update
      1. table_name to a unique value (CUSTOM_WH)
      2. jobname to IR_Custom_Loader
  3. Update to autojoin_control table
    1. Update the sql field in the row where batch_name=” WORKHISTORY” and table_name=”WorkHistory”
      1. Select the new field (VIQMEL|ERNAM as CC_CREATED_BY)
      2. Add a left autojoin to include the custom table included in step 2 left outer join "CUSTOM_WH" on “VIQMEL|QMNAM.” =” MI_EVWKHIST_RQST_ID_C”

Work Management Interface

An end is recommended to have a custom field in SAP to be extracted and added to a custom field in APM. Details on SAP and APM Families are as follows:
  • SAP Table Name: VIMPLA
  • SAP Field Name: ERNAM
  • APM Family Name: MI_TASKINSP
  • APM Field Name: CC_CREATED_BY

Inspection Task

About This Task

To update the interface, the following steps need to be followed for inspection tasks:

Procedure

  1. Updates to autoextractor_control table
    1. a. Schema definition needs to be added to the extract_schema_definition field for batch name “WMI_STEP_2”. This can be done by appending “VIMPLA L|ERNAM” to the end of the extract_schema_definition.
  2. Updates to autoloader_control table
    1. a. Duplicate the row for batch_name=” WMI_STEP_2”
    2. In the new row, update
      1. table_name to a unique value (CUSTOM_WMI_INSP)
      2. jobname to IR_Custom_Loader
  3. Update to autojoin_control table
    1. Update the sql field in the row where batch_name=”WMI” and table_name=” EQUIP_INSPECTION_TASK”
      1. Select the new field (VIMPLA |ERNAM as CC_CREATED_BY)
      2. Add a left autojoin to include the custom table included in step 2 left outer join "CUSTOM_WMI_INSP" on “VIMPLA|WARPL.” =” MI_TASK_MAINT_PLAN_NBR_C”
    2. Update the sql field in the row where batch_name=”WMI” and table_name=” FLOC_INSPECTION_TASK”
      1. Select the new field (VIMPLA |ERNAM as CC_CREATED_BY)
      2. ii. Add a left autojoin to include the custom table included in step 2 left outer join "CUSTOM_WMI_INSP" on “VIMPLA|WARPL.” =” MI_TASK_MAINT_PLAN_NBR_C”

Calibration Task

About This Task

To update the interface the following steps need to be followed for Calibration tasks:

Procedure

  1. Updates to autoextractor_control table
    1. a. Schema definition needs to be added to the extract_schema_definition field for batch name “WMI_STEP_3”. This can be done by appending “VIMPLA L|ERNAM” to the end of the extract_schema_definition.
  2. Updates to autoloader_control table
    1. Duplicate the row for batch_name=” WMI_STEP_3”
    2. In the new row, update
      1. table_name to a unique value (CUSTOM_WMI_CAL)
      2. jobname to IR_Custom_Loader
  3. Update to autojoin_control table
    1. Update the sql field in the row where batch_name=”WMI” and table_name=” EQUIP_CALIBRATION_TASK”
      1. Select the new field (VIMPLA |ERNAM as CC_CREATED_BY)
      2. ii. Add a left autojoin to include the custom table included in step 2 left outer join "CUSTOM_WMI_CAL" on “VIMPLA|WARPL.” =” MI_TASK_MAINT_PLAN_NBR_C”
    2. Update the sql field in the row where batch_name=”WMI” and table_name=” FLOC_CALIBRATION_TASK”
      1. Select the new field (VIMPLA |ERNAM as CC_CREATED_BY)
      2. ii. Add a left autojoin to include the custom table included in step 2 left outer join "CUSTOM_WMI_CAL" on “VIMPLA|WARPL.” =” MI_TASK_MAINT_PLAN_NBR_C”

Notifications

About This Task

An end user is recommended to have a custom field in APM to be extracted and sent back to SAP into the SAP Coding Code. Details on SAP and APM Families are as follows:

  • APM Field Name: MI_REC_CODING
  • SAP Target Field Name: CODING

To update,

Procedure

  1. Open the table southbound_mapping_control table.
  2. Update the field apm_family_name to “MI_REC_CODING” where target_field_name=”CODING”.
  3. Additionally, change the mapping_enabled Boolean to True.