ADRCITYT

Transparent Table Customizing Table
4 Fields 2 CDS Views

Postalische Orte (Langtexte)

ADRCITYT is an SAP database table in S/4HANA. Postalische Orte (Langtexte). It contains 4 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_BPCityTextTmp view from BASIC City Code txt
I_PostalCityText view_entity from BASIC Description of Postal City

Fields (4)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY langu langu Language
KEY country land1 Country/Reg.
KEY city_code city_code City Number

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.

-- Postalische Orte (Langtexte)
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ADRCITYT (
    CLIENT,     -- Client [mandt]
    LANGU,      -- Language [langu]
    COUNTRY,    -- Country/Reg. [land1]
    CITY_CODE,  -- City Number [city_code]
    PRIMARY KEY (CLIENT, LANGU, COUNTRY, CITY_CODE)
);

Learn More