/SMERP/STG_PM002 - Data staging - Functional Location complex table

Data staging - Functional Location complex table information is stored in SAP table /SMERP/STG_PM002.
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_PM002

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6
DSF_GUIDDSF GUIDX/SMFND/DSF_GUID_DTECHAR64
.INCLUDE/SMFND/DSF_REQ_FLDS_STR0
DSF_DSTORE_IDData Store ID/SMFND/DSF_DSTORE_ID_DTECHAR80*
USER_GUIDUser GUID/SYCLO/CORE_USER_GUID_DTECHAR64
DSF_RECORD_IDDSF Record ID/SMFND/DSF_RECORD_ID_DTENUMC20
DSF_CHANGED_BYLast Changed By/SYCLO/CORE_CHANGEDBY_DTECHAR24
DSF_CHANGED_TSChanged time stamp/SYCLO/CORE_CHANGEDTS_DTEDEC8
.INCLUDE/SMERP/PM_IFLOT_INCL_STR0
TPLNRFunctional LocationTPLNRCHAR60
.INCLUDEIFLOT_INC0
MLANGPrimary language for object textsMLANGLANG2T002
TPLKZFunctional Location Structure IndicatorTPLKZCHAR10T370S
FLTYPFunctional location categoryFLTYPCHAR2T370F
TPLMASuperior functional locationTPLMACHAR60IFLOT
ERDATDate on which the object was createdICRDTDATS16
ERNAMName of User Who Created the ObjectICRNACHAR24
AEDATDate on which the object was last changedIUPDTDATS16
AENAMName of the user who last changed the objectIUPNACHAR24
DATABStart-up Date of the Technical ObjectILOM_DATABDATS16
BEGRUTechnical Object Authorization GroupIAUTGCHAR8T370B
TRPNRReference functional locationTRPNRCHAR60IRLOT
PSTAESAP Development reserve: Format CHAR, length 4RESERVE_CHAR_004CHAR8
STNAMSAP Development Reserve: Format CHAR, Length 12RESERVE_CHAR_012CHAR24
LVORMSAP Development Reserve: Format CHAR, Length 1RESERVE_CHAR_001CHAR2
SUBMTConstruction type material of the objectSUBMTCHAR80MARA
SUBMTIData origin for construction type fieldINH_SUBMTICHAR2
MAPARManufacturer part numberMAPARCHAR60
MAPARISAP Development Reserve: Format CHAR, Length 1RESERVE_CHAR_001CHAR2
IEQUIInstallation of equipment allowed at the functional locationIEQUICHAR2
IEQUIIData origin for equip. inst. allowed fieldINH_IEQUIICHAR2
EINZLSingle equipment installation at functional locationEINZLCHAR2
EINZLIData origin for authorization group fieldINH_BEGRUICHAR2
IWERKMaintenance Planning PlantIWERKCHAR8T399I
IWERKIData origin for planning plant fieldINH_IWERKICHAR2
INGRPPlanner Group for Customer Service and Plant MaintenanceINGRPCHAR6T024I
INGRPIData origin for maintenance planner group fieldINH_INGRPICHAR2
PM_OBJTYObject Type of CIM Resources for Work CenterPM_OBJTYCHAR4
LGWIDObject ID of the Work CenterLGWIDNUMC16CRID
LGWIDIData Origin for the Field 'Work Center'INH_LGWIDICHAR2
RBNRCatalog ProfileRBNRCHAR18T352B
RBNR_IData origin for maintenance catalog fieldINH_RBNR_ICHAR2
ILOANLocation and account assignment for technical objectILOANCHAR24ILOA
OBJNRObject numberJ_OBJNRCHAR44ONR00
POSNRPosition in superior technical objectILOM_POSNRCHAR8
ISTYPObject category for Industry Solutions (IS)ILOM_ISTYPCHAR2
PREMSPremiseILOM_PREMSCHAR20
EQARTType of Technical ObjectEQARTCHAR20T370K
INVNRInventory numberINVNRCHAR50
GROESSize/dimensionGROSSCHAR36
BRGEWGross weightBRGEWQUAN7
GEWEIWeight UnitGEWEIUNIT6T006
ANSWTAcquisition ValueANSWTCURR7
WAERSCurrency KeyWAERSCUKY10TCURC
ANSDTAcquisition dateANDTIDATS16
HERSTManufacturer of AssetHERSTCHAR60
HERLDCountry/Region of ManufactureHERLDCHAR6T005
BAUJJYear of constructionBAUJJCHAR8
BAUMMMonth of constructionBAUMMCHAR4
TYPBZManufacturer model numberTYPBZCHAR40
EMATNMaterial number corresponding to manufacturer part numberEMATNCHAR80*
SERGEManufacturer's Serial NumberSERGECHAR60
HANDLESAP Development Reserve: Integration of Date Segment (Key)ITOBTMP_TSEGGUIDCHAR44
TSEGTPSAP Development Reserve: Integration Date Segment (Tempate)ITOBTMP_TSEGTEMPLACHAR20*
CHANGEDDATETIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)TZNTSTMPSDEC8
ENDOFUSEEnd-of-Use Date of the Technical ObjectENDOFUSE_DATEDATS16
.INCLUDEIFLOT_INCL_EEW_PS0
.INCLUDECI_IFLOT0
DUMMY_IFLOT_INCL_EEW_PSCustom Fields: Dummy for Use in Extension IncludesCFD_DUMMYCHAR2
.INCLU--APDIACL_IFLOT_APPEND0
FLLB_DUTYLogbook DutyDIACL_DUTYCHAR2
FLLB_HIDEHide Logbook DisplayDIACL_HIDECHAR2
.INCLU--APIFLOT_INC_SR_APPEND0
IFLOT_SRTYPEShift Report Type for ObjectILOM_SR_SRTYPECHAR20
IFLOT_SNTYPENotification Type for Shift Note for ObjectILOM_SN_SNTYPECHAR4TQ80
.INCLUDE/SYCLO/PM_SI_ILOA_STR0
ABCKZABC Indicator for Technical ObjectABCKZCHAR2*
ABCKZIData origin for ABC indicator fieldINH_ABCKZICHAR2
EQFNRSort FieldEQFNRCHAR60
EQFNRIData origin for sort fieldINH_EQFNRICHAR2
SWERKMaintenance PlantSWERKCHAR8*
SWERKIData origin for maintenance plant fieldINH_SWERKICHAR2
STORTLocation of maintenance objectPMLOCCHAR20*
STORTIData origin for location fieldINH_STORTICHAR2
MSGRPRoomRAUMNRCHAR16
MSGRPIData origin for room number fieldINH_MSGRPICHAR2
BEBERPlant SectionBEBERCHAR6*
BEBERIData origin for plant section fieldINH_BEBERICHAR2
CR_OBJTYObject types of the CIM resourceCR_OBJTYCHAR4
PPSIDObject ID of PP work centerPPSIDNUMC16*
PPSIDIData origin for PP work center fieldINH_PPSIDICHAR2
GSBERBusiness AreaGSBERCHAR8*
GSBERIData origin for business area fieldINH_GSBERICHAR2
KOKRSControlling AreaKOKRSCHAR8*
KOKRSIData origin for controlling area fieldINH_KOKRSICHAR2
KOSTLCost CenterKOSTLCHAR20*
KOSTLIData origin for cost center fieldINH_KOSTLICHAR2
PROIDWork Breakdown Structure Element (WBS Element)PS_PSP_PNRNUMC16*
PROIDIData origin for WBS element fieldINH_PROIDICHAR2
BUKRSCompany CodeBUKRSCHAR8
BUKRSIData origin for company code fieldINH_BUKRSICHAR2
ANLNRMain Asset NumberANLN1CHAR24*
ANLNRIData origin for asset main no./sub-no. fieldsINH_ANLNRICHAR2
ANLUNAsset SubnumberANLN2CHAR8*
ANLUNIData origin indicatorINHERCHAR2
DAUFNStanding order numberDAUFNCHAR24
DAUFNIData origin of standing order number fieldINH_DAUFNICHAR2
AUFNRSettlement orderILOM_ORDSTCHAR24
AUFNRIData origin for settlement order fieldINH_AUFNRICHAR2
TPLNRIData origin for functional location fieldINH_TPLNRICHAR2
VKORGSales OrganizationVKORGCHAR8
VKORGIData origin for sales organization fieldINH_VKORGICHAR2
VTWEGDistribution ChannelVTWEGCHAR4
VTWEGIData origin of distribution channel fieldINH_VTWEGICHAR2
SPARTDivisionSPARTCHAR4
SPARTIData origin for division fieldINH_SPARTICHAR2
ADRNRAddress NumberAD_ADDRNUMCHAR20*
ADRNRIData origin for address fieldINH_ADRNRICHAR2
OWNERObject reference indicatorILOM_OWNERCHAR2
VKBURSales officeVKBURCHAR8*
VKGRPSales groupVKGRPCHAR6*
SYSTEM_STATUSDisplay lines for system statusILOM_STTXSCHAR80
USER_STATUSDisplay lines for user statusILOM_STTXUCHAR80
SYST_STATUS_CODENameTXT50CHAR100
USER_STATUS_CODENameTXT50CHAR100
.INCLUDEIFLOTX_INC0
PLTXTDescription of functional locationPLTXTCHAR80
KZLTXLong Text ExistsILOM_KZLTXCHAR2
KZMLAPrimary language indicator for text segmentKZMLACHAR2
PLTXUDescription of functional location in capital lettersILOM_PLTXUCHAR80
TEXTCHANGEDDATETIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)TZNTSTMPSDEC8
ARBPL_LOCWork CenterARBPLCHAR16
ARBPL_LOC_TEXTShort descriptionCR_KTEXTCHAR80
ARBPLWork CenterARBPLCHAR16
ARBPL_TEXTShort descriptionCR_KTEXTCHAR80
TYPTXDescription of functional location categoryFLTTXCHAR60
EARTXText for Object TypeEARTXCHAR40
STORT_TEXTText, Length 40TXT40CHAR80
BEBER_TEXTText, Length 40TXT40CHAR80
TPLNR_EXTFunction location - external formatCHAR80
TPLMA_EXTSuperior Function location - external formatCHAR80
Privacy Policy