EWMINSPDETAIL

Inspection List Detail | #masterdata | Component: Processing
Column Name Description
MANDT FK Client
CAMPAIGN FK Campaigns for inspections
OBJNR FK Object number
Column Name Description
Column Name Description
Column Name Description
LAST_INSP_DATE Date of last inspection
NEXT_INSP_DATE Date of next inspection
SERVICE_DATE Date when order or notification are scheduled
COMPLETION_DATE Completion date for inspection order or notification
Column Name Description
KZ_TECHINST Equipment is a technical installation Show values
ABLEIN_EINDEUTIG Meter reading unit is unique Show values
Column Name Description Domain name
VSTELLE Premise VSTELLE
HOUSENUM House number (numerical part) NUMC10
PERIOD_M Period for inspections in months INT4
PERIOD_Y Period for inspections in years INT4
AUFTRAG Order Number AUFNR
MELDUNG Notification Number QMNUM
DUMMY1 Dummy function in length 1 DUMMY
Master Data Relations Join Conditions
Meter Reading Unit
  • EWMINSPDETAIL.MANDT == TE422.MANDT
  • EWMINSPDETAIL.ABLEINHEIT == TE422.TERMSCHL
Campaigns for inspections
City Code for City/Street File
  • Country/Region Key
  • Client
  • City Code for City/Street File
  • EWMINSPDETAIL.COUNTRY == ADRCITY.COUNTRY
  • EWMINSPDETAIL.MANDT == ADRCITY.CLIENT
  • EWMINSPDETAIL.CITY_CODE == ADRCITY.CITY_CODE
Country/Region Key
  • Country/Region Key
  • Client
  • EWMINSPDETAIL.COUNTRY == T005.LAND1
  • EWMINSPDETAIL.MANDT == T005.MANDT
Device Location
  • EWMINSPDETAIL.MANDT == IFLOT.MANDT
  • EWMINSPDETAIL.DEVLOC == IFLOT.TPLNR
Type of Technical Object
  • EWMINSPDETAIL.MANDT == T370K.MANDT
  • EWMINSPDETAIL.EQART == T370K.EQART
Equipment Number
  • Equipment Number
  • Client
  • EWMINSPDETAIL.EQUNR == EQUI.EQUNR
  • EWMINSPDETAIL.MANDT == EQUI.MANDT
Connection Object
  • EWMINSPDETAIL.MANDT == IFLOT.MANDT
  • EWMINSPDETAIL.HAUS == IFLOT.TPLNR
Client EWMINSPDETAIL.MANDT == T000.MANDT
Notification code
Order Code
Regional structure grouping
Division
  • EWMINSPDETAIL.MANDT == TSPA.MANDT
  • EWMINSPDETAIL.SPARTE == TSPA.SPART
Street Number for City/Street File
  • Country/Region Key
  • Street Number for City/Street File
Type of premise
  • Type of premise
  • Client
  • EWMINSPDETAIL.VBSART == TE102.VBSART
  • EWMINSPDETAIL.MANDT == TE102.MANDT