ADRSTREET

Transparent Table Customizing Table
9 Fields 2 CDS Views

Streets

ADRSTREET is an SAP database table in S/4HANA. Streets. It contains 9 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 (9)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY country LAND1 Country/Reg.
KEY strt_code STRT_CODE Street Number
city_code CITY_CODE City Number
cityp_code CITYP_CODE District Code
strtypeab STRTYPEAB Street type
commu_code COMMU_CODE Municip. key
regiogroup REGIOGROUP Structure Group
taxjurcode AD_TXJCD Tax Jurisdiction

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.

-- Streets
-- 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]
    CITY_CODE,   -- City Number [CITY_CODE]
    CITYP_CODE,  -- District Code [CITYP_CODE]
    STRTYPEAB,   -- Street type [STRTYPEAB]
    COMMU_CODE,  -- Municip. key [COMMU_CODE]
    REGIOGROUP,  -- Structure Group [REGIOGROUP]
    TAXJURCODE,  -- Tax Jurisdiction [AD_TXJCD]
    PRIMARY KEY (CLIENT, COUNTRY, STRT_CODE)
);

Learn More