ADR2

Transparent Table Application Table
18 Fields 24 CDS Views

Telefonnummern (Business Address Services)

ADR2 is an SAP database table in S/4HANA. Telefonnummern (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 Helper View for Query By Phys. 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_PrmtHbCreatorContactCard view inner BASIC Creator Data for Contact Card
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.

-- Telefonnummern (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