ADRTOWNSHIP

Transparent Table Customizing Table
5 Fields 3 CDS Views

Township codes

ADRTOWNSHIP is an SAP database table in S/4HANA. Township codes. It contains 5 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_BPTownshipValueHelpTmp view from BASIC Township Code
I_TertiaryRegion view_entity from BASIC Tertiary Region
I_TownshipCode view from BASIC Township Code

Fields (5)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY country LAND1 Country/Reg.
KEY region REGIO Region
KEY county_code CNTY_CODE County code
KEY township_code TWSHP_CODE Township code

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 codes
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ADRTOWNSHIP (
    CLIENT,         -- Client [MANDT]
    COUNTRY,        -- Country/Reg. [LAND1]
    REGION,         -- Region [REGIO]
    COUNTY_CODE,    -- County code [CNTY_CODE]
    TOWNSHIP_CODE,  -- Township code [TWSHP_CODE]
    PRIMARY KEY (CLIENT, COUNTRY, REGION, COUNTY_CODE, TOWNSHIP_CODE)
);

Learn More