ADRT

Transparent Table Application Table
9 Fields 2 CDS Views

Texte zu Kommunikationsdaten (Business Address Services)

ADRT is an SAP database table in S/4HANA. Texte zu Kommunikationsdaten (Business Address Services). It contains 9 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_AddressCommunicationRemark view from BASIC Communication Notes
I_AddressCommunicationRemark_2 view_entity from BASIC Remark for Communication Data

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY addrnumber ad_addrnum Address Number
KEY persnumber ad_persnum Person Number
KEY comm_type ad_comm Comm. Method
KEY date_from ad_date_fr From
KEY consnumber ad_consnum Sequence Number
KEY langu spras Language
remark ad_remark2 Notes
_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.

-- Texte zu Kommunikationsdaten (Business Address Services)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ADRT (
    CLIENT,      -- Client [mandt]
    ADDRNUMBER,  -- Address Number [ad_addrnum]
    PERSNUMBER,  -- Person Number [ad_persnum]
    COMM_TYPE,   -- Comm. Method [ad_comm]
    DATE_FROM,   -- From [ad_date_fr]
    CONSNUMBER,  -- Sequence Number [ad_consnum]
    LANGU,       -- Language [spras]
    REMARK,      -- Notes [ad_remark2]
    _DATAAGING,  -- Data Aging [data_temperature]
    PRIMARY KEY (CLIENT, ADDRNUMBER, PERSNUMBER, COMM_TYPE, DATE_FROM, CONSNUMBER, LANGU)
);

Learn More