V_EHAU_ADDRNR SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




ABAP Code to SELECT data from V_EHAU_ADDRNR
Related tables to V_EHAU_ADDRNR
Access table V_EHAU_ADDRNR




Table View field list including key, data, relationships and ABAP select examples

V_EHAU_ADDRNR is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.

The V_EHAU_ADDRNR table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include HAUS (Functional Location), COUNC (County Code), REGIOGROUP (Regional structure grouping), REGPOLIT (Political regional structure element).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP V_EHAU_ADDRNR table view fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
HAUSFunctional Location TPLNRCHAR30IFLOTTPLNRTPLNRIFLIFLM
COUNCCounty Code COUNCCHAR3Assigned to domainCOUNC
REGIOGROUPRegional structure grouping REGIOGROUPCHAR8Assigned to domainREGIOGROUP
REGPOLITPolitical regional structure element REGPOLITCHAR8Assigned to domainREGPOLITTE227
REGIOGROUP_PERMRegional structure group for supply permit processing REGIOGROUP_PERMITCHAR8Assigned to domainREGIOGROUP
CRM_GUIDCRM GUID of Connection Object EHAU_GUIDRAW16SYSUUID
TPLNRFunctional Location TPLNRCHAR30Assigned to domainTPLNRTPLNRIFLIFLM
MLANGPrimary language for object texts MLANGLANG1T002ISOLASPRAS
TPLKZFunctional location structure indicator TPLKZCHAR5T370STPLKZISR
FLTYPFunctional location category FLTYPCHAR1T370FFLTYPIFT
TPLMASuperior functional location TPLMACHAR30IFLOTTPLNRTPLNRIFLM
ERDATDate on which the object was created ICRDTDATS8DATUM
ERNAMName of User Who Created the Object ICRNACHAR12USNAM
AEDATDate on which the object was last changed IUPDTDATS8DATUM
AENAMName of the user who last changed the object IUPNACHAR12USNAM
DATABStart-up Date of the Technical Object ILOM_DATABDATS8DATUM
BEGRUTechnical object authorization group IAUTGCHAR4T370BIAUTG
TRPNRReference functional location TRPNRCHAR30IRLOTTRPNRIRLIRLM
SUBMTConstruction type material of the object SUBMTCHAR18MARAMATN1MATNRMAT
SUBMTIData origin for construction type field INH_SUBMTICHAR1INHER
IEQUIInstallation of equipment allowed at the functional location IEQUICHAR1X
IEQUIIData origin for equip. inst. allowed field INH_IEQUIICHAR1INHER
EINZLSingle equipment installation at functional location EINZLCHAR1XFELD
EINZLIData origin for authorization group field INH_BEGRUICHAR1INHER
IWERKMaintenance Planning Plant IWERKCHAR4T399IWERKSIWK
IWERKIData origin for planning plant field INH_IWERKICHAR1INHER
INGRPPlanner Group for Customer Service and Plant Maintenance INGRPCHAR3T024IINGRPIHG
INGRPIData origin for maintenance planner group field INH_INGRPICHAR1INHER
PM_OBJTYObject Type of CIM Resources for Work Center PM_OBJTYCHAR2CR_OBJTY
OBJNRObject number J_OBJNRCHAR22ONR00J_OBJNRONR
POSNRPosition in superior technical object ILOM_POSNRCHAR4CHAR4
ISTYPObject category for Industry Solutions (IS) ILOM_ISTYPCHAR1ILOM_ISTYP
PREMSPremise ILOM_PREMSCHAR10CHAR10
EQARTType of Technical Object EQARTCHAR10T370KEQART
INVNRInventory number INVNRCHAR25INVNR_ANLA
GROESSize/dimension GROSSCHAR18GROES
BRGEWGross Weight BRGEWQUAN13(3) MENG13
GEWEIWeight Unit GEWEIUNIT3T006CUNITMEINS
ANSWTAcquisition Value ANSWTCURR13(2) WERT
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
ANSDTAcquisition date ANDTIDATS8DATUM
HERSTManufacturer of asset HERSTCHAR30TEXT30
HERLDCountry of manufacture HERLDCHAR3T005LAND1
BAUJJYear of construction BAUJJCHAR4GJAHRCJAHR
BAUMMMonth of construction BAUMMCHAR2BAUMM
TYPBZManufacturer model number TYPBZCHAR20TYPBZ
EMATNMaterial Number Corresponding to Manufacturer Part Number EMATNCHAR18Assigned to domainMATN1MATNRHTN
SERGEManufacturer serial number SERGECHAR30CHAR30
HANDLESAP Development Reserve: Integration of Date Segment (Key) ITOBTMP_TSEGGUIDCHAR22SYSUUID_22
TSEGTPSAP Development Reserve: Integration Date Segment (Tempate) ITOBTMP_TSEGTEMPLACHAR10Assigned to domainTMPLATSEGTEMPLA
FLLB_DUTYLogbook Duty DIACL_DUTYCHAR1XFLAG
FLLB_HIDEHide Logbook Display DIACL_HIDECHAR1XFLAG
IFLOT_SRTYPEShift Report Type for Object ILOM_SR_SRTYPECHAR10
IFLOT_SNTYPENotification Type for Shift Note for Object ILOM_SN_SNTYPECHAR2TQ80QMART
ILOANLocation and account assignment for technical object ILOANCHAR12Assigned to domainILOAN
ADDRNUMBERAddress number AD_ADDRNUMCHAR10ADRCALPHAAD_ADDRNUMADR
SWERKMaintenance plant SWERKCHAR4T001WWERKSSWK
SWERKIData origin for maintenance plant field INH_SWERKICHAR1INHER
OWNERObject reference indicator ILOM_OWNERCHAR1ILOM_OWNER

Key field Non-key field



How do I retrieve data from SAP table V_EHAU_ADDRNR using ABAP code

The following ABAP code Example will allow you to do a basic selection on V_EHAU_ADDRNR to SELECT all data from the table
DATA: WA_V_EHAU_ADDRNR TYPE V_EHAU_ADDRNR.

SELECT SINGLE *
FROM V_EHAU_ADDRNR
INTO CORRESPONDING FIELDS OF WA_V_EHAU_ADDRNR
WHERE...

How to access SAP table V_EHAU_ADDRNR

Within an ECC or HANA version of SAP you can also view further information about V_EHAU_ADDRNR and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!