ADRCT

Transparent Table Application Table
7 Fields 3 CDS Views

Texte zu Adressen (Business Address Services)

ADRCT is an SAP database table in S/4HANA. Texte zu Adressen (Business Address Services). It contains 7 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
Fclm_Bm_Address view left_outer Address data for bank master and business partner
P_ADDRESSTEXT view from CONSUMPTION Text view for Address
P_REFERENCEADDRESSTEXT view from CONSUMPTION Reference Address

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY addrnumber ad_addrnum Address Number
KEY date_from ad_date_fr From
KEY nation ad_nation Address Version
KEY langu spras Language
remark ad_remark1 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 Adressen (Business Address Services)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ADRCT (
    CLIENT,      -- Client [mandt]
    ADDRNUMBER,  -- Address Number [ad_addrnum]
    DATE_FROM,   -- From [ad_date_fr]
    NATION,      -- Address Version [ad_nation]
    LANGU,       -- Language [spras]
    REMARK,      -- Notes [ad_remark1]
    _DATAAGING,  -- Data Aging [data_temperature]
    PRIMARY KEY (CLIENT, ADDRNUMBER, DATE_FROM, NATION, LANGU)
);

Learn More