ADR2

Transparent Table Application Table
18 Fields 24 CDS Views

Telephone Numbers (Business Address Services)

ADR2 is an SAP database table in S/4HANA. Telephone Numbers (Business Address Services). It contains 18 fields. 24 CDS views read from this table.

CDS Views using this table (24)

ViewTypeJoinVDMDescription
/SAM4U/BTL_L_USER view left_outer User
/SCMTMS/CV_LocQuByPhysAdd view left_outer Obsolete: Use CDS View /SCMTMS/VE_LocQuByPhysAdd
/SCMTMS/VE_LocQuByPhysAdd view_entity left_outer BOPF: Location Query By Physical Address
Fclm_Bm_Address view left_outer Address data for bank master and business partner
fiscds_adr2_mphone view inner User Mobile Phone Numbers
fiscds_adr2_phone view inner User Phone Numbers
FNDEI_ADR2_BLOCKINGINFO view from Filter View for table ADR2
fndei_adr2_filter view from Filter View for table ADR2
I_AddressPhoneNumber view from BASIC Address Phone Number
I_AddressPhoneNumber_2 view_entity from BASIC Phone Number
I_BPContactPersonMblNumberGov view_entity inner TRANSACTIONAL Base Union for Workplace Mbl Number
I_BPContactPersonTelNumberGov view_entity inner TRANSACTIONAL Base Union for Workplace Tel Number
I_PrmtHbSupplierContactCard view inner BASIC Supplier Data for Contact Card
ICM_BP_ADDR_INDP view left_outer BusinessPartner_Address_Indep
ICM_EMPLOYEE_CONTACT view left_outer Employee
ICM_PARTNER_CONTACT view left_outer BusinessPartner_contact
ICM_PARTNER_ORGANIZATION view left_outer BusinessPartner_Organization
ICM_PARTNER_PERSON view left_outer BusinessPartner_person
P_Bpcontacts_Mobilephone view from BASIC
P_Bpcontacts_Telephone view from BASIC
P_DDMRPController view left_outer BASIC
P_FrcElmntOrgAddrPhoneNumber view from BASIC
P_MobileNumbers view from BASIC
P_TelephoneNumbers view from BASIC

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY addrnumber AD_ADDRNUM Address Number
KEY persnumber AD_PERSNUM Person Number
KEY date_from AD_DATE_FR From
KEY consnumber AD_CONSNUM Sequence Number
country AD_COMCTRY Country/Region
flgdefault AD_FLGDFNR Standard No.
flg_nouse AD_FLNOUSE Do not use
home_flag AD_FLGHOME Home Address
tel_number AD_TLNMBR Telephone
tel_extens AD_TLXTNS Extension
telnr_long AD_TELNRLG Telephone no.
telnr_call AD_TELNRCL Caller number
dft_receiv AD_FLGSMS SMS-Enab.
r3_user AD_FLGMOB Mobile phone
valid_from AD_VALFROM Valid From
valid_to AD_VALTO Valid To
_dataaging DATA_TEMPERATURE Data Aging

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Telephone Numbers (Business Address Services)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ADR2 (
    CLIENT,      -- Client [MANDT]
    ADDRNUMBER,  -- Address Number [AD_ADDRNUM]
    PERSNUMBER,  -- Person Number [AD_PERSNUM]
    DATE_FROM,   -- From [AD_DATE_FR]
    CONSNUMBER,  -- Sequence Number [AD_CONSNUM]
    COUNTRY,     -- Country/Region [AD_COMCTRY]
    FLGDEFAULT,  -- Standard No. [AD_FLGDFNR]
    FLG_NOUSE,   -- Do not use [AD_FLNOUSE]
    HOME_FLAG,   -- Home Address [AD_FLGHOME]
    TEL_NUMBER,  -- Telephone [AD_TLNMBR]
    TEL_EXTENS,  -- Extension [AD_TLXTNS]
    TELNR_LONG,  -- Telephone no. [AD_TELNRLG]
    TELNR_CALL,  -- Caller number [AD_TELNRCL]
    DFT_RECEIV,  -- SMS-Enab. [AD_FLGSMS]
    R3_USER,     -- Mobile phone [AD_FLGMOB]
    VALID_FROM,  -- Valid From [AD_VALFROM]
    VALID_TO,    -- Valid To [AD_VALTO]
    _DATAAGING,  -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (CLIENT, ADDRNUMBER, PERSNUMBER, DATE_FROM, CONSNUMBER)
);

Learn More