SAP Table EHAU

Connect. Obj.

EHAU (Connect. Obj.) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link EHAU to other SAP tables.

EHAU table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
HAUS Connection Object HAUS CHAR 30 0
SPRAS Language Key SPRAS LANG 1 0
PLTXT Description of functional location PLTXT CHAR 40 0
KZLTX Indicator: More long text exists KZLTX CHAR 1 0
X Yes
NULL No
TPLKZ Functional location structure indicator TPLKZ CHAR 5 0
FLTYP Functional location category FLTYP CHAR 1 0
TPLMA Superior functional location TPLMA CHAR 30 0
DATAB Valid-From Date DATAB DATS 8 0
BEGRU Technical object authorization group IAUTG T370B CHAR 4 0
EINZLI Data origin for authorization group field INH_BEGRUI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
IWERK Maintenance Planning Plant IWERK CHAR 4 0
IWERKI Data origin for planning plant field INH_IWERKI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
POSNR Position in superior technical object ILOM_POSNR CHAR 4 0
ISTYP Object category for Industry Solutions (IS) ILOM_ISTYP CHAR 1 0
D Device location IS-U
C Connection object IS-U
PREMS Premise ILOM_PREMS CHAR 10 0
EQFNR Sort field EQFNR CHAR 30 0
SWERK Maintenance plant SWERK T001W CHAR 4 0
SWERKI Data origin for maintenance plant field INH_SWERKI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
BUKRS Company Code BUKRS CHAR 4 0
BUKRSI Data origin for company code field INH_BUKRSI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
ADDRNUMBER Address number AD_ADDRNUM CHAR 10 0
ADRNRI Data origin for address field INH_ADRNRI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
LVORM Deletion Indicator LVORM CHAR 1 0
X Yes
NULL No
ILOAN Location and account assignment for technical object ILOAN CHAR 12 0
IEQUI Installation of equipment allowed at the functional location IEQUI CHAR 1 0
X Yes
NULL No
IEQUII Data origin for equip. inst. allowed field INH_IEQUII CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
COUNC County Code COUNC T005E CHAR 3 0
REGIOGROUP Regional structure grouping REGIOGROUP ADRREGGRP CHAR 8 0
REGPOLIT Political regional structure element REGPOLIT TE227 CHAR 8 0
REGIOGROUP_PERM Regional structure group for supply permit processing REGIOGROUP_PERMIT ADRREGGRP CHAR 8 0
OBJNR Object number J_OBJNR CHAR 22 0
ERDAT Date on which the object was created ICRDT DATS 8 0
ERNAM Name of User Who Created the Object ICRNA CHAR 12 0
AEDAT Date on which the object was last changed IUPDT DATS 8 0
AENAM Name of the user who last changed the object IUPNA CHAR 12 0
CRM_GUID CRM GUID of Connection Object EHAU_GUID RAW 16 0
STRNO Connection Object Identification AO_STRNO CHAR 40 0

EHAU foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
EHAU BEGRU EHAU MANDT T370B Technical object authorization group MANDT
EHAU BEGRU EHAU BEGRU T370B Technical object authorization group BEGRU
EHAU COUNC * T005E County LAND1
EHAU COUNC * T005E County REGIO
EHAU COUNC EHAU COUNC T005E County COUNC
EHAU COUNC EHAU MANDT T005E County MANDT
EHAU REGIOGROUP EHAU MANDT ADRREGGRP Regional structure grouping CLIENT
EHAU REGIOGROUP EHAU REGIOGROUP ADRREGGRP Regional structure grouping REGIOGROUP
EHAU REGIOGROUP_PERM EHAU MANDT ADRREGGRP Regional structure grouping CLIENT
EHAU REGIOGROUP_PERM EHAU REGIOGROUP_PERM ADRREGGRP Regional structure grouping REGIOGROUP
EHAU REGPOLIT EHAU MANDT TE227 Elements of Political Regional Structure MANDT
EHAU REGPOLIT * TE227 Elements of Political Regional Structure COUNTRY
EHAU REGPOLIT EHAU REGPOLIT TE227 Elements of Political Regional Structure REGPOLIT
EHAU SWERK EHAU MANDT T001W Plants/Branches MANDT
EHAU SWERK EHAU SWERK T001W Plants/Branches WERKS