/SMERP/STG_PM001

Data staging - Equipment complex table | #masterdata | #language | Component: Mobile Application Integration - ERP Core
Column Name Description
MANDT Client
DSF_GUID DSF GUID
Column Name Description
💲 Currency Key (EQUI.WAERS):
ANSWT Acquisition Value
WDBWT Equipment replacement value
Column Name Description
📏 Unit of weight (EQUI.GEWEI):
BRGEW Weight of object
Column Name Description
ERDAT Date on which the record was created
AEDAT Last Changed On
ANSDT Acquisition date
GWLEN Date on which the warranty ends
GWLDT Guarantee date
AULDT First delivery date of the equipment
INBDT Start-up Date of the Technical Object
GWLDV Warranty date for Sales and Distribution
EQDAT Date, intended for SAP internal use
DATLWB Date of Last Goods Movement
DATBI Valid To Date
TIMBI Equipment usage period time stamp
DATAB Valid-From Date
EZDAT Date, intended for SAP internal use
BLDAT Document Date in Document
ERDAZ Date on which the record was created
AEDAZ Last Changed On
Column Name Description
BAUMM Month of construction Show values
KRFKZ Referenced Configuration Show values
BEGRUI Data origin for authorization group field Show values
S_EQUI Equipment data exists Show values
S_SERIAL Serial data when maintaining equipment Show values
S_KONFI Configuration supported Show values
S_SALE Sales equipment Show values
S_FHM Equip. category relevant to production resources and tools Show values
S_ELSE Indicator: Other Data Active Show values
S_ISU IS-U data Show values
S_FLEET Indicator: Fleet object active Show values
BSTVP Stock Check for Serial Numbers Show values
ACT_CHANGE_AA Change Equipment Master when Changing Asset Show values
S_CC Configuration Control Data Show values
IWERKI Data origin indicator Show values
INGRPI Data origin indicator Show values
PM_OBJTY Object Type of CIM Resources for Work Center Show values
GEWRKI Data origin indicator Show values
TIDNRI Data origin indicator Show values
RBNR_I Data origin indicator Show values
FRCFIT Indicator: Forced Installation/Dismantling Show values
FRCRMV Force Dismantling Flag Show values
KZLTX Long Text Indicator Show values
ABCKZI Data origin for ABC indicator field Show values
EQFNRI Data origin for sort field Show values
SWERKI Data origin for maintenance plant field Show values
STORTI Data origin for location field Show values
MSGRPI Data origin for room number field Show values
BEBERI Data origin for plant section field Show values
CR_OBJTY Object types of the CIM resource Show values
PPSIDI Data origin for PP work center field Show values
GSBERI Data origin for business area field Show values
KOKRSI Data origin for controlling area field Show values
KOSTLI Data origin for cost center field Show values
PROIDI Data origin for WBS element field Show values
BUKRSI Data origin for company code field Show values
ANLNRI Data origin for asset main no./sub-no. fields Show values
ANLUNI Data origin indicator Show values
DAUFNI Data origin of standing order number field Show values
AUFNRI Data origin for settlement order field Show values
TPLNRI Data origin for functional location field Show values
VKORGI Data origin for sales organization field Show values
VTWEGI Data origin of distribution channel field Show values
SPARTI Data origin for division field Show values
ADRNRI Data origin for address field Show values
OWNER Object reference indicator 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
EQUNR Equipment Number EQUNR
ERNAM Name of Person Responsible for Creating the Object USNAM
AENAM Name of Person Who Changed Object USNAM
LVORM SAP Development Reserve: Format CHAR, Length 1 CHAR1
INVNR Inventory number INVNR_ANLA
GROES Size/dimension GROES
HERST Manufacturer of Asset TEXT30
HZEIN Manufacturer drawing number HZEIN
SERGE Manufacturer's Serial Number CHAR30
TYPBZ Manufacturer model number TYPBZ
BAUJJ Year of construction CJAHR
APLKZ Indicator: Task List Exists APLKZ
GERNR Serial Number GERNR
EQBER Technical information, intended for SAP internal use CHAR30
EQNUM Numerical field, intended for SAP internal use NUM9
OBJNR Object number J_OBJNR
CUOBJ Configuration (internal object number) CUOBJ
SERNR Serial Number GERNR
REVLV Revision Level REVLV
S_EQBS EQSI Exists KZEQBS
HANDLE SAP Development Reserve: Integration of Date Segment (Key) SYSUUID_22
TSEGTP SAP Development Reserve: Integration Date Segment (Tempate) TSEGTEMPLA
EMATN Material number corresponding to manufacturer part number MATNR
EQLFN Consecutive numbering of EquipUsagePeriods on same day NUM03
EQUZN Number of next EquipUsagePeriod on same day NUM03
ESTAI SAP Development Reserve: Format CHAR, Length 1 CHAR1
ESTAE SAP Development reserve: Format CHAR, length 4 CHAR4
STNAM SAP Development Reserve: Format CHAR, Length 12 CHAR12
IWERK Maintenance Planning Plant WERKS
SUBMT Construction type material of the object MATNR
MAPAR Manufacturer part number MAPAR
HEQUI Superordinate Equipment EQUNR
HEQNR Equipment position at InstallLoc (Superior Equip./FunctLoc) CHAR4
INGRP Planner Group for Customer Service and Plant Maintenance INGRP
GEWRK Object ID of the Work Center CR_OBJID
TIDNR Technical identification number TIDNR
ILOAN Location and account assignment for technical object ILOAN
KUND1 Customer number KUNNR
KUND2 End customer number KUNNR
KUND3 Operator KUNNR
LIZNR Equipment license number CHAR20
RBNR Catalog Profile RBNR
EZBER Technical information, intended for SAP internal use CHAR30
EZNUM Numerical field, intended for SAP internal use NUM9
IBLNR Physical Inventory Document BELNR
PVS_FOCUS Internal Identification for PVS Objects SYSUUID
PPEGUID Internal Identification for PVS Objects SYSUUID
TECHS Parameter Variant/Standard Variant TECHS
FUNCID Function Identifier CHAR40
SPRAS Language Key SPRAS
EQKTX Description of technical object TEXT40
TXASP Primary language indicator for text segment CHAR1
EQKTU Equipment description in capital letters CHAR40
TPLNR Functional Location TPLNR
ABCKZ ABC Indicator for Technical Object ABCKZ
EQFNR Sort Field CHAR30
SWERK Maintenance Plant WERKS
STORT Location of maintenance object AP_STAND
MSGRP Room CHAR8
BEBER Plant Section BEBER
PPSID Object ID of PP work center CR_OBJID
GSBER Business Area GSBER
KOKRS Controlling Area CACCD
KOSTL Cost Center KOSTL
PROID Work Breakdown Structure Element (WBS Element) PS_POSNR
BUKRS Company Code BUKRS
ANLNR Main Asset Number ANLN1
ANLUN Asset Subnumber ANLN2
DAUFN Standing order number AUFNR
AUFNR Settlement order AUFNR
VKORG Sales Organization VKORG
VTWEG Distribution Channel VTWEG
SPART Division SPART
ADRNR Address Number AD_ADDRNUM
VKBUR Sales office VKBUR
VKGRP Sales group VKGRP
LVORZ SAP Development Reserve: Format CHAR, Length 1 CHAR1
ERNAZ Name of Person Responsible for Creating the Object USNAM
AENAZ Name of Person Who Changed Object USNAM
ARBPL_LOC Work Center ARBPL
ARBPL_LOC_TEXT Short description TEXT40
ARBPL Work Center ARBPL
ARBPL_TEXT Short description TEXT40
TYPTX Equipment category description TEXT30
EARTX Text for Object Type TEXT20
STORT_TEXT Text, Length 40 TEXT40
BEBER_TEXT Text, Length 40 TEXT40
SYSTEM_STATUS Display lines for system status TEXT40
USER_STATUS Display lines for user status TEXT40
SYST_STATUS_CODE Name TEXT50
USER_STATUS_CODE Name TEXT50
TPLNR_EXT null
B_WERK Plant WERKS
B_LAGER Storage location LGORT
B_CHARGE Batch Number CHARG
SOBKZ Special Stock Indicator SOBKZ
KUNNR Special stock customer account number KUNNR
LIFNR Account number of the vendor LIFNR
KDAUF Sales Order Number VBELN
KDPOS Item number in Sales Order NUM06
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_POSNR
DISUB_OWNER Owner of stock LIFNR
Master Data Relations Join Conditions
Technical Object Authorization Group
  • /SMERP/STG_PM001.MANDT == T370B.MANDT
  • /SMERP/STG_PM001.BEGRU == T370B.BEGRU
