SAP Work History Detail Mappings

The following table explains the SAP fields that are used to populate the baseline Work History Detail fields when you extract Orders and Notifications from SAP.

Note: If a Technical Object in the object list is associated with a Notification that has items, separate Work History Detail records will be created for each of those items. The Work History Detail records will be linked to the Work History record that was created using that Technical Object.

GE Digital APM Family ID	GE Digital APM Field ID	GE Digital APM Field Caption	SAP Table	SAP Field	SAP Field Caption
MI_DTWKHIST	MI_DTWKHIST_CAUSE_CD_C	Cause Code	QMUR	URCOD	Cause Code
MI_DTWKHIST	MI_DTWKHIST_CAUSE_DESC_C	Cause Description	QPCT	KURZTEXT	Short Text for Code
MI_DTWKHIST Note: The time zone used for the value in the CMMS Creation Date field is the same as the SAP server time zone.	MI_DTWKHIST_CREATE_DATE_D	CMMS Creation Date	VIAUFKS	ERDAT, ERZEIT	SAP Creation Date
MI_DTWKHIST Note: The time zone used for the value in the CMMS Last Changed Date field is the same as the SAP server time zone.	MI_DTWKHIST_CHANGE_DATE_D	CMMS Last Changed Date	VIAUFKS	AEDAT, AEZEIT	SAP Last Changed Date
MI_DTWKHIST	MI_DTWKHIST_CNDTN_CD_C	Condition Code	QMFE	FECOD	Problem
MI_DTWKHIST	MI_DTWKHIST_CNDTN_DESC_C	Condition Description	QPCT	KURZTEXT	Short Text for Code
MI_DTWKHIST	MI_DTWKHIST_DTL_NARTV_T	Detail Narrative	QMFE	LTXT	Long Text
MI_DTWKHIST	MI_DTWKHIST_EAM_REF_CREATE_DT_C	EAM Reference Creation Date	VIAUFKS	ERDAT, ERZEIT	SAP Creation Date
MI_DTWKHIST	MI_DTWKHIST_EAM_REF_CHANGE_DT_C	EAM Reference Last Changed Date	VIAUFKS	AEDAT, AEZEIT	SAP Last Changed Date
MI_DTWKHIST	MI_DTWKHIST_ASST_CTGRY_C	Equipment Category	EQUI	EQTYP	Equipment category
MI_DTWKHIST	MI_DTWKHIST_ASST_CTGRY_DESC_C	Equipment Category Description	T370U	TYPTX	Equipment category description
MI_DTWKHIST	MI_DTWKHIST_ASST_CLASS_C	Equipment Class	KLAH	CLASS	Class Number
MI_DTWKHIST	MI_DTWKHIST_ASST_CLASS_DESC_C	Equipment Class Description	SWOR	KSCHL	Keywords
MI_DTWKHIST	MI_DTWKHIST_ASST_ID_C	Equipment ID	VIQMEL	EQUNR	Equipment number
MI_DTWKHIST	MI_DTWKHIST_ASST_TYP_C	Equipment Type	EQUI	EQART	Type of Technical Object
MI_DTWKHIST	MI_DTWKHIST_ASST_TYP_DESC_C	Equipment Type Description	T370K_T	EARTX	Text for Object Type
MI_DTWKHIST	MI_DTWKHIST_LOC_ID_C	Location ID	VIQMEL	TPLNR	Functional Location
MI_DTWKHIST	MI_DTWKHIST_MAINT_ITEM_CD_C	Maintainable Item Code	QMFE	OTEIL	Part of Object
MI_DTWKHIST	MI_DTWKHIST_MAINT_ITEM_DESC_C	Maintainable Item Description	QPCT	KURZTEXT	Short Text for Code
MI_DTWKHIST	MI_DTWKHIST_MAINT_ACTN_CD_C	Maintenance Action Code	QMMA	MNCOD	Activity Code
MI_DTWKHIST	MI_DTWKHIST_MAINT_ACTN_DESC_C	Maintenance Action Description	QPCT	KURZTEXT	Short Text for Code
MI_DTWKHIST	MI_DTWKHIST_MARKED_FOR_DEL_F	Marked for Deletion?	QMFE	KZLOESCH	Delete Data Record
MI_DTWKHIST	MI_DTWKHIST_EVNT_DTL_DESC_C	Work History Detail Description	VIQMEL	QMTXT	Short Text
MI_DTWKHIST	MI_DTWKHIST_EVNT_DTL_ID_C	Work History Detail ID	QMFE, VIQMEL	QMNUM, AUFNR, FENUM	Notification Number - Order Number
MI_DTWKHIST	MI_DTWKHIST_WRK_HISTRY_ID_C	Work History ID	VIAUFKS	QMNUM	Notification Number
MI_DTWKHIST	MI_DTWKHIST_ORDR_ID_C	Order ID	VIAUFKS	AUFNR	Order Number
MI_DTWKHIST	MI_DTWKHIST_RQST_ID_C	Request ID	VIQMEL	QMNUM	Notification Number