EHDMOD_ADR_ROOT SAP (Address - Root) Table details

Dictionary Type: Table
Description: Address - Root




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




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

EHDMOD_ADR_ROOT is a standard SAP Table which is used to store Address - Root data and is available within R/3 SAP systems depending on the version and release level.

The EHDMOD_ADR_ROOT table consists of various fields, each holding specific information or linking keys about Address - Root data available in SAP. These include DB_KEY (NodeID), DATETIME_CR (Date/Time of Item Creation), USER_ID_CR (Object Created By), DATETIME_CH (Date/Time of Item Change).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP EHDMOD_ADR_ROOT table 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 MANDTCLNT3Assigned to domainMANDT
DB_KEYNodeID /BOBF/CONF_KEYRAW16/BOBF/CONF_KEY
DATETIME_CRDate/Time of Item Creation /BOBF/DATETIME_CRDEC15TSTLC/BOBF/TIMESTAMP
USER_ID_CRObject Created By /BOBF/USER_ID_CRCHAR12UNAMEUSER_COMP
DATETIME_CHDate/Time of Item Change /BOBF/DATETIME_CHDEC15TSTLC/BOBF/TIMESTAMP
USER_ID_CHObject Changed By /BOBF/USER_ID_CHCHAR12UNAME
STATUSAddress Status EHDMO_ADR_STATUS_CODECHAR2DFVALEHFND_BO_STATUS_MAST_DATA_CODE
COUNTRYCountry EHDMO_ADR_COUNTRY_CODECHAR3Assigned to domainLAND1EHFND_ELM_COUNTRY_CODE
REGIONRegion Code EHDMO_ADR_REGION_CODECHAR3Assigned to domainREGIOEHFND_ELM_COUNTRY_REGIONS
CITYCity EHDMO_ADR_CITYCHAR40EHDMO_ADR_CITY
POSTAL_CODEPostal Code EHDMO_ADR_POSTAL_CODECHAR10EHDMO_ADR_POSTAL_CODE
STREETStreet EHDMO_ADR_STREETCHAR30EHDMO_ADR_STREET
HOUSE_NUMBERHouse Number EHDMO_ADR_HOUSE_NUMBERDEC11EHDMO_ADR_HOUSE_NUMBER
NOTES_REL_KEYNodeID /BOBF/CONF_KEYRAW16/BOBF/CONF_KEY
EEW_ADDR_ROOT_DTDummy function in length 1 DUMMYCHAR1DUMMY
ATF_KEYNodeID /BOBF/CONF_KEYRAW16/BOBF/CONF_KEY
CONFIDENTIAL_TSConfidential Address Information EHDMO_ADR_CONFID_TSCHAR1EHFND_TRI_STATE
ARCHIVING_STATUSArchiving Status /BOFU/ARCHIVING_STATUS_CODECHAR2/BOFU/ARCHIVING_STATUS_CODE
NAME_KEY_REFNodeID /BOBF/CONF_KEYRAW16/BOBF/CONF_KEY
NOTES_KEY_REFNodeID /BOBF/CONF_KEYRAW16/BOBF/CONF_KEY
DTS_ROOT_KEY_REFData Series Root Key Reference EHDMO_ADR_DTS_ROOT_KEY_REFRAW16EHRKREHDMO_ADR_DTS_ROOT_KEY_REFEHDMO_ELM_ADR_DATA_SERIES
NAME_TXC_REFNodeID /BOBF/CONF_KEYRAW16/BOBF/CONF_KEY
NOTES_TXC_REFNodeID /BOBF/CONF_KEYRAW16/BOBF/CONF_KEY

Key field Non-key field



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

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

SELECT SINGLE *
FROM EHDMOD_ADR_ROOT
INTO CORRESPONDING FIELDS OF WA_EHDMOD_ADR_ROOT
WHERE...

How to access SAP table EHDMOD_ADR_ROOT

Within an ECC or HANA version of SAP you can also view further information about EHDMOD_ADR_ROOT 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!