Batch Number
  • Material Number
  • Client
  • Batch Number
  • /SMERP/STG_PM001.MATNR == MCH1.MATNR
  • /SMERP/STG_PM001.MANDT == MCH1.MANDT
  • /SMERP/STG_PM001.CHARGE == MCH1.CHARG
Vendor number
  • /SMERP/STG_PM001.MANDT == LFA1.MANDT
  • /SMERP/STG_PM001.ELIEF == LFA1.LIFNR
Type of Technical Object
  • /SMERP/STG_PM001.MANDT == T370K.MANDT
  • /SMERP/STG_PM001.EQART == T370K.EQART
Language in Which the Piece of Equipment was Entered /SMERP/STG_PM001.EQASP == T002.SPRAS
EQSE Number
  • /SMERP/STG_PM001.MANDT == EQSE.MANDT
  • /SMERP/STG_PM001.EQSNR == EQSE.EQSNR
Equipment category
  • Equipment category
  • Client
  • /SMERP/STG_PM001.EQTYP == T370T.EQTYP
  • /SMERP/STG_PM001.MANDT == T370T.MANDT
Unit of weight
  • /SMERP/STG_PM001.MANDT == T006.MANDT
  • /SMERP/STG_PM001.GEWEI == T006.MSEHI
Country/Region of Manufacture
  • Country/Region of Manufacture
  • Client
  • /SMERP/STG_PM001.HERLD == T005.LAND1
  • /SMERP/STG_PM001.MANDT == T005.MANDT
