SAP ABAP Table EWMINSPDETAIL (Inspection List Detail)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-WM-PC (Application Component) Processing
     ⤷ EEWM_HIK (Package) IS-U: Inspections

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	EWMINSPDETAIL	Table Relationship Diagram
Short Description	Inspection List Detail

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	CAMPAIGN	☑	EEWM_CAMPAIGN	CHAR030	CHAR	30	0	Campaigns for inspections	EWMINSPHEAD
3	OBJNR	☑	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
4	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
5	KZ_TECHINST	☐	KZ_TECHINST	KENNZX	CHAR	1	0	Equipment is a technical installation
6	VSTELLE	☐	VSTELLE	VSTELLE	CHAR	10	0	Premise	*
7	SPARTE	☐	SPARTE	SPART	CHAR	2	0	Division	TSPA
8	REGIOGROUP	☐	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping	ADRREGGRP
9	ABLEINHEIT	☐	ABLEINHEIT	ABLEINHEIT	CHAR	8	0	Meter reading unit	TE422
10	ABLEIN_EINDEUTIG	☐	EEWM_KZ_ABLEIN_EINDEUTIG	KENNZX	CHAR	1	0	Meter reading unit is unique
11	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
12	CITY_CODE	☐	CITY_CODE	CITY_CODE	CHAR	12	0	City Code for City/Street File	ADRCITY
13	STREETCODE	☐	AD_STRNUM	STRT_CODE	CHAR	12	0	Street Number for City/Street File	ADRSTREET
14	HOUSENUM	☐	HOUSENUM	NUMC10	NUMC	10	0	House number (numerical part)
15	VBSART	☐	VBSART	VBSART	CHAR	8	0	Type of premise	TE102
16	EQART	☐	EQART	EQART	CHAR	10	0	Type of Technical Object	T370K
17	LAST_INSP_DATE	☐	EEWM_LAST_INSPECTION	DATS	DATS	8	0	Date of last inspection
18	NEXT_INSP_DATE	☐	EEWM_NEXT_INSPECTION	DATS	DATS	8	0	Date of next inspection
19	PERIOD_M	☐	EEWM_INSP_PERIOD_M	INT4	INT4	10	0	Period for inspections in months
20	PERIOD_Y	☐	EEWM_INSP_PERIOD_Y	INT4	INT4	10	0	Period for inspections in years
21	DEVLOC	☐	DEVLOC	TPLNR	CHAR	30	0	Device Location	IFLOT
22	HAUS	☐	HAUS	TPLNR	CHAR	30	0	Connection Object	IFLOT
23	ORDER_CODE	☐	ORDER_CODE	CHAR004	CHAR	4	0	Order Code	TEWOCODES
24	NOTIF_CODE	☐	NOTIF_CODE	CHAR004	CHAR	4	0	Notification code	TENOCODES
25	AUFTRAG	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
26	MELDUNG	☐	QMNUM	QMNUM	CHAR	12	0	Message Number	*
27	SERVICE_DATE	☐	EEWM_PLANNED_SERVICE_DATE	DATS	DATS	8	0	Date when order or notification are scheduled
28	COMPLETION_DATE	☐	EEWM_COMPLETION_DATE	DATS	DATS	8	0	Completion date for inspection order or notification
29	.INCLUDE	☐				0	0	Include customer-specific fields in inspection list
30	DUMMY1	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
31	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EWMINSPDETAIL	ABLEINHEIT	TE422	TERMSCHL
2	EWMINSPDETAIL	CAMPAIGN	EWMINSPHEAD	CAMPAIGN
3	EWMINSPDETAIL	CITY_CODE	ADRCITY	CITY_CODE
4	EWMINSPDETAIL	COUNTRY	T005	LAND1
5	EWMINSPDETAIL	DEVLOC	IFLOT	TPLNR
6	EWMINSPDETAIL	EQART	T370K	EQART
7	EWMINSPDETAIL	EQUNR	EQUI	EQUNR
8	EWMINSPDETAIL	HAUS	IFLOT	TPLNR
9	EWMINSPDETAIL	MANDT	T000	MANDT
10	EWMINSPDETAIL	NOTIF_CODE	TENOCODES	NOTIF_CODE
11	EWMINSPDETAIL	OBJNR	ONR00	OBJNR
12	EWMINSPDETAIL	ORDER_CODE	TEWOCODES	ORDER_CODE
13	EWMINSPDETAIL	REGIOGROUP	ADRREGGRP	REGIOGROUP
14	EWMINSPDETAIL	SPARTE	TSPA	SPART
15	EWMINSPDETAIL	STREETCODE	ADRSTREET	STRT_CODE
16	EWMINSPDETAIL	VBSART	TE102	VBSART

History

Last changed by/on	SAP	20130529
SAP Release Created in