ADRSTREETT

Transparent Table Customizing Table
5 Fields 2 CDS Views

Straßen (Langtexte)

ADRSTREETT is an SAP database table in S/4HANA. Straßen (Langtexte). It contains 5 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_BPStreetTextTmp view from BASIC Street Code txt
I_StreetText view_entity from BASIC Street - Text

Fields (5)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY langu langu Language
KEY country land1 Country/Reg.
KEY strt_code strt_code Street Number
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.

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

Learn More