SAP ABAP Table V_EHAU (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_EHAU	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
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	HAUS	☑	TPLNR	TPLNR	CHAR	30	0	Functional Location	IFLOT
3	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code
4	REGIOGROUP	☐	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping
5	REGPOLIT	☐	REGPOLIT	REGPOLIT	CHAR	8	0	Political regional structure element
6	REGIOGROUP_PERM	☐	REGIOGROUP_PERMIT	REGIOGROUP	CHAR	8	0	Regional structure group for supply permit processing
7	CRM_GUID	☐	EHAU_GUID	SYSUUID	RAW	16	0	CRM GUID of Connection Object
8	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location
9	MLANG	☐	MLANG	SPRAS	LANG	1	0	Primary language for object texts	T002
10	TPLKZ	☐	TPLKZ	TPLKZ	CHAR	5	0	Functional location structure indicators	T370S
11	FLTYP	☐	FLTYP	FLTYP	CHAR	1	0	Functional Location Category	T370F
12	TPLMA	☐	TPLMA	TPLNR	CHAR	30	0	Superior functional location	IFLOT
13	ERDAT	☐	ICRDT	DATUM	DATS	8	0	Date on Which Object Was Created
14	ERNAM	☐	ICRNA	USNAM	CHAR	12	0	Name of User Who Created the Object
15	AEDAT	☐	IUPDT	DATUM	DATS	8	0	Date on which the object was last changed
16	AENAM	☐	IUPNA	USNAM	CHAR	12	0	Name of the User Who Last Changed the Object
17	DATAB	☐	ILOM_DATAB	DATUM	DATS	8	0	Start-up Date of the Technical Object
18	BEGRU	☐	IAUTG	IAUTG	CHAR	4	0	Authorization Group for Technical Object	T370B
19	TRPNR	☐	TRPNR	TRPNR	CHAR	30	0	Reference functional location	IRLOT
20	SUBMT	☐	SUBMT	MATNR	CHAR	18	0	Construction Type Material of the Object	MARA
21	SUBMTI	☐	INH_SUBMTI	INHER	CHAR	1	0	Data origin for construction type field
22	IEQUI	☐	IEQUI	X	CHAR	1	0	Installation of equipment allowed at the functional location
23	IEQUII	☐	INH_IEQUII	INHER	CHAR	1	0	Data origin for equip. inst. allowed field
24	EINZL	☐	EINZL	XFELD	CHAR	1	0	Single equipment installation at functional location
25	EINZLI	☐	INH_BEGRUI	INHER	CHAR	1	0	Data origin for authorization group field
26	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	T399I
27	IWERKI	☐	INH_IWERKI	INHER	CHAR	1	0	Data origin for planning plant field
28	INGRP	☐	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	T024I
29	INGRPI	☐	INH_INGRPI	INHER	CHAR	1	0	Data origin for maintenance planner group field
30	PM_OBJTY	☐	PM_OBJTY	CR_OBJTY	CHAR	2	0	Object Type of CIM Resources for Work Center
31	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
32	POSNR	☐	ILOM_POSNR	CHAR4	CHAR	4	0	Position in superior technical object
33	ISTYP	☐	ILOM_ISTYP	ILOM_ISTYP	CHAR	1	0	Object category for Industry Solutions (IS)
34	PREMS	☐	ILOM_PREMS	CHAR10	CHAR	10	0	Premise
35	EQART	☐	EQART	EQART	CHAR	10	0	Type of Technical Object	T370K
36	INVNR	☐	INVNR	INVNR_ANLA	CHAR	25	0	Inventory number
37	GROES	☐	GROSS	GROES	CHAR	18	0	Size/dimension
38	BRGEW	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
39	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
40	ANSWT	☐	ANSWT	WERT	CURR	13	2	Acquisition Value
41	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
42	ANSDT	☐	ANDTI	DATUM	DATS	8	0	Acquisition date
43	HERST	☐	HERST	TEXT30	CHAR	30	0	Manufacturer of asset
44	HERLD	☐	HERLD	LAND1	CHAR	3	0	Country of manufacture	T005
45	BAUJJ	☐	BAUJJ	CJAHR	CHAR	4	0	Year of construction
46	BAUMM	☐	BAUMM	BAUMM	CHAR	2	0	Month of construction
47	TYPBZ	☐	TYPBZ	TYPBZ	CHAR	20	0	Manufacturer model number
48	EMATN	☐	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number
49	SERGE	☐	SERGE	CHAR30	CHAR	30	0	Manufacturer serial number
50	HANDLE	☐	ITOBTMP_TSEGGUID	SYSUUID_22	CHAR	22	0	SAP Development Reserve: Integration of Date Segment (Key)
51	TSEGTP	☐	ITOBTMP_TSEGTEMPLA	TSEGTEMPLA	CHAR	10	0	SAP Development Reserve: Integration Date Segment (Template)
52	FLLB_DUTY	☐	DIACL_DUTY	XFLAG	CHAR	1	0	Logbook Duty
53	FLLB_HIDE	☐	DIACL_HIDE	XFLAG	CHAR	1	0	Hide Logbook Display
54	IFLOT_SRTYPE	☐	ILOM_SR_SRTYPE		CHAR	10	0	Shift Report Type for Object
55	IFLOT_SNTYPE	☐	ILOM_SN_SNTYPE	QMART	CHAR	2	0	Notification Type for Shift Note for Object	TQ80
56	ILOAN	☐	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object
57	ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	ADRC
58	SWERK	☐	SWERK	WERKS	CHAR	4	0	Maintenance Plant	T001W
59	SWERKI	☐	INH_SWERKI	INHER	CHAR	1	0	Data origin for maintenance plant field
60	OWNER	☐	ILOM_OWNER	ILOM_OWNER	CHAR	1	0	Object reference indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_EHAU	ADDRNUMBER	ADRC	ADDRNUMBER	REF	1	CN
2	V_EHAU	BEGRU	T370B	BEGRU	REF	C	CN
3	V_EHAU	EQART	T370K	EQART	REF	1	CN
4	V_EHAU	FLTYP	T370F	FLTYP	REF	1	CN
5	V_EHAU	GEWEI	T006	MSEHI	REF	1	CN
6	V_EHAU	HAUS	IFLOT	TPLNR	KEY	1	C
7	V_EHAU	HERLD	T005	LAND1	REF	1	CN
8	V_EHAU	IFLOT_SNTYPE	TQ80	QMART	KEY	1	CN
9	V_EHAU	INGRP	T024I	INGRP	REF	C	CN
10	V_EHAU	IWERK	T399I	IWERK	REF	C	CN
11	V_EHAU	MANDT	T000	MANDT
12	V_EHAU	MLANG	T002	SPRAS	REF	C	CN
13	V_EHAU	OBJNR	ONR00	OBJNR	REF	C	1
14	V_EHAU	SUBMT	MARA	MATNR	REF	C	CN
15	V_EHAU	SWERK	T001W	WERKS	REF	1	CN
16	V_EHAU	TPLKZ	T370S	TPLKZ	REF	1	CN
17	V_EHAU	TPLMA	IFLOT	TPLNR	REF	C	CN
18	V_EHAU	TRPNR	IRLOT	TRPNR	REF	C	CN
19	V_EHAU	WAERS	TCURC	WAERS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in