/SMERP/STG_PM009

Data staging - Func. Loc. List Set - Meas. Pts - cmplex tab | #masterdata | #language | Component: Mobile Application Integration - ERP Core
Column Name Description
MANDT Client
DSF_GUID DSF GUID
Column Name Description
Column Name Description
Column Name Description
ERDAT Date on which the object was created
AEDAT Date on which the object was last changed
P_IDATE Date of the Measurement
P_ITIME Time of Measurement
Column Name Description
PSORTR Indicator: Position Number Comes From Reference MeasPoint Show values
KZLTX Long Text Exists Show values
IRFMP Indicator: MeasPoint Is a Reference Measuring Point Show values
INACT Indicator: Measuring Point Inactive Show values
LVORM Deletion Flag for 2-Level Deletion Logic Show values
ATINNR Indicator: Charac Comes From Reference Measuring Point Show values
DECIM Number of Decimal Places for Number Display Show values
DESIRI Indicator: Associated Number Field Contains a Value Show values
DESIRR Indicator: Target Value Comes From Reference Measuring Point Show values
DSTXTR Indicator: Additional Text Comes From Reference MeasPoint Show values
MRMINI Indicator: Associated Number Field Contains a Value Show values
MRMAXI Indicator: Associated Number Field Contains a Value Show values
INDCT Indicator to Show that Measuring Point Is a Counter Show values
INDRV Indicator: Counter Runs Backwards Show values
INDTR Indicator That Measurement Reading Transfer is Supported Show values
CJUMPI Indicator: Associated Number Field Contains a Value Show values
PYEARI Indicator: Associated Number Field Contains a Value Show values
CODGRR Indicator: Code Group Comes From Reference Measuring Point Show values
CDSUF Indicator: Valuation Code Sufficient for Measurmnt. Document Show values
MODTR Mode of Counter Reading Transfer Show values
INDTRR Indicator: Measurement Transfer Comes from Ref. Meas. Point Show values
ATFOR Data type of characteristic Show values
ATVOR Indicator: Negative Values Allowed Show values
PREV_DOC Checkbox Show values
Column Name Description Domain name
DSF_DSTORE_ID Data Store ID /SMFND/DSF_DSTORE_ID
USER_GUID User GUID SYSUUID_C
DSF_RECORD_ID DSF Record ID NUM10
DSF_CHANGED_BY Last Changed By USNAM
DSF_CHANGED_TS Changed time stamp TZNTSTMPS
POINT Measuring Point IMRC_POINT
PSORT Position Number of the Object Measuring Point (Sort Field) CHAR20
PTTXT Description of Measuring Point TEXT40
ERNAM Name of User Who Created the Object USNAM
AENAM Name of the user who last changed the object USNAM
EXPON Power of Ten Exponent for Floating Point Display IMRC_EXPON
DESIR Measuring Point Target Value IMRC_FLTPS
DSTXT Aditional Short Text for Measuring Point TEXT40
MRMIN Lower Measurement Range Limit/Minimum Total Counter Reading IMRC_FLTPS
MRMAX Upper Measurement Range Limit/Maximum Total Counter Reading IMRC_FLTPS
CJUMP Counter Overflow Reading in SI Unit IMRC_FLTPS
PYEAR Annual Estimate in SI Unit IMRC_FLTPS
ATNAM Characteristic Name ATNAM
ATDIM Exponent display EXP10
ANZDZ Number of Decimal Places ANZDZ
AUSWAHLMGE Selected Set QAUSWAHLMG
TPLNR Functional Location TPLNR
EQUNR Equipment Number EQUNR
STATION Character field of length 40 CHAR40
ACTION Single-Character Flag CHAR1
LIMIT_MIN_CHAR Value in target unit CHAR22
LIMIT_MIN_CHAR1 Value in target unit CHAR22
LIMIT_MAX_CHAR Value in target unit CHAR22
LIMIT_MAX_CHAR1 Value in target unit CHAR22
ROLLOVER_CHAR Value in target unit CHAR22
ANNUAL_CHAR Value in target unit CHAR22
TARGET_CHAR Value in target unit CHAR22
UOM_CHAR Value in target unit CHAR22
P_MDOCM Measurement Document IMRC_MDOCM
P_READG Measurement Reading/Total Counter Reading in SI Unit IMRC_FLTPS
P_CNTRR Counter Reading in SI Unit IMRC_FLTPS
P_CDIFF Counter Reading Difference in SI Unit IMRC_FLTPS
P_CODCT Catalog Type - Measurement Reading Valuation Code QKATART
P_CODGR Code Group - Measurement Reading Valuation Code QCODEGRP
P_VLCOD Valuation Code QCODE
P_READG_CHAR Value in target unit CHAR22
P_CNTRR_CHAR Value in target unit CHAR22
P_CDIFF_CHAR Value in target unit CHAR22
P_MDTXT Measurement Document Text TEXT40
P_CODETXT Short Text for Code QKURZTEXT
ATINN_EXT null
TPLNR_EXT null
ATBEZ Characteristic description TEXT30
Master Data Relations Join Conditions
Internal characteristic
  • Internal characteristic
  • ?
  • /SMERP/STG_PM009.MANDT == CABN.MANDT
  • /SMERP/STG_PM009.ATINN == CABN.ATINN
  • /SMERP/STG_PM009.[column in domain "ADZHL"] == CABN.ADZHL
Technical Object Authorization Group
  • /SMERP/STG_PM009.MANDT == T370B.MANDT
  • /SMERP/STG_PM009.BEGRU == T370B.BEGRU
Catalog Type - Measurement Reading Valuation Code
  • /SMERP/STG_PM009.MANDT == TQ15.MANDT
  • /SMERP/STG_PM009.CODCT == TQ15.KATALOGART
Code Group - Measurement Reading Valuation Code
  • Catalog Type - Measurement Reading Valuation Code
  • Client
  • Code Group - Measurement Reading Valuation Code
  • /SMERP/STG_PM009.CODCT == QPGR.KATALOGART
  • /SMERP/STG_PM009.MANDT == QPGR.MANDT
  • /SMERP/STG_PM009.CODGR == QPGR.CODEGRUPPE
Assembly for Localization of Measuring Point
  • Assembly for Localization of Measuring Point
  • Client
  • /SMERP/STG_PM009.LOCAS == MARA.MATNR
  • /SMERP/STG_PM009.MANDT == MARA.MANDT
Language Key /SMERP/STG_PM009.MLANG == T002.SPRAS
Measuring Point Category
  • Measuring Point Category
  • Client
  • /SMERP/STG_PM009.MPTYP == T370P.MPTYP
  • /SMERP/STG_PM009.MANDT == T370P.MANDT
Measurement Range Unit
  • /SMERP/STG_PM009.MANDT == T006.MANDT
  • /SMERP/STG_PM009.MRNGU == T006.MSEHI
Reference Meas.Pt
  • Reference Meas.Pt
  • Client
  • /SMERP/STG_PM009.REFMP == IMPTT.POINT
  • /SMERP/STG_PM009.MANDT == IMPTT.MANDT
Measuring Point from Which Meas. Reading Was Transferred
  • Measuring Point from Which Meas. Reading Was Transferred
  • Client
  • /SMERP/STG_PM009.TRANS == IMPTT.POINT
  • /SMERP/STG_PM009.MANDT == IMPTT.MANDT