ADRSTREET

Transparent Table Customizing Table
3 Fields 2 CDS Views

Straßen

ADRSTREET is an SAP database table in S/4HANA. Straßen. It contains 3 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_BPStreetValueHelpTmp view from BASIC Street Code
I_Street view_entity from BASIC Street

Fields (3)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY country land1 Country/Reg.
KEY strt_code strt_code Street 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
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ADRSTREET (
    CLIENT,     -- Client [mandt]
    COUNTRY,    -- Country/Reg. [land1]
    STRT_CODE,  -- Street Number [strt_code]
    PRIMARY KEY (CLIENT, COUNTRY, STRT_CODE)
);

Learn More