/SMERP/STG_PM001 - Data staging - Equipment complex table

Data staging - Equipment complex table information is stored in SAP table /SMERP/STG_PM001.
It is part of development package /SMERP/MDO_PM in software component MOB-APP-MAO-ERP. This development package consists of objects that can be grouped under "MDO Framework - Plant Maintenance".

Fields for table /SMERP/STG_PM001

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
DSF_GUID	DSF GUID	X	/SMFND/DSF_GUID_DTE	CHAR	64
.INCLUDE				/SMFND/DSF_REQ_FLDS_STR	0
DSF_DSTORE_ID	Data Store ID		/SMFND/DSF_DSTORE_ID_DTE	CHAR	80	*
USER_GUID	User GUID		/SYCLO/CORE_USER_GUID_DTE	CHAR	64
DSF_RECORD_ID	DSF Record ID		/SMFND/DSF_RECORD_ID_DTE	NUMC	20
DSF_CHANGED_BY	Last Changed By		/SYCLO/CORE_CHANGEDBY_DTE	CHAR	24
DSF_CHANGED_TS	Changed time stamp		/SYCLO/CORE_CHANGEDTS_DTE	DEC	8
.INCLUDE				/SMERP/PM_EQUI_INCL_STR	0
EQUNR	Equipment Number		EQUNR	CHAR	36
ERDAT	Date on which the record was created		ERDAT	DATS	16
ERNAM	Name of Person Responsible for Creating the Object		ERNAM	CHAR	24
EQASP	Language in Which the Piece of Equipment was Entered		EQASP	LANG	2	T002
AEDAT	Last Changed On		AEDAT	DATS	16
AENAM	Name of Person Who Changed Object		AENAM	CHAR	24
BEGRU	Technical Object Authorization Group		IAUTG	CHAR	8	T370B
EQTYP	Equipment category		EQTYP	CHAR	2	T370T
EQART	Type of Technical Object		EQART	CHAR	20	T370K
LVORM	SAP Development Reserve: Format CHAR, Length 1		RESERVE_CHAR_001	CHAR	2
INVNR	Inventory number		INVNR	CHAR	50
GROES	Size/dimension		GROSS	CHAR	36
BRGEW	Weight of object		OBJ_WEIGHT	QUAN	7
GEWEI	Unit of weight		WEIGHT_UNIT	UNIT	6	T006
ANSDT	Acquisition date		ANDTI	DATS	16
ANSWT	Acquisition Value		ANSWT	CURR	7
WAERS	Currency Key		WAERS	CUKY	10	TCURC
ELIEF	Vendor number		ELIEF	CHAR	20	LFA1
GWLEN	Date on which the warranty ends		GWLEN	DATS	16
GWLDT	Guarantee date		GWLDT	DATS	16
WDBWT	Equipment replacement value		WDBWT	CURR	7
HERST	Manufacturer of Asset		HERST	CHAR	60
HERLD	Country/Region of Manufacture		HERLD	CHAR	6	T005
HZEIN	Manufacturer drawing number		HZEIN	CHAR	60
SERGE	Manufacturer's Serial Number		SERGE	CHAR	60
TYPBZ	Manufacturer model number		TYPBZ	CHAR	40
BAUJJ	Year of construction		BAUJJ	CHAR	8
BAUMM	Month of construction		BAUMM	CHAR	4
APLKZ	Indicator: Task List Exists		APLKZ	CHAR	2
AULDT	First delivery date of the equipment		AULDT	DATS	16
INBDT	Start-up Date of the Technical Object		ILOM_DATAB	DATS	16
GERNR	Serial Number		GERNR	CHAR	36
GWLDV	Warranty date for Sales and Distribution		GWLDV	DATS	16
EQDAT	Date, intended for SAP internal use		EQDAT	DATS	16
EQBER	Technical information, intended for SAP internal use		EQBER	CHAR	60
EQNUM	Numerical field, intended for SAP internal use		EQNUM	NUMC	18
OBJNR	Object number		J_OBJNR	CHAR	44	*
EQSNR	EQSE Number		EQSNR	CHAR	36	EQSE
CUOBJ	Configuration (internal object number)		CUOBJ	NUMC	36
KRFKZ	Referenced Configuration		KRFKZ	CHAR	2
KMATN	Configurable Material		KMATN	CHAR	80	MARA
MATNR	Material Number		MATNR	CHAR	80	MARA
SERNR	Serial Number		GERNR	CHAR	36
WERK	Plant		WERKS_D	CHAR	8	T001W
LAGER	Storage location		LGORT_D	CHAR	8	T001L
CHARGE	Batch Number		CHARG_D	CHAR	20	MCH1
KUNDE	Customer to Whom Serial Number was Delivered		KUNDSE	CHAR	20	KNA1
WARPL	Maintenance Plan		WARPL	CHAR	24	MPLA
IMRC_POINT	Measuring Point		IMRC_POINT	CHAR	24	IMPTT
REVLV	Revision Level		REVLV	CHAR	4
MGANR	Master warranty number		MGANR	CHAR	40	BGMK
BEGRUI	Data origin for authorization group field		INH_BEGRUI	CHAR	2
S_EQUI	Equipment data exists		EQUIP_KNZ	CHAR	2
S_SERIAL	Serial data when maintaining equipment		KZKSD	CHAR	2
S_KONFI	Configuration supported		KONFKNZ	CHAR	2
S_SALE	Sales equipment		SDKNZ	CHAR	2
S_FHM	Equip. category relevant to production resources and tools		FHMKZ	CHAR	2
S_ELSE	Indicator: Other Data Active		ELSE_KNZ	CHAR	2
S_ISU	IS-U data		ISU_KNZ	CHAR	2
S_EQBS	EQSI Exists		KZEQBS	CHAR	2
S_FLEET	Indicator: Fleet object active		FLEET_KNZ	CHAR	2
BSTVP	Stock Check for Serial Numbers		BSTVP	CHAR	2
SPARTE	Division		SPARTE	CHAR	4	TSPA
HANDLE	SAP Development Reserve: Integration of Date Segment (Key)		ITOBTMP_TSEGGUID	CHAR	44
TSEGTP	SAP Development Reserve: Integration Date Segment (Tempate)		ITOBTMP_TSEGTEMPLA	CHAR	20	*
EMATN	Material number corresponding to manufacturer part number		EMATN	CHAR	80	*
ACT_CHANGE_AA	Change Equipment Master when Changing Asset		AAPM_ACT_CHANGE_AA	CHAR	2
S_CC	Configuration Control Data		CCC_KNZ	CHAR	2
DATLWB	Date of Last Goods Movement		DATLWB	DATS	16
DATBI	Valid To Date		DATBI	DATS	16
EQLFN	Consecutive numbering of EquipUsagePeriods on same day		EQLFN	NUMC	6
EQUZN	Number of next EquipUsagePeriod on same day		EQNNR	NUMC	6
TIMBI	Equipment usage period time stamp		TIMBI	TIMS	12
ESTAI	SAP Development Reserve: Format CHAR, Length 1		RESERVE_CHAR_001	CHAR	2
ESTAE	SAP Development reserve: Format CHAR, length 4		RESERVE_CHAR_004	CHAR	8
STNAM	SAP Development Reserve: Format CHAR, Length 12		RESERVE_CHAR_012	CHAR	24
DATAB	Valid-From Date		DATAB	DATS	16
IWERK	Maintenance Planning Plant		IWERK	CHAR	8	*
IWERKI	Data origin indicator		INHER	CHAR	2
SUBMT	Construction type material of the object		SUBMT	CHAR	80	*
MAPAR	Manufacturer part number		MAPAR	CHAR	60
HEQUI	Superordinate Equipment		HEQUI	CHAR	36	*
HEQNR	Equipment position at InstallLoc (Superior Equip./FunctLoc)		HEQNR	CHAR	8
INGRP	Planner Group for Customer Service and Plant Maintenance		INGRP	CHAR	6	*
INGRPI	Data origin indicator		INHER	CHAR	2
PM_OBJTY	Object Type of CIM Resources for Work Center		PM_OBJTY	CHAR	4
GEWRK	Object ID of the Work Center		LGWID	NUMC	16	*
GEWRKI	Data origin indicator		INHER	CHAR	2
TIDNR	Technical identification number		TIDNR	CHAR	50
TIDNRI	Data origin indicator		INHER	CHAR	2
ILOAN	Location and account assignment for technical object		ILOAN	CHAR	24	*
KUND1	Customer number		KUND1	CHAR	20	*
KUND2	End customer number		KUND2	CHAR	20	*
KUND3	Operator		KUND3	CHAR	20	*
LIZNR	Equipment license number		LIZNR	CHAR	40
RBNR	Catalog Profile		RBNR	CHAR	18	*
EZDAT	Date, intended for SAP internal use		EQDAT	DATS	16
EZBER	Technical information, intended for SAP internal use		EQBER	CHAR	60
EZNUM	Numerical field, intended for SAP internal use		EQNUM	NUMC	18
RBNR_I	Data origin indicator		INHER	CHAR	2
IBLNR	Physical Inventory Document		IBLNR	CHAR	20
BLDAT	Document Date in Document		BLDAT	DATS	16
PVS_FOCUS	Internal Identification for PVS Objects		PVS_GUID_CCC	RAW	16
PPEGUID	Internal Identification for PVS Objects		PVS_GUID_CCC	RAW	16
TECHS	Parameter Variant/Standard Variant		TECHS	CHAR	24
FUNCID	Function Identifier		CCC_FUNCID	CHAR	80
FRCFIT	Indicator: Forced Installation/Dismantling		CCC_FRCFIT	CHAR	2
FRCRMV	Force Dismantling Flag		CCC_FRCRMV	CHAR	2
SPRAS	Language Key		SPRAS	LANG	2
EQKTX	Description of technical object		KTX01	CHAR	80
KZLTX	Long Text Indicator		KZLTA	CHAR	2
TXASP	Primary language indicator for text segment		KZMLA	CHAR	2
EQKTU	Equipment description in capital letters		EQKTU	CHAR	80
TPLNR	Functional Location		TPLNR	CHAR	60
ABCKZ	ABC Indicator for Technical Object		ABCKZ	CHAR	2	*
ABCKZI	Data origin for ABC indicator field		INH_ABCKZI	CHAR	2
EQFNR	Sort Field		EQFNR	CHAR	60
EQFNRI	Data origin for sort field		INH_EQFNRI	CHAR	2
SWERK	Maintenance Plant		SWERK	CHAR	8	*
SWERKI	Data origin for maintenance plant field		INH_SWERKI	CHAR	2
STORT	Location of maintenance object		PMLOC	CHAR	20	*
STORTI	Data origin for location field		INH_STORTI	CHAR	2
MSGRP	Room		RAUMNR	CHAR	16
MSGRPI	Data origin for room number field		INH_MSGRPI	CHAR	2
BEBER	Plant Section		BEBER	CHAR	6	*
BEBERI	Data origin for plant section field		INH_BEBERI	CHAR	2
CR_OBJTY	Object types of the CIM resource		CR_OBJTY	CHAR	4
PPSID	Object ID of PP work center		PPSID	NUMC	16	*
PPSIDI	Data origin for PP work center field		INH_PPSIDI	CHAR	2
GSBER	Business Area		GSBER	CHAR	8	*
GSBERI	Data origin for business area field		INH_GSBERI	CHAR	2
KOKRS	Controlling Area		KOKRS	CHAR	8	*
KOKRSI	Data origin for controlling area field		INH_KOKRSI	CHAR	2
KOSTL	Cost Center		KOSTL	CHAR	20	*
KOSTLI	Data origin for cost center field		INH_KOSTLI	CHAR	2
PROID	Work Breakdown Structure Element (WBS Element)		PS_PSP_PNR	NUMC	16	*
PROIDI	Data origin for WBS element field		INH_PROIDI	CHAR	2
BUKRS	Company Code		BUKRS	CHAR	8
BUKRSI	Data origin for company code field		INH_BUKRSI	CHAR	2
ANLNR	Main Asset Number		ANLN1	CHAR	24	*
ANLNRI	Data origin for asset main no./sub-no. fields		INH_ANLNRI	CHAR	2
ANLUN	Asset Subnumber		ANLN2	CHAR	8	*
ANLUNI	Data origin indicator		INHER	CHAR	2
DAUFN	Standing order number		DAUFN	CHAR	24
DAUFNI	Data origin of standing order number field		INH_DAUFNI	CHAR	2
AUFNR	Settlement order		ILOM_ORDST	CHAR	24
AUFNRI	Data origin for settlement order field		INH_AUFNRI	CHAR	2
TPLNRI	Data origin for functional location field		INH_TPLNRI	CHAR	2
VKORG	Sales Organization		VKORG	CHAR	8
VKORGI	Data origin for sales organization field		INH_VKORGI	CHAR	2
VTWEG	Distribution Channel		VTWEG	CHAR	4
VTWEGI	Data origin of distribution channel field		INH_VTWEGI	CHAR	2
SPART	Division		SPART	CHAR	4
SPARTI	Data origin for division field		INH_SPARTI	CHAR	2
ADRNR	Address Number		AD_ADDRNUM	CHAR	20	*
ADRNRI	Data origin for address field		INH_ADRNRI	CHAR	2
OWNER	Object reference indicator		ILOM_OWNER	CHAR	2
VKBUR	Sales office		VKBUR	CHAR	8	*
VKGRP	Sales group		VKGRP	CHAR	6	*
LVORZ	SAP Development Reserve: Format CHAR, Length 1		RESERVE_CHAR_001	CHAR	2
ERNAZ	Name of Person Responsible for Creating the Object		ERNAM	CHAR	24
ERDAZ	Date on which the record was created		ERDAT	DATS	16
AENAZ	Name of Person Who Changed Object		AENAM	CHAR	24
AEDAZ	Last Changed On		AEDAT	DATS	16
ARBPL_LOC	Work Center		ARBPL	CHAR	16
ARBPL_LOC_TEXT	Short description		CR_KTEXT	CHAR	80
ARBPL	Work Center		ARBPL	CHAR	16
ARBPL_TEXT	Short description		CR_KTEXT	CHAR	80
TYPTX	Equipment category description		ETYTX	CHAR	60
EARTX	Text for Object Type		EARTX	CHAR	40
STORT_TEXT	Text, Length 40		TXT40	CHAR	80
BEBER_TEXT	Text, Length 40		TXT40	CHAR	80
SYSTEM_STATUS	Display lines for system status		ILOM_STTXS	CHAR	80
USER_STATUS	Display lines for user status		ILOM_STTXU	CHAR	80
SYST_STATUS_CODE	Name		TXT50	CHAR	100
USER_STATUS_CODE	Name		TXT50	CHAR	100
TPLNR_EXT	Function location - external format			CHAR	80
.INCLUDE				EBSINF	0
LBBSA	Stock Type of Goods Movement (Primary Posting)		LBBSA	CHAR	4	T156C
B_WERK	Plant		WERKS_D	CHAR	8
B_LAGER	Storage location		LGORT_D	CHAR	8	*
B_CHARGE	Batch Number		B_CHARGE	CHAR	20	*
SOBKZ	Special Stock Indicator		SOBKZ	CHAR	2	*
KUNNR	Special stock customer account number		B_KUNNR	CHAR	20	*
LIFNR	Account number of the vendor		B_LIFNR	CHAR	20
KDAUF	Sales Order Number		KDAUF	CHAR	20
KDPOS	Item number in Sales Order		KDPOS	NUMC	12
PS_PSP_PNR	Work Breakdown Structure Element (WBS Element)		PS_PSP_PNR	NUMC	16	*
.INCLU--AP				DISUB_EBSINF_DATA	0
DISUB_OWNER	Owner of stock		OWNER_D	CHAR	20	*