CRMS4_IU_I_DEV

Device | view: CRMS4IUVIDEV | Extraction: Not supported | Component: S4CRM: Utilities Industry
Tables used: EGERHEGERREGERHEGERREGERSEQUIIFLOT
Column Name Description
equnr Equipment Number
Column Name Description
Column Name Description
Column Name Description
bis null
ab Date from which time slice is valid
einbdat Installation date
ausbdat Device removal date
einbzeit Device Installation Time
ausbzeit Device Removal Time
umbaudat Modification date
aedat Last Changed On
erdat Date on which the record was created
plombdat Date of last lead sealing
Column Name Description
bglstat Certification status Show values
kzstich Status of sample device Show values
eichfael Use calibration validity Show values
bglnetz Certify installed devices Show values
IsDeviceInfoRecord Truth Value: True/False Show values
Column Name Description Domain name
logiknr Logical device number LOGIKNR
primwnr1 Winding number of active primary winding LFDNR2
sekwnr1 Winding number of active secondary winding LFDNR2
primwnr2 Winding number of active primary winding LFDNR2
sekwnr2 Winding number of active secondary winding LFDNR2
kombinat Combination of a device category KOMBINAT
ppm_meter Prepayment Meter PPM_METER
ams Advanced Metering System E_AMI_AMS
amcg_cap_grp Advanced Meter Capability Group (AMCG) E_AMI_CAP_GRP
msg_attr_id Message Attribute E_AMI_MSG_ATTR_ID
cap_act_grp Activation Group for AMI Capabilities (AMICAG) E_AMI_CAPACT_GRP
gerwechs Activity reason GERWECHS
devloc Device Location TPLNR
zeitzone Time Zone for Installation and/or Removal Time TZNZONE
messdrck Measured Pressure (Outlet Pressure) in Bars MESSDRCK
ueberver Transformation ratio UEBERV
umbaugr Modification reason UMBAUGR
aenam Name of Person Who Changed Object USNAM
zspanns Register factor: secondary transformer voltage SPANNUNG
zstroms Register factor: secondary transformer current E_ZSTROMS
zspannp Register factor: primary transformer voltage WSPANNP
zstromp Register factor: primary transformer current E_ZSTROMP
geraet Serial Number GERNR
ernam Name of Person Responsible for Creating the Object USNAM
sparte Division SPART
uii Unique Item Identifier UII_CHAR72
los Sample lot GEGST
besitz Inspection relevance of device BESITZ
bgljahr Certification Year JAHR
wechsel Advance replacement year JAHR
schwgrad Difficulty level: Factor for meter reader payment DEC2_1
bglart Type of certification BGLART
bglnum Certification number CHAR15
parametr Parametrization PARAMETR
plombe Seal code PLOMBE
approvalnr Device inspection number CHAR15
order_code Special Order Code for Dev./Dev. Category in Replacement CHAR004
notif_code Notification code CHAR004
werk Plant WERKS
lager Storage location LGORT
herst Manufacturer of Asset TEXT30
baujj Year of construction CJAHR
typbz Manufacturer model number TYPBZ
s_eqbs EQSI Exists KZEQBS
objnr Object number J_OBJNR
tplma Superior functional location TPLNR
Master Data Relations Join Conditions
Technical Object Authorization Group
  • Technical Object Authorization Group
  • Client
  • CRMS4_IU_I_DEV.BEGRU == T370B.BEGRU
  • CRMS4_IU_I_DEV.MANDT == T370B.MANDT
Device group
  • Client
  • Device group
  • CRMS4_IU_I_DEV.MANDT == EDEVGR.MANDT
  • CRMS4_IU_I_DEV.DEVGRP == EDEVGR.DEVGRP
ARCR Command Group
  • Client
  • ?
  • ARCR Command Group
  • CRMS4_IU_I_DEV.MANDT == EKOG.MANDT
  • CRMS4_IU_I_DEV.[column in domain "PROLFDNR"] == EKOG.PROLFDNR
  • CRMS4_IU_I_DEV.KOMGRP == EKOG.KOMGRP
Loss Determination Group
  • Client
  • Loss Determination Group
  • CRMS4_IU_I_DEV.MANDT == TE1001.MANDT
  • CRMS4_IU_I_DEV.LOSSDTGROUP == TE1001.LOSSDTGROUP
Material Number
  • Client
  • Material Number
  • CRMS4_IU_I_DEV.MANDT == ETYP.MANDT
  • CRMS4_IU_I_DEV.MATNR == ETYP.MATNR
Service Provider for Device Info Record
  • Client
  • Service Provider for Device Info Record
  • CRMS4_IU_I_DEV.MANDT == ESERVPROV.MANDT
  • CRMS4_IU_I_DEV.SERVICE_PROV == ESERVPROV.SERVICEID
Winding group
  • Client
  • Winding group
  • ?
  • CRMS4_IU_I_DEV.MANDT == EWIK.MANDT
  • CRMS4_IU_I_DEV.WGRUPPE == EWIK.WGRUPPE
  • CRMS4_IU_I_DEV.[column in domain "WNUMMER"] == EWIK.WNUMMER