ADR3

Transparent Table Application Table
19 Fields 8 CDS Views

Faxnummern (Business Address Services)

ADR3 is an SAP database table in S/4HANA. Faxnummern (Business Address Services). It contains 19 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
CUAN_TG_TEAM_MEMBER_SEARCH view left_outer AT_TG_TEAM_MEMBER_SEARCH
cuan_user_search view left_outer User Search
Fclm_Bm_Address view left_outer Address data for bank master and business partner
fiscds_adr3_fax view inner User Fax Data
I_AddressFaxNumber view from BASIC Address Fax Number
I_AddressFaxNumber_2 view_entity from BASIC Fax Number
I_Addressindependentfax view from BASIC Core View Addr Indp Fax
I_BPContactPersonFaxNumberGov view_entity inner TRANSACTIONAL Base Union for Workplace Fax Number

Fields (19)

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
fax_number ad_fxnmbr Fax
fax_extens ad_fxxtns Extension
faxnr_long ad_fxnrlng Fax Number
faxnr_call ad_faxnrcl Sender number
fax_group ad_fxgrp Fax group
dft_receiv ad_dftrcnr Std.recipient
r3_user ad_r3_user SAP Connection
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.

-- Faxnummern (Business Address Services)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ADR3 (
    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]
    FAX_NUMBER,  -- Fax [ad_fxnmbr]
    FAX_EXTENS,  -- Extension [ad_fxxtns]
    FAXNR_LONG,  -- Fax Number [ad_fxnrlng]
    FAXNR_CALL,  -- Sender number [ad_faxnrcl]
    FAX_GROUP,   -- Fax group [ad_fxgrp]
    DFT_RECEIV,  -- Std.recipient [ad_dftrcnr]
    R3_USER,     -- SAP Connection [ad_r3_user]
    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