ADRCT

Transparent Table Application Table
7 Fields 6 CDS Views

Address Texts (Business Address Services)

ADRCT is an SAP database table in S/4HANA. Address Texts (Business Address Services). It contains 7 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
I_InvgCsMAddressText view from BASIC ICM Address - Text
I_OIL_LocationAddressText view_entity from BASIC Business Location Address - Text
P_ADDRESSTEXT view from CONSUMPTION
P_FrcElmntOrgBusinessAddrText view from BASIC
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.

-- Address Texts (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