ADRTOWNSHIPT

Transparent Table Customizing Table
10 Fields 3 CDS Views

Township (long texts)

ADRTOWNSHIPT is an SAP database table in S/4HANA. Township (long texts). It contains 10 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_BPTownshipTextTmp view from BASIC Township code text
I_TertiaryRegionText view from BASIC Description of Tertiary Region
I_TownshipCodeText view from BASIC Township Code Text

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY langu LANGU Language
KEY country LAND1 Country/Reg.
KEY region REGIO Region
KEY county_code CNTY_CODE County code
KEY township_code TWSHP_CODE Township code
township AD_TOWNSHIP Township
mc_township AD_MC_TWSHP Township
twship_short TOWNSHIP_SHORT Twshp Abb. (24)
twship_sh15 TOWNSHIP_SH15 Twshp Abb. (15)

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.

-- Township (long texts)
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ADRTOWNSHIPT (
    CLIENT,         -- Client [MANDT]
    LANGU,          -- Language [LANGU]
    COUNTRY,        -- Country/Reg. [LAND1]
    REGION,         -- Region [REGIO]
    COUNTY_CODE,    -- County code [CNTY_CODE]
    TOWNSHIP_CODE,  -- Township code [TWSHP_CODE]
    TOWNSHIP,       -- Township [AD_TOWNSHIP]
    MC_TOWNSHIP,    -- Township [AD_MC_TWSHP]
    TWSHIP_SHORT,   -- Twshp Abb. (24) [TOWNSHIP_SHORT]
    TWSHIP_SH15,    -- Twshp Abb. (15) [TOWNSHIP_SH15]
    PRIMARY KEY (CLIENT, LANGU, COUNTRY, REGION, COUNTY_CODE, TOWNSHIP_CODE)
);

Learn More