ADR13

Transparent Table Application Table
18 Fields

Pager (Business Address Services)

ADR13 is an SAP database table in S/4HANA. Pager (Business Address Services). It contains 18 fields.

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_FLGDFAD Standard addr.
flg_nouse AD_FLNOUSE Do not use
home_flag AD_FLGHOME Home Address
pager_serv AD_PAGSERV Pager service
pager_nmbr AD_PAGNMBR Pager no.
pager_long AD_PGNRLNG Pager no.
pager_call AD_PAGNRCL Sender number (Pagr)
dft_receiv AD_CONSREF Reference Seq.No.
r3_user AD_CONSREF Reference Seq.No.
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.

-- Pager (Business Address Services)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ADR13 (
    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 addr. [AD_FLGDFAD]
    FLG_NOUSE,   -- Do not use [AD_FLNOUSE]
    HOME_FLAG,   -- Home Address [AD_FLGHOME]
    PAGER_SERV,  -- Pager service [AD_PAGSERV]
    PAGER_NMBR,  -- Pager no. [AD_PAGNMBR]
    PAGER_LONG,  -- Pager no. [AD_PGNRLNG]
    PAGER_CALL,  -- Sender number (Pagr) [AD_PAGNRCL]
    DFT_RECEIV,  -- Reference Seq.No. [AD_CONSREF]
    R3_USER,     -- Reference Seq.No. [AD_CONSREF]
    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