Measuring Point
  • Measuring Point
  • Client
  • /SMERP/STG_PM001.IMRC_POINT == IMPTT.POINT
  • /SMERP/STG_PM001.MANDT == IMPTT.MANDT
Configurable Material
  • Configurable Material
  • Client
  • /SMERP/STG_PM001.KMATN == MARA.MATNR
  • /SMERP/STG_PM001.MANDT == MARA.MANDT
Customer to Whom Serial Number was Delivered
  • /SMERP/STG_PM001.MANDT == KNA1.MANDT
  • /SMERP/STG_PM001.KUNDE == KNA1.KUNNR
Storage location
  • Storage location
  • Client
  • Plant
  • /SMERP/STG_PM001.LAGER == T001L.LGORT
  • /SMERP/STG_PM001.MANDT == T001L.MANDT
  • /SMERP/STG_PM001.WERK == T001L.WERKS
Material Number
  • Material Number
  • Client
  • /SMERP/STG_PM001.MATNR == MARA.MATNR
  • /SMERP/STG_PM001.MANDT == MARA.MANDT
Master warranty number
  • Master warranty number
  • Client
  • /SMERP/STG_PM001.MGANR == BGMK.MGANR
  • /SMERP/STG_PM001.MANDT == BGMK.MANDT
Division
  • /SMERP/STG_PM001.MANDT == TSPA.MANDT
  • /SMERP/STG_PM001.SPARTE == TSPA.SPART
Currency Key
  • /SMERP/STG_PM001.MANDT == TCURC.MANDT
  • /SMERP/STG_PM001.WAERS == TCURC.WAERS
Maintenance Plan
  • Maintenance Plan
  • Client
  • /SMERP/STG_PM001.WARPL == MPLA.WARPL
  • /SMERP/STG_PM001.MANDT == MPLA.MANDT
Plant
  • /SMERP/STG_PM001.MANDT == T001W.MANDT
  • /SMERP/STG_PM001.WERK == T001W.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Stock Type of Goods Movement (Primary Posting)
  • Stock Type of Goods Movement (Primary Posting)
  • Special Stock Indicator
  • /SMERP/STG_PM001.LBBSA == T156C.LBBSA
  • /SMERP/STG_PM001.SOBKZ == T156C.SOBKZ