ADR3

Transparent Table Application Table
19 Fields 6 CDS Views

Fax Numbers (Business Address Services)

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

CDS Views using this table (6)

ViewTypeJoinVDMDescription
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.

-- Fax Numbers (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