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