/SMERP/STG_PM014 - Data staging LAM - Functional Location complex table

Data staging LAM - Functional Location complex table information is stored in SAP table /SMERP/STG_PM014.
It is part of development package /SMERP/E5_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_PM014

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_IFLOT_INCL_STR	0
TPLNR	Functional Location		TPLNR	CHAR	60
.INCLUDE				IFLOT_INC	0
MLANG	Primary language for object texts		MLANG	LANG	2	T002
TPLKZ	Functional Location Structure Indicator		TPLKZ	CHAR	10	T370S
FLTYP	Functional location category		FLTYP	CHAR	2	T370F
TPLMA	Superior functional location		TPLMA	CHAR	60	IFLOT
ERDAT	Date on which the object was created		ICRDT	DATS	16
ERNAM	Name of User Who Created the Object		ICRNA	CHAR	24
AEDAT	Date on which the object was last changed		IUPDT	DATS	16
AENAM	Name of the user who last changed the object		IUPNA	CHAR	24
DATAB	Start-up Date of the Technical Object		ILOM_DATAB	DATS	16
BEGRU	Technical Object Authorization Group		IAUTG	CHAR	8	T370B
TRPNR	Reference functional location		TRPNR	CHAR	60	IRLOT
PSTAE	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
LVORM	SAP Development Reserve: Format CHAR, Length 1		RESERVE_CHAR_001	CHAR	2
SUBMT	Construction type material of the object		SUBMT	CHAR	80	MARA
SUBMTI	Data origin for construction type field		INH_SUBMTI	CHAR	2
MAPAR	Manufacturer part number		MAPAR	CHAR	60
MAPARI	SAP Development Reserve: Format CHAR, Length 1		RESERVE_CHAR_001	CHAR	2
IEQUI	Installation of equipment allowed at the functional location		IEQUI	CHAR	2
IEQUII	Data origin for equip. inst. allowed field		INH_IEQUII	CHAR	2
EINZL	Single equipment installation at functional location		EINZL	CHAR	2
EINZLI	Data origin for authorization group field		INH_BEGRUI	CHAR	2
IWERK	Maintenance Planning Plant		IWERK	CHAR	8	T399I
IWERKI	Data origin for planning plant field		INH_IWERKI	CHAR	2
INGRP	Planner Group for Customer Service and Plant Maintenance		INGRP	CHAR	6	T024I
INGRPI	Data origin for maintenance planner group field		INH_INGRPI	CHAR	2
PM_OBJTY	Object Type of CIM Resources for Work Center		PM_OBJTY	CHAR	4
LGWID	Object ID of the Work Center		LGWID	NUMC	16	CRID
LGWIDI	Data Origin for the Field 'Work Center'		INH_LGWIDI	CHAR	2
RBNR	Catalog Profile		RBNR	CHAR	18	T352B
RBNR_I	Data origin for maintenance catalog field		INH_RBNR_I	CHAR	2
ILOAN	Location and account assignment for technical object		ILOAN	CHAR	24	ILOA
OBJNR	Object number		J_OBJNR	CHAR	44	ONR00
POSNR	Position in superior technical object		ILOM_POSNR	CHAR	8
ISTYP	Object category for Industry Solutions (IS)		ILOM_ISTYP	CHAR	2
PREMS	Premise		ILOM_PREMS	CHAR	20
EQART	Type of Technical Object		EQART	CHAR	20	T370K
INVNR	Inventory number		INVNR	CHAR	50
GROES	Size/dimension		GROSS	CHAR	36
BRGEW	Gross weight		BRGEW	QUAN	7
GEWEI	Weight Unit		GEWEI	UNIT	6	T006
ANSWT	Acquisition Value		ANSWT	CURR	7
WAERS	Currency Key		WAERS	CUKY	10	TCURC
ANSDT	Acquisition date		ANDTI	DATS	16
HERST	Manufacturer of Asset		HERST	CHAR	60
HERLD	Country/Region of Manufacture		HERLD	CHAR	6	T005
BAUJJ	Year of construction		BAUJJ	CHAR	8
BAUMM	Month of construction		BAUMM	CHAR	4
TYPBZ	Manufacturer model number		TYPBZ	CHAR	40
EMATN	Material number corresponding to manufacturer part number		EMATN	CHAR	80	*
SERGE	Manufacturer's Serial Number		SERGE	CHAR	60
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	*
CHANGEDDATETIME	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)		TZNTSTMPS	DEC	8
ENDOFUSE	End-of-Use Date of the Technical Object		ENDOFUSE_DATE	DATS	16
.INCLUDE				IFLOT_INCL_EEW_PS	0
.INCLUDE				CI_IFLOT	0
DUMMY_IFLOT_INCL_EEW_PS	Custom Fields: Dummy for Use in Extension Includes		CFD_DUMMY	CHAR	2
.INCLU--AP				DIACL_IFLOT_APPEND	0
FLLB_DUTY	Logbook Duty		DIACL_DUTY	CHAR	2
FLLB_HIDE	Hide Logbook Display		DIACL_HIDE	CHAR	2
.INCLU--AP				IFLOT_INC_SR_APPEND	0
IFLOT_SRTYPE	Shift Report Type for Object		ILOM_SR_SRTYPE	CHAR	20
IFLOT_SNTYPE	Notification Type for Shift Note for Object		ILOM_SN_SNTYPE	CHAR	4	TQ80
.INCLUDE				/SYCLO/PM_SI_ILOA_STR	0
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	*
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
.INCLUDE				IFLOTX_INC	0
PLTXT	Description of functional location		PLTXT	CHAR	80
KZLTX	Long Text Exists		ILOM_KZLTX	CHAR	2
KZMLA	Primary language indicator for text segment		KZMLA	CHAR	2
PLTXU	Description of functional location in capital letters		ILOM_PLTXU	CHAR	80
TEXTCHANGEDDATETIME	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)		TZNTSTMPS	DEC	8
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	Description of functional location category		FLTTX	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
TPLNR_EXT	Function location - external format			CHAR	80
TPLMA_EXT	Superior Function location - external format			CHAR	80
LAM_FLAG	Boolean Type: 'X' == True '' == False		/SYCLO/CORE_BOOLEAN_DTE	CHAR	2
OBART	Object Type for Linear Data		/SMERP/PM_LAM_EAML_OBART_DTE	CHAR	4
TABKEY	Table Key of Reference Object		/SMERP/PM_LAM_EAML_TABKEY_DTE	CHAR	60
START_POINT	Start Point in SI Unit		/SMERP/PM_EAML_START_PT_SI_DTE	FLTP	8
START_POINT_CHAR	Value in target unit		SZME_VALC2	CHAR	44
END_POINT	End Point in SI Unit		/SMERP/PM_EAML_END_PT_SI_DTE	FLTP	8
END_POINT_CHAR	Value in target unit		SZME_VALC2	CHAR	44
LINEAR_LENGTH	Length in SI Unit		/SMERP/PM_EAMLLINEARLEN_SI_DTE	FLTP	8
LINEAR_LENGTH_C	Value in target unit		SZME_VALC2	CHAR	44
LINEAR_UNIT	Unit of Measurement for Linear Data		/SMERP/PM_EAML_LINEAR_UNIT_DTE	UNIT	6
MARKER_START	Marker for Start Point		/SMERP/PM_EAMLMRKERSTARTPT_DTE	CHAR	36
MARKER_DIST_STA	Distance between Start Marker and Start Point in SI		/SMERP/PM_EAML_MARK_DISBEG_DTE	FLTP	8
MARKER_DIST_STAC	Value in target unit		SZME_VALC2	CHAR	44
MARKER_END	Marker for End Point		/SMERP/PM_EAML_MARKERENDPT_DTE	CHAR	36
MARKER_DIST_END	Distance between End Marker and End Point in SI		/SMERP/PM_EAML_MARK_DISEND_DTE	FLTP	8
MARKER_DIST_ENDC	Value in target unit		SZME_VALC2	CHAR	44
MARKER_DIST_UNIT	Unit for the Distance from Marker		/SMERP/PM_EAML_MARKDISUNIT_DTE	UNIT	6
.INCLUDE				/SMERP/PM_EAML_S_ADD_FLDS_STR	0
LRPID	Linear Reference Pattern		/SMERP/PM_EAML_LRPID_DTE	CHAR	20
.INCLUDE				CI_EAML_LFE	0
OFFSET1_TYPE	Type of First Offset		/SMERP/PM_EAMLOFFSET1TYPCD_DTE	CHAR	4
OFFSET1_VALUE	Value of Offset 1		/SMERP/PM_EAML_OFFSET1_VAL_DTE	FLTP	8
OFFSET1_VALUE_C	Value in target unit		SZME_VALC2	CHAR	44
OFFSET1_UNIT	Unit of Measurement for Offset 1		/SMERP/PM_EAML_OFFSET1UNIT_DTE	UNIT	6
OFFSET2_TYPE	Type of Second Offset		/SMERP/PM_EAMLOFFSET2TYPCD_DTE	CHAR	4
OFFSET2_VALUE	Value of Offset 2		/SMERP/PM_EAML_OFFSET2VAL_DTE	FLTP	8
OFFSET2_VALUE_C	Value in target unit		SZME_VALC2	CHAR	44
OFFSET2_UNIT	Unit of Measurement for Offset 2		/SMERP/PM_EAML_OFFSET2UNIT_DTE	UNIT	6